private dynamic Get_Resources(int DR_AU_AD_Code)
{
IEnumerable <CT_Daily_Resource> resources = null;
if (DR_AU_AD_Code > 0)
{
resources = CT_Daily_Resource.Query(@"where [DR_AU_AD_Code] = @0", DR_AU_AD_Code);
}
return(resources);
}
private void Save_Resources(dynamic data, DBCRMTree db)
{
var s_resources = JsonConvert.SerializeObject(data.resources);
if (string.IsNullOrWhiteSpace(s_resources))
{
return;
}
List <CT_Daily_Resource> resources = JsonConvert.DeserializeObject <List <CT_Daily_Resource> >(s_resources);
foreach (var resource in resources)
{
resource.DR_AU_AD_Code = UserSession.DealerEmpl.DE_AD_OM_Code;
resource.DR_Update_dt = DateTime.Now;
if (CT_Daily_Resource.Exists("DR_UType = @0 AND DR_AU_AD_Code = @1", resource.DR_UType, resource.DR_AU_AD_Code))
{
db.Update <CT_Daily_Resource>(@"
SET [DR_D1_AM] = @DR_D1_AM,
[DR_D1_PM] = @DR_D1_PM,
[DR_D2_AM] = @DR_D2_AM,
[DR_D2_PM] = @DR_D2_PM,
[DR_D3_AM] = @DR_D3_AM,
[DR_D3_PM] = @DR_D3_PM,
[DR_D4_AM] = @DR_D4_AM,
[DR_D4_PM] = @DR_D4_PM,
[DR_D5_AM] = @DR_D5_AM,
[DR_D5_PM] = @DR_D5_PM,
[DR_D6_AM] = @DR_D6_AM,
[DR_D6_PM] = @DR_D6_PM,
[DR_D7_AM] = @DR_D7_AM,
[DR_D7_PM] = @DR_D7_PM,
[DR_Update_dt] = @DR_Update_dt
WHERE [DR_UType] = @DR_UType AND
[DR_AU_AD_Code] = @DR_AU_AD_Code" , resource);
}
else
{
resource.Insert();
}
}
}
