Реферат Розробка автоматизованої інформаційної системи "Автосервіс"

>

connectionString = WebConfigurationManager.ConnectionStrings ["connectionStringName"]. ConnectionString;

}

// додавання новини

public int InsertNewsletter (DateTime AddedDate, string AddedBy, string Subject, string HtmlBody)

{if (AddedBy == null) {AddedBy = "";} (Subject == null) {Subject = "";} (HtmlBody == null) {HtmlBody = " ; ";} (AddedDate == null) {AddedDate = DateTime.Now;} cn = new SqlConnection (connectionString); cmd = new SqlCommand (" tbh_Newsletters_InsertNewsletter ", cn);. CommandType = CommandType.StoredProcedure;. Parameters. Add ("@ AddedDate", SqlDbType.DateTime). Value = AddedDate;. Parameters.Add ("@ AddedBy", SqlDbType.NVarChar). Value = AddedBy;. Parameters.Add ("@ Subject", SqlDbType. NVarChar). Value = Subject;. Parameters.Add ("@ HtmlBody", SqlDbType.NText). Value = HtmlBody;. Parameters.Add ("@ NewsletterID", SqlDbType.Int). Direction = ParameterDirection.Output;

finally

{cn.Close ();}}

// отримання новини за її ідентифікатором (ID)

public NewsletterDetails GetNewsletterByID (int id)

{using (SqlConnection con = new SqlConnection (connectionString))

{cmd = new SqlCommand ("tbh_Newsletters_GetNewsletterByID", con);. CommandType = CommandType.StoredProcedure;. Parameters.Add ("@ NewsletterID", SqlDbType.Int). Value = id;

{con.Open (); reader = cmd.ExecuteReader (CommandBehavior.SingleRow);

// отримати перший рядок

reader.Read ();

NewsletterDetails newslett = new NewsletterDetails (Convert.ToInt32 (reader ["NewsletterID"]), Convert.ToDateTime (reader ["AddedDate"]), Convert.ToString (reader ["AddedBy" ]), Convert.ToString (reader ["Subject"]), Convert.ToString (reader ["HtmlBody"]), Convert.ToBoolean (reader ["NewsletterSend"]));. Close (); newslett; } (SqlException err)

{throw new ApplicationException ("Помилка даних");}

{con.Close ();

}}}

// отримати всі новини з частковим пошуком по полях: Subject, HtmlBody, AddedBy, AddedDate

public List GetNewsletters (string param)

{SqlConnection con = new SqlConnection (connectionString); cmd = new SqlCommand ("tbh_Newsletters_GetNewsletters", con);. CommandType = CommandType.StoredProcedure;. Parameters.Add ("@ param", SqlDbType . NVarChar). Value = "%" + param + "%";

// Створити колекцію для всіх записів

List newsletter = n...