ew List ();
{con.Open (); reader = cmd.ExecuteReader (); (reader.Read ())
{NewsletterDetails newslet = new NewsletterDetails (Convert.ToInt32 (reader ["NewsletterID"]), Convert.ToDateTime (reader ["AddedDate"]), Convert.ToString (reader ["AddedBy" ;]), Convert.ToString (reader ["Subject"]), Convert.ToString (reader ["HtmlBody"]), err)
{throw new ApplicationException ("Помилка даних");}
finally
{con.Close ();}
}
// отримати останні 3 новини
public List GetNewsletters3 ()
{SqlConnection con = new SqlConnection (connectionString); cmd = new SqlCommand ("tbh_Newsletters_GetNewsletters3", con);. CommandType = CommandType.StoredProcedure;
// Створити колекцію для всіх записів
List newsletter = new List ();
{con.Open (); reader = cmd.ExecuteReader (); (reader.Read ())
{NewsletterDetails newslet = new NewsletterDetails (Convert.ToInt32 (reader ["NewsletterID"]), Convert.ToDateTime (reader ["AddedDate"]), Convert.ToString (reader ["AddedBy" ;]), Convert.ToString (reader ["Subject"]), Convert.ToString (reader ["HtmlBody"]), err)
{throw new ApplicationException ("Помилка даних");}
finally
{con.Close ();}
}
// новину відіслана передплатникам
public void UpdateNewsletterSend (int id)
{SqlConnection cn = new SqlConnection (connectionString); cmd = new SqlCommand ("tbh_Newsletters_UpdateNewsletterSend", cn);. CommandType = CommandType.StoredProcedure;. Parameters.Add ("@ NewsletterID", SqlDbType . Int). Value = id;
{cn.Open ();. ExecuteNonQuery ();
}
{cn.Close ();}}
// оновити новину
public void UpdateNewsletter (string Subject, string HtmlBody, int id)
{if (Subject == null) {Subject = "";} (HtmlBody == null) {HtmlBody = "";} cn = new SqlConnection (connectionString); cmd = new SqlCommand ("tbh_Newsletters_UpdateNewsletter", cn);. CommandType = CommandType.StoredProcedure;. Parameters.Add ("@ Subject", SqlDbType.NVarChar). Value = Subject;. Parameters.Add ("@ HtmlBody", SqlDbType . NText). Value = HtmlBody;. Parameters.Add ("@ NewsletterID", SqlDbType.Int). Value = id;
{cn.Open ();. ExecuteNonQuery ();}
{cn.Close ();}}
// видалити новину
public void DeleteNews...
