public static void SetDelete(DBLayer.ServiceSales.Details det)
{
ZFort.DB.Execute.ExecuteString_void("UPDATE ServiceSales SET IsDeleted = 1 WHERE [Id] = " + det.Id.ToString());
ZFort.DB.Execute.ExecuteString_void("UPDATE ServiceSales SET DeleteDate = '" + det.DeleteDate.ToString("yyyyMMdd") + "' WHERE [Id] = " + det.Id.ToString());
ZFort.DB.Execute.ExecuteString_void("UPDATE ServiceSales SET DeleteReason = '" + det.DeleteReason + "' WHERE [Id] = " + det.Id.ToString());
}
public static void Insert(DBLayer.ServiceSales.Details det)
{
string sql = "INSERT INTO ServiceSales (ServiceId, UserId, [Date], [Time], [Quantity], IsDeleted) ";
sql += " VALUES (" + det.ServiceId.ToString() + ", " + det.UserId.ToString() + ", '" + det.Date.ToString("yyyyMMdd") + "', '" + det.Time + "', " + det.Quantity.ToString() + ", 0)";
ZFort.DB.Execute.ExecuteString_void(sql);
}
void frm3_SelectDateMsg(object sender, FitnessProject.ServiceForms.FrmCalendar.DateSelectEventArgs args)
{
DBLayer.ServiceSales.Details det = DBLayer.ServiceSales.GetDetails(this.Id);
det.Date = args.SelectedDate;
DBLayer.ServiceSales.Update(det);
LoadData();
}
void frm_SelectReasonMsg(object sender, FitnessProject.ServiceForms.ReasonEventArgs args)
{
DBLayer.ServiceSales.Details det = DBLayer.ServiceSales.GetDetails(this.Id);
det.DeleteReason = args.Reason;
det.DeleteDate = DateTime.Now;
DBLayer.ServiceSales.SetDelete(det);
LoadData();
}
public static void Update(DBLayer.ServiceSales.Details det)
{
ZFort.DB.Execute.ExecuteString_void("UPDATE ServiceSales SET [ServiceId] = " + det.ServiceId.ToString() + " WHERE [Id] = " + det.Id.ToString());
ZFort.DB.Execute.ExecuteString_void("UPDATE ServiceSales SET [UserId] = " + det.UserId.ToString() + " WHERE [Id] = " + det.Id.ToString());
ZFort.DB.Execute.ExecuteString_void("UPDATE ServiceSales SET [Date] = '" + det.Date.ToString("yyyyMMdd") + "' WHERE [Id] = " + det.Id.ToString());
ZFort.DB.Execute.ExecuteString_void("UPDATE ServiceSales SET [Time] = '" + det.Time + "' WHERE [Id] = " + det.Id.ToString());
ZFort.DB.Execute.ExecuteString_void("UPDATE ServiceSales SET [Quantity] = " + det.Quantity.ToString().Replace(",", ".") + " WHERE [Id] = " + det.Id.ToString());
}
