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