protected void UncheckedLevel3Escalate(int Slaid)
{
objLevel3 = objLevel3.Get_By_Slaid(Slaid);
if (objLevel3.Slaid != 0)
{
int varLevelid3;
varLevelid3 = objLevel3.Level3id;
objLevel3.Delete(varLevelid3);
}
}
public int GetLevel3EscalationTimeInMins(int slaid)
{
int varDays = 0;
int varHours = 0;
int VarMins = 0;
int TotalMins = 0;
objLevel3 = objLevel3.Get_By_Slaid(slaid);
if (objLevel3.Slaid != 0)
{
varDays = objLevel1.Days;
varHours = objLevel1.Hours;
VarMins = objLevel1.Min;
TotalMins = (varDays * 24 * 60) + (varHours * 60) + VarMins;
}
return(TotalMins);
}
protected void UpdateLevel3Escalate(int Slaid)
{
EscalateLevel3 obj = new EscalateLevel3();
string varemail = "";
if (radio1Level3.Checked == true)
{
objLevel3.After = false;
objLevel3.Before = true;
}
else
{
objLevel3.After = true;
objLevel3.Before = false;
}
objLevel3.Slaid = Slaid;
for (int i = listLevel3.Items.Count - 1; i >= 0; i--)
{
if (listLevel3.Items[i].Selected == true)
{
varemail = varemail + listLevel3.Items[i].Text + ",";
}
}
objLevel3.Days = Convert.ToInt32(txtDaysLevel3.Text);
objLevel3.Hours = Convert.ToInt32(drpHoursLevel3.SelectedValue);
objLevel3.Min = Convert.ToInt32(drpMinLevel3.SelectedValue);
obj = obj.Get_By_Slaid(Slaid);
if (obj.Slaid != 0)
{
if (varemail == "")
{
varemail = obj.Emailid;
}
objLevel3.Emailid = varemail;
objLevel3.Level3id = obj.Level3id;
objLevel3.Update();
}
else
{
objLevel3.Emailid = varemail;
objLevel3.Insert();
}
}
protected void Level3Escalate()
{
int Slaid = Convert.ToInt32(Request.QueryString[0]);
objLevel3 = objLevel3.Get_By_Slaid(Slaid);
if (objLevel3.Slaid != 0)
{
string varEmail = objLevel3.Emailid;
string[] arrEmail = varEmail.Split(',');
if (arrEmail.Length > 2)
{
selectLevale3.Text = objLevel3.Emailid;
}
else
{
selectLevale3.Text = arrEmail[0].ToString();
}
chkLevel3.Checked = true;
if (objLevel3.Before == true)
{
radio1Level3.Checked = true;
}
else
{
radio2Level3.Checked = true;
}
txtDaysLevel3.Text = Convert.ToString(objLevel3.Days);
drpHoursLevel3.SelectedIndex = objLevel3.Hours;
drpMinLevel3.SelectedIndex = objLevel3.Min;
}
else
{
selectLevale3.Visible = false;
listLevel3.Visible = true;
radio1Level3.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 UncheckedLevel3Escalate(int Slaid)
{
objLevel3 = objLevel3.Get_By_Slaid(Slaid);
if (objLevel3.Slaid != 0)
{
int varLevelid3;
varLevelid3 = objLevel3.Level3id;
objLevel3.Delete(varLevelid3);
}
}
protected void UpdateLevel3Escalate(int Slaid)
{
EscalateLevel3 obj = new EscalateLevel3();
string varemail = "";
if (radio1Level3.Checked == true)
{
objLevel3.After = false;
objLevel3.Before = true;
}
else
{
objLevel3.After = true;
objLevel3.Before = false;
}
objLevel3.Slaid = Slaid;
for (int i = listLevel3.Items.Count - 1; i >= 0; i--)
{
if (listLevel3.Items[i].Selected == true)
{
varemail = varemail + listLevel3.Items[i].Text + ",";
}
}
objLevel3.Days = Convert.ToInt32(txtDaysLevel3.Text);
objLevel3.Hours = Convert.ToInt32(drpHoursLevel3.SelectedValue);
objLevel3.Min = Convert.ToInt32(drpMinLevel3.SelectedValue);
obj = obj.Get_By_Slaid(Slaid);
if (obj.Slaid != 0)
{
if (varemail == "")
{
varemail = obj.Emailid;
}
objLevel3.Emailid = varemail;
objLevel3.Level3id = obj.Level3id;
objLevel3.Update();
}
else
{
objLevel3.Emailid = varemail;
objLevel3.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 Level3Escalate()
{
int Slaid = Convert.ToInt32(Request.QueryString[0]);
objLevel3 = objLevel3.Get_By_Slaid(Slaid);
if (objLevel3.Slaid != 0)
{
string varEmail = objLevel3.Emailid;
string[] arrEmail = varEmail.Split(',');
if (arrEmail.Length > 2)
{
selectLevale3.Text = objLevel3.Emailid;
}
else { selectLevale3.Text = arrEmail[0].ToString(); }
chkLevel3.Checked = true;
if (objLevel3.Before == true)
{
radio1Level3.Checked = true;
}
else { radio2Level3.Checked = true; }
txtDaysLevel3.Text = Convert.ToString(objLevel3.Days);
drpHoursLevel3.SelectedIndex = objLevel3.Hours;
drpMinLevel3.SelectedIndex = objLevel3.Min;
}
else
{
selectLevale3.Visible = false;
listLevel3.Visible = true;
radio1Level3.Checked = true;
}
}
public int GetLevel3EscalationTimeInMins(int slaid)
{
int varDays = 0;
int varHours = 0;
int VarMins = 0;
int TotalMins = 0;
objLevel3 = objLevel3.Get_By_Slaid(slaid);
if (objLevel3.Slaid != 0)
{
varDays = objLevel1.Days;
varHours = objLevel1.Hours;
VarMins = objLevel1.Min;
TotalMins = (varDays * 24 * 60) + (varHours * 60) + VarMins;
}
return TotalMins;
}
public int Update_EscalateLevel3_By_id(EscalateLevel3 objEscalateLevel3)
{
return (int)ExecuteNonQuery(sp_EscalateLevel3_mst_Update, new object[] { objEscalateLevel3.Slaid, objEscalateLevel3.Min, objEscalateLevel3.Level3id, objEscalateLevel3.Hours, objEscalateLevel3.Emailid, objEscalateLevel3.Days, objEscalateLevel3.Before, objEscalateLevel3.After });
}
public int Insert_EscalateLevel3(EscalateLevel3 objEscalateLevel3)
{
return (int)ExecuteNonQuery(sp_EscalateLevel3_mst_Insert, new object[] { objEscalateLevel3.Slaid, objEscalateLevel3.Min, objEscalateLevel3.Hours, objEscalateLevel3.Emailid, objEscalateLevel3.Days, objEscalateLevel3.Before, objEscalateLevel3.After });
}
public object GenerateEscalateLevel3Object(ref IDataReader returnData)
{
EscalateLevel3 obj = new EscalateLevel3();
while (returnData.Read())
{
obj.Slaid = (int)returnData["Slaid"];
obj.Min = (int)returnData["Min"];
obj.Level3id = (int)returnData["Level3id"];
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 GenerateEscalateLevel3Collection(ref IDataReader returnData)
{
BLLCollection<EscalateLevel3> col = new BLLCollection<EscalateLevel3>();
while (returnData.Read())
{
EscalateLevel3 obj = new EscalateLevel3();
obj.Slaid = (int)returnData["Slaid"];
obj.Min = (int)returnData["Min"];
obj.Level3id = (int)returnData["Level3id"];
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;
}
