private void Save_Options(dynamic data)
{
var s_options = JsonConvert.SerializeObject(data.options);
if (string.IsNullOrWhiteSpace(s_options))
{
return;
}
CT_Service_Dep servDep = JsonConvert.DeserializeObject <CT_Service_Dep>(s_options);
servDep.SD_AD_Code = UserSession.DealerEmpl.DE_AD_OM_Code;
servDep.SD_Update_dt = DateTime.Now;
var db = DBCRMTree.GetInstance();
if (CT_Service_Dep.Exists("SD_AD_Code = @SD_AD_Code AND SD_PDN_Code = @SD_PDN_Code", servDep))
{
db.Update <CT_Service_Dep>(@"SET
SD_SA_Selection=@SD_SA_Selection,
SD_Serv_Package=@SD_Serv_Package,
SD_Update_dt=@SD_Update_dt
where SD_AD_Code = @SD_AD_Code AND SD_PDN_Code = @SD_PDN_Code", servDep);
}
else
{
servDep.Insert();
}
}
private dynamic Get_Options(int AU_AD_Code, int SD_PDN_Code)
{
var servDep = new CT_Service_Dep();
servDep = CT_Service_Dep.SingleOrDefault(@"where SD_AD_Code = @0 AND SD_PDN_Code = @1", AU_AD_Code, SD_PDN_Code);
return(servDep);
}
private CT_Service_Dep Get_CT_Service_Dep(dynamic data)
{
return(CT_Service_Dep.SingleOrDefault(@"where SD_AD_Code = @0 AND SD_PDN_Code = @1",
UserSession.DealerEmpl.DE_AD_OM_Code,
(int)data.SD_PDN_Code));
}