//select the triger phone and traking
public AddCasenotesModel selecttrigerandtraking(string case_id)
{
var agentcase = (from ep in db.case_details
// join e in db.case_details on ep.case_id equals e.case_id
join t in db.recipient_details on ep.case_id equals t.case_id
where ep.case_id == case_id
select new
{
tracking = ep.tracking_number,
trigger_phone = t.phone
}).ToList();
AddCasenotesModel addcase = new AddCasenotesModel();
foreach (var item in agentcase)
{
addcase.trigger_phone = item.trigger_phone;
addcase.tracking = item.tracking;
}
return(addcase);
}
//insert a DATA agent_case_attempts_made AND add_case_notes ,update follow_up_date as case_details table
public void insertcasenotes(string case_id, string agent_id, CaseViewModel caseviewmodel)
{
CaseviewPersistence caseviewpersistence = new CaseviewPersistence();
DateTime dt = new DateTime();
DateTime dt1 = new DateTime();
string attempt = selectattempt(caseviewmodel.cheattempt1, caseviewmodel.cheattempt2, caseviewmodel.cheattempt3);
int priority = 0;
if (caseviewmodel.setpriority == "1")
{
priority = 1;
}
if (caseviewmodel.timer1 == null)
{
}
else
{
string date = caseviewmodel.timer1?.ToString("hh:mm tt");
caseviewmodel.datepicker1 = caseviewmodel.datepicker1 + " " + date;
dt = Convert.ToDateTime(caseviewmodel.datepicker1);
if (caseviewmodel.setpriority == "1")
{
priority = 1;
}
}
if (caseviewmodel.timer2 == null)
{
}
else
{
string date = caseviewmodel.timer2?.ToString("hh:mm tt");
caseviewmodel.datepicker2 = caseviewmodel.datepicker2 + " " + date;
dt = Convert.ToDateTime(caseviewmodel.datepicker2);
if (caseviewmodel.setpriority2 == "1")
{
priority = 1;
}
}
if (caseviewmodel.timer3 == null)
{
}
else
{
string date = caseviewmodel.timer3?.ToString("hh:mm tt");
caseviewmodel.datepicker3 = caseviewmodel.datepicker3 + " " + date;
dt = Convert.ToDateTime(caseviewmodel.datepicker3);
if (caseviewmodel.setpriority3 == "1")
{
priority = 1;
}
}
if (caseviewmodel.txtfollowupdate != null)
{
dt1 = Convert.ToDateTime(caseviewmodel.txtfollowupdate);
}
AddCasenotesModel addcase = caseviewpersistence.selecttrigerandtraking(case_id); //insertsaveandupdate
if (priority != 0)
{
caseviewpersistence.updatecasedetailspriority(case_id, priority);
}
//insertprimarytable
if (caseviewmodel.txtremarks != null)
{
if (attempt != null)
{
int itm1 = 1;
string strqu1 = "'" + case_id + "' ,'" + agent_id + "' ,'" + attempt + "' ,'" + dt + "' ,'" + priority + "')";
//string strqu1=
caseviewpersistence.insertsaveandupdate(strqu1, itm1, case_id, caseviewmodel.txtfollowupdate);
}
if (caseviewmodel.Deadline1 != Convert.ToDateTime("1/1/0001 12:00:00 AM"))
{
caseviewpersistence.updatedeadline(case_id, caseviewmodel.Deadline1);
}
int itm = 2;
int attempts = caseviewpersistence.attemptsmadecount(case_id);
if (attempts == -51)
{
}
else if (caseviewmodel.atemtcount != null)
{
caseviewpersistence.updatecasetable(attempts + 1, case_id);
}
if (caseviewmodel.atemtcount != null)
{
//addcase.trigger_phone---->caseviewmodel.txtphone
attempts = attempts + 1;
string strqu = "'" + case_id + "' ,'" + caseviewmodel.txtphone + "' ,'" + caseviewmodel.txtspoke +
"' ,'" + caseviewmodel.txtvmail + "','" + caseviewmodel.txtinforeq + "','" + caseviewmodel.txtinforec + "','" + addcase.tracking + "','" + caseviewmodel.txtdeadline
+ "','" + attempts + "','" + dt1 + "','" + caseviewmodel.txtremarks + "','" + DateTime.Now + "','" + DateTime.Now + "','" + agent_id + "')";
caseviewpersistence.insertsaveandupdate(strqu, itm, case_id, caseviewmodel.txtfollowupdate);
}
else if (caseviewmodel.txtremarks != null)
{
string strqu = "'" + case_id + "' ,'" + caseviewmodel.txtremarks + "','" + DateTime.Now + "','" + DateTime.Now + "','" + agent_id + "')";
caseviewpersistence.insertremarks(strqu);
}
//insertbottrigger(case_id, "save and update");
//ctx.Database.ExecuteSqlCommand(strqu);
if (caseviewmodel.btnsave == "Save & Update")
{
insertbottrigger(case_id, "save_update");
}
if (caseviewmodel.btnsaveandreturn == "Save & Return")
{
string strq = "" + 1 + ",'" + case_id + "','" + DateTime.Now + "','" + DateTime.Now + "')";
caseviewpersistence.insertstatustable(strq);
insertbottrigger(case_id, "save_return");
}
}
if (caseviewmodel.alternatetitle != null)
{
caseviewpersistence.updatecasealternatetitle(caseviewmodel.alternatetitle, case_id);
}
if (caseviewmodel.CasetoUtl != null)
{
if (caseviewmodel.CasetoUtl == "on" || caseviewmodel.CasetoUtl == "ON")
{
caseviewmodel.CasetoUtl = "UTL";
}
caseviewpersistence.updatecasetable(caseviewmodel.CasetoUtl, case_id);
}
if (caseviewmodel.chkSupervisor != null)
{
if (caseviewmodel.chkSupervisor == "Supervisor")
{
caseviewpersistence.updatecasetable("Supervisor", case_id);
}
else if (caseviewmodel.chkSupervisor == "Blockedaccounts")
{
caseviewpersistence.updatecasetable("Blockedaccounts", case_id);
}
else if (caseviewmodel.chkSupervisor == "Hours")
{
caseviewpersistence.updatecasetable("24Hours", case_id);
}
else if (caseviewmodel.chkSupervisor == "clearselection")
{
caseviewpersistence.updatecasetable("clearselection", case_id);
}
}
//if (caseviewmodel.chkSupervisor != null)
//{
// if (caseviewmodel.chkSupervisor == "Blockedaccounts")
// {
// caseviewpersistence.updatecasetable("Blockedaccounts", case_id);
// }
//}
//if (caseviewmodel.chkhours != null)
//{
// if (caseviewmodel.chkhours == "Hours")
// {
// caseviewpersistence.updatecasetable("24Hours", case_id);
// }
//}
}
