public string GetResolutionTimeInHours(int slaid) { int varDays = 0; int varHours = 0; int VarMins = 0; int TotalHours = 0; string total = ""; objSlaPriority = objSlaPriority.Get_By_id(slaid); if (objSlaPriority.Slaid != 0) { varDays = objSlaPriority.Resolutiondays; varHours = objSlaPriority.Resolutionhours; VarMins = objSlaPriority.Resolutionmin; if (VarMins <= 0) { TotalHours = (varDays * 24) + (varHours); total = TotalHours.ToString() + " " + "Hours"; } else { TotalHours = (varDays * 24) + (varHours); total = TotalHours.ToString() + " " + "Hours" + VarMins + " " + "Minutes"; } } return(total); }
public string GetResolutionTimeInHours(int slaid) { int varDays = 0; int varHours = 0; int VarMins = 0; int TotalHours = 0; string total=""; objSlaPriority = objSlaPriority.Get_By_id(slaid); if (objSlaPriority.Slaid != 0) { varDays = objSlaPriority.Resolutiondays; varHours = objSlaPriority.Resolutionhours; VarMins = objSlaPriority.Resolutionmin; if (VarMins <= 0) { TotalHours = (varDays * 24) + (varHours); total = TotalHours.ToString()+" "+"Hours"; } else { TotalHours = (varDays * 24) + (varHours); total = TotalHours.ToString() + " " + "Hours" + VarMins + " " +"Minutes"; } } return total; }
protected void Update() { int Slaid = Convert.ToInt32(Request.QueryString[0]); objSla = objSla.Get_By_id(Slaid); if (objSla.Slaid != 0) { int siteid = objSla.Siteid; objSite = objSite.Get_By_id(siteid); if (objSite.Siteid != 0) { lblSite.Text = objSite.Sitename; } txtSlaName.Text = objSla.Slaname.ToString().Trim(); txtDescription.Text = objSla.Description.ToString().Trim(); objSlaPriority = objSlaPriority.Get_By_id(objSla.Slaid); if (objSlaPriority.Priorityid != 0) { objPriority = objPriority.Get_By_id(objSlaPriority.Priorityid); if (objPriority.Priorityid != 0) { lblPriority.Text = objPriority.Name.ToString().Trim(); drphr.SelectedValue = Convert.ToString(objSlaPriority.Resolutionhours); drpMin.SelectedValue = Convert.ToString(objSlaPriority.Resolutionmin); txtDays.Text = Convert.ToString(objSlaPriority.Resolutiondays); } } } }
public int GetResolutionTimeInMins(int slaid) { int varDays = 0; int varHours = 0; int VarMins = 0; int TotalMins = 0; objSlaPriority = objSlaPriority.Get_By_id(slaid); if (objSlaPriority.Slaid != 0) { varDays = objSlaPriority.Resolutiondays; varHours = objSlaPriority.Resolutionhours; VarMins = objSlaPriority.Resolutionmin; TotalMins = (varDays * 24 * 60) + (varHours * 60) + VarMins; } return(TotalMins); }
protected void btnUpdate_Click(object sender, EventArgs e) { bool FlagEscalateLevel1 = true; bool FlagEscalateLevel2 = true; bool FlagEscalateLevel3 = true; lblErrorTimeSelect.Text = ""; if (txtDays.Text == "0" && drphr.SelectedValue == "0" && drpMin.SelectedValue == "0") { lblErrorTimeSelect.Text = Resources.MessageResource.errResTime.ToString(); } else { if (chkLevel1.Checked == true) { if (radio1Level1.Checked == true) { int varTotalTime = calculateTotalminutes(); int varTotalTimeLevel1 = calculateTotalminutesLevel1(); if (varTotalTimeLevel1 > varTotalTime) { FlagEscalateLevel1 = false; } } if (radio2Level1.Checked == true) { int varTotalTime = calculateTotalminutes(); int varTotalTimeLevel1 = calculateTotalminutesLevel1(); //if (varTotalTimeLevel1 < varTotalTime) //{ // FlagEscalateLevel1 = false; //} } } if (chkLevel2.Checked == true) { if (radio1Level2.Checked == true) { int varTotalTime = calculateTotalminutes(); int varTotalTimeLevel2 = calculateTotalminutesLevel2(); if (varTotalTimeLevel2 > varTotalTime) { FlagEscalateLevel2 = false; } } if (radio2Level2.Checked == true) { int varTotalTime = calculateTotalminutes(); int varTotalTimeLevel2 = calculateTotalminutesLevel2(); //if (varTotalTimeLevel2 < varTotalTime) //{ // FlagEscalateLevel2 = false; //} } } if (chkLevel3.Checked == true) { if (radio1Level3.Checked == true) { int varTotalTime = calculateTotalminutes(); int varTotalTimeLevel3 = calculateTotalminutesLevel3(); if (varTotalTimeLevel3 > varTotalTime) { FlagEscalateLevel3 = false; } } if (radio2Level3.Checked == true) { int varTotalTime = calculateTotalminutes(); int varTotalTimeLevel3 = calculateTotalminutesLevel3(); //if (varTotalTimeLevel3 < varTotalTime) //{ // FlagEscalateLevel3 = false; //} } } int Slaid = Convert.ToInt32(Request.QueryString[0]); objSla = objSla.Get_By_id(Slaid); if (objSla.Slaid != 0) { if (FlagEscalateLevel1 == true && FlagEscalateLevel2 == true && FlagEscalateLevel3 == true) { if (chkLevel1.Checked == true) { UpdateLevel1Escalate(Slaid); } else { UncheckedLevel1Escalate(Slaid); } if (chkLevel2.Checked == true) { UpdateLevel2Escalate(Slaid); } else { UncheckedLevel2Escalate(Slaid); } if (chkLevel3.Checked == true) { UpdateLevel3Escalate(Slaid); } else { UncheckedLevel3Escalate(Slaid); } if (objSla.Slaname == txtSlaName.Text.ToString().Trim()) { objSla.Description = txtDescription.Text.ToString().Trim(); objSlaPriority = objSlaPriority.Get_By_id(objSla.Slaid); if (objSlaPriority.Slaid != 0) { objSlaPriority.Resolutiondays = Convert.ToInt32(txtDays.Text); objSlaPriority.Resolutionhours = Convert.ToInt32(drphr.SelectedValue); objSlaPriority.Resolutionmin = Convert.ToInt32(drpMin.SelectedValue); objSla.Update(); objSlaPriority.Update(); Response.Redirect("~/admin/ViewSla.aspx"); } } else { SLA_mst objSLa1 = new SLA_mst(); objSLa1 = objSla.Get_By_SLAName(txtSlaName.Text.ToString().Trim(), objSla.Siteid); if (objSLa1.Slaid == 0) { objSla.Slaname = txtSlaName.Text.ToString().Trim(); objSla.Description = txtDescription.Text.ToString().Trim(); objSlaPriority = objSlaPriority.Get_By_id(objSla.Slaid); if (objSlaPriority.Slaid != 0) { objSlaPriority.Resolutiondays = Convert.ToInt32(txtDays.Text); objSlaPriority.Resolutionhours = Convert.ToInt32(drphr.SelectedValue); objSlaPriority.Resolutionmin = Convert.ToInt32(drpMin.SelectedValue); objSla.Update(); objSlaPriority.Update(); Response.Redirect("~/admin/ViewSla.aspx"); } } else { lblErrorMsg.Text = Resources.MessageResource.errSLAExist.ToString(); } } } else { if (FlagEscalateLevel1 == false) { lblErrorMsg.Text = Resources.MessageResource.strLevel1.ToString(); } if (FlagEscalateLevel2 == false) { lblErrorMsg.Text = Resources.MessageResource.strLevel2.ToString(); } if (FlagEscalateLevel3 == false) { lblErrorMsg.Text = Resources.MessageResource.strLevel3.ToString(); } } } else { lblErrorMsg.Text = Resources.MessageResource.errOccured.ToString(); } } }
protected void Update() { int Slaid = Convert.ToInt32(Request.QueryString[0]); objSla = objSla.Get_By_id(Slaid); if (objSla.Slaid!=0) { int siteid = objSla.Siteid; objSite = objSite.Get_By_id(siteid); if (objSite.Siteid !=0) { lblSite.Text = objSite.Sitename; } txtSlaName.Text = objSla.Slaname.ToString().Trim(); txtDescription.Text = objSla.Description.ToString().Trim(); objSlaPriority = objSlaPriority.Get_By_id(objSla.Slaid); if (objSlaPriority.Priorityid!=0) { objPriority= objPriority.Get_By_id(objSlaPriority.Priorityid); if (objPriority.Priorityid!=0) { lblPriority.Text = objPriority.Name.ToString().Trim(); drphr.SelectedValue = Convert.ToString(objSlaPriority.Resolutionhours); drpMin.SelectedValue = Convert.ToString(objSlaPriority.Resolutionmin); txtDays.Text = Convert.ToString(objSlaPriority.Resolutiondays); } } } }
protected void btnSave_Click(object sender, EventArgs e) { // Declare local variable varsiteid,FlagInsertSla and FlagStatus int varsiteid; ServiceWindow_mst objservicewindow = new ServiceWindow_mst(); varsiteid = Convert.ToInt16(drpSites.SelectedValue); int count = objservicewindow.Get_ServiceWindow_By_Siteid(varsiteid); if (count >= 1) { int FlagInsertSla; int FlagStatus; bool FlagEscalateLevel1 = true; bool FlagEscalateLevel2 = true; bool FlagEscalateLevel3 = true; lblErrorTimeSelect.Text = ""; if (txtDays.Text == "0" && drphr.SelectedValue == "0" && drpMin.SelectedValue == "0") { lblErrorTimeSelect.Text = Resources.MessageResource.errResTime.ToString(); } else { if (chkLevel1.Checked == true) { if (radio1Level1.Checked == true) { int varTotalTime = calculateTotalminutes(); int varTotalTimeLevel1 = calculateTotalminutesLevel1(); if (varTotalTimeLevel1 > varTotalTime) { FlagEscalateLevel1 = false; } } if (radio2Level1.Checked == true) { int varTotalTime = calculateTotalminutes(); int varTotalTimeLevel1 = calculateTotalminutesLevel1(); if (varTotalTimeLevel1 == 0) { FlagEscalateLevel1 = false; } } } if (chkLevel2.Checked == true) { if (radio1Level2.Checked == true) { int varTotalTime = calculateTotalminutes(); int varTotalTimeLevel2 = calculateTotalminutesLevel2(); if (varTotalTimeLevel2 > varTotalTime) { FlagEscalateLevel2 = false; } } if (radio2Level2.Checked == true) { int varTotalTime = calculateTotalminutes(); int varTotalTimeLevel2 = calculateTotalminutesLevel2(); if (varTotalTimeLevel2 == 0) { FlagEscalateLevel2 = false; } } } if (chkLevel3.Checked == true) { if (radio1Level3.Checked == true) { int varTotalTime = calculateTotalminutes(); int varTotalTimeLevel3 = calculateTotalminutesLevel3(); if (varTotalTimeLevel3 > varTotalTime) { FlagEscalateLevel3 = false; } } if (radio2Level3.Checked == true) { int varTotalTime = calculateTotalminutes(); int varTotalTimeLevel3 = calculateTotalminutesLevel3(); if (varTotalTimeLevel3 == 0) { FlagEscalateLevel3 = false; } } } // get sitetd from dropdown to variable varsiteid // Check SLA Definition is exist in database with same name and site objSla = objSla.Get_By_SLAName(txtSlaName.Text.ToString().Trim(), varsiteid); // Check SLA Priority definition is exist in databse with siteid and priorityid objSlaPriority = objSlaPriority.Get_By_Siteid(varsiteid, Convert.ToInt16(drpPriority.SelectedValue)); // if both objSla.Siteid and objSlaPriority.Slaid is zero then,No SLA Definition is exist in database if (objSla.Siteid == 0 && objSlaPriority.Slaid == 0) { if (FlagEscalateLevel1 == true && FlagEscalateLevel2 == true && FlagEscalateLevel3 == true) { objSla.Siteid = varsiteid; objSla.Slaname = txtSlaName.Text.ToString().Trim(); objSla.Createdatetime = DateTime.Now.ToString(); objSla.Enable = true; objSla.Description = txtDescription.Text.ToString().Trim(); // Call objSla.Insert() to insert records in database FlagInsertSla = objSla.Insert(); // If FlagInsertSla is 1 then record insert in database successfully if (FlagInsertSla == 1) { // Call Function objSla.Get_By_SLAName() to get Slaid of created sla objSla = objSla.Get_By_SLAName(txtSlaName.Text.ToString().Trim(), varsiteid); if (objSla.Siteid != 0) { // declare local variable FlagInsertPriority int FlagInsertPriority; objSlaPriority.Slaid = objSla.Slaid; objSlaPriority.Siteid = varsiteid; objSlaPriority.Priorityid = Convert.ToInt16(drpPriority.SelectedValue); objSlaPriority.Resolutiondays = Convert.ToInt16(txtDays.Text); objSlaPriority.Resolutionhours = Convert.ToInt16(drphr.SelectedValue); objSlaPriority.Resolutionmin = Convert.ToInt16(drpMin.SelectedValue); // Call function objSlaPriority.Insert() to insert records in SLA_Priority_mst FlagInsertPriority = objSlaPriority.Insert(); // if FlagInsertPriority is not zero then records insert successfully if (FlagInsertPriority != 0) { //lblErrorMsg.Text = Resources.MessageResource.errSLADef.ToString(); if (chkLevel1.Checked == true) { InsertIntoLevel1(objSla.Slaid); } if (chkLevel2.Checked == true) { InsertIntoLevel2(objSla.Slaid); } if (chkLevel3.Checked == true) { InsertIntoLevel3(objSla.Slaid); } Clear(); Response.Redirect("~/admin/viewsla.aspx"); //CheckDefaultValueForEscalation(); } else { // Call objSla.Delete to delete record from SLA_mst to delete sla definition,because some error occurred in SLA_Priority_mst objSla.Delete(objSla.Slaid); // Display Error message some error occurred lblErrorMsg.Text = Resources.MessageResource.errOccured.ToString(); } } } } else { if (FlagEscalateLevel1 == false) { lblErrorMsg.Text = Resources.MessageResource.strLevel1.ToString(); } if (FlagEscalateLevel2 == false) { lblErrorMsg.Text = Resources.MessageResource.strLevel2.ToString(); } if (FlagEscalateLevel3 == false) { lblErrorMsg.Text = Resources.MessageResource.strLevel3.ToString(); } } } else { lblErrorMsg.Text = Resources.MessageResource.errSLAExist.ToString(); } } } else { lblErrorMsg.Text = "Service Window not set for this Site,Set the Service Window for this Site"; } }
protected void btnSave_Click(object sender, EventArgs e) { // Declare local variable varsiteid,FlagInsertSla and FlagStatus int varsiteid; ServiceWindow_mst objservicewindow = new ServiceWindow_mst(); varsiteid = Convert.ToInt16(drpSites.SelectedValue); int count = objservicewindow.Get_ServiceWindow_By_Siteid(varsiteid); if (count >= 1) { int FlagInsertSla; int FlagStatus; bool FlagEscalateLevel1 = true; bool FlagEscalateLevel2 = true; bool FlagEscalateLevel3 = true; lblErrorTimeSelect.Text = ""; if (txtDays.Text == "0" && drphr.SelectedValue == "0" && drpMin.SelectedValue == "0") { lblErrorTimeSelect.Text = Resources.MessageResource.errResTime.ToString(); } else { if (chkLevel1.Checked == true) { if (radio1Level1.Checked == true) { int varTotalTime = calculateTotalminutes(); int varTotalTimeLevel1 = calculateTotalminutesLevel1(); if (varTotalTimeLevel1 > varTotalTime) { FlagEscalateLevel1 = false; } } if (radio2Level1.Checked == true) { int varTotalTime = calculateTotalminutes(); int varTotalTimeLevel1 = calculateTotalminutesLevel1(); if (varTotalTimeLevel1 ==0) { FlagEscalateLevel1 = false; } } } if (chkLevel2.Checked == true) { if (radio1Level2.Checked == true) { int varTotalTime = calculateTotalminutes(); int varTotalTimeLevel2 = calculateTotalminutesLevel2(); if (varTotalTimeLevel2 > varTotalTime) { FlagEscalateLevel2 = false; } } if (radio2Level2.Checked == true) { int varTotalTime = calculateTotalminutes(); int varTotalTimeLevel2 = calculateTotalminutesLevel2(); if (varTotalTimeLevel2 == 0) { FlagEscalateLevel2 = false; } } } if (chkLevel3.Checked == true) { if (radio1Level3.Checked == true) { int varTotalTime = calculateTotalminutes(); int varTotalTimeLevel3 = calculateTotalminutesLevel3(); if (varTotalTimeLevel3 > varTotalTime) { FlagEscalateLevel3 = false; } } if (radio2Level3.Checked == true) { int varTotalTime = calculateTotalminutes(); int varTotalTimeLevel3 = calculateTotalminutesLevel3(); if (varTotalTimeLevel3 == 0) { FlagEscalateLevel3 = false; } } } // get sitetd from dropdown to variable varsiteid // Check SLA Definition is exist in database with same name and site objSla = objSla.Get_By_SLAName(txtSlaName.Text.ToString().Trim(), varsiteid); // Check SLA Priority definition is exist in databse with siteid and priorityid objSlaPriority = objSlaPriority.Get_By_Siteid(varsiteid, Convert.ToInt16(drpPriority.SelectedValue)); // if both objSla.Siteid and objSlaPriority.Slaid is zero then,No SLA Definition is exist in database if (objSla.Siteid == 0 && objSlaPriority.Slaid == 0) { if (FlagEscalateLevel1 == true && FlagEscalateLevel2 == true && FlagEscalateLevel3 == true) { objSla.Siteid = varsiteid; objSla.Slaname = txtSlaName.Text.ToString().Trim(); objSla.Createdatetime = DateTime.Now.ToString(); objSla.Enable = true; objSla.Description = txtDescription.Text.ToString().Trim(); // Call objSla.Insert() to insert records in database FlagInsertSla = objSla.Insert(); // If FlagInsertSla is 1 then record insert in database successfully if (FlagInsertSla == 1) { // Call Function objSla.Get_By_SLAName() to get Slaid of created sla objSla = objSla.Get_By_SLAName(txtSlaName.Text.ToString().Trim(), varsiteid); if (objSla.Siteid != 0) { // declare local variable FlagInsertPriority int FlagInsertPriority; objSlaPriority.Slaid = objSla.Slaid; objSlaPriority.Siteid = varsiteid; objSlaPriority.Priorityid = Convert.ToInt16(drpPriority.SelectedValue); objSlaPriority.Resolutiondays = Convert.ToInt16(txtDays.Text); objSlaPriority.Resolutionhours = Convert.ToInt16(drphr.SelectedValue); objSlaPriority.Resolutionmin = Convert.ToInt16(drpMin.SelectedValue); // Call function objSlaPriority.Insert() to insert records in SLA_Priority_mst FlagInsertPriority = objSlaPriority.Insert(); // if FlagInsertPriority is not zero then records insert successfully if (FlagInsertPriority != 0) { //lblErrorMsg.Text = Resources.MessageResource.errSLADef.ToString(); if (chkLevel1.Checked == true) { InsertIntoLevel1(objSla.Slaid); } if (chkLevel2.Checked == true) { InsertIntoLevel2(objSla.Slaid); } if (chkLevel3.Checked == true) { InsertIntoLevel3(objSla.Slaid); } Clear(); Response.Redirect("~/admin/viewsla.aspx"); //CheckDefaultValueForEscalation(); } else { // Call objSla.Delete to delete record from SLA_mst to delete sla definition,because some error occurred in SLA_Priority_mst objSla.Delete(objSla.Slaid); // Display Error message some error occurred lblErrorMsg.Text = Resources.MessageResource.errOccured.ToString(); } } } } else { if (FlagEscalateLevel1 == false) { lblErrorMsg.Text = Resources.MessageResource.strLevel1.ToString(); } if (FlagEscalateLevel2 == false) { lblErrorMsg.Text = Resources.MessageResource.strLevel2.ToString(); } if (FlagEscalateLevel3 == false) { lblErrorMsg.Text = Resources.MessageResource.strLevel3.ToString(); } } } else { lblErrorMsg.Text = Resources.MessageResource.errSLAExist.ToString(); } } } else { lblErrorMsg.Text = "Service Window not set for this Site,Set the Service Window for this Site"; } }
public int GetResolutionTimeInMins(int slaid) { int varDays=0; int varHours=0; int VarMins=0; int TotalMins=0; objSlaPriority = objSlaPriority.Get_By_id(slaid); if (objSlaPriority.Slaid != 0) { varDays = objSlaPriority.Resolutiondays; varHours = objSlaPriority.Resolutionhours; VarMins = objSlaPriority.Resolutionmin; TotalMins = (varDays * 24 * 60) + (varHours * 60) + VarMins; } return TotalMins; }
public int Update_SLA_Priority_mst_By_id(SLA_Priority_mst objSLAPriority) { return (int)ExecuteNonQuery(Sp_SLA_Priority_Update, new object[] { objSLAPriority.Slaid, objSLAPriority.Responsemin, objSLAPriority.Responsehours, objSLAPriority.Responsedays, objSLAPriority.Resolutionmin, objSLAPriority.Resolutionhours, objSLAPriority.Resolutiondays, objSLAPriority.Priorityid, objSLAPriority.Siteid }); }
public object GenerateSLAPriority_mstObject(ref IDataReader returnData) { SLA_Priority_mst obj = new SLA_Priority_mst(); while (returnData.Read()) { obj.Slaid = (int)returnData["Slaid"]; obj.Siteid = (int)returnData["Siteid"]; obj.Priorityid = (int)returnData["Priorityid"]; obj.Resolutiondays = (int)returnData["Resolutiondays"]; obj.Resolutionhours = (int)returnData["Resolutionhours"]; obj.Resolutionmin = (int)returnData["Resolutionmin"]; obj.Responsedays = (int)returnData["Responsedays"]; obj.Responsehours = (int)returnData["Responsehours"]; obj.Responsemin = (int)returnData["Responsemin"]; } returnData.Close(); returnData.Dispose(); return obj; }