public static void UpdatePhonecallCASFlag(SLMDBEntities slmdb, int phonecall_id, string casFlag) { try { var phonecall = slmdb.kkslm_phone_call.Where(p => p.slm_PhoneCallId == phonecall_id).FirstOrDefault(); if (phonecall != null) { phonecall.slm_CAS_Flag = casFlag; phonecall.slm_CAS_Date = DateTime.Now; slmdb.SaveChanges(); } } catch (Exception ex) { errMsg = ex.ToString(); } }
public override void FeedbackData() { var feedback = 0; if (_selectedList.Count > 0) { const int pageSize = 10000; var sqlsStamp0 = new List <string>(); for (var i = 0; i < _rejectedList.Count; i += pageSize) { sqlsStamp0.Add(string.Format(@" UPDATE {0}kkslm_tr_prelead SET slm_IsExportTKS = 0, slm_IsExportTKSDate = @now, slm_UpdatedDate = @now, slm_UpdatedBy = 'SYSTEM' WHERE slm_Prelead_Id IN ({1}); ", AppConstant.SLMDBName + ".dbo.", string.Join(",", _rejectedList.Skip(i).Take(pageSize)))); } var sqlsStamp1 = new List <string>(); for (var i = 0; i < _selectedList.Count; i += pageSize) { sqlsStamp1.Add(string.Format(@" UPDATE {0}kkslm_tr_prelead SET slm_IsExportTKS = 1, slm_IsExportTKSDate = @now, slm_UpdatedDate = @now, slm_UpdatedBy = 'SYSTEM' WHERE slm_Prelead_Id IN ({1}); ", AppConstant.SLMDBName + ".dbo.", string.Join(",", _selectedList.Skip(i).Take(pageSize)))); } string sql = $@" BEGIN DECLARE @now AS DATETIME = getdate(); {string.Join("\n", sqlsStamp0)} {string.Join("\n", sqlsStamp1)} END; "; feedback = db.ExecuteNonQuery(sql); } System.Diagnostics.Debug.Assert(!_selectedList.GroupBy(x => x).Any(x => x.Count() > 1)); Console.WriteLine($"DataTable contain {_selectedList.Count} rows, rejected {_rejectedList.Count} rows, feedback = {feedback}, prelead"); feedback = 0; if (_portMonList.Count > 0) { using (SLMDBEntities slmdb = AppUtil.GetSlmDbEntities()) { DateTime dbNow = slmdb.DBNow(); foreach (kkslm_tr_preleadportmonitor portmon in _portMonList) { slmdb.kkslm_tr_preleadportmonitor.Attach(portmon); portmon.slm_TKSFlag = "Y"; portmon.slm_UpdatedDate = dbNow; portmon.slm_UpdatedBy = "SYSTEM"; } feedback += slmdb.SaveChanges(); } } System.Diagnostics.Debug.Assert(!_portMonList.GroupBy(x => x.slm_CMTLot).Any(x => x.Count() > 1)); Console.WriteLine($"DataTable contain {_portMonList.Count} rows, feedback = {feedback}, portMon"); }