public bool insertShopCollectTime(ShopCollectTime obj)
{
if (SqlDbmanager.ExecuteNonQry(SqlExtension.GetInsertSqlCmd("ShopCollectTime", obj)))
{
return(true);
}
return(false);
}
public bool deleteShopCollectTime(ShopCollectTime obj)
{
if (SqlDbmanager.ExecuteNonQry(SqlExtension.GetDeleteSqlCmd("ShopCollectTime", obj, new List <string> {
"SCT02=@SCT02", "SCT03=@SCT03", "SCT04=@SCT04"
})))
{
return(true);
}
return(false);
}
private static List <ShopCollectTime> MapShopCollectTime(List <PrescoShopCollect> shopCollectionResponses)
{
var result = new List <ShopCollectTime>();
foreach (var shopcollect in shopCollectionResponses)
{
foreach (var item in shopcollect.data)
{
foreach (var time in item.OpeningHours)
{
var shopcollectdaily = new ShopCollectTime();
shopcollectdaily.SCT02 = item.Name;
shopcollectdaily.SCT03 = item.ShortName;
shopcollectdaily.SCT04 = time.DayofWeek + 1;
shopcollectdaily.SCT05 = time.StartTime;
shopcollectdaily.SCT06 = time.EndTime;
result.Add(shopcollectdaily);
}
}
}
return(result);
}
private static bool IsNewShopCollectTime(ShopCollectTime shopCollectTime, DataTable existingShopCollectTime)
{
return(!existingShopCollectTime.AsEnumerable().Any(x => x.Field <string>("SCT02") == shopCollectTime.SCT02 &&
x.Field <string>("SCT03") == shopCollectTime.SCT03 &&
x.Field <int>("SCT04") == shopCollectTime.SCT04));
}