public void UpdateData(DateTime holidayDate, string holidayDesc, List <string> branchCodeList, string createdBy)
{
try
{
string del = "";
string dateStr = "";
using (TransactionScope ts = new TransactionScope(TransactionScopeOption.Required, new TransactionOptions {
IsolationLevel = IsolationLevel.ReadCommitted
}))
{
if (holidayDate.Year != 1)
{
dateStr = holidayDate.Year.ToString() + holidayDate.ToString("-MM-dd");
del = @"DELETE FROM " + SLMConstant.SLMDBName + ".dbo.kkslm_ms_calendar_branch WHERE CONVERT(DATE, slm_HolidayDate) = '" + dateStr + "'";
}
else
{
throw new Exception("Cannot find holiday date");
}
if (!string.IsNullOrEmpty(del))
{
slmdb.ExecuteStoreCommand(del);
}
DateTime createdDate = DateTime.Now;
foreach (string branchcode in branchCodeList)
{
kkslm_ms_calendar_branch obj = new kkslm_ms_calendar_branch()
{
slm_HolidayDate = holidayDate,
slm_HolidayDesc = holidayDesc,
slm_BranchCode = branchcode,
slm_CreatedBy = createdBy,
slm_CreatedDate = createdDate,
slm_UpdatedBy = createdBy,
slm_UpdatedDate = createdDate,
is_Deleted = false
};
slmdb.kkslm_ms_calendar_branch.AddObject(obj);
}
slmdb.SaveChanges();
ts.Complete();
}
}
catch (Exception ex)
{
throw ex;
}
}
public void InsertData(DateTime holidayDate, string holidayDesc, List <string> branchCodeList, string createdBy)
{
try
{
DateTime createdDate = DateTime.Now;
List <string> dbBranchCodeList = null;
//หา branch ที่มีอยู่ในเบส
if (holidayDate.Year != 1)
{
dbBranchCodeList = slmdb.kkslm_ms_calendar_branch.Where(p => EntityFunctions.TruncateTime(p.slm_HolidayDate) == EntityFunctions.TruncateTime(holidayDate) && p.is_Deleted == false).Select(p => p.slm_BranchCode).ToList();
}
else
{
throw new Exception("Cannot find holiday date");
}
//เอา branch ที่มีอยู่ในเบสแล้ว ออกจาก list ที่ต้องการ insert
if (dbBranchCodeList.Count > 0)
{
branchCodeList = branchCodeList.Except <string>(dbBranchCodeList).ToList();
}
if (branchCodeList.Count > 0)
{
foreach (string branchcode in branchCodeList)
{
kkslm_ms_calendar_branch obj = new kkslm_ms_calendar_branch()
{
slm_HolidayDate = holidayDate,
slm_HolidayDesc = holidayDesc,
slm_BranchCode = branchcode,
slm_CreatedBy = createdBy,
slm_CreatedDate = createdDate,
slm_UpdatedBy = createdBy,
slm_UpdatedDate = createdDate,
is_Deleted = false
};
slmdb.kkslm_ms_calendar_branch.AddObject(obj);
}
slmdb.SaveChanges();
}
}
catch (Exception ex)
{
throw ex;
}
}
