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