public static bool UpdateLeave(Urlopy editedLeave) { using (IDbConnection myDBconnection = new SqlConnection(ConfigurationManager.ConnectionStrings["EWUDatabase"].ConnectionString)) { if (myDBconnection.State == ConnectionState.Closed) { myDBconnection.Open(); } var result = myDBconnection.Execute(@"UPDATE ewu.urlopy SET IDstatus = @Status, IDurlopu_typ = @IDLeaveType, data_wniosku = @AppDate, urlop_od = @Since, urlop_do = @To, ilosc_dni_urlopu = @Quantity, uwagi = @Notes WHERE IDewidencji = @IDLeave", new { Status = editedLeave.IDstatus, IDLeaveType = editedLeave.IDurlopu_typ, AppDate = editedLeave.data_wniosku, Since = editedLeave.urlop_od, To = editedLeave.urlop_do, Quantity = editedLeave.ilosc_dni_urlopu, Notes = editedLeave.uwagi, IDLeave = editedLeave.IDewidencji }); return(result == 1); } }
public static bool InsertLeave(Urlopy newLeave) { using (IDbConnection myDBconnection = new SqlConnection(ConfigurationManager.ConnectionStrings["EWUDatabase"].ConnectionString)) { if (myDBconnection.State == ConnectionState.Closed) { myDBconnection.Open(); } var result = myDBconnection.Execute(@"INSERT INTO ewu.urlopy (IDzatrudnienia, IDstatus, IDurlopu_typ, data_wniosku, urlop_od, urlop_do, ilosc_dni_urlopu, uwagi) VALUES (@IDperoid, @Status, @IDLeaveType, @AppDate,@Since, @To, @Quantity, @Notes)", new { IDperoid = newLeave.IDzatrudnienia, Status = newLeave.IDstatus, IDLeaveType = newLeave.IDurlopu_typ, AppDate = newLeave.data_wniosku, Since = newLeave.urlop_od, To = newLeave.urlop_do, Quantity = newLeave.ilosc_dni_urlopu, Notes = newLeave.uwagi }); return(result == 1); } }