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); } } } }
string GetSLAName(int slaid) { string SLAname = ""; objSLA = objSLA.Get_By_id(slaid); if (objSLA.Slaid != 0) { SLAname = objSLA.Slaname; } return SLAname; }
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 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 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"; } }
public int Update_SLA_mst_By_id(SLA_mst objSLA) { return (int)ExecuteNonQuery(Sp_SLA_Update, new object[] { objSLA.Slaname, objSLA.Slaid, objSLA.Siteid, objSLA.Enable, objSLA.Createdatetime, objSLA.Description }); }
public int Insert_SLA_mst(SLA_mst objSLA) { return (int)ExecuteNonQuery(Sp_SLA_Insert, new object[] { objSLA.Slaname, objSLA.Slaid, objSLA.Siteid, objSLA.Enable, objSLA.Createdatetime, objSLA.Description }); }
public object GenerateSLA_mstObject(ref IDataReader returnData) { SLA_mst obj = new SLA_mst(); while (returnData.Read()) { DateTime Mydatetime = new DateTime(); obj.Slaid = (int)returnData["Slaid"]; obj.Siteid = (int)returnData["Siteid"]; obj.Slaname = (string)returnData["Slaname"]; obj.Description = (string)returnData["Description"]; obj.Enable = (bool)returnData["Enable"]; Mydatetime = (DateTime)returnData["Createdatetime"]; obj.Createdatetime = Mydatetime.ToString(); } returnData.Close(); returnData.Dispose(); return obj; }
public CollectionBase GenerateSLA_mstCollection(ref IDataReader returnData) { BLLCollection<SLA_mst> col = new BLLCollection<SLA_mst>(); while (returnData.Read()) { SLA_mst obj = new SLA_mst(); obj.Slaid = (int)returnData["Slaid"]; obj.Siteid = (int)returnData["Siteid"]; obj.Slaname = (String)returnData["Slaname"]; obj.Description = (string)returnData["description"]; obj.Enable = (bool)returnData["Enable"]; DateTime Mydatetime = new DateTime(); Mydatetime = (DateTime)returnData["Createdatetime"]; obj.Createdatetime = Mydatetime.ToString(); col.Add(obj); } returnData.Close(); returnData.Dispose(); return col; }