protected void btnColorupdate_Click(object sender, EventArgs e) { int colorcount; string colorname = txtcolorname.Text.ToString(); objcolor = objcolor.Get_By_id(colorid); if (objcolor.Colorid!=0) { if (objcolor.Colorname.ToLower() == txtcolorname.Text.ToString().ToLower()) { objcolor.Colorid = colorid; objcolor.Colorname = txtcolorname.Text.ToString(); objcolor.Percnt = Convert.ToInt16(txtPercent.Text); objcolor.Percnt_to = Convert.ToInt16(txtPercentTo.Text); objcolor.CallStatus = txtcallstatus.Text.ToString(); objcolor.Update(); Response.Redirect("../admin/AddcolorScheme.aspx"); } else { colorcount = objcolor.Check_Colorname(colorname); if (colorcount == 0) { objcolor.Colorid = colorid; objcolor.Colorname = txtcolorname.Text.ToString(); objcolor.Percnt = Convert.ToInt16(txtPercent.Text); objcolor.Percnt_to = Convert.ToInt16(txtPercentTo.Text); objcolor.CallStatus = txtcallstatus.Text.ToString(); objcolor.Update(); Response.Redirect("../admin/AddcolorScheme.aspx"); } else { lblErrorMsg.Text = "Color Name Already Exist"; } } } //colorcount = objcolor.Check_Colorname(colorname); //if (colorcount == 0) //{ // objcolor.Colorid = colorid; // objcolor.Colorname = txtcolorname.Text.ToString(); // objcolor.Percnt = Convert.ToInt16(txtPercent.Text); // objcolor.Percnt_to = Convert.ToInt16(txtPercentTo.Text); // objcolor.CallStatus = txtcallstatus.Text.ToString(); // objcolor.Update(); // Response.Redirect("../admin/AddcolorScheme.aspx"); //} //else //{ // lblErrorMsg.Text = "Color Name Already Exist"; //} }
protected void btnColorupdate_Click(object sender, EventArgs e) { int colorcount; string colorname = txtcolorname.Text.ToString(); objcolor = objcolor.Get_By_id(colorid); if (objcolor.Colorid != 0) { if (objcolor.Colorname.ToLower() == txtcolorname.Text.ToString().ToLower()) { objcolor.Colorid = colorid; objcolor.Colorname = txtcolorname.Text.ToString(); objcolor.Percnt = Convert.ToInt16(txtPercent.Text); objcolor.Percnt_to = Convert.ToInt16(txtPercentTo.Text); objcolor.CallStatus = txtcallstatus.Text.ToString(); objcolor.Update(); Response.Redirect("../admin/AddcolorScheme.aspx"); } else { colorcount = objcolor.Check_Colorname(colorname); if (colorcount == 0) { objcolor.Colorid = colorid; objcolor.Colorname = txtcolorname.Text.ToString(); objcolor.Percnt = Convert.ToInt16(txtPercent.Text); objcolor.Percnt_to = Convert.ToInt16(txtPercentTo.Text); objcolor.CallStatus = txtcallstatus.Text.ToString(); objcolor.Update(); Response.Redirect("../admin/AddcolorScheme.aspx"); } else { lblErrorMsg.Text = "Color Name Already Exist"; } } } //colorcount = objcolor.Check_Colorname(colorname); //if (colorcount == 0) //{ // objcolor.Colorid = colorid; // objcolor.Colorname = txtcolorname.Text.ToString(); // objcolor.Percnt = Convert.ToInt16(txtPercent.Text); // objcolor.Percnt_to = Convert.ToInt16(txtPercentTo.Text); // objcolor.CallStatus = txtcallstatus.Text.ToString(); // objcolor.Update(); // Response.Redirect("../admin/AddcolorScheme.aspx"); //} //else //{ // lblErrorMsg.Text = "Color Name Already Exist"; //} }
protected void Page_Load(object sender, EventArgs e) { colorid = Convert.ToInt16(Request.QueryString[0]); if (!IsPostBack) { colorid = Convert.ToInt16(Request.QueryString[0]); objcolor = objcolor.Get_By_id(colorid); txtcolorname.Text = objcolor.Colorname.ToString(); txtPercent.Text = objcolor.Percnt.ToString();; txtPercentTo.Text = objcolor.Percnt_to.ToString(); txtcallstatus.Text = objcolor.CallStatus.ToString(); //reqValcolor.Text = "Enter the Color Name"; //reqValPercent.Text = "Enter Percent Value"; //reqValPercentTo.Text = "Enter the Value of PercentTo"; //reqValcallstatus.Text = "Select Call Status"; } }
protected void grdvwRequest_RowDataBound(Object sender, GridViewRowEventArgs e) { /////Add Exception handilng try catch change by vishal 21-05-2012 try { System.Drawing.ColorConverter colConvert = new ColorConverter(); BLLCollection<ColorScheme_mst> colColor = new BLLCollection<ColorScheme_mst>(); if (e.Row.RowType == DataControlRowType.DataRow) { #region Autogenerate Serial number Label lblSerial = (Label)e.Row.FindControl("lblSerial"); lblSerial.Text = i.ToString(); i++; #endregion int TotalTimeSpentonCall; int TotalResolutionTime; int varIncidentid = Convert.ToInt32(((Label)e.Row.FindControl("incidentid")).Text.ToString()); string varCreateDatetime = e.Row.Cells[9].Text; string varStatusOpen = Resources.MessageResource.strStatusOpen.ToString(); string varStatusClose = Resources.MessageResource.strStatusClose.ToString(); string varStatusOnHold = Resources.MessageResource.strStatusOnHold.ToString(); string varStatusResolved = Resources.MessageResource.strStatusResolved.ToString(); #region Bind Data Row at Run time with requesterid to Requester name int requesterid = Convert.ToInt32(e.Row.Cells[3].Text); //objUser = objUser.Get_By_id(requesterid); objContactmst = objContactmst.Get_By_id(requesterid); //if (objUser.Userid != 0) //{ // e.Row.Cells[3].Text = objUser.Username.ToString(); // //e.Row.Cells[3].Text = objContactmst.Firstname.ToString(); //} //else { e.Row.Cells[3].Text = ""; } //if (objUser.Userid != 0) //{ //e.Row.Cells[3].Text = objUser.Username.ToString(); if (objContactmst.Firstname != null) { e.Row.Cells[3].Text = objContactmst.Firstname.ToString(); } // }else { e.Row.Cells[3].Text = ""; } #endregion #region Bind Datarow at Run Time with Createdbyid to Created by name int createdbyid = Convert.ToInt32(e.Row.Cells[4].Text); objUser = objUser.Get_By_id(createdbyid); if (objUser.Userid != 0) { e.Row.Cells[4].Text = objUser.Username.ToString(); } else { e.Row.Cells[4].Text = ""; } #endregion #region Bind Datarow at Run Time with technicianid to technician name int technicianid = Convert.ToInt32(e.Row.Cells[5].Text); objUser = objUser.Get_By_id(technicianid); if (objUser.Userid != 0) { e.Row.Cells[5].Text = objUser.Username.ToString(); } else { e.Row.Cells[5].Text = ""; } #endregion #region Bind Datarow at run time with Statusid to Status int statusid = Convert.ToInt32(e.Row.Cells[6].Text); objStatus = objStatus.Get_By_id(statusid); if (objStatus.Statusid != 0) { e.Row.Cells[6].Text = objStatus.Statusname.ToString(); } else { e.Row.Cells[6].Text = ""; } #endregion #region Bind Datarow at run time with Priorityid to Priority int priorityid = Convert.ToInt32(e.Row.Cells[7].Text); objPriority = objPriority.Get_By_id(priorityid); if (objPriority.Priorityid != 0) { e.Row.Cells[7].Text = objPriority.Name.ToString(); } else { e.Row.Cells[7].Text = ""; } #endregion #region Bind Datarow at run time with Siteid to Site int siteid = Convert.ToInt32(e.Row.Cells[8].Text); objSite = objSite.Get_By_id(siteid); if (objSite.Siteid != 0) { string custSiteName; int custid = 0; colCustToSite = objCustToSite.Get_All_By_siteid(objSite.Siteid); foreach (CustomerToSiteMapping objCuToSite in colCustToSite) { custid = objCuToSite.Custid; } objCustomer = objCustomer.Get_By_id(custid); e.Row.Cells[8].Text = objCustomer.Customer_name + "/" + objSite.Sitename.ToString(); } else { e.Row.Cells[8].Text = ""; } #endregion #region Apply Color Coding to Open Calls,According to define SLA if (varStatusOpen.ToLower() == objStatus.Statusname.ToString().ToLower()) { Incident_mst obj = new Incident_mst(); obj = obj.Get_By_id(varIncidentid); if (obj.Incidentid != 0) { if (obj.Slaid != 0) { #region Declare local variables,and objects of various classes int percent; ProcessEscalateEmail objPro = new ProcessEscalateEmail(); #endregion #region Get Total Resolution time define for particular SLA and Time Spent on Request TotalResolutionTime = objPro.GetResolutionTimeInMins(obj.Slaid); TotalTimeSpentonCall = objIncident.Get_TimeSpentonRequest(varIncidentid, siteid, varCreateDatetime, DateTime.Now.ToString()); if (TotalTimeSpentonCall < 0) { TotalTimeSpentonCall = 0; } #endregion #region Calculate Percent if (TotalResolutionTime != 0) { percent = (TotalTimeSpentonCall * 100) / TotalResolutionTime; } else { percent = 0; } #endregion ColorScheme_mst objColor = new ColorScheme_mst(); colColor = objColor.Get_All_By_CallStatus(varStatusOpen); foreach (ColorScheme_mst objCol in colColor) { if (objCol.Percnt_to != 0) { if (percent >= objCol.Percnt && percent <= objCol.Percnt_to) { e.Row.BackColor = (System.Drawing.Color)colConvert.ConvertFromString(objCol.Colorname); } } else { if (percent >= objCol.Percnt) { e.Row.BackColor = (System.Drawing.Color)colConvert.ConvertFromString(objCol.Colorname); } } } } else { ColorScheme_mst objColor = new ColorScheme_mst(); colColor = objColor.Get_All_By_CallStatus("NonSLA"); foreach (ColorScheme_mst objCol in colColor) { e.Row.BackColor = (System.Drawing.Color)colConvert.ConvertFromString(objCol.Colorname); } } } } #endregion #region Apply Color Coding to Close Calls if (varStatusClose.ToLower() == objStatus.Statusname.ToString().ToLower()) { ColorScheme_mst objColor = new ColorScheme_mst(); colColor = objColor.Get_All_By_CallStatus(varStatusClose); foreach (ColorScheme_mst obj in colColor) { try { e.Row.BackColor = (System.Drawing.Color)colConvert.ConvertFromString(obj.Colorname); } catch (Exception ex) { e.Row.BackColor = (System.Drawing.Color)colConvert.ConvertFromString("White"); } } } #endregion #region Apply Color Coding to On Hold Calls if (varStatusOnHold.ToLower() == objStatus.Statusname.ToString().ToLower()) { ColorScheme_mst objColor = new ColorScheme_mst(); colColor = objColor.Get_All_By_CallStatus(varStatusOnHold); foreach (ColorScheme_mst obj in colColor) { e.Row.BackColor = (System.Drawing.Color)colConvert.ConvertFromString(obj.Colorname); } } #endregion #region Apply Color Coding to Resolved Calls if (varStatusResolved.ToLower() == objStatus.Statusname.ToString().ToLower()) { ColorScheme_mst objColor = new ColorScheme_mst(); colColor = objColor.Get_All_By_CallStatus(varStatusResolved); foreach (ColorScheme_mst obj in colColor) { e.Row.BackColor = (System.Drawing.Color)colConvert.ConvertFromString(obj.Colorname); } } #endregion } } catch (Exception ex) { string myScript; myScript = "<script language=javascript>alert('Exception - '" + ex + "');</script>"; Page.RegisterClientScriptBlock("MyScript", myScript); return; } }
protected void grdvwRequest_RowDataBound(Object sender, GridViewRowEventArgs e) { System.Drawing.ColorConverter colConvert = new ColorConverter(); BLLCollection <ColorScheme_mst> colColor = new BLLCollection <ColorScheme_mst>(); if (e.Row.RowType == DataControlRowType.DataRow) { #region Autogenerate Serial number Label lblSerial = (Label)e.Row.FindControl("lblSerial"); lblSerial.Text = i.ToString(); i++; #endregion int TotalTimeSpentonCall; int TotalResolutionTime; int varIncidentid = Convert.ToInt16(((Label)e.Row.FindControl("incidentid")).Text.ToString()); string varCreateDatetime = e.Row.Cells[9].Text; string varStatusOpen = Resources.MessageResource.strStatusOpen.ToString(); string varStatusClose = Resources.MessageResource.strStatusClose.ToString(); string varStatusOnHold = Resources.MessageResource.strStatusOnHold.ToString(); string varStatusResolved = Resources.MessageResource.strStatusResolved.ToString(); #region Bind Data Row at Run time with requesterid to Requester name int requesterid = Convert.ToInt16(e.Row.Cells[3].Text); objUser = objUser.Get_By_id(requesterid); if (objUser.Userid != 0) { e.Row.Cells[3].Text = objUser.Username.ToString(); } else { e.Row.Cells[3].Text = ""; } #endregion #region Bind Datarow at Run Time with Createdbyid to Created by name int createdbyid = Convert.ToInt16(e.Row.Cells[4].Text); objUser = objUser.Get_By_id(createdbyid); if (objUser.Userid != 0) { e.Row.Cells[4].Text = objUser.Username.ToString(); } else { e.Row.Cells[4].Text = ""; } #endregion #region Bind Datarow at Run Time with technicianid to technician name int technicianid = Convert.ToInt16(e.Row.Cells[5].Text); objUser = objUser.Get_By_id(technicianid); if (objUser.Userid != 0) { e.Row.Cells[5].Text = objUser.Username.ToString(); } else { e.Row.Cells[5].Text = ""; } #endregion #region Bind Datarow at run time with Statusid to Status int statusid = Convert.ToInt16(e.Row.Cells[6].Text); objStatus = objStatus.Get_By_id(statusid); if (objStatus.Statusid != 0) { e.Row.Cells[6].Text = objStatus.Statusname.ToString(); } else { e.Row.Cells[6].Text = ""; } #endregion #region Bind Datarow at run time with Priorityid to Priority int priorityid = Convert.ToInt16(e.Row.Cells[7].Text); objPriority = objPriority.Get_By_id(priorityid); if (objPriority.Priorityid != 0) { e.Row.Cells[7].Text = objPriority.Name.ToString(); } else { e.Row.Cells[7].Text = ""; } #endregion #region Bind Datarow at run time with Siteid to Site int siteid = Convert.ToInt16(e.Row.Cells[8].Text); objSite = objSite.Get_By_id(siteid); if (objSite.Siteid != 0) { string custSiteName; int custid = 0; colCustToSite = objCustToSite.Get_All_By_siteid(objSite.Siteid); foreach (CustomerToSiteMapping objCuToSite in colCustToSite) { custid = objCuToSite.Custid; } objCustomer = objCustomer.Get_By_id(custid); e.Row.Cells[8].Text = objCustomer.Customer_name + "/" + objSite.Sitename.ToString(); } else { e.Row.Cells[8].Text = ""; } #endregion #region Apply Color Coding to Open Calls,According to define SLA if (varStatusOpen.ToLower() == objStatus.Statusname.ToString().ToLower()) { Incident_mst obj = new Incident_mst(); obj = obj.Get_By_id(varIncidentid); if (obj.Incidentid != 0) { if (obj.Slaid != 0) { #region Declare local variables,and objects of various classes int percent; ProcessEscalateEmail objPro = new ProcessEscalateEmail(); #endregion #region Get Total Resolution time define for particular SLA and Time Spent on Request TotalResolutionTime = objPro.GetResolutionTimeInMins(obj.Slaid); TotalTimeSpentonCall = objIncident.Get_TimeSpentonRequest(varIncidentid, siteid, varCreateDatetime, DateTime.Now.ToString()); if (TotalTimeSpentonCall < 0) { TotalTimeSpentonCall = 0; } #endregion #region Calculate Percent percent = (TotalTimeSpentonCall * 100) / TotalResolutionTime; #endregion ColorScheme_mst objColor = new ColorScheme_mst(); colColor = objColor.Get_All_By_CallStatus(varStatusOpen); foreach (ColorScheme_mst objCol in colColor) { if (objCol.Percnt_to != 0) { if (percent >= objCol.Percnt && percent <= objCol.Percnt_to) { e.Row.BackColor = (System.Drawing.Color)colConvert.ConvertFromString(objCol.Colorname); } } else { if (percent >= objCol.Percnt) { e.Row.BackColor = (System.Drawing.Color)colConvert.ConvertFromString(objCol.Colorname); } } } } else { ColorScheme_mst objColor = new ColorScheme_mst(); colColor = objColor.Get_All_By_CallStatus("NonSLA"); foreach (ColorScheme_mst objCol in colColor) { e.Row.BackColor = (System.Drawing.Color)colConvert.ConvertFromString(objCol.Colorname); } } } } #endregion #region Apply Color Coding to Close Calls if (varStatusClose.ToLower() == objStatus.Statusname.ToString().ToLower()) { ColorScheme_mst objColor = new ColorScheme_mst(); colColor = objColor.Get_All_By_CallStatus(varStatusClose); foreach (ColorScheme_mst obj in colColor) { try { e.Row.BackColor = (System.Drawing.Color)colConvert.ConvertFromString(obj.Colorname); } catch (Exception ex) { e.Row.BackColor = (System.Drawing.Color)colConvert.ConvertFromString("White"); } } } #endregion #region Apply Color Coding to On Hold Calls if (varStatusOnHold.ToLower() == objStatus.Statusname.ToString().ToLower()) { ColorScheme_mst objColor = new ColorScheme_mst(); colColor = objColor.Get_All_By_CallStatus(varStatusOnHold); foreach (ColorScheme_mst obj in colColor) { e.Row.BackColor = (System.Drawing.Color)colConvert.ConvertFromString(obj.Colorname); } } #endregion #region Apply Color Coding to Resolved Calls if (varStatusResolved.ToLower() == objStatus.Statusname.ToString().ToLower()) { ColorScheme_mst objColor = new ColorScheme_mst(); colColor = objColor.Get_All_By_CallStatus(varStatusResolved); foreach (ColorScheme_mst obj in colColor) { e.Row.BackColor = (System.Drawing.Color)colConvert.ConvertFromString(obj.Colorname); } } #endregion } }
protected void Page_Load(object sender, EventArgs e) { colorid = Convert.ToInt16(Request.QueryString[0]); if (!IsPostBack) { colorid = Convert.ToInt16(Request.QueryString[0]); objcolor = objcolor.Get_By_id(colorid); txtcolorname.Text = objcolor.Colorname.ToString(); txtPercent.Text = objcolor.Percnt.ToString(); ; txtPercentTo.Text = objcolor.Percnt_to.ToString(); txtcallstatus.Text = objcolor.CallStatus.ToString(); //reqValcolor.Text = "Enter the Color Name"; //reqValPercent.Text = "Enter Percent Value"; //reqValPercentTo.Text = "Enter the Value of PercentTo"; //reqValcallstatus.Text = "Select Call Status"; } }
public int Update_ColorScheme_mst_By_id(ColorScheme_mst objColorScheme_mst) { return (int)ExecuteNonQuery(sp_ColorScheme_Update, new object[] { objColorScheme_mst.Percnt, objColorScheme_mst.Colorname, objColorScheme_mst.Colorid, objColorScheme_mst.Percnt_to, objColorScheme_mst.CallStatus }); }
public int Insert_ColorScheme_mst(ColorScheme_mst objColorScheme_mst) { return (int)ExecuteNonQuery(sp_ColorScheme_Insert, new object[] { objColorScheme_mst.Percnt, objColorScheme_mst.Colorname, objColorScheme_mst.Percnt_to, objColorScheme_mst.CallStatus }); }
public object GenerateColorScheme_mstObject(ref IDataReader returnData) { ColorScheme_mst obj = new ColorScheme_mst(); while (returnData.Read()) { obj.Colorid = (int)returnData["Colorid"]; obj.Percnt = (int)returnData["Percnt"]; obj.Percnt_to = (int)returnData["Percnt_to"]; obj.Colorname = (string)returnData["Colorname"]; obj.CallStatus = (string)returnData["CallStatus"]; } returnData.Close(); returnData.Dispose(); return obj; }
public CollectionBase GenerateColorScheme_mstCollection(ref IDataReader returnData) { BLLCollection<ColorScheme_mst> col = new BLLCollection<ColorScheme_mst>(); while (returnData.Read()) { ColorScheme_mst obj = new ColorScheme_mst(); obj.Colorid = (int)returnData["Colorid"]; obj.Percnt = (int)returnData["Percnt"]; obj.Percnt_to = (int)returnData["Percnt_to"]; obj.Colorname = (string)returnData["Colorname"]; obj.CallStatus = (string)returnData["CallStatus"]; col.Add(obj); } returnData.Close(); returnData.Dispose(); return col; }