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);
}
}
