protected void Page_Load(object sender, EventArgs e)
{
//Add Exception handilng try catch change by vishal 21-05-2012
try
{
if (!IsPostBack)
{
int problemid = Convert.ToInt32(Request.QueryString[1]);
int flag = Convert.ToInt32(Request.QueryString[0]);
Objproblem = Objproblem.Get_By_id(problemid);
txtTitle.Text = Objproblem.title.ToString();
BindDrpCategory();
if (flag == 3)
{
updateSolution();
}
if (flag == 4)
{
updateWorkaround();
}
}
}
catch (Exception ex)
{
string myScript;
myScript = "<script language=javascript>alert('Exception - '" + ex + "');</script>";
Page.RegisterClientScriptBlock("MyScript", myScript);
return;
}
}
public void SentMailToTechnicianForProblemCall(int problemid, int userid)
{
string strYourSinscerely = Resources.MessageResource.strYourSinscerely.ToString();
string strContactNumber = Resources.MessageResource.strContactNumber.ToString();
Problem_mst objProblem = new Problem_mst();
objUser = objUser.Get_By_id(userid);
ContactInfo_mst objCont_info = new ContactInfo_mst();
objCont_info = objCont_info.Get_By_id(objUser.Userid);
objProblem = objProblem.Get_By_id(problemid);
objPriority = objPriority.Get_By_id(objProblem.Priorityid);
UserLogin_mst objReq = new UserLogin_mst();
objReq = objReq.Get_By_id(objProblem.Requesterid);
ContactInfo_mst objReqCont = new ContactInfo_mst();
objReqCont = objReqCont.Get_By_id(objReq.Userid);
objSDE = objSDE.Get_By_id(objProblem.CreatedByid);
if (objCont_info.Emailid != null)
{
obj.To = objCont_info.Emailid;
obj.From = Resources.MessageResource.strAdminEmail.ToString();
obj.Subject = " New Problem Call Assigned to you. Problem Id : " + problemid;
obj.Body = "Dear " + objUser.Username + "," + "<br/> A Call with the following details have been assigned to you.<br/><br/><b>Problem Details : </b> <br/><br/><b>Problem Id :</b>" + objProblem.ProblemId + "<br/><b>Title of Call :</b>" + objProblem.title + " <br/><b>Logged Date & Time   :</b>" + objProblem.CreateDatetime + "<br/><b>Description :</b>" + objProblem.Description + "<br/><b>Priority :</b> " + objPriority.Name + "<br/><b>UserName :</b>" + objReq.Username + "<br/><b>Mobile No. :<b/>" + objReqCont.Mobile + "<br/><b>Landline No. :<b/>" + objReqCont.Landline + "<br/><b>Mail Address :</b>" + objReqCont.Emailid + "<br/><b>Service Desk Executive :</b>" + objSDE.Username + "<br/><br/> For any other support kindly get in touch with us at <b>" + strContactNumber + "</b>.<br/><br/> <b>This is an auto generated mail. Please do not reply.</b><br/><br/><b>Yours sincerely,</b><br/> <b>" + strYourSinscerely + "</b>";
obj.SmtpServer = obj.SmtpServer = Resources.MessageResource.strSMTPServer.ToString();
obj.SentMail();
}
}
protected void btnCancell_Click(object sender, EventArgs e)
{//Add Exception handilng try catch change by vishal 21-05-2012
try
{
#region Fetch Each Row from GridView,and Check Which Check Box is Selected
foreach (GridViewRow gv in grdvwProblem.Rows)
{
string gvIDs;
#region Declare local variable deleteChkBxItem of Checkbox type to get the Checkbox Instance of Grid Row
CheckBox deleteChkBxItem = (CheckBox)gv.FindControl("deleteRec");
#endregion
#region If deleteChkBxItem is Checked then ,mapped Current site to this user
if (deleteChkBxItem.Checked)
{
#region Declare local Variables
int Problemid;
int varSiteid;
int oldtechnicianvalue;
#endregion
#region Get the Problemid from variable of Label type declare in GridView of grdvwSite
gvIDs = ((Label)gv.FindControl("Problemid")).Text.ToString();
#endregion
#region Convert to incident id into integer
Problemid = Convert.ToInt32(gvIDs);
#endregion
#region If Incident id in Not Null
if (gvIDs != "")
{
Problem_mst Obj = new Problem_mst();
Obj = ObjProblem.Get_By_id(Problemid);
if (Obj.ProblemId != 0)
{
Obj.Active = false;
Obj.Update();
}
}
#endregion
}
#endregion
}
BindGridForAllParameter();
#endregion
}
catch (Exception ex)
{
string myScript;
myScript = "<script language=javascript>alert('Exception - '" + ex + "');</script>";
Page.RegisterClientScriptBlock("MyScript", myScript);
return;
}
}
protected void Showvalues()
{
int problemid = Convert.ToInt16(Session["problemid"]);
ObjProblem = ObjProblem.Get_By_id(problemid);
drpTechnician.SelectedValue = ObjProblem.Technicianid.ToString();
drpCategory.SelectedValue = ObjProblem.Categoryid.ToString();
BindDropSubCategory();
drpSubcategory.SelectedValue = ObjProblem.Subcategoryid.ToString();
drpPriority.SelectedValue = ObjProblem.Priorityid.ToString();
txtTitle.Text = ObjProblem.title.ToString();
txtDescription.Text = ObjProblem.Description.ToString();
ObjUserLogin = ObjUserLogin.Get_By_id(ObjProblem.Requesterid);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
int problemid = Convert.ToInt16(Request.QueryString[1]);
int flag = Convert.ToInt16(Request.QueryString[0]);
Objproblem = Objproblem.Get_By_id(problemid);
txtTitle.Text = Objproblem.title.ToString();
BindDrpCategory();
if (flag == 3)
{
updateSolution();
}
if (flag == 4)
{
updateWorkaround();
}
}
}
protected void btnCancell_Click(object sender, EventArgs e)
{
#region Fetch Each Row from GridView,and Check Which Check Box is Selected
foreach (GridViewRow gv in grdvwProblem.Rows)
{
string gvIDs;
#region Declare local variable deleteChkBxItem of Checkbox type to get the Checkbox Instance of Grid Row
CheckBox deleteChkBxItem = (CheckBox)gv.FindControl("deleteRec");
#endregion
#region If deleteChkBxItem is Checked then ,mapped Current site to this user
if (deleteChkBxItem.Checked)
{
#region Declare local Variables
int Problemid;
int varSiteid;
int oldtechnicianvalue;
#endregion
#region Get the Problemid from variable of Label type declare in GridView of grdvwSite
gvIDs = ((Label)gv.FindControl("Problemid")).Text.ToString();
#endregion
#region Convert to incident id into integer
Problemid = Convert.ToInt16(gvIDs);
#endregion
#region If Incident id in Not Null
if (gvIDs != "")
{
Problem_mst Obj = new Problem_mst();
Obj = ObjProblem.Get_By_id(Problemid);
if (Obj.ProblemId != 0)
{
Obj.Active = false;
Obj.Update();
}
}
#endregion
}
#endregion
}
BindGridForAllParameter();
#endregion
}
protected void Showproblempanal()
{
panelProblem.Visible = true;
pan1.Visible = true;
panelincidentproblem.Visible = false;
//panelHistory.Visible = false;
panaleditproblem.Visible = false;
panalanalysis.Visible = false;
btnUpdate.Visible = false;
btnCancel.Visible = false;
lnkEdit.Visible = true;
panalsolution.Visible = false;
panelHistory.Visible = false;
int problemid = Convert.ToInt16(Request.QueryString[0]);
lblProblemId.Text = problemid.ToString();
ObjProblem = ObjProblem.Get_By_id(problemid);
if (ObjProblem.title != null)
{
lblTitle.Text = ObjProblem.title.ToString();
}
if (ObjProblem.Description != null)
{
lblDescription.Text = ObjProblem.Description.ToString();
}
int priorityid = Convert.ToInt16(ObjProblem.Priorityid);
ObjPriority = ObjPriority.Get_By_id(priorityid);
if (priorityid!=0)
{
lblpriority.Text = ObjPriority.Name.ToString();
}
else
{
lblpriority.Text = "";
}
int status = Convert.ToInt16(ObjProblem.Statusid);
ObjStatus = ObjStatus.Get_By_id(status);
lblStatus.Text = ObjStatus.Statusname.ToString();
int category = Convert.ToInt16(ObjProblem.Categoryid);
ObjCategory = ObjCategory.Get_By_id(category);
if (category != 0)
{
lblcategory.Text = ObjCategory.CategoryName.ToString();
}
else
{
lblcategory.Text = "";
}
int subcategory = Convert.ToInt16(ObjProblem.Subcategoryid);
Objsubcategory = Objsubcategory.Get_By_id(subcategory);
if (subcategory != 0)
{
lblsubcategory.Text = Objsubcategory.Subcategoryname.ToString();
}
else
{
lblsubcategory.Text = "";
}
int requesterid = Convert.ToInt16(ObjProblem.Requesterid);
ObjUser = ObjUser.Get_By_id(requesterid);
lblRequesterDisp.Text = ObjUser.Username;
int techid = Convert.ToInt16(ObjProblem.Technicianid);
ObjUser = ObjUser.Get_By_id(techid);
if (techid != 0)
{
lbltechid.Text = ObjUser.Username.ToString();
}
else
{
lbltechid.Text = "";
}
int creator = Convert.ToInt16(ObjProblem.CreatedByid);
ObjUser = ObjUser.Get_By_id(creator);
lblCreatedby.Text = ObjUser.Username.ToString();
lblCreatedDate.Text = ObjProblem.CreateDatetime.ToString();
lblDateDisp.Text = ObjProblem.CreateDatetime.ToString();
lblProblemId.Text = ObjProblem.ProblemId.ToString();
if (ObjProblem.Closedatetime != null)
{
lblCompletedDate.Text = ObjProblem.Closedatetime.ToString();
}
else
{
lblCompletedDate.Text = "";
}
}
protected void Showvalues()
{
int problemid = Convert.ToInt32(Session["problemid"]);
ObjProblem = ObjProblem.Get_By_id(problemid);
drpTechnician.SelectedValue = ObjProblem.Technicianid.ToString();
drpCategory.SelectedValue = ObjProblem.Categoryid.ToString();
BindDropSubCategory();
drpSubcategory.SelectedValue = ObjProblem.Subcategoryid.ToString();
drpPriority.SelectedValue = ObjProblem.Priorityid.ToString();
txtTitle.Text = ObjProblem.title.ToString();
txtDescription.Text = ObjProblem.Description.ToString();
ObjUserLogin = ObjUserLogin.Get_By_id(ObjProblem.Requesterid);
}
protected void btnCancell_Click(object sender, EventArgs e)
{
#region Fetch Each Row from GridView,and Check Which Check Box is Selected
foreach (GridViewRow gv in grdvwProblem.Rows)
{
string gvIDs;
#region Declare local variable deleteChkBxItem of Checkbox type to get the Checkbox Instance of Grid Row
CheckBox deleteChkBxItem = (CheckBox)gv.FindControl("deleteRec");
#endregion
#region If deleteChkBxItem is Checked then ,mapped Current site to this user
if (deleteChkBxItem.Checked)
{
#region Declare local Variables
int Problemid;
int varSiteid;
int oldtechnicianvalue;
#endregion
#region Get the Problemid from variable of Label type declare in GridView of grdvwSite
gvIDs = ((Label)gv.FindControl("Problemid")).Text.ToString();
#endregion
#region Convert to incident id into integer
Problemid = Convert.ToInt32(gvIDs);
#endregion
#region If Incident id in Not Null
if (gvIDs != "")
{
Problem_mst Obj = new Problem_mst();
Obj = ObjProblem.Get_By_id(Problemid);
if (Obj.ProblemId != 0)
{
Obj.Active = false;
Obj.Update();
}
}
#endregion
}
#endregion
}
BindGridForAllParameter();
#endregion
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
#region Get problemid from QueryString
int problemid = Convert.ToInt16(Request.QueryString[0]);
#endregion
#region Declare Local Variable
// Declare local Variable
int historyid;
int varTotalTimeSpentonCall = 0;
int SLAid;
string userName;
int userid = 0;
string strCreateDatetime = "";
string statusString;
string strStatusOpen;
string strStatusClose;
string strStatusResolved;
string strStatusOnHold;
bool FlagTechnicianId;
bool FlagCloseStatus;
int requesttypeid;
string OldStatusString;
FlagTechnicianId = false;
FlagCloseStatus = false;
string oldCompletedTime = "";
Incident_mst objIncidentOld = new Incident_mst();
Problem_mst objproblemstatusold = new Problem_mst();
objproblemstatusold = objproblemstatusold.Get_By_id(problemid);
string VarResolutionAdded = "";
#endregion
#region Fetch Current User
// Fetch Current User and assign to local variable userName
MembershipUser User = Membership.GetUser();
userName = User.UserName.ToString();
#endregion
#region Fetch Data from MessageResource file and assign to Local Variable
statusString = GetStatusString(Convert.ToInt16(drpStatus.SelectedValue));
strStatusOpen = Resources.MessageResource.strStatusOpen.ToString().Trim();
strStatusClose = Resources.MessageResource.strStatusClose.ToString().Trim();
strStatusResolved = Resources.MessageResource.strStatusResolved.ToString().Trim();
strStatusOnHold = Resources.MessageResource.strStatusOnHold.ToString().Trim();
#endregion
#region On the basis of Username ,get Userid by calling Function Get_UserLogin_By_UserName(),via passing parameter Username and organizationid
if (userName != "")
{
Objorganization = Objorganization.Get_Organization();
ObjUser = ObjUser.Get_UserLogin_By_UserName(userName, Objorganization.Orgid);
if (ObjUser.Userid != 0)
{
userid = ObjUser.Userid;
}
}
#endregion
#region Insert value in IncidentHistory Table ,for every update of Page
if (statusString.ToLower() == strStatusClose.ToLower())
{
ObjProblemHistory.Problemid = problemid;
ObjProblemHistory.Operationownerid = userid;
ObjProblemHistory.Operation = "closed";
ObjProblemHistory.Insert();
}
else if (statusString.ToLower() == strStatusResolved.ToLower())
{
ObjProblemHistory.Problemid = problemid;
ObjProblemHistory.Operationownerid = userid;
ObjProblemHistory.Operation = "resolved";
ObjProblemHistory.Insert();
}
else
{
ObjProblemHistory.Problemid = problemid;
ObjProblemHistory.Operationownerid = userid;
ObjProblemHistory.Operation = "update";
ObjProblemHistory.Insert();
}
#endregion
#region Get the Current historyid by calling function Get_Current_ProblemHistoryid()
historyid = ObjProblemHistory.Get_Current_ProblemHistoryid();
#endregion
#region Find Current value of Problem aBy Calling Function Get_By_id(),via passing problemid
ObjProblem = ObjProblem.Get_By_id(problemid);
#endregion
#region Insert into IncidentHistoryDiff table ,By Comparing Current value and Updated Values
if (ObjProblem.ProblemId != 0)
{
#region Declare local variable
string columnName;
string prev_value;
string curnt_value;
#endregion
#region If Priority value is changed,Insert into IncidentHistoryDiff table
if (ObjProblem.Priorityid != Convert.ToInt16(drpPriority.SelectedValue))
{
columnName = Resources.MessageResource.strColumnPriorityid.ToString();
prev_value = Convert.ToString(ObjProblem.Priorityid);
curnt_value = Convert.ToString(drpPriority.SelectedValue);
ObjProblemHistoryDiff.Historyid = historyid;
ObjProblemHistoryDiff.Columnname = columnName;
ObjProblemHistoryDiff.Current_value = curnt_value;
ObjProblemHistoryDiff.Prev_value = prev_value;
ObjProblemHistoryDiff.Insert();
}
#endregion
#region If Category value is changed,Insert into IncidentHistoryDiff table
if (ObjProblem.Categoryid != Convert.ToInt16(drpCategory.SelectedValue))
{
columnName = Resources.MessageResource.strColumnCategoryid.ToString();
prev_value = Convert.ToString(ObjProblem.Categoryid);
curnt_value = Convert.ToString(drpCategory.SelectedValue);
ObjProblemHistoryDiff.Historyid = historyid;
ObjProblemHistoryDiff.Columnname = columnName;
ObjProblemHistoryDiff.Current_value = curnt_value;
ObjProblemHistoryDiff.Prev_value = prev_value;
ObjProblemHistoryDiff.Insert();
}
#endregion
#region If SubCategory value is changed,Insert into IncidentHistoryDiff table
if (ObjProblem.Subcategoryid != Convert.ToInt16(drpSubcategory.SelectedValue))
{
columnName = Resources.MessageResource.strColumnSubcategoryid.ToString();
prev_value = Convert.ToString(ObjProblem.Subcategoryid);
curnt_value = Convert.ToString(drpSubcategory.SelectedValue);
ObjProblemHistoryDiff.Historyid = historyid;
ObjProblemHistoryDiff.Columnname = columnName;
ObjProblemHistoryDiff.Current_value = curnt_value;
ObjProblemHistoryDiff.Prev_value = prev_value;
ObjProblemHistoryDiff.Insert();
}
#endregion
#region If Status value is changed,Insert into IncidentHistoryDiff table
if (ObjProblem.Statusid != Convert.ToInt16(drpStatus.SelectedValue))
{
string Statusprev;
string StatusCurrent;
columnName = Resources.MessageResource.strColumnstatusid.ToString();
prev_value = Convert.ToString(ObjProblem.Statusid);
curnt_value = Convert.ToString(drpStatus.SelectedValue);
ObjProblemHistoryDiff.Historyid = historyid;
ObjProblemHistoryDiff.Columnname = columnName;
ObjProblemHistoryDiff.Current_value = curnt_value;
ObjProblemHistoryDiff.Prev_value = prev_value;
ObjProblemHistoryDiff.Insert();
Statusprev = GetStatusString(Convert.ToInt16(objproblemstatusold.Statusid));
StatusCurrent = GetStatusString(Convert.ToInt16(drpStatus.SelectedValue));
if (Statusprev == strStatusOpen && StatusCurrent == strStatusOnHold)
{
columnName = Resources.MessageResource.strColumnStarttime.ToString();
prev_value = "0";
curnt_value = DateTime.Now.ToString();
ObjProblemHistoryDiff.Historyid = historyid;
ObjProblemHistoryDiff.Columnname = columnName;
ObjProblemHistoryDiff.Current_value = curnt_value;
ObjProblemHistoryDiff.Prev_value = prev_value;
ObjProblemHistoryDiff.Insert();
}
if (Statusprev == strStatusOnHold && StatusCurrent != strStatusOnHold)
{
columnName = Resources.MessageResource.srColumnEndtime.ToString();
prev_value = "0";
curnt_value = DateTime.Now.ToString();
ObjProblemHistoryDiff.Historyid = historyid;
ObjProblemHistoryDiff.Columnname = columnName;
ObjProblemHistoryDiff.Current_value = curnt_value;
ObjProblemHistoryDiff.Prev_value = prev_value;
ObjProblemHistoryDiff.Insert();
}
}
#endregion
#region If technician value is changed,Insert into IncidentHistoryDiff table
if (ObjProblem.Technicianid != Convert.ToInt16(drpTechnician.SelectedValue))
{
columnName = Resources.MessageResource.strColumnTechnicianid.ToString();
prev_value = Convert.ToString(ObjProblem.Technicianid);
curnt_value = Convert.ToString(drpTechnician.SelectedValue);
ObjProblemHistoryDiff.Historyid = historyid;
ObjProblemHistoryDiff.Columnname = columnName;
ObjProblemHistoryDiff.Current_value = curnt_value;
ObjProblemHistoryDiff.Prev_value = prev_value;
ObjProblemHistoryDiff.Insert();
objSentMailToUser.SentMailToTechnicianForProblemCall(problemid, Convert.ToInt16(drpTechnician.SelectedValue));
if (objproblemstatusold.AssginedTime == null)
{
columnName = Resources.MessageResource.strColumnAssignedTime.ToString();
prev_value = "0";
curnt_value = DateTime.Now.ToString();
ObjProblemHistoryDiff.Historyid = historyid;
ObjProblemHistoryDiff.Columnname = columnName;
ObjProblemHistoryDiff.Current_value = curnt_value;
ObjProblemHistoryDiff.Prev_value = prev_value;
ObjProblemHistoryDiff.Insert();
}
else
{
columnName = "AssignedTime";
prev_value = objproblemstatusold.AssginedTime;
curnt_value = DateTime.Now.ToString();
ObjProblemHistoryDiff.Historyid = historyid;
ObjProblemHistoryDiff.Columnname = columnName;
ObjProblemHistoryDiff.Current_value = curnt_value;
ObjProblemHistoryDiff.Prev_value = prev_value;
ObjProblemHistoryDiff.Insert();
}
FlagTechnicianId = true;
}
#endregion
}
#endregion
#region Update values in Problem Table
ObjProblemnew.ProblemId = problemid;
ObjProblemnew.Technicianid = Convert.ToInt16(drpTechnician.SelectedValue);
ObjProblemnew.Statusid = Convert.ToInt16(drpStatus.SelectedValue);
ObjProblemnew.Priorityid = Convert.ToInt16(drpPriority.SelectedValue);
ObjProblemnew.Categoryid = Convert.ToInt16(drpCategory.SelectedValue);
ObjProblemnew.Subcategoryid = Convert.ToInt16(drpSubcategory.SelectedValue);
ObjProblemnew.Active = true;
if (ObjProblem.Technicianid != Convert.ToInt16(drpTechnician.SelectedValue))
{
ObjProblemnew.AssginedTime = DateTime.Now.ToString();
}
else
{
ObjProblemnew.AssginedTime = ObjProblem.AssginedTime;
}
#region If Current status is closed,then Assign Completed time
if (statusString.ToLower() == strStatusClose.ToLower())
{
#region If FlagCloseStatus=flase ie Currrent status is closed ,and old status is not Closed
int status = ObjProblem.Statusid;
ObjStatus = ObjStatus.Get_By_id(status);
if (ObjStatus.Statusname == "closed")
{
ObjProblemnew.Closedatetime = ObjProblem.Closedatetime;
// varTotalTimeSpentonCall = objIncident.Get_TimeSpentonRequest(incidentid, Convert.ToInt16(drpSite.SelectedValue), strCreateDatetime, DateTime.Now.ToString());
//CalculateTotalTimeofRequest();
//varTotalTimeSpentonCall = objIncident.Get_TimeSpentonRequest(strCreateDatetime, DateTime.Now.ToString());
}
else
{
ObjProblemnew.Closedatetime = DateTime.Now.ToString();
//varTotalTimeSpentonCall = objIncident.Get_TimeSpentonRequest(strCreateDatetime, oldCompletedTime);
// varTotalTimeSpentonCall = objIncident.Get_TimeSpentonRequest(incidentid, Convert.ToInt16(drpSite.SelectedValue), strCreateDatetime, oldCompletedTime);
}
#endregion
}
#endregion
ObjProblemnew.Update();
#endregion
Showproblempanal();
LogNoteUpdatePanel();
HistoryUpdatePanel();
}
public object GenerateProblem_mstObject(ref IDataReader returnData)
{
Problem_mst obj = new Problem_mst();
while (returnData.Read())
{
obj.ProblemId = (int)returnData["ProblemId"];
obj.CreatedByid = (int)returnData["CreatedByid"];
obj.Requesterid = (int)returnData["Requesterid"];
obj.Technicianid = (int)returnData["Technicianid"];
obj.Categoryid = (int)returnData["Categoryid"];
obj.Statusid = (int)returnData["Statusid"];
obj.Priorityid = (int)returnData["Priorityid"];
obj.Subcategoryid = (int)returnData["Subcategoryid"];
obj.title = (string)returnData["title"];
if (returnData["Description"] != DBNull.Value)
{
obj.Description = (string)returnData["Description"];
}
if (returnData["CreateDatetime"] != DBNull.Value)
{
DateTime Mydatetime = new DateTime();
Mydatetime = (DateTime)returnData["CreateDatetime"];
obj.CreateDatetime = Mydatetime.ToString();
}
if (returnData["Closedatetime"] != DBNull.Value)
{
DateTime Mydatetime1 = new DateTime();
Mydatetime1 = (DateTime)returnData["Closedatetime"];
obj.Closedatetime = Mydatetime1.ToString();
}
if (returnData["CompletedTime"] != DBNull.Value)
{
DateTime Mydatetime2 = new DateTime();
Mydatetime2 = (DateTime)returnData["CompletedTime"];
obj.CompletedTime = Mydatetime2.ToString();
}
if (returnData["AssignedTime"] != DBNull.Value)
{
DateTime Mydatetime3 = new DateTime();
Mydatetime3 = (DateTime)returnData["AssignedTime"];
obj.AssginedTime = Mydatetime3.ToString();
}
}
returnData.Close();
returnData.Dispose();
return obj;
}
public void SentMailToTechnicianForProblemCall(int problemid, int userid)
{
string strYourSinscerely = Resources.MessageResource.strYourSinscerely.ToString();
string strContactNumber = Resources.MessageResource.strContactNumber.ToString();
Problem_mst objProblem = new Problem_mst();
objUser = objUser.Get_By_id(userid);
ContactInfo_mst objCont_info = new ContactInfo_mst();
objCont_info = objCont_info.Get_By_id(objUser.Userid);
objProblem = objProblem.Get_By_id(problemid);
objPriority = objPriority.Get_By_id(objProblem.Priorityid);
UserLogin_mst objReq = new UserLogin_mst();
objReq = objReq.Get_By_id(objProblem.Requesterid);
ContactInfo_mst objReqCont = new ContactInfo_mst();
objReqCont = objReqCont.Get_By_id(objReq.Userid);
objSDE = objSDE.Get_By_id(objProblem.CreatedByid);
if (objCont_info.Emailid != null)
{
obj.To = objCont_info.Emailid;
obj.From = Resources.MessageResource.strAdminEmail.ToString();
obj.Subject = " New Problem Call Assigned to you. Problem Id : " + problemid;
obj.Body = "Dear " + objUser.Username + "," + "<br/> A Call with the following details have been assigned to you.<br/><br/><b>Problem Details : </b> <br/><br/><b>Problem Id :</b>" + objProblem.ProblemId + "<br/><b>Title of Call :</b>" + objProblem.title + " <br/><b>Logged Date & Time   :</b>" + objProblem.CreateDatetime + "<br/><b>Description :</b>" + objProblem.Description + "<br/><b>Priority :</b> " + objPriority.Name + "<br/><b>UserName :</b>" + objReq.Username + "<br/><b>Mobile No. :<b/>" + objReqCont.Mobile + "<br/><b>Landline No. :<b/>" + objReqCont.Landline + "<br/><b>Mail Address :</b>" + objReqCont.Emailid + "<br/><b>Service Desk Executive :</b>" + objSDE.Username + "<br/><br/> For any other support kindly get in touch with us at <b>" + strContactNumber + "</b>.<br/><br/> <b>This is an auto generated mail. Please do not reply.</b><br/><br/><b>Yours sincerely,</b><br/> <b>" + strYourSinscerely + "</b>";
obj.SmtpServer = obj.SmtpServer = Resources.MessageResource.strSMTPServer.ToString();
obj.SentMail();
}
}
protected void btnupdatesymptom_Click(object sender, EventArgs e)
{
//Add Exception handilng try catch change by vishal 21-05-2012
try
{
string prev_value;
string curnt_value;
int historyid;
int problemid = Convert.ToInt32(Request.QueryString[0]);
#region For updating values in Problem history table
ObjProblemHistory.Problemid = problemid;
MembershipUser User = Membership.GetUser();
string username = User.UserName.ToString();
Objorganization = Objorganization.Get_Organization();
int userid = ObjUser.Get_By_UserName(username, Objorganization.Orgid);
ObjProblemHistory.Operationownerid = userid;
ObjProblemHistory.Operation = "SymptomUpdate";
ObjProblemHistory.Insert();
#endregion
#region Get the Current historyid by calling function Get_Current_ProblemHistoryid()
historyid = ObjProblemHistory.Get_Current_ProblemHistoryid();
#endregion
#region Find Current value of Problem aBy Calling Function Get_By_id(),via passing problemid
ObjProblem = ObjProblem.Get_By_id(problemid);
#endregion
#region Find the value of current symptom
ObjProblemSymptom = ObjProblemSymptom.Get_By_id(ObjProblem.ProblemId);
#endregion
#region Insert the values in history difference table
prev_value = Convert.ToString(ObjProblemSymptom.Description);
curnt_value = Convert.ToString(Editorsymptom.Text);
ObjProblemHistoryDiff.Historyid = historyid;
ObjProblemHistoryDiff.Columnname = "Description";
ObjProblemHistoryDiff.Current_value = curnt_value;
ObjProblemHistoryDiff.Prev_value = prev_value;
ObjProblemHistoryDiff.Insert();
#endregion
ObjProblemSymptom.Problemid = problemid;
ObjProblemSymptom.Description = Editorsymptom.Text.ToString();
ObjProblemSymptom.Update();
ShowSymptomPlaceholder();
btnupdatesymptom.Visible = false;
btncancellSymptom.Visible = false;
btncancellSymptom.Visible = false;
Editorsymptom.Visible = false;
lnksymptomadd.Visible = false;
lnksymptomedit.Visible = true;
ShowImpactPlaceholder();
ShowRootcausePlaceholder();
}
catch (Exception ex)
{
string myScript;
myScript = "<script language=javascript>alert('Exception - '" + ex + "');</script>";
Page.RegisterClientScriptBlock("MyScript", myScript);
return;
}
}
protected void btnCancell_Click(object sender, EventArgs e)
{
//Add Exception handilng try catch change by vishal 21-05-2012
try
{
#region Fetch Each Row from GridView,and Check Which Check Box is Selected
foreach (GridViewRow gv in grdvwProblem.Rows)
{
string gvIDs;
#region Declare local variable deleteChkBxItem of Checkbox type to get the Checkbox Instance of Grid Row
CheckBox deleteChkBxItem = (CheckBox)gv.FindControl("deleteRec");
#endregion
#region If deleteChkBxItem is Checked then ,mapped Current site to this user
if (deleteChkBxItem.Checked)
{
#region Declare local Variables
int Problemid;
int varSiteid;
int oldtechnicianvalue;
#endregion
#region Get the Problemid from variable of Label type declare in GridView of grdvwSite
gvIDs = ((Label)gv.FindControl("Problemid")).Text.ToString();
#endregion
#region Convert to incident id into integer
Problemid = Convert.ToInt32(gvIDs);
#endregion
#region If Incident id in Not Null
if (gvIDs != "")
{
Problem_mst Obj = new Problem_mst();
Obj = ObjProblem.Get_By_id(Problemid);
if (Obj.ProblemId != 0)
{
Obj.Active = false;
Obj.Update();
}
}
#endregion
}
#endregion
}
BindGridForAllParameter();
#endregion
}
catch (Exception ex)
{
string myScript;
myScript = "<script language=javascript>alert('Exception - '" + ex + "');</script>";
Page.RegisterClientScriptBlock("MyScript", myScript);
return;
}
}
protected void UpdatePanel2()
{
pan1.Visible = false;
panaleditproblem.Visible = true;
panelProblem.Visible = true;
//panalrequestinfo.Visible = false;
//panelHistory.Visible = false;
//panelincidentproblem.Visible = false;
//lbltimespentonDisp.Visible = false;
//lbltimespentonreq.Text = "";
BindDropCategory();
//BindDropImpact();
BindDropStatus();
// BindDropMode();
BindDropPriority();
BindDropTechnician();
// BindDropRequestType();
//BindDropVendor();
int problemid = Convert.ToInt16(Request.QueryString[0]);
ObjProblem = ObjProblem.Get_By_id(problemid);
if (problemid != 0)
{
drpTechnician.SelectedValue = ObjProblem.Technicianid.ToString();
drpStatus.SelectedValue = ObjProblem.Statusid.ToString();
drpPriority.SelectedValue = ObjProblem.Priorityid.ToString();
drpCategory.SelectedValue = ObjProblem.Categoryid.ToString();
BindDropSubCategory();
drpSubcategory.SelectedValue = ObjProblem.Subcategoryid.ToString();
drpTechnician.SelectedValue = ObjProblem.Technicianid.ToString();
if (ObjProblem.CompletedTime != null)
{
lblCompletedDateeditproblem.Text = ObjProblem.CompletedTime.ToString();
}
else
{
lblCompletedDateeditproblem.Text = "";
}
int createdby = Convert.ToInt16(ObjProblem.CreatedByid);
ObjUser = ObjUser.Get_By_id(createdby);
if (createdby != 0)
{
lblcreatedbyditproblem.Text = ObjUser.Username.ToString();
}
else
{
lblcreatedbyditproblem.Text = "";
}
lblCreateddateeditproblem.Text = ObjProblem.CreateDatetime.ToString();
}
}
protected void btnupdatesymptom_Click(object sender, EventArgs e)
{
string prev_value;
string curnt_value;
int historyid;
int problemid = Convert.ToInt16(Request.QueryString[0]);
#region For updating values in Problem history table
ObjProblemHistory.Problemid = problemid;
MembershipUser User=Membership.GetUser();
string username=User.UserName.ToString();
Objorganization=Objorganization.Get_Organization();
int userid = ObjUser.Get_By_UserName(username, Objorganization.Orgid);
ObjProblemHistory.Operationownerid = userid;
ObjProblemHistory.Operation = "SymptomUpdate";
ObjProblemHistory.Insert();
#endregion
#region Get the Current historyid by calling function Get_Current_ProblemHistoryid()
historyid = ObjProblemHistory.Get_Current_ProblemHistoryid();
#endregion
#region Find Current value of Problem aBy Calling Function Get_By_id(),via passing problemid
ObjProblem = ObjProblem.Get_By_id(problemid);
#endregion
#region Find the value of current symptom
ObjProblemSymptom = ObjProblemSymptom.Get_By_id(ObjProblem.ProblemId);
#endregion
#region Insert the values in history difference table
prev_value = Convert.ToString(ObjProblemSymptom.Description);
curnt_value = Convert.ToString(Editorsymptom.Text);
ObjProblemHistoryDiff.Historyid = historyid;
ObjProblemHistoryDiff.Columnname = "Description";
ObjProblemHistoryDiff.Current_value = curnt_value;
ObjProblemHistoryDiff.Prev_value = prev_value;
ObjProblemHistoryDiff.Insert();
#endregion
ObjProblemSymptom.Problemid = problemid;
ObjProblemSymptom.Description = Editorsymptom.Text.ToString();
ObjProblemSymptom.Update();
ShowSymptomPlaceholder();
btnupdatesymptom.Visible = false;
btncancellSymptom.Visible = false;
btncancellSymptom.Visible = false;
Editorsymptom.Visible = false;
lnksymptomadd.Visible = false;
lnksymptomedit.Visible = true;
ShowImpactPlaceholder();
ShowRootcausePlaceholder();
}
public int Insert_Problem_mst(Problem_mst ObjProblem)
{
return (int)ExecuteNonQuery(Sp_Problem_Insert, new object[] { ObjProblem.CreatedByid, ObjProblem.Requesterid, ObjProblem.Technicianid, ObjProblem.Categoryid, ObjProblem.Statusid, ObjProblem.Priorityid, ObjProblem.Subcategoryid, ObjProblem.title, ObjProblem.Description, ObjProblem.AssginedTime });
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
int problemid = Convert.ToInt16(Request.QueryString[1]);
int flag = Convert.ToInt16(Request.QueryString[0]);
Objproblem = Objproblem.Get_By_id(problemid);
txtTitle.Text = Objproblem.title.ToString();
BindDrpCategory();
if (flag == 3 )
{
updateSolution();
}
if (flag == 4 )
{
updateWorkaround();
}
}
}
public int Update_Problem_By_id(Problem_mst ObjProblem)
{
return (int)ExecuteNonQuery(Sp_Problem_Update, new object[] { ObjProblem.Technicianid, ObjProblem.Categoryid, ObjProblem.Statusid, ObjProblem.Priorityid, ObjProblem.Subcategoryid, ObjProblem.Description, ObjProblem.ProblemId, ObjProblem.Closedatetime, ObjProblem.AssginedTime, ObjProblem.Active });
}
protected void BindProblemToChangegrid()
{
#region Declaration of table Variable
DataTable dtTable = new DataTable();
dtTable = CreateDataTable();
#endregion
int changeid = Convert.ToInt32(Request.QueryString[0]);
colproblemtochange = ObjProblemToChange.Get_All_By_changeid(changeid);
foreach (Problem_To_Change obj in colproblemtochange)
{
int id = Convert.ToInt32(obj.Problemid);
ObjProblem = ObjProblem.Get_By_id(id);
DataRow row;
row = dtTable.NewRow();
// row["incidentid"] = Convert.ToString(objIncident.Incidentid);
row["ID"] = ObjProblem.ProblemId;
row["title"] = ObjProblem.title;
row["requesterid"] = Convert.ToString(ObjProblem.Requesterid);
row["technicianid"] = ObjProblem.Technicianid;
row["statusid"] = ObjProblem.Statusid;
row["createdatetime"] = Convert.ToString(ObjProblem.CreateDatetime);
//row["createdbyid"] = Convert.ToString(objIncident.Createdbyid);
//row["siteid"] = Convert.ToString(objIncident.Siteid);
//row["priorityid"] = objIncidentStates.Priorityid;
dtTable.Rows.Add(row);
}
grdvwproblemchange.DataSource = dtTable;
grdvwproblemchange.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
//Add Exception handilng try catch change by vishal 21-05-2012
try
{
if (!IsPostBack)
{
int problemid = Convert.ToInt32(Request.QueryString[1]);
int flag = Convert.ToInt32(Request.QueryString[0]);
Objproblem = Objproblem.Get_By_id(problemid);
txtTitle.Text = Objproblem.title.ToString();
BindDrpCategory();
if (flag == 3)
{
updateSolution();
}
if (flag == 4)
{
updateWorkaround();
}
}
}
catch (Exception ex)
{
string myScript;
myScript = "<script language=javascript>alert('Exception - '" + ex + "');</script>";
Page.RegisterClientScriptBlock("MyScript", myScript);
return;
}
}
protected void Page_Load(object sender, EventArgs e)
{
//Add Exception handilng try catch change by vishal 21-05-2012
try
{
string strStatusClose = Resources.MessageResource.strStatusClose.ToString().Trim();
string statusString = "";
int problemid = Convert.ToInt32(Request.QueryString[0]);
ObjProbelm = ObjProbelm.Get_By_id(problemid);
objrootcause = objrootcause.Get_By_id(problemid);
objimpact = objimpact.Get_By_id(problemid);
objstatus = objstatus.Get_By_id(ObjProbelm.Statusid);
statusString = objstatus.Statusname.ToString();
if (statusString.ToLower() == strStatusClose.ToLower())
{
string ii = objimpact.Description.ToString();
string stripped4 = Regex.Replace(ii, @"<(.|\n)*?>", string.Empty);
lblserviceeffected.Text = objimpact.Description.ToString();
string rr = objrootcause.Description.ToString();
string stripped1 = Regex.Replace(rr, @"<(.|\n)*?>", string.Empty);
lblcause.Text = stripped1.ToString();
objproblemsysmptom = objproblemsysmptom.Get_By_id(problemid);
string ss = objproblemsysmptom.Description.ToString();
string stripped3 = Regex.Replace(ss, @"<(.|\n)*?>", string.Empty);
lblsymptom.Text = stripped3.ToString();
lbltcktno.Text = ObjProbelm.ProblemId.ToString();
lblcreatedate.Text = ObjProbelm.CreateDatetime.ToString();
if (ObjProbelm.AssginedTime != null)
{
lblstarttime.Text = ObjProbelm.AssginedTime.ToString();
}
lblendtime.Text = ObjProbelm.Closedatetime.ToString();
Objcategory = Objcategory.Get_By_id(ObjProbelm.Categoryid);
lblcomponenteffected.Text = Objcategory.CategoryName.ToString();
lbldescription.Text = ObjProbelm.title.ToString();
objproblemtosolution = objproblemtosolution.Get_By_id(ObjProbelm.ProblemId);
Objsolution = Objsolution.Get_By_id(objproblemtosolution.Solutionid);
string bb = Objsolution.Solution.ToString();
string stripped = Regex.Replace(bb, @"<(.|\n)*?>", string.Empty);
lblresolution.Text = stripped.ToString();
//bind data to data bound controls and do other stuff
objUser = objUser.Get_By_id(ObjProbelm.Requesterid);
lblcustomer.Text = objUser.Username.ToString();
objUser = objUser.Get_By_id(ObjProbelm.Technicianid);
lblengineer.Text = objUser.Username.ToString();
lblrcaresult.Text = "Completed";
}
Response.Clear(); //this clears the Response of any headers or previous output
Response.Buffer = true; //make sure that the entire output is rendered simultaneously
///
///Set content type to MS Excel sheet
///Use "application/msword" for MS Word doc files
///"application/pdf" for PDF files
///
Response.ContentType = "application/vnd.ms-excel";
StringWriter stringWriter = new StringWriter(); //System.IO namespace should be used
HtmlTextWriter htmlTextWriter = new HtmlTextWriter(stringWriter);
///
///Render the entire Page control in the HtmlTextWriter object
///We can render individual controls also, like a DataGrid to be
///exported in custom format (excel, word etc)
///
this.RenderControl(htmlTextWriter);
Response.Write(stringWriter.ToString());
Response.End();
}
catch (Exception ex)
{
string myScript;
myScript = "<script language=javascript>alert('Exception - '" + ex + "');</script>";
Page.RegisterClientScriptBlock("MyScript", myScript);
return;
}
}
protected void Page_Load(object sender, EventArgs e)
{//Add Exception handilng try catch change by vishal 21-05-2012
try
{
string strStatusClose = Resources.MessageResource.strStatusClose.ToString().Trim();
string statusString = "";
int problemid = Convert.ToInt32(Request.QueryString[0]);
ObjProbelm = ObjProbelm.Get_By_id(problemid);
objrootcause = objrootcause.Get_By_id(problemid);
objimpact = objimpact.Get_By_id(problemid);
objstatus = objstatus.Get_By_id(ObjProbelm.Statusid);
statusString = objstatus.Statusname.ToString();
if (statusString.ToLower() == strStatusClose.ToLower())
{
string ii = objimpact.Description.ToString();
string stripped4 = Regex.Replace(ii, @"<(.|\n)*?>", string.Empty);
lblserviceeffected.Text = objimpact.Description.ToString();
string rr = objrootcause.Description.ToString();
string stripped1 = Regex.Replace(rr, @"<(.|\n)*?>", string.Empty);
lblcause.Text = stripped1.ToString();
objproblemsysmptom = objproblemsysmptom.Get_By_id(problemid);
string ss = objproblemsysmptom.Description.ToString();
string stripped3 = Regex.Replace(ss, @"<(.|\n)*?>", string.Empty);
lblsymptom.Text = stripped3.ToString();
lbltcktno.Text = ObjProbelm.ProblemId.ToString();
lblcreatedate.Text = ObjProbelm.CreateDatetime.ToString();
if (ObjProbelm.AssginedTime != null)
{
lblstarttime.Text = ObjProbelm.AssginedTime.ToString();
}
lblendtime.Text = ObjProbelm.Closedatetime.ToString();
Objcategory = Objcategory.Get_By_id(ObjProbelm.Categoryid);
lblcomponenteffected.Text = Objcategory.CategoryName.ToString();
lbldescription.Text = ObjProbelm.title.ToString();
objproblemtosolution = objproblemtosolution.Get_By_id(ObjProbelm.ProblemId);
Objsolution = Objsolution.Get_By_id(objproblemtosolution.Solutionid);
string bb = Objsolution.Solution.ToString();
string stripped = Regex.Replace(bb, @"<(.|\n)*?>", string.Empty);
lblresolution.Text = stripped.ToString();
//bind data to data bound controls and do other stuff
objUser = objUser.Get_By_id(ObjProbelm.Requesterid);
lblcustomer.Text = objUser.Username.ToString();
objUser = objUser.Get_By_id(ObjProbelm.Technicianid);
lblengineer.Text = objUser.Username.ToString();
lblrcaresult.Text = "Completed";
}
Response.Clear(); //this clears the Response of any headers or previous output
Response.Buffer = true; //make sure that the entire output is rendered simultaneously
///
///Set content type to MS Excel sheet
///Use "application/msword" for MS Word doc files
///"application/pdf" for PDF files
///
Response.ContentType = "application/vnd.ms-excel";
StringWriter stringWriter = new StringWriter(); //System.IO namespace should be used
HtmlTextWriter htmlTextWriter = new HtmlTextWriter(stringWriter);
///
///Render the entire Page control in the HtmlTextWriter object
///We can render individual controls also, like a DataGrid to be
///exported in custom format (excel, word etc)
///
this.RenderControl(htmlTextWriter);
Response.Write(stringWriter.ToString());
Response.End();
}
catch (Exception ex)
{
string myScript;
myScript = "<script language=javascript>alert('Exception - '" + ex + "');</script>";
Page.RegisterClientScriptBlock("MyScript", myScript);
return;
}
}
