protected void UncheckedLevel2Escalate(int Slaid)
{
objLevel2 = objLevel2.Get_By_Slaid(Slaid);
if (objLevel2.Slaid != 0)
{
int varLevelid2;
varLevelid2 = objLevel2.Level2id;
objLevel2.Delete(varLevelid2);
}
}
public int GetLevel2EscalationTimeInMins(int slaid)
{
int varDays = 0;
int varHours = 0;
int VarMins = 0;
int TotalMins = 0;
objLevel2 = objLevel2.Get_By_Slaid(slaid);
if (objLevel2.Slaid != 0)
{
varDays = objLevel2.Days;
varHours = objLevel2.Hours;
VarMins = objLevel2.Min;
TotalMins = (varDays * 24 * 60) + (varHours * 60) + VarMins;
}
return(TotalMins);
}
protected void UpdateLevel2Escalate(int Slaid)
{
EscalateLevel2 obj = new EscalateLevel2();
string varemail = "";
if (radio1Level2.Checked == true)
{
objLevel2.After = false;
objLevel2.Before = true;
}
else
{
objLevel2.After = true;
objLevel2.Before = false;
}
objLevel2.Slaid = Slaid;
for (int i = listLevel2.Items.Count - 1; i >= 0; i--)
{
if (listLevel2.Items[i].Selected == true)
{
varemail = varemail + listLevel2.Items[i].Text + ",";
}
}
objLevel2.Days = Convert.ToInt32(txtDaysLevel2.Text);
objLevel2.Hours = Convert.ToInt32(drpHoursLevel2.SelectedValue);
objLevel2.Min = Convert.ToInt32(drpMinLevel2.SelectedValue);
obj = obj.Get_By_Slaid(Slaid);
if (obj.Slaid != 0)
{
if (varemail == "")
{
varemail = obj.Emailid;
}
objLevel2.Emailid = varemail;
objLevel2.Level2id = obj.Level2id;
objLevel2.Update();
}
else
{
objLevel2.Emailid = varemail;
objLevel2.Insert();
}
}
protected void Level2Escalate()
{
int Slaid = Convert.ToInt32(Request.QueryString[0]);
objLevel2 = objLevel2.Get_By_Slaid(Slaid);
if (objLevel2.Slaid != 0)
{
string varEmail = objLevel2.Emailid;
string[] arrEmail = varEmail.Split(',');
if (arrEmail.Length > 2)
{
selectLevale2.Text = objLevel2.Emailid;
}
else
{
selectLevale2.Text = arrEmail[0].ToString();
}
chkLevel2.Checked = true;
if (objLevel2.Before == true)
{
radio1Level2.Checked = true;
}
else
{
radio2Level2.Checked = true;
}
txtDaysLevel2.Text = Convert.ToString(objLevel2.Days);
drpHoursLevel2.SelectedIndex = objLevel2.Hours;
drpMinLevel2.SelectedIndex = objLevel2.Min;
}
else
{
selectLevale2.Visible = false;
listLevel2.Visible = true;
radio1Level2.Checked = true;
}
}
protected void SendEmail(int incidentid, int level, int slaid)
{
SentEmail objEmail = new SentEmail();
#region Sent Mail for Level 1 Escalation
if (level == 1)
{
objLevel1 = objLevel1.Get_By_Slaid(slaid);
if (objLevel1 != null)
{
string varemail = objLevel1.Emailid;
string[] arrEmail = varemail.Split(',');
int lengthCount = Convert.ToInt32(arrEmail.Length.ToString());
for (int i = 0; i < lengthCount - 1; i++)
{
string emailId = arrEmail[i].ToString();
if (emailId != "," && emailId != "")
{
objIncident = objIncident.Get_By_id(incidentid);
if (objIncident != null)
{
objCheckLevel1 = objCheckLevel1.Get_By_id(incidentid);
if (objCheckLevel1.Incidentid == 0)
{
CheckLevel1Escalate obj = new CheckLevel1Escalate();
obj.Incidentid = incidentid;
obj.Level1escalate = true;
obj.Insert();
objEmail.To = emailId;
objEmail.From = Resources.MessageResource.strEmailFromLevel1Escalate.ToString();
objEmail.Subject = "Problem Not Resolve for Call -" + objIncident.Title;
objEmail.Body = "Dear Sir, The Current Request is not Solved whose Incident Id is " + objIncident.Incidentid + " and Title of Call is " + objIncident.Title + " Thanks & Regards Admin";
objEmail.SmtpServer = Resources.MessageResource.strMailServer.ToString();
objEmail.SentMail();
}
}
}
}
}
}
#endregion
#region Sent Mail for Level 2 Escalation
if (level == 2)
{
objLevel2 = objLevel2.Get_By_Slaid(slaid);
if (objLevel2.Slaid != 0)
{
string varemail = objLevel2.Emailid;
string[] arrEmail = varemail.Split(',');
int lengthCount = Convert.ToInt32(arrEmail.Length.ToString());
for (int i = 0; i < lengthCount - 1; i++)
{
string emailId = arrEmail[i].ToString();
if (emailId != "," && emailId != "")
{
objIncident = objIncident.Get_By_id(incidentid);
if (objIncident != null)
{
objCheckLevel2 = objCheckLevel2.Get_By_id(incidentid);
if (objCheckLevel2.Incidentid == 0)
{
CheckLevel2Escalate obj = new CheckLevel2Escalate();
obj.Incidentid = incidentid;
obj.Level2escalate = true;
obj.Insert();
objEmail.To = emailId;
objEmail.From = Resources.MessageResource.strEmailFromLevel2Escalate.ToString();
objEmail.Subject = "Problem Not Resolve for Call -" + objIncident.Title;
objEmail.Body = "Dear Sir, The Current Request is not Solved whose Incident Id is " + objIncident.Incidentid + " and Title of Call is " + objIncident.Title + " Thanks & Regards <br/> Admin";
objEmail.SmtpServer = Resources.MessageResource.strMailServer.ToString();
objEmail.SentMail();
}
}
}
}
}
}
#endregion
#region Sent Mail for Level 3 Escalation
if (level == 3)
{
objLevel3 = objLevel3.Get_By_Slaid(slaid);
if (objLevel3.Slaid != 0)
{
string varemail = objLevel3.Emailid;
string[] arrEmail = varemail.Split(',');
int lengthCount = Convert.ToInt32(arrEmail.Length.ToString());
for (int i = 0; i < lengthCount - 1; i++)
{
string emailId = arrEmail[i].ToString();
if (emailId != "," && emailId != "")
{
objIncident = objIncident.Get_By_id(incidentid);
if (objIncident != null)
{
objCheckLevel3 = objCheckLevel3.Get_By_id(incidentid);
if (objCheckLevel3.Incidentid == 0)
{
CheckLevel3Escalate obj = new CheckLevel3Escalate();
obj.Incidentid = incidentid;
obj.Level3escalate = true;
obj.Insert();
objEmail.To = emailId;
objEmail.From = Resources.MessageResource.strEmailFromLevel3Escalate.ToString();
objEmail.Subject = "Problem Not Resolve for Call -" + objIncident.Title;
objEmail.Body = "Dear Sir, The Current Request is not Solved whose Incident Id is " + objIncident.Incidentid + " and Title of Call is " + objIncident.Title + " Thanks & Regards Admin";
objEmail.SmtpServer = Resources.MessageResource.strMailServer.ToString();
objEmail.SentMail();
}
}
}
}
}
}
#endregion
}
protected void UncheckedLevel2Escalate(int Slaid)
{
objLevel2 = objLevel2.Get_By_Slaid(Slaid);
if (objLevel2.Slaid != 0)
{
int varLevelid2;
varLevelid2 = objLevel2.Level2id;
objLevel2.Delete(varLevelid2);
}
}
protected void UpdateLevel2Escalate(int Slaid)
{
EscalateLevel2 obj = new EscalateLevel2();
string varemail = "";
if (radio1Level2.Checked == true)
{
objLevel2.After = false;
objLevel2.Before = true;
}
else
{
objLevel2.After = true;
objLevel2.Before = false;
}
objLevel2.Slaid = Slaid;
for (int i = listLevel2.Items.Count - 1; i >= 0; i--)
{
if (listLevel2.Items[i].Selected == true)
{
varemail = varemail + listLevel2.Items[i].Text + ",";
}
}
objLevel2.Days = Convert.ToInt32(txtDaysLevel2.Text);
objLevel2.Hours = Convert.ToInt32(drpHoursLevel2.SelectedValue);
objLevel2.Min = Convert.ToInt32(drpMinLevel2.SelectedValue);
obj = obj.Get_By_Slaid(Slaid);
if (obj.Slaid != 0)
{
if (varemail == "")
{
varemail = obj.Emailid;
}
objLevel2.Emailid = varemail;
objLevel2.Level2id = obj.Level2id;
objLevel2.Update();
}
else
{
objLevel2.Emailid = varemail;
objLevel2.Insert();
}
}
protected void SendEmail(int incidentid, int level,int slaid)
{
SentEmail objEmail = new SentEmail();
#region Sent Mail for Level 1 Escalation
if (level==1)
{
objLevel1 = objLevel1.Get_By_Slaid(slaid);
if (objLevel1!=null )
{
string varemail = objLevel1.Emailid;
string[] arrEmail = varemail.Split(',');
int lengthCount = Convert.ToInt16(arrEmail.Length.ToString());
for (int i = 0; i < lengthCount - 1; i++)
{
string emailId = arrEmail[i].ToString();
if (emailId != "," && emailId!="")
{
objIncident = objIncident.Get_By_id(incidentid);
if (objIncident!=null)
{
objCheckLevel1 = objCheckLevel1.Get_By_id(incidentid);
if (objCheckLevel1.Incidentid ==0)
{
CheckLevel1Escalate obj = new CheckLevel1Escalate();
obj.Incidentid = incidentid;
obj.Level1escalate = true;
obj.Insert();
objEmail.To = emailId;
objEmail.From = Resources.MessageResource.strEmailFromLevel1Escalate.ToString();
objEmail.Subject = "Problem Not Resolve for Call -" + objIncident.Title;
objEmail.Body = "Dear Sir, The Current Request is not Solved whose Incident Id is " + objIncident.Incidentid + " and Title of Call is " + objIncident.Title + " Thanks & Regards Admin";
objEmail.SmtpServer = Resources.MessageResource.strMailServer.ToString();
objEmail.SentMail();
}
}
}
}
}
}
#endregion
#region Sent Mail for Level 2 Escalation
if (level == 2)
{
objLevel2 = objLevel2.Get_By_Slaid(slaid);
if (objLevel2.Slaid != 0)
{
string varemail = objLevel2.Emailid;
string[] arrEmail = varemail.Split(',');
int lengthCount = Convert.ToInt16(arrEmail.Length.ToString());
for (int i = 0; i < lengthCount - 1; i++)
{
string emailId = arrEmail[i].ToString();
if (emailId != "," && emailId != "")
{
objIncident = objIncident.Get_By_id(incidentid);
if (objIncident != null)
{
objCheckLevel2 = objCheckLevel2.Get_By_id(incidentid);
if (objCheckLevel2.Incidentid == 0)
{
CheckLevel2Escalate obj = new CheckLevel2Escalate();
obj.Incidentid = incidentid;
obj.Level2escalate = true;
obj.Insert();
objEmail.To = emailId;
objEmail.From = Resources.MessageResource.strEmailFromLevel2Escalate.ToString();
objEmail.Subject = "Problem Not Resolve for Call -" + objIncident.Title;
objEmail.Body = "Dear Sir, The Current Request is not Solved whose Incident Id is " + objIncident.Incidentid + " and Title of Call is " + objIncident.Title + " Thanks & Regards <br/> Admin";
objEmail.SmtpServer = Resources.MessageResource.strMailServer.ToString();
objEmail.SentMail();
}
}
}
}
}
}
#endregion
#region Sent Mail for Level 3 Escalation
if (level == 3)
{
objLevel3 = objLevel3.Get_By_Slaid(slaid);
if (objLevel3.Slaid != 0)
{
string varemail = objLevel3.Emailid;
string[] arrEmail = varemail.Split(',');
int lengthCount = Convert.ToInt16(arrEmail.Length.ToString());
for (int i = 0; i < lengthCount - 1; i++)
{
string emailId = arrEmail[i].ToString();
if (emailId != "," && emailId != "")
{
objIncident = objIncident.Get_By_id(incidentid);
if (objIncident != null)
{
objCheckLevel3 = objCheckLevel3.Get_By_id(incidentid);
if (objCheckLevel3.Incidentid == 0)
{
CheckLevel3Escalate obj = new CheckLevel3Escalate();
obj.Incidentid = incidentid;
obj.Level3escalate = true;
obj.Insert();
objEmail.To = emailId;
objEmail.From = Resources.MessageResource.strEmailFromLevel3Escalate.ToString();
objEmail.Subject = "Problem Not Resolve for Call -" + objIncident.Title;
objEmail.Body = "Dear Sir, The Current Request is not Solved whose Incident Id is " + objIncident.Incidentid + " and Title of Call is " + objIncident.Title + " Thanks & Regards Admin";
objEmail.SmtpServer = Resources.MessageResource.strMailServer.ToString();
objEmail.SentMail();
}
}
}
}
}
}
#endregion
}
protected void Level2Escalate()
{
int Slaid = Convert.ToInt32(Request.QueryString[0]);
objLevel2 = objLevel2.Get_By_Slaid(Slaid);
if (objLevel2.Slaid != 0)
{
string varEmail = objLevel2.Emailid;
string[] arrEmail = varEmail.Split(',');
if (arrEmail.Length > 2)
{
selectLevale2.Text = objLevel2.Emailid;
}
else { selectLevale2.Text = arrEmail[0].ToString(); }
chkLevel2.Checked = true;
if (objLevel2.Before == true)
{
radio1Level2.Checked = true;
}
else { radio2Level2.Checked = true; }
txtDaysLevel2.Text = Convert.ToString(objLevel2.Days);
drpHoursLevel2.SelectedIndex = objLevel2.Hours;
drpMinLevel2.SelectedIndex = objLevel2.Min;
}
else
{
selectLevale2.Visible = false;
listLevel2.Visible = true;
radio1Level2.Checked = true;
}
}
public int GetLevel2EscalationTimeInMins(int slaid)
{
int varDays = 0;
int varHours = 0;
int VarMins = 0;
int TotalMins = 0;
objLevel2 = objLevel2.Get_By_Slaid(slaid);
if (objLevel2.Slaid != 0 )
{
varDays = objLevel2.Days;
varHours = objLevel2.Hours;
VarMins = objLevel2.Min;
TotalMins = (varDays * 24 * 60) + (varHours * 60) + VarMins;
}
return TotalMins;
}
public int Update_EscalateLevel2_By_id(EscalateLevel2 objEscalateLevel2)
{
return (int)ExecuteNonQuery(sp_EscalateLevel2_mst_Update, new object[] { objEscalateLevel2.Slaid, objEscalateLevel2.Min, objEscalateLevel2.Level2id, objEscalateLevel2.Hours, objEscalateLevel2.Emailid, objEscalateLevel2.Days, objEscalateLevel2.Before, objEscalateLevel2.After });
}
public int Insert_EscalateLevel2(EscalateLevel2 objEscalateLevel2)
{
return (int)ExecuteNonQuery(sp_EscalateLevel2_mst_Insert, new object[] { objEscalateLevel2.Slaid, objEscalateLevel2.Min, objEscalateLevel2.Hours, objEscalateLevel2.Emailid, objEscalateLevel2.Days, objEscalateLevel2.Before, objEscalateLevel2.After });
}
public object GenerateEscalateLevel2Object(ref IDataReader returnData)
{
EscalateLevel2 obj = new EscalateLevel2();
while (returnData.Read())
{
obj.Slaid = (int)returnData["Slaid"];
obj.Min = (int)returnData["Min"];
obj.Level2id = (int)returnData["Level2id"];
obj.Hours = (int)returnData["Hours"];
obj.Emailid = (string)returnData["Emailid"];
obj.Days = (int)returnData["Days"];
obj.Before = (bool)returnData["Before"];
obj.After = (bool)returnData["After"];
if (returnData["Sent"] != DBNull.Value)
{
obj.Sent = (bool)returnData["Sent"];
}
}
returnData.Close();
returnData.Dispose();
return obj;
}
public CollectionBase GenerateEscalateLevel2Collection(ref IDataReader returnData)
{
BLLCollection<EscalateLevel2> col = new BLLCollection<EscalateLevel2>();
while (returnData.Read())
{
EscalateLevel2 obj = new EscalateLevel2();
obj.Slaid = (int)returnData["Slaid"];
obj.Min = (int)returnData["Min"];
obj.Level2id = (int)returnData["Level2id"];
obj.Hours = (int)returnData["Hours"];
obj.Emailid = (string)returnData["Emailid"];
obj.Days = (int)returnData["Days"];
obj.Before = (bool)returnData["Before"];
obj.After = (bool)returnData["After"];
if (returnData["Sent"] != DBNull.Value)
{
obj.Sent = (bool)returnData["Sent"];
}
col.Add(obj);
}
returnData.Close();
returnData.Dispose();
return col;
}
