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; } }