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