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(); } }
//function to check user exist or not protected void CheckUserExist() { lblerrmsg.Text = ""; // BindDropSite(); // BindDropDept(); #region Find Userid of User who is Requesting to log a call objOrganization = objOrganization.Get_Organization(); objUser = objUser.Get_UserLogin_By_UserName(txtUsername.Text.Trim().ToString().Trim(), objOrganization.Orgid); int usrid = Convert.ToInt16(objUser.Userid); int tempuser = 0; if (objUser.Userid == 0) { string myScript; tempuser = 1; myScript = "<script language=javascript>function __doPostBack(eventTarget, eventArgument){var theForm = document.forms['aspnetForm']; if (theForm){ theForm.__EVENTTARGET.value = eventTarget;theForm.__EVENTARGUMENT.value = eventArgument;theForm.submit(); }} var Flag= confirm('User Does not Exist,Do You Want to Create User');if(Flag==true){ __doPostBack('callPostBack', 'create');}if(Flag==false){ __doPostBack('callPostBack', 'notcreate');}</script>"; Page.RegisterClientScriptBlock("MyScript", myScript); Session["tempuser"] = tempuser; //txtassignasset.Text = ""; } else { IncidentToAsset(usrid); ContactInfo_mst objConInfo = new ContactInfo_mst(); objConInfo = objConInfo.Get_By_id(usrid); txtEmail.Text = objConInfo.Emailid; //txtassignasset.Text = assetid.ToString(); //txtassignasset.Text = compname; Session["assignassetid"] = assetid; Session["UserCreate"] = "Exist"; } string username1 = txtUsername.Text.Trim().ToString(); Session["Username"] = username1; Session["Email"] = txtEmail.Text; #endregion }
protected void GetUserDetail() { string userName = ""; MembershipUser User = Membership.GetUser(); if (User != null) { userName = User.UserName.ToString(); txtUsername.Text = User.UserName.ToString(); } if (userName != "") { int userid; objOrganization = objOrganization.Get_Organization(); objUser = objUser.Get_UserLogin_By_UserName(userName, objOrganization.Orgid); if (objUser.Userid != 0) { ContactInfo_mst objConInfo = new ContactInfo_mst(); userid = objUser.Userid; IncidentToAsset(userid); objConInfo = objConInfo.Get_By_id(userid); txtEmail.Text = objConInfo.Emailid; txtassignasset.Text = compname; } } }
protected void btnSolutionAdd_Click(object sender, EventArgs e) {///Add Exception handilng try catch change by vishal 21-05-2012 try { string userName; MembershipUser User = Membership.GetUser(); userName = User.UserName.ToString(); int userid; objOrganization = objOrganization.Get_Organization(); objUser = objUser.Get_UserLogin_By_UserName(userName, objOrganization.Orgid); int Solutionid; ObjSolution.Title = txtTitle.Text.ToString(); ObjSolution.Content = Editor.Text.ToString(); ObjSolution.Topicid = Convert.ToInt32(drpTopic.SelectedValue); ObjSolution.Solution = drpSolutionType.SelectedValue; ObjSolution.Insert(); Solutionid = ObjSolutionKeyword.Get_SolutionId(); ObjSolutionKeyword.Keywords = txtKeywords.Text.ToString(); ObjSolutionKeyword.Solutionid = Solutionid; ObjSolutionKeyword.Insert(); ObjSolutionCreator.Solutionid = Solutionid; ObjSolutionCreator.Createdby = objUser.Userid; ObjSolutionCreator.Insert(); objSentMailToUser.SentMailToPManager(Solutionid); Response.Redirect("ViewSolution.aspx?solutionid" + Solutionid); } catch (Exception ex) { string myScript; myScript = "<script language=javascript>alert('Exception - '" + ex + "');</script>"; Page.RegisterClientScriptBlock("MyScript", myScript); return; } }
protected void btnMapped_Click(object sender, EventArgs e) { //lblErrorMsg.Text = ""; int flag = 0; foreach (GridViewRow gv in grdvwViewUser.Rows) { string gvIDs; RadioButton selectonebutton = (RadioButton)gv.FindControl("selectone"); if (selectonebutton.Checked) { flag = 1; gvIDs = ((Label)gv.FindControl("lblUserID")).Text.ToString(); userid = Convert.ToInt32(gvIDs); objUser = objUser.Get_By_id(userid); string username = objUser.Username.ToString(); Session["username"] = username; Session["userid"] = userid; Session["flag"] = flag; Session["flag2"] = flag; break; } } string myScript; myScript = "<script language=javascript>javascript:refreshParent(); javascript:window.close();</script>"; Page.RegisterClientScriptBlock("MyScript", myScript); }
protected void btnMapped_Click(object sender, EventArgs e) { //lblErrorMsg.Text = ""; int flag = 0; foreach (GridViewRow gv in grdvwViewUser.Rows) { string gvIDs; RadioButton selectonebutton = (RadioButton)gv.FindControl("selectone"); if (selectonebutton.Checked) { flag = 1; gvIDs = ((Label)gv.FindControl("lblUserID")).Text.ToString(); userid = Convert.ToInt16(gvIDs); objUser = objUser.Get_By_id(userid); string username = objUser.Username.ToString(); Session["username"] = username; Session["userid"] = userid; Session["flag"] = flag; Session["flag2"] = flag; break; } } string myScript; myScript = "<script language=javascript>javascript:refreshParent(); javascript:window.close();</script>"; Page.RegisterClientScriptBlock("MyScript", myScript); }
public void SentMailToPManager(int solutionid) { string strYourSinscerely = Resources.MessageResource.strYourSinscerely.ToString(); string strContactNumber = Resources.MessageResource.strContactNumber.ToString(); Solution_mst objSolution = new Solution_mst(); SolutionCreator objSolutionCreator = new SolutionCreator(); objSolution = objSolution.Get_By_id(solutionid); objSolutionCreator = objSolutionCreator.Get_By_id(solutionid); UserLogin_mst objUserCreator = new UserLogin_mst(); objUserCreator = objUserCreator.Get_By_id(objSolutionCreator.Createdby); int FlagUser; string varRole = Resources.MessageResource.strPManagerRole.ToString(); int roleid; roleid = objRole.Get_By_RoleName(varRole); colUser = objUser.Get_All_By_Role(roleid); foreach (UserLogin_mst objusr in colUser) { objC_info = objC_info.Get_By_id(objusr.Userid); obj.From = Resources.MessageResource.strAdminEmail.ToString(); obj.To = objC_info.Emailid; obj.Subject = "New Solution Added. Solution Id : " + solutionid; obj.Body = "Dear Sir/Madam,<br/>A New Solution has been Added.Please find the New Solution details .<br/><br/><b>Solution Details : </b> <br/><br/><b>Solution Id :</b>" + objSolution.Solutionid + "<br/><b>Title :</b>" + objSolution.Title + " <br/><b>Added By :</b>" + objUserCreator.Username + "<br/><b>Created Date   :</b>" + objSolutionCreator.CreateDatetime + "<br/><b>Content :</b>" + objSolution.Content + "<br/><br/>This is an auto generated mail. Please do not reply.</b><br/><br/><b>Yours sincerely,</b><br/> <b>" + strYourSinscerely + "</b>"; obj.SmtpServer = Resources.MessageResource.strSMTPServer.ToString(); obj.SentMail(); } }
public void SentmailTechnician(int technicianid, int incidentid) { string strYourSinscerely = Resources.MessageResource.strYourSinscerely.ToString(); string strContactNumber = Resources.MessageResource.strContactNumber.ToString(); objIncident = objIncident.Get_By_id(incidentid); objSite = objSite.Get_By_id(objIncident.Siteid); objIncidentStates = objIncidentStates.Get_By_id(incidentid); objPriority = objPriority.Get_By_id(objIncidentStates.Priorityid); objUser = objUser.Get_By_id(objIncident.Requesterid); objtech = objtech.Get_By_id(technicianid); objSDE = objSDE.Get_By_id(objIncident.Createdbyid); objC_info = objC_info.Get_By_id(technicianid); objUserInfo = objUserInfo.Get_By_id(objIncident.Requesterid); if (objC_info.Emailid != null) { obj.To = objC_info.Emailid; obj.From = Resources.MessageResource.strAdminEmail.ToString(); obj.Subject = " New Call Assigned to you. Ticket id : " + incidentid; obj.Body = "Dear " + objtech.Username + "," + "<br/> A Call with the following details have been assigned to you.<br/><br/><b>Complaints Details : </b> <br/><br/><b>Ticket Id :</b>" + incidentid + "<br/><b>Title of Call :</b>" + objIncident.Title + " <br/><b>Site :</b>" + objSite.Sitename + "<br/><b>Logged Date & Time   :</b>" + objIncident.Createdatetime + "<br/><b>Description :</b>" + objIncident.Description + "<br/><b>Priority :</b> " + objPriority.Name + "<br/><b>UserName :</b>" + objUser.Username + "<br/><b>Mobile No. :<b/>" + objUserInfo.Mobile + "<br/><b>Landline No. :<b/>" + objUserInfo.Landline + "<br/><b>Mail Address :</b>" + objC_info.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 txtUsername_TextChanged(object sender, EventArgs e) { #region Find Userid of User who is Requesting to log a call /////Add Exception handilng try catch change by vishal 21-05-2012 try { objOrganization = objOrganization.Get_Organization(); ObjUserLogin = ObjUserLogin.Get_UserLogin_By_UserName(txtUsername.Text.ToString().Trim(), objOrganization.Orgid); if (ObjUserLogin.Userid == 0) { string myScript; myScript = "<script language=javascript>function __doPostBack(eventTarget, eventArgument){var theForm = document.forms['aspnetForm']; if (theForm){ theForm.__EVENTTARGET.value = eventTarget;theForm.__EVENTARGUMENT.value = eventArgument;theForm.submit(); }} var Flag= confirm('User Does not Exist,Do You Want to Create User');if(Flag==true){ __doPostBack('callPostBack', 'create');}if(Flag==false){ __doPostBack('callPostBack', 'notcreate');}</script>"; Page.RegisterClientScriptBlock("MyScript", myScript); } else { ViewState["UserCreate"] = "Exist"; ContactInfo_mst objCont = new ContactInfo_mst(); objCont = objCont.Get_By_id(ObjUserLogin.Userid); txtEmail.Text = objCont.Emailid; } } catch (Exception ex) { string myScript; myScript = "<script language=javascript>alert('Exception - '" + ex + "');</script>"; Page.RegisterClientScriptBlock("MyScript", myScript); return; } #endregion }
protected void btnapprove_Click(object sender, EventArgs e) { /////Add Exception handilng try catch change by vishal 21-05-2012 try { int userid = 0; int incidentid = Convert.ToInt32(Session["incidentid"].ToString()); if (incidentid != 0) { //objIncidentLog = objIncidentLog.Get_By_id(incidentid); //if (objIncidentLog.Incidentid != 0) //{ // objIncidentLog.Incidentid = incidentid; // objIncidentLog.Incidentlog = txtcomments.Text; // objIncidentLog.Update(); //} //else //{ // objIncidentLog.Incidentid = incidentid; // objIncidentLog.Incidentlog = txtcomments.Text; // objIncidentLog.Insert(); //} string userName = ""; MembershipUser User = Membership.GetUser(); if (User != null) { userName = User.UserName.ToString(); } if (userName != "") { objOrganization = objOrganization.Get_Organization(); objUser = objUser.Get_UserLogin_By_UserName(userName, objOrganization.Orgid); if (objUser.Userid != 0) { userid = objUser.Userid; } } objIncidentLog.Incidentid = incidentid; objIncidentLog.Userid = userid; objIncidentLog.Incidentlog = txtcomments.Text; objIncidentLog.Insert(); string myScript; myScript = "<script language=javascript>javascript:refreshParent(); javascript:window.close();</script>"; Page.RegisterClientScriptBlock("MyScript", myScript); } } catch (Exception ex) { string myScript; myScript = "<script language=javascript>alert('Exception - '" + ex + "');</script>"; Page.RegisterClientScriptBlock("MyScript", myScript); return; } }
protected void btnapprove_Click(object sender, EventArgs e) { int userid = 0; int incidentid = Convert.ToInt16(Session["incidentid"].ToString()); if (incidentid != 0) { string userName = ""; MembershipUser User = Membership.GetUser(); if (User != null) { userName = User.UserName.ToString(); } if (userName != "") { objOrganization = objOrganization.Get_Organization(); objUser = objUser.Get_UserLogin_By_UserName(userName, objOrganization.Orgid); if (objUser.Userid != 0) { userid = objUser.Userid; } } objIncidentLog.Incidentid = incidentid; objIncidentLog.Userid = userid; objIncidentLog.Incidentlog = txtcomments.Text; objIncidentLog.Insert(); string myScript; myScript = "<script language=javascript>javascript:window.close();</script>"; Page.RegisterClientScriptBlock("MyScript", myScript); } }
protected void btnSolutionAdd_Click(object sender, EventArgs e) { string userName; MembershipUser User = Membership.GetUser(); userName = User.UserName.ToString(); int userid; objOrganization = objOrganization.Get_Organization(); objUser = objUser.Get_UserLogin_By_UserName(userName, objOrganization.Orgid); int Solutionid; ObjSolution.Title = txtTitle.Text.ToString(); ObjSolution.Content=Editor.Text.ToString(); ObjSolution.Topicid = Convert.ToInt16(drpTopic.SelectedValue); ObjSolution.Solution = drpSolutionType.SelectedValue; ObjSolution.Insert(); Solutionid = ObjSolutionKeyword.Get_SolutionId(); ObjSolutionKeyword.Keywords=txtKeywords.Text.ToString(); ObjSolutionKeyword.Solutionid = Solutionid; ObjSolutionKeyword.Insert(); ObjSolutionCreator.Solutionid = Solutionid; ObjSolutionCreator.Createdby = objUser.Userid; ObjSolutionCreator.Insert(); objSentMailToUser.SentMailToPManager(Solutionid); Response.Redirect("ViewSolution.aspx?solutionid" + Solutionid); }
protected void Showvalues() { int incidentid = Convert.ToInt32(Session["incidentid"]); ObjIncident = ObjIncident.Get_By_id(incidentid); ObjIncidentStates = ObjIncidentStates.Get_By_id(incidentid); // drpTechnician.SelectedValue = ObjIncidentStates.Technicianid.ToString(); drpCategory.SelectedValue = ObjIncidentStates.Categoryid.ToString(); BindDropSubCategory(); drpSubcategory.SelectedValue = ObjIncidentStates.Subcategoryid.ToString(); // drpPriority.SelectedValue = ObjIncidentStates.Priorityid.ToString(); txtTitle.Text = ObjIncident.Title.ToString(); if (ObjIncident.Description != null) { txtDescription.Text = ObjIncident.Description.ToString(); } UserLogin_mst objUsr = new UserLogin_mst(); ContactInfo_mst objInfo = new ContactInfo_mst(); objInfo = objInfo.Get_By_id(ObjIncident.Requesterid); objUsr = objUsr.Get_By_id(ObjIncident.Requesterid); txtUsername.Text = objUsr.Username; txtEmail.Text = objInfo.Emailid; ViewState["UserCreate"] = "Exist"; }
protected void btnSolutionAdd_Click(object sender, EventArgs e) { string userName; MembershipUser User = Membership.GetUser(); userName = User.UserName.ToString(); int userid; objOrganization = objOrganization.Get_Organization(); objUser = objUser.Get_UserLogin_By_UserName(userName, objOrganization.Orgid); int Solutionid; ObjSolution.Title = txtTitle.Text.ToString(); ObjSolution.Content = Editor.Text.ToString(); ObjSolution.Topicid = Convert.ToInt16(drpTopic.SelectedValue); ObjSolution.Solution = drpSolutionType.SelectedValue; ObjSolution.Insert(); Solutionid = ObjSolutionKeyword.Get_SolutionId(); ObjSolutionKeyword.Keywords = txtKeywords.Text.ToString(); ObjSolutionKeyword.Solutionid = Solutionid; ObjSolutionKeyword.Insert(); ObjSolutionCreator.Solutionid = Solutionid; ObjSolutionCreator.Createdby = objUser.Userid; ObjSolutionCreator.Insert(); objSentMailToUser.SentMailToPManager(Solutionid); Response.Redirect("ViewSolution.aspx?solutionid" + Solutionid); }
public void updatecomment() { string userName; MembershipUser User = Membership.GetUser(); solutionstatusid = Convert.ToInt16(Request.QueryString[0]); flag = Convert.ToInt16(Request.QueryString[1]); int userid; if (flag == 3) { string seeionsid = Session["SolutionId"].ToString(); string[] str = seeionsid.Split(new char[] { ',' }); foreach (string s in str) { if (s == "") { break; } int solid = Convert.ToInt16(s); ObjSolution = ObjSolution.Get_By_id(solid); ObjSolution.Title = ObjSolution.Title; ObjSolution.Topicid = ObjSolution.Topicid; ObjSolution.Content = ObjSolution.Content; ObjSolution.Comments = txtcomments.Text; ObjSolution.SolutionStatus = solutionstatusid; ObjSolution.Update(); userName = User.UserName.ToString(); Objorganization = Objorganization.Get_Organization(); objUser = objUser.Get_UserLogin_By_UserName(userName, Objorganization.Orgid); ObjSolutionCreator.Solutionid = solid; ObjSolutionCreator.LastUpdateBy = objUser.Userid; ObjSolutionCreator.Update(); } } else { int solutionid = Convert.ToInt16(Request.QueryString[1]); ObjSolution = ObjSolution.Get_By_id(solutionid); ObjSolution.Title = ObjSolution.Title; ObjSolution.Topicid = ObjSolution.Topicid; ObjSolution.Content = ObjSolution.Content; ObjSolution.Comments = txtcomments.Text; ObjSolution.SolutionStatus = solutionstatusid; ObjSolution.Update(); userName = User.UserName.ToString(); Objorganization = Objorganization.Get_Organization(); objUser = objUser.Get_UserLogin_By_UserName(userName, Objorganization.Orgid); ObjSolutionCreator.Solutionid = solutionid; ObjSolutionCreator.LastUpdateBy = objUser.Userid; ObjSolutionCreator.Update(); } }
protected void Page_Load(object sender, EventArgs e) { string strStatusClose = Resources.MessageResource.strStatusClose.ToString().Trim(); string statusString = ""; int incidentid = Convert.ToInt16(Request.QueryString[0]); Objincident = Objincident.Get_By_id(incidentid); Objincidentstate = Objincidentstate.Get_By_id(incidentid); Objincidentresoution = Objincidentresoution.Get_By_id(incidentid); objstatus = objstatus.Get_By_id(Objincidentstate.Statusid); statusString = objstatus.Statusname.ToString(); if (statusString.ToLower() == strStatusClose.ToLower()) { lbltcktno.Text = Objincident.Incidentid.ToString(); lblcreatedate.Text = Objincident.Createdatetime.ToString(); if (Objincidentstate.AssignedTime != null) { lblstarttime.Text = Objincidentstate.AssignedTime.ToString(); } lblendtime.Text = Objincident.Completedtime.ToString(); Objcategory = Objcategory.Get_By_id(Objincidentstate.Categoryid); lblcomponenteffected.Text = Objcategory.CategoryName.ToString(); lbldescription.Text = Objincident.Title.ToString(); string bb = Objincidentresoution.Resolution.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(Objincident.Requesterid); lblcustomer.Text = objUser.Username.ToString(); objUser = objUser.Get_By_id(Objincidentstate.Technicianid); lblengineer.Text = objUser.Username.ToString(); objstatus = objstatus.Get_By_id(Objincidentstate.Statusid); lblrcaresult.Text = objstatus.Statusname.ToString(); } 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(); }
public void updatecomment() { string userName; MembershipUser User = Membership.GetUser(); solutionstatusid = Convert.ToInt32(Request.QueryString[0]); flag = Convert.ToInt32(Request.QueryString[1]); int userid; if (flag == 3) { string seeionsid = Session["SolutionId"].ToString(); string[] str = seeionsid.Split(new char[] { ',' }); foreach (string s in str) { if (s == "") { break; } int solid = Convert.ToInt32(s); ObjSolution = ObjSolution.Get_By_id(solid); ObjSolution.Title = ObjSolution.Title; ObjSolution.Topicid = ObjSolution.Topicid; ObjSolution.Content = ObjSolution.Content; ObjSolution.Comments = txtcomments.Text; ObjSolution.SolutionStatus = solutionstatusid; ObjSolution.Update(); userName = User.UserName.ToString(); Objorganization = Objorganization.Get_Organization(); objUser = objUser.Get_UserLogin_By_UserName(userName, Objorganization.Orgid); ObjSolutionCreator.Solutionid = solid; ObjSolutionCreator.LastUpdateBy = objUser.Userid; ObjSolutionCreator.Update(); } } else { int solutionid = Convert.ToInt32(Request.QueryString[1]); ObjSolution = ObjSolution.Get_By_id(solutionid); ObjSolution.Title = ObjSolution.Title; ObjSolution.Topicid = ObjSolution.Topicid; ObjSolution.Content = ObjSolution.Content; ObjSolution.Comments = txtcomments.Text; ObjSolution.SolutionStatus = solutionstatusid; ObjSolution.Update(); userName = User.UserName.ToString(); Objorganization = Objorganization.Get_Organization(); objUser = objUser.Get_UserLogin_By_UserName(userName, Objorganization.Orgid); ObjSolutionCreator.Solutionid = solutionid; ObjSolutionCreator.LastUpdateBy = objUser.Userid; ObjSolutionCreator.Update(); } }
protected void Page_Load(object sender, EventArgs e) { string strStatusClose = Resources.MessageResource.strStatusClose.ToString().Trim(); string statusString = ""; int incidentid =Convert.ToInt16(Request.QueryString[0]); Objincident = Objincident.Get_By_id(incidentid); Objincidentstate = Objincidentstate.Get_By_id(incidentid); Objincidentresoution = Objincidentresoution.Get_By_id(incidentid); objstatus = objstatus.Get_By_id(Objincidentstate.Statusid); statusString = objstatus.Statusname.ToString(); if (statusString.ToLower() == strStatusClose.ToLower()) { lbltcktno.Text = Objincident.Incidentid.ToString(); lblcreatedate.Text = Objincident.Createdatetime.ToString(); if (Objincidentstate.AssignedTime != null) { lblstarttime.Text = Objincidentstate.AssignedTime.ToString(); } lblendtime.Text = Objincident.Completedtime.ToString(); Objcategory=Objcategory.Get_By_id(Objincidentstate.Categoryid); lblcomponenteffected.Text = Objcategory.CategoryName.ToString(); lbldescription.Text = Objincident.Title.ToString(); string bb = Objincidentresoution.Resolution.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(Objincident.Requesterid); lblcustomer.Text = objUser.Username.ToString(); objUser = objUser.Get_By_id(Objincidentstate.Technicianid); lblengineer.Text = objUser.Username.ToString(); objstatus = objstatus.Get_By_id(Objincidentstate.Statusid); lblrcaresult.Text = objstatus.Statusname.ToString(); } 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(); }
protected void IncidentToAsset(int userid) { objOrganization = objOrganization.Get_Organization(); objUser = objUser.Get_UserLogin_By_UserName(txtUsername.Text.Trim().ToString().Trim(), objOrganization.Orgid); userid = Convert.ToInt16(objUser.Userid); assetid = Convert.ToInt16(objusertoasset.Get_AssetId_By_UserId(userid)); objassetmst = objassetmst.Get_By_id(assetid); compname = objassetmst.Computername; }
string GetUsername(int userid) { string username = ""; objUser = objUser.Get_By_id(userid); if (objUser.Userid != 0) { username = objUser.Username; } return(username); }
protected void BindDropSite() { string userName = ""; MembershipUser User = Membership.GetUser(); if (User != null) { userName = User.UserName.ToString(); } if (userName != "") { int userid; objOrganization = objOrganization.Get_Organization(); objUser = objUser.Get_UserLogin_By_UserName(userName, objOrganization.Orgid); if (objUser.Userid != 0) { userid = objUser.Userid; colUserToSite = ObjUserToSite.Get_All_By_userid(userid); foreach (UserToSiteMapping obj in colUserToSite) { int siteid; Site_mst objSite1 = new Site_mst(); siteid = obj.Siteid; objSite1 = objSite1.Get_By_id(siteid); if (objSite1.Siteid != 0) { colSite.Add(objSite1); } } } drpSite.DataTextField = "sitename"; drpSite.DataValueField = "siteid"; drpSite.DataSource = colSite; drpSite.DataBind(); ListItem item = new ListItem(); item.Text = "-------------Select-------------"; item.Value = "0"; drpSite.Items.Add(item); drpSite.SelectedValue = "0"; //drpSite1.DataTextField = "sitename"; //drpSite1.DataValueField = "siteid"; //drpSite1.DataSource = colSite; //drpSite1.DataBind(); //ListItem item1= new ListItem(); //item1.Text = "-------------Select-------------"; //item1.Value = "0"; //drpSite1.Items.Add(item1); //drpSite1.SelectedValue = "0"; } }
protected void btnapprove_Click(object sender, EventArgs e) { int userid=0; int incidentid = Convert.ToInt16(Session["incidentid"].ToString()); if (incidentid != 0) { //objIncidentLog = objIncidentLog.Get_By_id(incidentid); //if (objIncidentLog.Incidentid != 0) //{ // objIncidentLog.Incidentid = incidentid; // objIncidentLog.Incidentlog = txtcomments.Text; // objIncidentLog.Update(); //} //else //{ // objIncidentLog.Incidentid = incidentid; // objIncidentLog.Incidentlog = txtcomments.Text; // objIncidentLog.Insert(); //} string userName=""; MembershipUser User = Membership.GetUser(); if (User != null) { userName = User.UserName.ToString(); } if (userName != "") { objOrganization = objOrganization.Get_Organization(); objUser = objUser.Get_UserLogin_By_UserName(userName, objOrganization.Orgid); if (objUser.Userid != 0) { userid = objUser.Userid; } } objIncidentLog.Incidentid = incidentid; objIncidentLog.Userid = userid; objIncidentLog.Incidentlog = txtcomments.Text; objIncidentLog.Insert(); string myScript; myScript = "<script language=javascript>javascript:refreshParent(); javascript:window.close();</script>"; Page.RegisterClientScriptBlock("MyScript", myScript); } }
protected void BindDropSite() { string userName = ""; MembershipUser User = Membership.GetUser(); if (User != null) { userName = User.UserName.ToString(); } if (userName != "") { int userid; objOrganization = objOrganization.Get_Organization(); objUser = objUser.Get_UserLogin_By_UserName(userName, objOrganization.Orgid); if (objUser.Userid != 0) { userid = objUser.Userid; colUserToSite = ObjUserToSite.Get_All_By_userid(userid); foreach (UserToSiteMapping obj in colUserToSite) { int siteid; Site_mst objSite1 = new Site_mst(); siteid = obj.Siteid; objSite1 = objSite1.Get_By_id(siteid); if (objSite1.Siteid != 0) { int custid = Convert.ToInt16(drpCustomer.SelectedValue); int flag = objCustToSite.Get_By_Id(custid, objSite1.Siteid); if (flag == 1) { colSite.Add(objSite1); } } } } drpSite.DataTextField = "sitename"; drpSite.DataValueField = "siteid"; drpSite.DataSource = colSite; drpSite.DataBind(); if (colSite.Count == 0) { ListItem item = new ListItem(); item.Text = "-------------Select-------------"; item.Value = "0"; drpSite.Items.Add(item); } } }
protected void GetUserDetail() { string userName = ""; MembershipUser User = Membership.GetUser(); if (User != null) { userName = User.UserName.ToString(); txtUsername.Text = User.UserName.ToString(); } if (userName != "") { int userid; objOrganization = objOrganization.Get_Organization(); objUser = objUser.Get_UserLogin_By_UserName(userName, objOrganization.Orgid); //objRole = objRole.Get_By_id(roleid); if (objUser.Userid != 0) { ContactInfo_mst objConInfo = new ContactInfo_mst(); userid = objUser.Userid; IncidentToAsset(userid); objConInfo = objConInfo.Get_By_id(userid); txtEmail.Text = objConInfo.Emailid; txtassignasset.Text = compname; //priorityid = Convert.ToInt32(objConInfo.userpriority); //BindDropPriority(int priorityid); //ContactInfo_mst objcnt = new ContactInfo_mst(); //if (objRole.roleid != 1) //{ if (objConInfo.userpriority == 1) { priorityid = objPriority.Get_By_PriorityName("High"); } else { priorityid = objPriority.Get_By_PriorityName("Medium"); } //} Priority_mst objP = new Priority_mst(); objP = objPriority.Get_By_id(priorityid); colPriority.Add(objP); drpPriority.DataTextField = "name"; drpPriority.DataValueField = "priorityid"; drpPriority.DataSource = colPriority; drpPriority.DataBind(); } } }
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); }
// Event handler btnShow_Click , To Bind Sites to Grid View on the Selected Username and Region protected void btnShow_Click(object sender, EventArgs e) { // Declare local Variable gvIDs,Username,organizationId and FlagStatus string gvIDs; string Username; int organizationId; int FlagStatus; lblErrorMsg.Text = ""; // To get the Object of Organization ,to find the organization id objOrganization = objOrganization.Get_Organization(); // Assign Organization Id to local variable organizationId organizationId = objOrganization.Orgid; // Assign Username from textbox to local variable Username Username = txtUserName.Text.ToString().Trim(); // Get Object of UserLogin_mst Class on the basis of username and OrganizationId objUser = objUser.Get_UserLogin_By_UserName(Username, organizationId); // If Userid is not equal to Zero ,then user Exist if (objUser.Userid != 0) { // Bind Grid of Sites BindGrid(); // To check row by row of gridview ,how many sites have been mapped to this user from table UserToSiteMapping foreach (GridViewRow gv in grdvwSite.Rows) { // Declare local variable deleteChkBxItem of Checkbox type to get the Checkbox Instance of Grid Row CheckBox deleteChkBxItem = (CheckBox)gv.FindControl("deleteRec"); // Get the Site Id from variable of Label type declare in GridView of grdvwSite gvIDs = ((Label)gv.FindControl("SiteID")).Text.ToString(); // Check if gvIDs is not null if (gvIDs != "") { // Declare local variable userid and siteid to get userid and SiteId int userid; int siteid; userid = Convert.ToInt16(objUser.Userid); siteid = Convert.ToInt16(gvIDs); // To Find Current Site to this User is Mapped by Calling Function objUserToSite.Get_By_Id() FlagStatus = objUserToSite.Get_By_Id(userid, siteid); // If FlagStatus is not zero then site is mapped to this user if (FlagStatus != 0) { //Checked checkbox to show site is mapped to this user deleteChkBxItem.Checked = true; } } } } }
protected void btnapprove_Click(object sender, EventArgs e) { /////Add Exception handilng try catch change by vishal 21-05-2012 try { int userid = 0; int incidentid = Convert.ToInt32(Session["incidentid"].ToString()); if (incidentid != 0) { string userName = ""; MembershipUser User = Membership.GetUser(); if (User != null) { userName = User.UserName.ToString(); } if (userName != "") { objOrganization = objOrganization.Get_Organization(); objUser = objUser.Get_UserLogin_By_UserName(userName, objOrganization.Orgid); if (objUser.Userid != 0) { userid = objUser.Userid; } } objIncidentLog.Incidentid = incidentid; objIncidentLog.Userid = userid; objIncidentLog.Incidentlog = txtcomments.Text; objIncidentLog.Insert(); string myScript; myScript = "<script language=javascript>javascript:window.close();</script>"; Page.RegisterClientScriptBlock("MyScript", myScript); } } catch (Exception ex) { string myScript; myScript = "<script language=javascript>alert('Exception - '" + ex + "');</script>"; Page.RegisterClientScriptBlock("MyScript", myScript); return; } }
protected void txtUsername_TextChanged(object sender, EventArgs e) { #region Find Userid of User who is Requesting to log a call objOrganization = objOrganization.Get_Organization(); ObjUserLogin = ObjUserLogin.Get_UserLogin_By_UserName(txtUsername.Text.ToString().Trim(), objOrganization.Orgid); if (ObjUserLogin.Userid == 0) { string myScript; myScript = "<script language=javascript>function __doPostBack(eventTarget, eventArgument){var theForm = document.forms['aspnetForm']; if (theForm){ theForm.__EVENTTARGET.value = eventTarget;theForm.__EVENTARGUMENT.value = eventArgument;theForm.submit(); }} var Flag= confirm('User Does not Exist,Do You Want to Create User');if(Flag==true){ __doPostBack('callPostBack', 'create');}if(Flag==false){ __doPostBack('callPostBack', 'notcreate');}</script>"; Page.RegisterClientScriptBlock("MyScript", myScript); } else { ViewState["UserCreate"] = "Exist"; } #endregion }
protected void BindIncidentToProblem() { if (Session["IncidentToProblem"] != null) { int incidentid = Convert.ToInt32(Session["IncidentToProblem"].ToString()); Incident_mst objIncident = new Incident_mst(); IncidentStates objIncidentStates = new IncidentStates(); objIncident = objIncident.Get_By_id(incidentid); objIncidentStates = objIncidentStates.Get_By_id(incidentid); objuser = objuser.Get_By_id(objIncident.Requesterid); if (objIncidentStates.Priorityid != 0) { drpPriority.SelectedValue = Convert.ToString(objIncidentStates.Priorityid); } if (objIncidentStates.Categoryid != 0) { drpCategory.SelectedValue = Convert.ToString(objIncidentStates.Categoryid); BindDropSubCategory(); } if (objIncidentStates.Subcategoryid != 0) { drpSubcategory.SelectedValue = Convert.ToString(objIncidentStates.Subcategoryid); } if (objIncidentStates.Technicianid != 0) { drpTechnician.SelectedValue = Convert.ToString(objIncidentStates.Technicianid); } txtDescription.Text = objIncident.Description; txtTitle.Text = objIncident.Title; if (objuser.Userid != 0) { ContactInfo_mst objInfo = new ContactInfo_mst(); objInfo = objInfo.Get_By_id(objuser.Userid); txtUsername.Text = objuser.Username; txtEmail.Text = objInfo.Emailid; ViewState["UserCreate"] = "Exist"; } } }
protected void grdvwUser_RowDeleting(object sender, GridViewDeleteEventArgs e) { // Hndling GridView RowDeleting Event for deleting Row for selected UserId int userid; userid = Convert.ToInt16(grdvwUser.Rows[e.RowIndex].Cells[0].Text); UserLogin_mst obj = new UserLogin_mst(); obj = ObjUserlogin.Get_By_id(userid); if (obj.Userid != 0) { Membership.DeleteUser(obj.Username, true); } Objcontactinfo.Delete(userid); ObjUserlogin.Delete(userid); // Bind GridView BindGrid(); }
public void SentMailToChangeCommittee(int changeid, int changetypeid) { string strYourSinscerely = Resources.MessageResource.strYourSinscerely.ToString(); string strContactNumber = Resources.MessageResource.strContactNumber.ToString(); Cab_mst Objcabmember = new Cab_mst(); ObjChange = ObjChange.Get_By_id(changeid); BLLCollection <Cab_mst> colmembers = new BLLCollection <Cab_mst>(); UserLogin_mst objUserCreator = new UserLogin_mst(); int FlagUser; int roleid; string varServerName; varServerName = Resources.MessageResource.serverNameForChangePage.ToString(); // varServerName = "10.80.0.15"; string url11; url11 = "http://" + varServerName + "/BEST/LoginPageAccess/ApproveorRejectChangeRequest.aspx?changeid=" + changeid; colmembers = Objcabmember.Get_All_By_ChangeTypeid(changetypeid); string url; foreach (Cab_mst objmember in colmembers) { url = "<a href=" + url11 + "&userid=" + objmember.Membername + " ' onclick=window.open()>Click Here For Approval</a>"; obj.From = Resources.MessageResource.strAdminEmail.ToString(); obj.To = objmember.Emailid; obj.Subject = "New Change Added. Change Id : " + changeid; obj.Body = "Dear Sir/Madam,<br/>A New Change has been requested.Please.<br/><br/><b>Solution Details : </b> <br/><br/><b>Changeid Id :</b>" + ObjChange.Changeid + "<br/><b>Title :</b>" + ObjChange.Title + " <br/><b>Added By :</b>" + ObjChange.CreatedByID + "<br/><b>Created Date   :</b>" + ObjChange.Createdtime + "<br/><b>Content :</b>" + ObjChange.Description + "<br/><br/>This is an auto generated mail. Please do not reply.</b><br/><br/></b><br/><b>Kindly Click the following link to Aprove or Reject the Change Request. <br></br>" + url + " <b><br/><br/><b>Yours sincerely,</b><br/> <b>" + strYourSinscerely + "</b>"; obj.SmtpServer = Resources.MessageResource.strSMTPServer.ToString(); obj.SentMail(); } }
public void SentMailToSDM(int siteid, int incidentid, int requesterid) { string strYourSinscerely = Resources.MessageResource.strYourSinscerely.ToString(); string strContactNumber = Resources.MessageResource.strContactNumber.ToString(); int FlagUser; string varRole = Resources.MessageResource.strSDMRole.ToString(); int roleid; roleid = objRole.Get_By_RoleName(varRole); colUser = objUser.Get_All_By_Role(roleid); foreach (UserLogin_mst objusr in colUser) { FlagUser = objUserToSiteMapping.Get_By_Id(objusr.Userid, siteid); if (FlagUser != 0) { objIncident = objIncident.Get_By_id(incidentid); objSite = objSite.Get_By_id(objIncident.Siteid); objIncidentStates = objIncidentStates.Get_By_id(incidentid); objPriority = objPriority.Get_By_id(objIncidentStates.Priorityid); UserLogin_mst obju = new UserLogin_mst(); UserLogin_mst objReq = new UserLogin_mst(); obju = obju.Get_By_id(objUserToSiteMapping.Userid); objC_info = objC_info.Get_By_id(objusr.Userid); objReq = objReq.Get_By_id(requesterid); ContactInfo_mst objReqContInfo = new ContactInfo_mst(); objReqContInfo = objReqContInfo.Get_By_id(objReq.Userid); obj.From = Resources.MessageResource.strAdminEmail.ToString(); obj.To = objC_info.Emailid; obj.Subject = "High Priority Call. Ticket Id: " + incidentid; obj.Body = "Dear Sir/Madam,<br/>High Priority Call has been logged, please find below the Complaint details .<br/><br/><b>Complaints Details : </b> <br/><br/><b>Ticket Id :</b>" + incidentid + "<br/><b>Title of Call :</b>" + objIncident.Title + " <br/><b>Site :</b>" + objSite.Sitename + "<br/><b>Logged Date & Time   :</b>" + objIncident.Createdatetime + "<br/><b>Description :</b>" + objIncident.Description + "<br/><b>Priority :</b> " + objPriority.Name + "<br/><b>UserName :</b>" + objReq.Username + "<br/><b>Mail Address :</b>" + objReqContInfo.Emailid + "<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 = Resources.MessageResource.strSMTPServer.ToString(); obj.SentMail(); } } }
protected void btnSolutionAdd_Click(object sender, EventArgs e) { ///Add Exception handilng try catch change by vishal 21-05-2012 try { string userName; MembershipUser User = Membership.GetUser(); userName = User.UserName.ToString(); int userid; objOrganization = objOrganization.Get_Organization(); objUser = objUser.Get_UserLogin_By_UserName(userName, objOrganization.Orgid); int Solutionid; ObjSolution.Title = txtTitle.Text.ToString(); ObjSolution.Content=Editor.Text.ToString(); ObjSolution.Topicid = Convert.ToInt32(drpTopic.SelectedValue); ObjSolution.Solution = drpSolutionType.SelectedValue; ObjSolution.Insert(); Solutionid = ObjSolutionKeyword.Get_SolutionId(); ObjSolutionKeyword.Keywords=txtKeywords.Text.ToString(); ObjSolutionKeyword.Solutionid = Solutionid; ObjSolutionKeyword.Insert(); ObjSolutionCreator.Solutionid = Solutionid; ObjSolutionCreator.Createdby = objUser.Userid; ObjSolutionCreator.Insert(); objSentMailToUser.SentMailToPManager(Solutionid); Response.Redirect("ViewSolution.aspx?solutionid" + Solutionid); } catch (Exception ex) { string myScript; myScript = "<script language=javascript>alert('Exception - '" + ex + "');</script>"; Page.RegisterClientScriptBlock("MyScript", myScript); return; } }
protected void Bindgrid() { #region Declaration of localvariable and table Variable int filterId; DataTable dtTable = new DataTable(); dtTable = CreateDataTable(); string userName = ""; int varTechnicianId = 0; string varSortParameter = "createdatetime"; #endregion #region Get Current User and his Role MembershipUser User = Membership.GetUser(); string varUserRole = ""; string varRoleTechnician = ""; if (User != null) { userName = User.UserName.ToString(); string[] arrUserRole = Roles.GetRolesForUser(); varUserRole = arrUserRole[0].ToString(); varRoleTechnician = Resources.MessageResource.strTechnicianRole.ToString(); } #endregion #region Get User object by Calling Function Get_UserLogin_By_UserName() via passing parameter username and organizationid objOrganization = objOrganization.Get_Organization(); objUser = objUser.Get_UserLogin_By_UserName(userName, objOrganization.Orgid); #endregion #region If User Exist if (objUser.Userid != 0) { string fromdate = null; string todate = null; #region Find how many sites have been mapped to current user by calling function Get_All_By_userid() via passing parameter userid int userid = objUser.Userid; colUserToSite = ObjUserToSite.Get_All_By_userid(userid); #endregion #region Fetch each object from Collection of UserToSiteMapping foreach (UserToSiteMapping obj in colUserToSite) { #region Declare Local Variables and Collection of Incident_mst Type string Status; BLLCollection <Incident_mst> col = new BLLCollection <Incident_mst>(); int siteid; #endregion #region Get the Siteid and Filter Parameter siteid = obj.Siteid; filterId = 0; #endregion #region If Role of User is Technician #region If Filter Variable is All if (filterId == 0) { col = objIncident.Get_All_By_Siteid_Requesterid(siteid, objUser.Userid, fromdate, todate, varSortParameter); } #endregion #endregion #region Fetch Each object of type Incident_mst from Collection Incident_mst foreach (Incident_mst objInc in col) { #region Create Table row and assign value to it DataRow row; row = dtTable.NewRow(); row["incidentid"] = Convert.ToString(objInc.Incidentid); row["title"] = objInc.Title; row["requesterid"] = Convert.ToString(objInc.Requesterid); row["createdbyid"] = Convert.ToString(objInc.Createdbyid); row["siteid"] = Convert.ToString(objInc.Siteid); row["createdatetime"] = Convert.ToString(objInc.Createdatetime); objIncidentStates = objIncidentStates.Get_By_id(objInc.Incidentid); row["statusid"] = objIncidentStates.Statusid; row["technicianid"] = objIncidentStates.Technicianid; row["priorityid"] = objIncidentStates.Priorityid; dtTable.Rows.Add(row); #endregion } #endregion } #endregion #region Bind Grid from datasource dtTable DataView dvData = new DataView(dtTable); string sortFormat = "{0} {1}"; String sortDirection = "DESC"; if (varSortParameter == "createdatetime") { varSortParameter = "incidentid"; } dvData.Sort = String.Format(sortFormat, varSortParameter, sortDirection); grdvwRequest.DataSource = dvData; grdvwRequest.DataBind(); #endregion } #endregion }
//#region Handle Button btnAssigned Click Event //protected void btnAssigned_Click(object sender, EventArgs e) //{ // #region Fetch Each Row from GridView,and Check Which Check Box is Selected // foreach (GridViewRow gv in grdvwRequest.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 incidentid; // int varSiteid; // int oldtechnicianvalue; // #endregion // #region Get the Incident Id from variable of Label type declare in GridView of grdvwSite // gvIDs = ((Label)gv.FindControl("incidentid")).Text.ToString(); // #endregion // #region Convert to incident id into integer // incidentid = Convert.ToInt32(gvIDs); // #endregion // #region If Incident id in Not Null // if (gvIDs != "") // { // Incident_mst objInc = new Incident_mst(); // IncidentStates objIncSta = new IncidentStates(); // objIncSta = objIncSta.Get_By_id(incidentid); // if (objIncSta.Incidentid != 0) // { // oldtechnicianvalue = objIncSta.Technicianid; // int technicianid=Convert.ToInt32(drpTechnician1.SelectedValue); // if(technicianid!=0) // { // int userid = Convert.ToInt32(ViewState["Userid"].ToString()); // #region Update into IncidentStates Table // objIncidentStates.Incidentid = incidentid; // objIncidentStates.Technicianid = technicianid; // objIncidentStates.Subcategoryid = objIncSta.Subcategoryid; // objIncidentStates.Statusid = objIncSta.Statusid; // objIncidentStates.Requesttypeid = objIncSta.Requesttypeid; // objIncidentStates.Priorityid = objIncSta.Priorityid; // objIncidentStates.Categoryid = objIncSta.Categoryid; // objIncidentStates.AssignedTime = objIncSta.AssignedTime; // objIncidentStates.Update(); // #endregion // #region Insert into IncidentHistory Table // objIncidentHistory.Incidentid = incidentid; // objIncidentHistory.Operationownerid = userid; // objIncidentHistory.Operation = "update"; // objIncidentHistory.Insert(); // #endregion // #region Get the Current historyid by calling function Get_Current_IncidentHistoryid() // int historyid = objIncidentHistory.Get_Current_IncidentHistoryid(); // #endregion // #region If technician value is changed,Insert into IncidentHistoryDiff table // #region Declare Local variables // string columnName; // string prev_value; // string curnt_value; // #endregion // #region Get Column Name from MessageResource File // columnName = Resources.MessageResource.strColumnTechnicianid.ToString(); // #endregion // prev_value = Convert.ToString(oldtechnicianvalue); // curnt_value = Convert.ToString(drpTechnician1.SelectedValue); // objIncidentHistoryDiff.Historyid = historyid; // objIncidentHistoryDiff.Columnname = columnName; // objIncidentHistoryDiff.Current_value = curnt_value; // objIncidentHistoryDiff.Prev_value = prev_value; // objIncidentHistoryDiff.Insert(); // if (objIncSta.AssignedTime == null) // { // columnName = Resources.MessageResource.strColumnAssignedTime.ToString(); // prev_value = "0"; // curnt_value = DateTime.Now.ToString(); // objIncidentHistoryDiff.Historyid = historyid; // objIncidentHistoryDiff.Columnname = columnName; // objIncidentHistoryDiff.Current_value = curnt_value; // objIncidentHistoryDiff.Prev_value = prev_value; // objIncidentHistoryDiff.Insert(); // } // else // { // columnName = "AssignedTime"; // prev_value = objIncSta.AssignedTime; // curnt_value = DateTime.Now.ToString(); // objIncidentHistoryDiff.Historyid = historyid; // objIncidentHistoryDiff.Columnname = columnName; // objIncidentHistoryDiff.Current_value = curnt_value; // objIncidentHistoryDiff.Prev_value = prev_value; // objIncidentHistoryDiff.Insert(); // } // #endregion // objInc = objIncident.Get_By_id(incidentid); // if (objInc.Siteid != Convert.ToInt32(drpSite1.SelectedValue)) // { // int oldsiteid = objInc.Siteid; // int oldslaid = objInc.Slaid; // objInc.Siteid = Convert.ToInt32(drpSite1.SelectedValue); // int SLAid = objIncident.Get_By_SLAid(Convert.ToInt32(drpSite1.SelectedValue), objIncSta.Priorityid ); // int requesttypeid = Convert.ToInt32(Resources.MessageResource.strRequestTypeId.ToString()); // if (requesttypeid == Convert.ToInt32(objIncSta.Requesttypeid )) // { // SLAid = 0; // } // objInc.Slaid = SLAid; // objInc.Active = true; // objInc.Update(); // #region If site value is changed,Insert into IncidentHistoryDiff table // columnName = Resources.MessageResource.strColumnSiteid.ToString(); // prev_value = Convert.ToString(oldsiteid); // curnt_value = drpSite1.SelectedValue; // objIncidentHistoryDiff.Historyid = historyid; // objIncidentHistoryDiff.Columnname = columnName; // objIncidentHistoryDiff.Current_value = curnt_value; // objIncidentHistoryDiff.Prev_value = prev_value; // objIncidentHistoryDiff.Insert(); // #endregion // #region If SLA value is changed,Insert into IncidentHistoryDiff table // columnName = Resources.MessageResource.strColumnSLAid.ToString(); // prev_value = Convert.ToString(oldslaid); // curnt_value = Convert.ToString(SLAid); // objIncidentHistoryDiff.Historyid = historyid; // objIncidentHistoryDiff.Columnname = columnName; // objIncidentHistoryDiff.Current_value = curnt_value; // objIncidentHistoryDiff.Prev_value = prev_value; // objIncidentHistoryDiff.Insert(); // #endregion // } // } // } // varSiteid = Convert.ToInt32(drpSite.SelectedValue); // if (varSiteid == 0) // { BindGridForAllParameter(); } // else { BindGridForSelectedParameter(); } // } // #endregion // } // #endregion // } // #endregion //} //#endregion protected void BindSelectedFilter() { string keyword = Session["keyword"].ToString(); string Filterid = Session["Filterid"].ToString(); string userName = ""; MembershipUser User = Membership.GetUser(); if (User != null) { userName = User.UserName.ToString(); } objOrganization = objOrganization.Get_Organization(); objUser = objUser.Get_UserLogin_By_UserName(userName, objOrganization.Orgid); string Uid = objUser.Userid.ToString(); #region Declaration of localvariable and table Variable DataTable dtTable = new DataTable(); dtTable = CreateDataTable(); #endregion BLLCollection<Incident_mst> col = new BLLCollection<Incident_mst>(); col = objIncident.Get_All_Incidentid_By_SearchParameter(Filterid, keyword,Uid); #region Create Table row and assign value to it foreach (Incident_mst obj in col) { IncidentStates objS = new IncidentStates(); DataRow row; row = dtTable.NewRow(); row["incidentid"] = Convert.ToString(obj.Incidentid); row["title"] = obj.Title; row["requesterid"] = Convert.ToString(obj.Requesterid); row["createdbyid"] = Convert.ToString(obj.Createdbyid); row["siteid"] = Convert.ToString(obj.Siteid); row["createdatetime"] = Convert.ToString(obj.Createdatetime); objS = objS.Get_By_id(obj.Incidentid); row["statusid"] = objS.Statusid; row["technicianid"] = objS.Technicianid; row["priorityid"] = objS.Priorityid; dtTable.Rows.Add(row); } #endregion grdvwRequest.DataSource = dtTable; grdvwRequest.DataBind(); Session.Remove("Filterid"); Session.Remove("keyword"); ViewState["keyword"] = keyword; ViewState["Filterid"] = Filterid; }
protected void btnAdd_Click(object sender, EventArgs e) { bool FlagUserStatus = true; #region Find Userid of User who is Requesting to log a call #region If User Already Exist if (ViewState["UserCreate"].ToString() == "Exist") { objOrganization = objOrganization.Get_Organization(); ObjUserLogin = ObjUserLogin.Get_UserLogin_By_UserName(txtUsername.Text.ToString().Trim(), objOrganization.Orgid); if (ObjUserLogin.Userid != 0) { requesterid = ObjUserLogin.Userid; } } #endregion #region If New User is to be Created else if (ViewState["UserCreate"].ToString() == "create") { string varEmail = ""; string varRoleName = Resources.MessageResource.BasicUserRole.ToString(); if (txtEmail.Text == "") { varEmail = Resources.MessageResource.errMemshipCreateUserEmail.ToString(); } else { varEmail = txtEmail.Text; } int roleid = objRole.Get_By_RoleName(varRoleName); int status; objOrganization = objOrganization.Get_Organization(); objuser.Username = txtUsername.Text.ToString(); objuser.Password = Resources.MessageResource.strDefaultPassword.ToString(); objuser.Roleid = roleid; objuser.Orgid = objOrganization.Orgid; objuser.ADEnable = false; objuser.Enable = true; objuser.Createdatetime = DateTime.Now.ToString(); status = objuser.Insert(); if (status == 1) { // Create Mstatus field to send in Membership.CreateUser function as Out Variable for creating Membership User database MembershipCreateStatus Mstatus = default(MembershipCreateStatus); // Call Membership.CreateUser function to create Membership user Membership.CreateUser(txtUsername.Text.ToString().Trim(), Resources.MessageResource.strDefaultPassword.ToString(), varEmail, "Project Name", "Helpdesk", true, out Mstatus); // Call Roles.AddUserToRole Function to Add User To Role Roles.AddUserToRole(txtUsername.Text.ToString().Trim(), varRoleName); // Declare Local Variable Userid to fetch userid of newly created user // Create Object objUserLogin of UserLogin_mst()Class objuser = new UserLogin_mst(); // Fetch userid of Newly created user and assign to local variable userid by calling function objUserLogin.Get_By_UserName requesterid = objuser.Get_By_UserName(txtUsername.Text.ToString().Trim(), objOrganization.Orgid); // If userid not equal to 0 then we get userid of Newly created user otherwise error Occured ContactInfo_mst objContactInfo = new ContactInfo_mst(); objContactInfo.Userid = requesterid; objContactInfo.Emailid = varEmail; objContactInfo.Firstname = txtUsername.Text.ToString(); objContactInfo.Lastname = txtUsername.Text.ToString(); objContactInfo.Insert(); } } #endregion #region If User is Not to be Created else if (ViewState["UserCreate"].ToString() == "notcreate") { FlagUserStatus = false; } #endregion #endregion MembershipUser User = Membership.GetUser(); string userName; userName = User.UserName.ToString(); if (FlagUserStatus == true) { objOrganization = objOrganization.Get_Organization(); objuser = objuser.Get_UserLogin_By_UserName(userName, objOrganization.Orgid); ObjProblem.CreatedByid = objuser.Userid; ObjProblem.Requesterid = requesterid; ObjProblem.Categoryid = Convert.ToInt16(drpCategory.SelectedValue); ObjProblem.Subcategoryid = Convert.ToInt16(drpSubcategory.SelectedValue); ObjProblem.Priorityid = Convert.ToInt16(drpPriority.SelectedValue); ObjProblem.Statusid = Convert.ToInt16(drpStatus.SelectedValue); ObjProblem.Technicianid = Convert.ToInt16(drpTechnician.SelectedValue); ObjProblem.title = txtTitle.Text; ObjProblem.Description = txtDescription.Text; if (Convert.ToInt16(drpTechnician.SelectedValue) != 0) { ObjProblem.AssginedTime = DateTime.Now.ToString(); } ObjProblem.Insert(); int problemid = ObjProblem.Get_Current_Problemid(); ObjProblemHistory.Operationtime = DateTime.Now.ToString(); ObjProblemHistory.Problemid = problemid; ObjProblemHistory.Operation = "create"; ObjProblemHistory.Operationownerid = objuser.Userid; if (Session["IncidentToProblem"] != null) { int incidentid = Convert.ToInt16(Session["IncidentToProblem"].ToString()); Incident_To_Problem objIncToprob = new Incident_To_Problem(); objIncToprob.Incidentid = incidentid; objIncToprob.Problemid = problemid; objIncToprob.Insert(); } if (Convert.ToInt16(drpTechnician.SelectedValue) != 0) { objSentMailToUser.SentMailToTechnicianForProblemCall(problemid, Convert.ToInt16(drpTechnician.SelectedValue)); } ObjProblemHistory.Insert(); //ResetControls(); string myScript; myScript = "<script language=javascript>javascript:window.close();</script>"; Page.RegisterClientScriptBlock("MyScript", myScript); } }
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 } }
string GetUsername(int userid) { string username = ""; objUser = objUser.Get_By_id(userid); if (objUser.Userid != 0) { username = objUser.Username; } return username; }
protected void btnSave_Click(object sender, EventArgs e) { // Save User to Database on Button Save click Event // Start objOrganization = objOrganization.Get_Organization(); //Declare Local Variables - Flag,varRolename,FlagMembership int Flag; string varRoleName; bool FlagMembership; // Use Asp.Net Membership Validator Control Membership.ValidateUser to check User Exist in aspnet Database FlagMembership = Membership.ValidateUser(txtUserName.Text.ToString().Trim(), txtPassword.Text.ToString().Trim()); // Create Object of UserLogin_mst Class to Check User Exist in Database UserLogin_mst table UserLogin_mst objUserLogin = new UserLogin_mst(); // Declare local Variable Flag to Check Status User Exist in databse Flag = objUserLogin.Get_By_UserName(txtUserName.Text.ToString().Trim(), objOrganization.Orgid ); // If User Does'nt exist in Database and in aspnet databse then flag value will 0 and FlagMembership value will be False if (Flag == 0 && FlagMembership==false) { // Declare status local variable int status; // Create Object objUserLogin of UserLogin_mst() Class to insert record in table objUserLogin = new UserLogin_mst(); objUserLogin.Username = txtUserName.Text.ToString().Trim(); objUserLogin.Password = txtPassword.Text.ToString().Trim(); objUserLogin.Roleid = Convert.ToInt16(dropRole.SelectedValue); objUserLogin.Orgid = objOrganization.Orgid ; objUserLogin.ADEnable = false; objUserLogin.Enable = true; objUserLogin.Createdatetime = DateTime.Now.ToString(); // Call Insert function to insert record in UserLogin_mst table // Check status whether Record inserted Successfully or Not,If status=1 then Success otherwise Operation Fail status = objUserLogin.Insert(); if (status == 1) { // Declare local variable varEmail to fetch email of user from textbox string varEmail; //If Email field is Not Empty then Assign value to varEmail Local Variable if (txtEmailId.Text != "") { varEmail = txtEmailId.Text.Trim(); } // Else Assign value define in MessagesResources.resx file in errMemshipCreateUserEmail field else { varEmail = Resources.MessageResource.errMemshipCreateUserEmail.ToString(); } // Assign selected text from droprole down to local variable field varRoleName varRoleName = dropRole.SelectedItem.Text.ToString().Trim(); // Create Mstatus field to send in Membership.CreateUser function as Out Variable for creating Membership User database MembershipCreateStatus Mstatus = default(MembershipCreateStatus); // Call Membership.CreateUser function to create Membership user Membership.CreateUser(txtUserName.Text.ToString().Trim(), txtPassword.Text.ToString().Trim(), varEmail, "Project Name", "Helpdesk", true, out Mstatus); // Call Roles.AddUserToRole Function to Add User To Role Roles.AddUserToRole(txtUserName.Text.ToString().Trim(), varRoleName); // Declare Local Variable Userid to fetch userid of newly created user int userid; // Create Object objUserLogin of UserLogin_mst()Class objUserLogin = new UserLogin_mst(); // Fetch userid of Newly created user and assign to local variable userid by calling function objUserLogin.Get_By_UserName userid = objUserLogin.Get_By_UserName(txtUserName.Text.ToString().Trim(), objOrganization.Orgid ); // If userid not equal to 0 then we get userid of Newly created user otherwise error Occured UserToSiteMapping objusertositemapping = new UserToSiteMapping(); if (userid != 0) { // Create Object objContactInfo of ContactInfo_mst class to Store User Contact Information in Contact_info table ContactInfo_mst objContactInfo = new ContactInfo_mst(); objContactInfo.Userid = userid; objContactInfo.Firstname = txtFname.Text.ToString().Trim(); objContactInfo.Lastname = txtLname.Text.ToString().Trim(); objContactInfo.Description = txtDesc.Text.ToString().Trim(); objContactInfo.Empid = txtEmpId.Text; objContactInfo.Emailid = txtEmailId.Text.ToString().Trim(); objContactInfo.Landline = txtLandline.Text.ToString().Trim(); objContactInfo.Mobile = txtMobile.Text.ToString().Trim(); objContactInfo.Siteid = Convert.ToInt16(DrpSite.SelectedValue); //if (DrpDepartment.SelectedItem.ToString() != null) //{ objContactInfo.Deptid = Convert.ToInt16(DrpDepartment.SelectedValue); //} // Call objContactInfo.Insert function to Insert record in Contact_info table objContactInfo.Insert(); // Show Message Operation perform successfully //lblMessage.Text = Resources.MessageResource.errDataSave.ToString(); // Calling Function Clear() to Clear all controls on Form objusertositemapping.Userid = userid; objusertositemapping.Siteid = Convert.ToInt16(DrpSite.SelectedValue); objusertositemapping.Insert(); Clear(); Response.Redirect("~/admin/ViewUser.aspx"); } else { // Show Message Error Occured due to some Reason lblMessage.Text = Resources.MessageResource.errOccured.ToString(); } } else { // Show Message Error Occured due to some Reason lblMessage.Text = Resources.MessageResource.errOccured.ToString(); } } else { // Show Message User Already Exist lblMessage.Text = Resources.MessageResource.errUserExist.ToString(); } // End Save button Click }
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 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 btngetuser_Click(object sender, EventArgs e) //{ // lblErrorMsg.Text = ""; // string Username = txtusername.Text.ToString().Trim(); // objUser = objUser.Get_UserLogin_By_UserName_Like(Username); // if (objUser.Userid != 0) // { // txtusername.Text = objUser.Username.ToString().Trim(); // userid = objUser.Userid; // } // else // { // txtusername.Text = ""; // } //} //protected void btnshow_Click(object sender, EventArgs e) //{ // lblErrorMsg.Text = ""; // string Username = txtusername.Text.ToString().Trim(); // objUser = objUser.Get_UserLogin_By_UserName_Like(Username); // userid = objUser.Userid; // int assid=Convert.ToInt32(objusertoasset.Get_AssetId_By_UserId(userid)); // int usercount = objusertoasset.Get_UserId_From_UserToAssetMap(userid); // col = ObjAsset.Get_Assetdetails_By_Assetid(assid); // grdvwViewAsset.DataSource = col; // grdvwViewAsset.DataBind(); // foreach (GridViewRow gv in grdvwViewAsset.Rows) // { // RadioButton selectonebutton = (RadioButton)gv.FindControl("selectone"); // selectonebutton.Checked = true; // } //} protected void btnMapped_Click(object sender, EventArgs e) { /////Add Exception handilng try catch change by vishal 21-05-2012 try { lblErrorMsg.Text = ""; int flag = 0; foreach (GridViewRow gv in grdvwViewAsset.Rows) { string gvIDs; RadioButton selectonebutton = (RadioButton)gv.FindControl("selectone"); if (selectonebutton.Checked) { flag = 1; int assetid; gvIDs = ((Label)gv.FindControl("lblAssetID")).Text.ToString(); assetid = Convert.ToInt32(gvIDs); string Username = txtusername.Text.ToString().Trim(); objUser = objUser.Get_UserLogin_By_UserName_Like(Username); //objcontactinfo = objcontactinfo.Get_By_id(objUser.Userid); //added by lalit 24 feb 2012 userid = objUser.Userid; if (txtusername.Text == "") { lblErrorMsg.Text = "Enter the user name for mapped a particular Asset"; break; } else if (userid == 0) { lblErrorMsg.Text = "User Name doesn't exist"; break; } else { assetcount = objusertoasset.Get_AssetId_From_UserToAssetMap(assetid); usercount = objusertoasset.Get_UserId_From_UserToAssetMap(userid); assetlocation = objUser.City; //added by lalit 24 feb 2012 companyname = objUser.Company; if (assetcount == 0) { if (usercount == 0) { objusertoasset.Insert(userid, assetid, assetlocation, companyname); //added a new field siteid on 24 feb. lblErrorMsg.Text = "Asset Mapped Successfully to the Current User"; break; } else { int oldassetid = Convert.ToInt32(objusertoasset.Get_AssetId_By_UserId(userid)); objusertoasset.Update_Assetid(oldassetid, assetid, assetlocation, companyname); lblErrorMsg.Text = "Asset Mapped Successfully to the Current User"; break; } } else { lblErrorMsg.Text = "Asset already Mapped"; break; } } } } if (flag == 0) { lblErrorMsg.Text = "Select Asset for mapping"; } } catch (Exception ex) { string myScript; myScript = "<script language=javascript>alert('Exception - '" + ex + "');</script>"; Page.RegisterClientScriptBlock("MyScript", myScript); return; } }
protected void BindDropTechnician() { objRole = objRole.Get_RoleInfo_By_RoleName("technician"); if (objRole.Roleid != 0) { int siteid = 0; int roleid; if (drpSite.SelectedValue != "") { siteid = Convert.ToInt32(drpSite.SelectedValue); } roleid = objRole.Roleid; if (siteid != 0 && roleid != 0) { colUser = objUser.Get_All_By_Role_Site(roleid, siteid); //meenakshi for (int i = 0; i < colUser.Count; i++) { for (int j = i; j < colUser.Count; j++) { if (String.Compare(colUser[i].Username, colUser[j].Username) > 0) { UserLogin_mst obj = new UserLogin_mst(); obj = colUser[i]; colUser[i] = colUser[j]; colUser[j] = obj; } } } //end drpTechnician.DataTextField = "username"; drpTechnician.DataValueField = "userid"; drpTechnician.DataSource = colUser; drpTechnician.DataBind(); ListItem item = new ListItem(); item.Text = "All"; item.Value = "0"; drpTechnician.Items.Add(item); //item.Text = "-----------Select-----------"; //item.Value = "0"; //drpTechnician.Items.Add(item); drpTechnician.SelectedValue = "0"; } else { colUser = objUser.Get_All_By_Role_Site(roleid, siteid); //meenakshi for (int i = 0; i < colUser.Count; i++) { for (int j = i; j < colUser.Count; j++) { if (String.Compare(colUser[i].Username, colUser[j].Username) > 0) { UserLogin_mst obj = new UserLogin_mst(); obj = colUser[i]; colUser[i] = colUser[j]; colUser[j] = obj; } } } //end drpTechnician.DataTextField = "username"; drpTechnician.DataValueField = "userid"; drpTechnician.DataSource = colUser; drpTechnician.DataBind(); ListItem item = new ListItem(); item.Text = "All"; item.Value = "0"; drpTechnician.Items.Add(item); //item.Text = "-----------Select-----------"; //item.Value = "0"; //drpTechnician.Items.Add(item); drpTechnician.SelectedValue = "0"; } } }
protected void FunctionUpdate() { #region Get incidentid from QueryString int incidentid = Convert.ToInt32(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(); IncidentStates objIncidentStatesOld = new IncidentStates(); bool FlagClosedStatus = true; 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.ToInt32(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 Get SLAid by Calling Function Get_By_SLAid() ,via Passing Parameter siteid and priorityid SLAid = objIncident.Get_By_SLAid(Convert.ToInt32(drpSite.SelectedValue), Convert.ToInt32(drpPriority.SelectedValue)); requesttypeid = Convert.ToInt32(Resources.MessageResource.strRequestTypeId.ToString()); if (requesttypeid == Convert.ToInt32(drpRequestType.SelectedValue)) { SLAid = 0; } #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()) //{ // if (Session["ResolutionAdded"] != null) // { // VarResolutionAdded = Session["ResolutionAdded"].ToString(); // } // if (VarResolutionAdded == "true") // { // objIncidentHistory.Incidentid = incidentid; // objIncidentHistory.Operationownerid = userid; // objIncidentHistory.Operation = "closed"; // objIncidentHistory.Insert(); // Session["ResolutionAdded"] = "false"; // } // else { FlagClosedStatus = false; } //} //else if (statusString.ToLower() == strStatusResolved.ToLower()) //{ // objIncidentHistory.Incidentid = incidentid; // objIncidentHistory.Operationownerid = userid; // objIncidentHistory.Operation = "resolved"; // objIncidentHistory.Insert(); //} //else //{ // objIncidentHistory.Incidentid = incidentid; // objIncidentHistory.Operationownerid = userid; // objIncidentHistory.Operation = "update"; // objIncidentHistory.Insert(); //} //#endregion #region Insert value in IncidentHistory Table ,for every update of Page if (statusString.ToLower() == strStatusClose.ToLower()) { objIncidentHistory.Incidentid = incidentid; objIncidentHistory.Operationownerid = userid; objIncidentHistory.Operation = "closed"; objIncidentHistory.Insert(); } else if (statusString.ToLower() == strStatusResolved.ToLower()) { if (Session["ResolutionAdded"] != null) { VarResolutionAdded = Session["ResolutionAdded"].ToString(); } if (VarResolutionAdded == "true") { objIncidentHistory.Incidentid = incidentid; objIncidentHistory.Operationownerid = userid; objIncidentHistory.Operation = "resolved"; objIncidentHistory.Insert(); Session["ResolutionAdded"] = "false"; } else { FlagClosedStatus = false; } //objIncidentHistory.Incidentid = incidentid; //objIncidentHistory.Operationownerid = userid; //objIncidentHistory.Operation = "resolved"; //objIncidentHistory.Insert(); } else { objIncidentHistory.Incidentid = incidentid; objIncidentHistory.Operationownerid = userid; objIncidentHistory.Operation = "update"; objIncidentHistory.Insert(); } #endregion #region Get the Current historyid by calling function Get_Current_IncidentHistoryid() historyid = objIncidentHistory.Get_Current_IncidentHistoryid(); #endregion #region Find Current value of Incident and IncidentStates object ,By Calling Function Get_By_id(),via passing incidentid objIncidentOld = objIncidentOld.Get_By_id(incidentid); objIncidentStatesOld = objIncidentStatesOld.Get_By_id(incidentid); #endregion if (FlagClosedStatus == true) { #region Insert into IncidentHistoryDiff table ,By Comparing Current value and Updated Values if (objIncidentOld.Incidentid != 0 && objIncidentStatesOld.Incidentid != 0) { #region Declare local variable string columnName; string prev_value; string curnt_value; #endregion #region If site value is changed,Insert into IncidentHistoryDiff table if (objIncidentOld.Siteid != Convert.ToInt32(drpSite.SelectedValue)) { columnName = Resources.MessageResource.strColumnSiteid.ToString(); prev_value = Convert.ToString(objIncidentOld.Siteid); curnt_value = drpSite.SelectedValue; objIncidentHistoryDiff.Historyid = historyid; objIncidentHistoryDiff.Columnname = columnName; objIncidentHistoryDiff.Current_value = curnt_value; objIncidentHistoryDiff.Prev_value = prev_value; objIncidentHistoryDiff.Insert(); } #endregion #region If Department value is changed,Insert into IncidentHistoryDiff table if (objIncidentOld.Deptid != Convert.ToInt32(drpDepartment.SelectedValue)) { columnName = Resources.MessageResource.strColumnDeptid.ToString(); prev_value = Convert.ToString(objIncidentOld.Deptid); curnt_value = drpDepartment.SelectedValue; objIncidentHistoryDiff.Historyid = historyid; objIncidentHistoryDiff.Columnname = columnName; objIncidentHistoryDiff.Current_value = curnt_value; objIncidentHistoryDiff.Prev_value = prev_value; objIncidentHistoryDiff.Insert(); } #endregion #region If Mode value is changed,Insert into IncidentHistoryDiff table if (objIncidentOld.Modeid != Convert.ToInt32(drpMode.SelectedValue)) { columnName = Resources.MessageResource.strColumnModeid.ToString(); prev_value = Convert.ToString(objIncidentOld.Modeid); curnt_value = drpMode.SelectedValue; objIncidentHistoryDiff.Historyid = historyid; objIncidentHistoryDiff.Columnname = columnName; objIncidentHistoryDiff.Current_value = curnt_value; objIncidentHistoryDiff.Prev_value = prev_value; objIncidentHistoryDiff.Insert(); } #endregion #region If SLA value is changed,Insert into IncidentHistoryDiff table if (objIncidentOld.Slaid != SLAid) { columnName = Resources.MessageResource.strColumnSLAid.ToString(); prev_value = Convert.ToString(objIncidentOld.Slaid); curnt_value = Convert.ToString(SLAid); objIncidentHistoryDiff.Historyid = historyid; objIncidentHistoryDiff.Columnname = columnName; objIncidentHistoryDiff.Current_value = curnt_value; objIncidentHistoryDiff.Prev_value = prev_value; objIncidentHistoryDiff.Insert(); } #endregion #region If Requesttype value is changed,Insert into IncidentHistoryDiff table if (objIncidentStatesOld.Requesttypeid != Convert.ToInt32(drpRequestType.SelectedValue)) { columnName = Resources.MessageResource.strColumnRequesttypeid.ToString(); prev_value = Convert.ToString(objIncidentStatesOld.Requesttypeid); curnt_value = Convert.ToString(drpRequestType.SelectedValue); objIncidentHistoryDiff.Historyid = historyid; objIncidentHistoryDiff.Columnname = columnName; objIncidentHistoryDiff.Current_value = curnt_value; objIncidentHistoryDiff.Prev_value = prev_value; objIncidentHistoryDiff.Insert(); } #endregion #region If Priority value is changed,Insert into IncidentHistoryDiff table if (objIncidentStatesOld.Priorityid != Convert.ToInt32(drpPriority.SelectedValue)) { columnName = Resources.MessageResource.strColumnPriorityid.ToString(); prev_value = Convert.ToString(objIncidentStatesOld.Priorityid); curnt_value = Convert.ToString(drpPriority.SelectedValue); objIncidentHistoryDiff.Historyid = historyid; objIncidentHistoryDiff.Columnname = columnName; objIncidentHistoryDiff.Current_value = curnt_value; objIncidentHistoryDiff.Prev_value = prev_value; objIncidentHistoryDiff.Insert(); } #endregion #region If Category value is changed,Insert into IncidentHistoryDiff table if (objIncidentStatesOld.Categoryid != Convert.ToInt32(drpCategory.SelectedValue)) { columnName = Resources.MessageResource.strColumnCategoryid.ToString(); prev_value = Convert.ToString(objIncidentStatesOld.Categoryid); curnt_value = Convert.ToString(drpCategory.SelectedValue); objIncidentHistoryDiff.Historyid = historyid; objIncidentHistoryDiff.Columnname = columnName; objIncidentHistoryDiff.Current_value = curnt_value; objIncidentHistoryDiff.Prev_value = prev_value; objIncidentHistoryDiff.Insert(); } #endregion #region If SubCategory value is changed,Insert into IncidentHistoryDiff table if (objIncidentStatesOld.Subcategoryid != Convert.ToInt32(drpSubcategory.SelectedValue)) { columnName = Resources.MessageResource.strColumnSubcategoryid.ToString(); prev_value = Convert.ToString(objIncidentStatesOld.Subcategoryid); curnt_value = Convert.ToString(drpSubcategory.SelectedValue); objIncidentHistoryDiff.Historyid = historyid; objIncidentHistoryDiff.Columnname = columnName; objIncidentHistoryDiff.Current_value = curnt_value; objIncidentHistoryDiff.Prev_value = prev_value; objIncidentHistoryDiff.Insert(); } #endregion #region If Status value is changed,Insert into IncidentHistoryDiff table if (objIncidentStatesOld.Statusid != Convert.ToInt32(drpStatus.SelectedValue)) { string Statusprev; string StatusCurrent; columnName = Resources.MessageResource.strColumnstatusid.ToString(); prev_value = Convert.ToString(objIncidentStatesOld.Statusid); curnt_value = Convert.ToString(drpStatus.SelectedValue); objIncidentHistoryDiff.Historyid = historyid; objIncidentHistoryDiff.Columnname = columnName; objIncidentHistoryDiff.Current_value = curnt_value; objIncidentHistoryDiff.Prev_value = prev_value; objIncidentHistoryDiff.Insert(); Statusprev = GetStatusString(Convert.ToInt32(objIncidentStatesOld.Statusid)); StatusCurrent = GetStatusString(Convert.ToInt32(drpStatus.SelectedValue)); if (Statusprev.ToLower() == strStatusOpen.ToLower() && StatusCurrent.ToLower() == strStatusOnHold.ToLower()) { columnName = Resources.MessageResource.strColumnStarttime.ToString(); prev_value = "0"; curnt_value = DateTime.Now.ToString(); objIncidentHistoryDiff.Historyid = historyid; objIncidentHistoryDiff.Columnname = columnName; objIncidentHistoryDiff.Current_value = curnt_value; objIncidentHistoryDiff.Prev_value = prev_value; objIncidentHistoryDiff.Insert(); } if (Statusprev.ToLower() == strStatusOnHold.ToLower() && StatusCurrent.ToLower() != strStatusOnHold.ToLower()) { columnName = Resources.MessageResource.srColumnEndtime.ToString(); prev_value = "0"; curnt_value = DateTime.Now.ToString(); objIncidentHistoryDiff.Historyid = historyid; objIncidentHistoryDiff.Columnname = columnName; objIncidentHistoryDiff.Current_value = curnt_value; objIncidentHistoryDiff.Prev_value = prev_value; objIncidentHistoryDiff.Insert(); } //Added by lalit //if current techncian is wintel and current status is closed then string prev_valuetechid = Convert.ToString(objIncidentStatesOld.Technicianid); if (StatusCurrent == "Closed") { // if (prev_valuetechid == "11740") if (IsSLANeedsToBeStopped(prev_valuetechid) == 1) { columnName = Resources.MessageResource.srColumnEndtime.ToString(); prev_value = "0"; curnt_value = DateTime.Now.ToString(); objIncidentHistoryDiff.Historyid = historyid; objIncidentHistoryDiff.Columnname = columnName; objIncidentHistoryDiff.Current_value = curnt_value; objIncidentHistoryDiff.Prev_value = prev_value; objIncidentHistoryDiff.Insert(); } } //end //end lalit } #endregion #region If technician value is changed,Insert into IncidentHistoryDiff table if (objIncidentStatesOld.Technicianid != Convert.ToInt32(drpTechnician.SelectedValue)) { string columnNametechid = Resources.MessageResource.strColumnTechnicianid.ToString(); string prev_valuetechid = Convert.ToString(objIncidentStatesOld.Technicianid); string curnt_valuetechid = Convert.ToString(drpTechnician.SelectedValue); // string Id = ""; //if (curnt_valuetechid == "11740" && prev_valuetechid!="11740") if (IsSLANeedsToBeStopped(curnt_valuetechid) == 1 && IsSLANeedsToBeStopped(prev_valuetechid) == 0) { string StatusCurrent = GetStatusString(Convert.ToInt32(drpStatus.SelectedValue)); if (StatusCurrent.ToLower() != strStatusOnHold.ToLower()) { //insert start time if (StatusCurrent.ToLower() != strStatusOnHold.ToLower()) { columnName = Resources.MessageResource.strColumnStarttime.ToString(); prev_value = "0"; curnt_value = DateTime.Now.ToString(); objIncidentHistoryDiff.Historyid = historyid; objIncidentHistoryDiff.Columnname = columnName; objIncidentHistoryDiff.Current_value = curnt_value; objIncidentHistoryDiff.Prev_value = prev_value; objIncidentHistoryDiff.Insert(); //end } //insert techcianid objIncidentHistoryDiff.Historyid = historyid; objIncidentHistoryDiff.Columnname = columnNametechid; objIncidentHistoryDiff.Current_value = curnt_valuetechid; objIncidentHistoryDiff.Prev_value = prev_valuetechid; objIncidentHistoryDiff.Insert(); //end //insert assigntime if (objIncidentStatesOld.AssignedTime == null) { columnName = Resources.MessageResource.strColumnAssignedTime.ToString(); prev_value = "0"; curnt_value = DateTime.Now.ToString(); objIncidentHistoryDiff.Historyid = historyid; objIncidentHistoryDiff.Columnname = columnName; objIncidentHistoryDiff.Current_value = curnt_value; objIncidentHistoryDiff.Prev_value = prev_value; objIncidentHistoryDiff.Insert(); } else { columnName = "AssignedTime"; prev_value = objIncidentStatesOld.AssignedTime; curnt_value = DateTime.Now.ToString(); objIncidentHistoryDiff.Historyid = historyid; objIncidentHistoryDiff.Columnname = columnName; objIncidentHistoryDiff.Current_value = curnt_value; objIncidentHistoryDiff.Prev_value = prev_value; objIncidentHistoryDiff.Insert(); } //end } } else { //if prev value- progress eng columnName = Resources.MessageResource.strColumnTechnicianid.ToString(); prev_value = Convert.ToString(objIncidentStatesOld.Technicianid); curnt_value = Convert.ToString(drpTechnician.SelectedValue); objIncidentHistoryDiff.Historyid = historyid; objIncidentHistoryDiff.Columnname = columnName; objIncidentHistoryDiff.Current_value = curnt_value; objIncidentHistoryDiff.Prev_value = prev_value; objIncidentHistoryDiff.Insert(); if (objIncidentStatesOld.AssignedTime == null) { columnName = Resources.MessageResource.strColumnAssignedTime.ToString(); prev_value = "0"; curnt_value = DateTime.Now.ToString(); objIncidentHistoryDiff.Historyid = historyid; objIncidentHistoryDiff.Columnname = columnName; objIncidentHistoryDiff.Current_value = curnt_value; objIncidentHistoryDiff.Prev_value = prev_value; objIncidentHistoryDiff.Insert(); } else { columnName = "AssignedTime"; prev_value = objIncidentStatesOld.AssignedTime; curnt_value = DateTime.Now.ToString(); objIncidentHistoryDiff.Historyid = historyid; objIncidentHistoryDiff.Columnname = columnName; objIncidentHistoryDiff.Current_value = curnt_value; objIncidentHistoryDiff.Prev_value = prev_value; objIncidentHistoryDiff.Insert(); } // if (prev_valuetechid == "11740") if (IsSLANeedsToBeStopped(prev_valuetechid) == 1) { string StatusCurrent = GetStatusString(Convert.ToInt32(drpStatus.SelectedValue)); if (StatusCurrent.ToLower() != strStatusOnHold.ToLower()) { columnName = Resources.MessageResource.srColumnEndtime.ToString(); prev_value = "0"; curnt_value = DateTime.Now.ToString(); objIncidentHistoryDiff.Historyid = historyid; objIncidentHistoryDiff.Columnname = columnName; objIncidentHistoryDiff.Current_value = curnt_value; objIncidentHistoryDiff.Prev_value = prev_value; objIncidentHistoryDiff.Insert(); } //end } //then insert end time 0 //end //else //end } if (Convert.ToInt32(drpTechnician.SelectedValue) != 0) { objSentMailtoUser.SentmailTechnician(Convert.ToInt32(drpTechnician.SelectedValue), objIncidentOld.Incidentid); } FlagTechnicianId = true; } #endregion #region If External Ticket value is changed,Insert into IncidentHistoryDiff table if (objIncidentOld.ExternalTicketNo == null) { objIncidentOld.ExternalTicketNo = " "; } if (objIncidentOld.ExternalTicketNo.ToString().Trim() != txtExternalTicket.Text.ToString().Trim()) { //////////////////////////////////////////////////change done by meenakshi int flag = Convert.ToInt32(Session["flag"]); if (flag == 1) { columnName = Resources.MessageResource.strColumnExternalTicket.ToString(); prev_value = objIncidentOld.ExternalTicketNo.ToString().Trim(); txtExternalTicket.Text = (string)Session["compname"]; curnt_value = txtExternalTicket.Text.ToString().Trim(); //curnt_value =(string) Session["compname"]; objIncidentHistoryDiff.Historyid = historyid; objIncidentHistoryDiff.Columnname = columnName; objIncidentHistoryDiff.Current_value = curnt_value; objIncidentHistoryDiff.Prev_value = prev_value; objIncidentHistoryDiff.Insert(); } } #endregion #region If Vendor value is changed,Insert into IncidentHistoryDiff table if (objIncidentOld.VendorId == null) { objIncidentOld.ExternalTicketNo = "0"; } if (objIncidentOld.VendorId != Convert.ToInt32(drpVendor.SelectedValue)) { columnName = Resources.MessageResource.strColumnVendorId.ToString(); prev_value = Convert.ToString(objIncidentOld.VendorId); curnt_value = Convert.ToString(drpVendor.SelectedValue); objIncidentHistoryDiff.Historyid = historyid; objIncidentHistoryDiff.Columnname = columnName; objIncidentHistoryDiff.Current_value = curnt_value; objIncidentHistoryDiff.Prev_value = prev_value; objIncidentHistoryDiff.Insert(); } #endregion #region Check Old status is closed and current status is closed,then Assign value to localvariable FlagCloseStatus=true and used later OldStatusString = GetStatusString(objIncidentStatesOld.Statusid); strCreateDatetime = objIncidentOld.Createdatetime; if (strStatusClose.ToLower() == OldStatusString.ToLower() && statusString.ToLower() == strStatusClose.ToLower()) { FlagCloseStatus = true; oldCompletedTime = objIncidentOld.Completedtime; } #endregion } #endregion } if (FlagClosedStatus == true) { #region Update values in Incident Table objIncident.Incidentid = incidentid; objIncident.Siteid = Convert.ToInt32(drpSite.SelectedValue); objIncident.Deptid = Convert.ToInt32(drpDepartment.SelectedValue); objIncident.Title = lblTitle.Text; objIncident.Description = lblDescription.Text; objIncident.Modeid = Convert.ToInt32(drpMode.SelectedValue); objIncident.Slaid = SLAid; objIncident.Active = true; if (drpAMCCall.Text.ToUpper() == "YES") { objIncident.AMCCall = true; } else if (drpAMCCall.Text.ToUpper() == "NO") { objIncident.AMCCall = false; } /////////////////////////////////////////////////////////////////change done by meenakshi///////////////////////// //objIncident.ExternalTicketNo = txtExternalTicket.Text.ToString().Trim(); objIncident.ExternalTicketNo = (string)(Session["compname"]); /////////////////////////////////////////////////////////////////end///////////////////////////////// objIncident.VendorId = Convert.ToInt32(drpVendor.SelectedValue); //#region If Current status is closed,then Assign Completed time #region If Current status is resolved,then Assign Completed time if (statusString.ToLower() == strStatusResolved.ToLower()) { #region If FlagCloseStatus=flase ie Currrent status is closed ,and old status is not Closed if (FlagCloseStatus == false) { objIncident.Completedtime = DateTime.Now.ToString(); varTotalTimeSpentonCall = objIncident.Get_TimeSpentonRequest(incidentid, Convert.ToInt32(drpSite.SelectedValue), strCreateDatetime, DateTime.Now.ToString()); } else { objIncident.Completedtime = oldCompletedTime; varTotalTimeSpentonCall = objIncident.Get_TimeSpentonRequest(incidentid, Convert.ToInt32(drpSite.SelectedValue), strCreateDatetime, oldCompletedTime); } #endregion } //added by lalit 27 march if (statusString.ToLower() == strStatusClose.ToLower()) { #region If FlagCloseStatus=flase ie Currrent status is closed ,and old status is not Closed varTotalTimeSpentonCall = objIncident.Timespentonreq; objIncident.Completedtime = oldCompletedTime; #endregion } //end lalit if (varTotalTimeSpentonCall <= 0) { varTotalTimeSpentonCall = 0; } if (lblextension.Text != "") { objIncident.Extension = Convert.ToInt64(lblextension.Text); } //if (lblAMCcall.Text != "") //{ // objIncident.AMCCall = Convert.ToInt32(lblAMCcall.Text); //} objIncident.Timespentonreq = varTotalTimeSpentonCall; objIncident.Update(); //if (statusString.ToLower() == strStatusClose.ToLower() && FlagClosedStatus == true) if (statusString.ToLower() == strStatusResolved.ToLower() && FlagClosedStatus == true) { objSentMailtoUser.SentmailUser(objIncidentOld.Requesterid, objIncidentOld.Incidentid, "closed"); } #endregion #endregion } if (FlagClosedStatus == true) { #region Update Values in IncidentStates objIncidentStates.Incidentid = incidentid; objIncidentStates.Categoryid = Convert.ToInt32(drpCategory.SelectedValue); objIncidentStates.Subcategoryid = Convert.ToInt32(drpSubcategory.SelectedValue); objIncidentStates.Technicianid = Convert.ToInt32(drpTechnician.SelectedValue); if (FlagTechnicianId == true) { objIncidentStates.AssignedTime = DateTime.Now.ToString(); } objIncidentStates.Statusid = Convert.ToInt32(drpStatus.SelectedValue); objIncidentStates.Priorityid = Convert.ToInt32(drpPriority.SelectedValue); objIncidentStates.Requesttypeid = Convert.ToInt32(drpRequestType.SelectedValue); objIncidentStates.Update(); #endregion } #region Callint Updatepanel1() function to display value in Non Editable Mode UpdatePanel1(); #endregion HistoryUpdatePanel(); }
protected void BindGridForAllParameter() { #region Declaration of localvariable and table Variable int filterId; DataTable dtTable = new DataTable(); dtTable = CreateDataTable(); string userName = ""; int varTechnicianId = 0; if (drpTechnician.SelectedValue != "") { varTechnicianId = Convert.ToInt32(drpTechnician.SelectedValue); } string varSortParameter = ""; varSortParameter = drpSort.SelectedValue; if (varSortParameter == "0") { varSortParameter = "createdatetime"; } #endregion #region Get Current User and his Role MembershipUser User = Membership.GetUser(); string varUserRole = ""; string varRoleTechnician = ""; if (User != null) { userName = User.UserName.ToString(); string[] arrUserRole = Roles.GetRolesForUser(); varUserRole = arrUserRole[0].ToString(); varRoleTechnician = Resources.MessageResource.strTechnicianRole.ToString(); } #endregion #region Get User object by Calling Function Get_UserLogin_By_UserName() via passing parameter username and organizationid objOrganization = objOrganization.Get_Organization(); objUser = objUser.Get_UserLogin_By_UserName(userName, objOrganization.Orgid); #endregion #region if UserExist if (objUser.Userid != 0) { ViewState["Userid"] = objUser.Userid; string fromdate = null; string todate = null; if (ViewState["fromdate"] != null) { fromdate = ViewState["fromdate"].ToString(); } if (ViewState["todate"] != null) { todate = ViewState["todate"].ToString(); } if (fromdate == "") { fromdate = null; } if (todate == "") { todate = null; } #region Declare Local Variables and Collection of Incident_mst Type string Status; // int siteid; #endregion #region Get the Siteid and Filter Parameter //siteid = obj.Siteid; filterId = Convert.ToInt32(drpFilter.SelectedValue); #endregion #region If Role of User is Technician if (varUserRole == varRoleTechnician) { lblTechnician.Visible = false; drpTechnician.Visible = false; //lblTechnician1.Visible = false; //drpTechnician1.Visible = false; //btnAssigned.Visible = false; #region If Filter Variable is All if (filterId == 0) { // col = objIncident.Get_All_By_Siteid_Technicianid(siteid, objUser.Userid, fromdate, todate, varSortParameter); } #endregion #region If Filter Variable is Requested else if (filterId == 1) { Status = Resources.MessageResource.strChangestatusrequested.ToString(); int statusid; statusid = ObjChangeStatus.Get_By_StatusName(Status); col = ObjChange.Get_All_By_Statusid_technicianid(statusid, objUser.Userid, fromdate, todate, varSortParameter); } #endregion #region If Filter Variable is Approval else if (filterId == 2) { Status = Resources.MessageResource.StrApproval.ToString(); int statusid; statusid = ObjChangeStatus.Get_By_StatusName(Status); col = ObjChange.Get_All_By_Statusid_technicianid(statusid, objUser.Userid, fromdate, todate, varSortParameter); } #endregion #region If Filter Variable is Approval else if (filterId == 3) { Status = Resources.MessageResource.StrApproved.ToString(); int statusid; statusid = ObjChangeStatus.Get_By_StatusName(Status); col = ObjChange.Get_All_By_Statusid_technicianid(statusid, objUser.Userid, fromdate, todate, varSortParameter); } #endregion #region If Filter Variable is Rejected else if (filterId == 4) { Status = Resources.MessageResource.StrRejected.ToString(); int statusid; statusid = ObjChangeStatus.Get_By_StatusName(Status); col = ObjChange.Get_All_By_Statusid_technicianid(statusid, objUser.Userid, fromdate, todate, varSortParameter); } #endregion #region If Filter Variable is Planning else if (filterId == 5) { Status = Resources.MessageResource.StrPlanning.ToString(); int statusid; statusid = ObjChangeStatus.Get_By_StatusName(Status); col = ObjChange.Get_All_By_Statusid_technicianid(statusid, objUser.Userid, fromdate, todate, varSortParameter); } #endregion #region If Filter Variable is Testing else if (filterId == 6) { Status = Resources.MessageResource.StrTesting.ToString(); int statusid; statusid = ObjChangeStatus.Get_By_StatusName(Status); col = ObjChange.Get_All_By_Statusid_technicianid(statusid, objUser.Userid, fromdate, todate, varSortParameter); } #endregion #region If Filter Variable is Release else if (filterId == 7) { Status = Resources.MessageResource.StrRelease.ToString(); int statusid; statusid = ObjChangeStatus.Get_By_StatusName(Status); col = ObjChange.Get_All_By_Statusid_technicianid(statusid, objUser.Userid, fromdate, todate, varSortParameter); } #endregion #region If Filter Variable is Implemented else if (filterId == 8) { Status = Resources.MessageResource.StrImplemented.ToString(); int statusid; statusid = ObjChangeStatus.Get_By_StatusName(Status); col = ObjChange.Get_All_By_Statusid_technicianid(statusid, objUser.Userid, fromdate, todate, varSortParameter); } #endregion #region If Filter Variable is Completed else if (filterId == 9) { Status = Resources.MessageResource.StrCompleted.ToString(); int statusid; statusid = ObjChangeStatus.Get_By_StatusName(Status); col = ObjChange.Get_All_By_Statusid_technicianid(statusid, objUser.Userid, fromdate, todate, varSortParameter); } #endregion } #endregion #region If User Role is other then technician else { #region If Filter Variable is All if (filterId == 0) { // col = objIncident.Get_All_By_Siteid_Technicianid(siteid, objUser.Userid, fromdate, todate, varSortParameter); } #endregion #region If Filter Variable is Requested else if (filterId == 1) { Status = Resources.MessageResource.strChangestatusrequested.ToString(); int statusid; statusid = ObjChangeStatus.Get_By_StatusName(Status); col = ObjChange.Get_All_By_Statusid(statusid, fromdate, todate, varTechnicianId, varSortParameter); } #endregion #region If Filter Variable is Approval else if (filterId == 2) { Status = Resources.MessageResource.StrApproval.ToString(); int statusid; statusid = ObjChangeStatus.Get_By_StatusName(Status); col = ObjChange.Get_All_By_Statusid(statusid, fromdate, todate, varTechnicianId, varSortParameter); } #endregion #region If Filter Variable is Approval else if (filterId == 3) { Status = Resources.MessageResource.StrApproved.ToString(); int statusid; statusid = ObjChangeStatus.Get_By_StatusName(Status); col = ObjChange.Get_All_By_Statusid(statusid, fromdate, todate, varTechnicianId, varSortParameter); } #endregion #region If Filter Variable is Rejected else if (filterId == 4) { Status = Resources.MessageResource.StrRejected.ToString(); int statusid; statusid = ObjChangeStatus.Get_By_StatusName(Status); col = ObjChange.Get_All_By_Statusid(statusid, fromdate, todate, varTechnicianId, varSortParameter); } #endregion #region If Filter Variable is Planning else if (filterId == 5) { Status = Resources.MessageResource.StrPlanning.ToString(); int statusid; statusid = ObjChangeStatus.Get_By_StatusName(Status); col = ObjChange.Get_All_By_Statusid(statusid, fromdate, todate, varTechnicianId, varSortParameter); } #endregion #region If Filter Variable is Testing else if (filterId == 6) { Status = Resources.MessageResource.StrTesting.ToString(); int statusid; statusid = ObjChangeStatus.Get_By_StatusName(Status); col = ObjChange.Get_All_By_Statusid(statusid, fromdate, todate, varTechnicianId, varSortParameter); } #endregion #region If Filter Variable is Release else if (filterId == 7) { Status = Resources.MessageResource.StrRelease.ToString(); int statusid; statusid = ObjChangeStatus.Get_By_StatusName(Status); col = ObjChange.Get_All_By_Statusid(statusid, fromdate, todate, varTechnicianId, varSortParameter); } #endregion #region If Filter Variable is Implemented else if (filterId == 8) { Status = Resources.MessageResource.StrImplemented.ToString(); int statusid; statusid = ObjChangeStatus.Get_By_StatusName(Status); col = ObjChange.Get_All_By_Statusid(statusid, fromdate, todate, varTechnicianId, varSortParameter); } #endregion #region If Filter Variable is Completed else if (filterId == 9) { Status = Resources.MessageResource.StrCompleted.ToString(); int statusid; statusid = ObjChangeStatus.Get_By_StatusName(Status); col = ObjChange.Get_All_By_Statusid(statusid, fromdate, todate, varTechnicianId, varSortParameter); } #endregion } #endregion } #endregion #region Fetch Each object of type Change_mst from Collection Change_mst foreach (Change_mst obj in col) { #region Create Table row and assign value to it DataRow row; row = dtTable.NewRow(); row["Changeid"] = Convert.ToString(obj.Changeid); row["title"] = obj.Title; row["Requestedby"] = Convert.ToString(obj.Requestedby); row["CreatedByid"] = Convert.ToString(obj.CreatedByID); row["Technician"] = Convert.ToString(obj.Technician); row["Statusid"] = obj.Statusid; row["Priority"] = obj.Priority; row["Createdtime"] = obj.Createdtime; dtTable.Rows.Add(row); #endregion } //} #endregion #region Bind Grid from datasource dtTable grdvwChange.DataSource = dtTable; grdvwChange.DataBind(); #endregion }
protected void grdvwChange_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) { //if(col.Count!=0) //{ #region Autogenerate Serial number //Label lblSerial = (Label)e.Row.FindControl("lblSerial"); //lblSerial.Text = i.ToString(); //i++; #endregion int TotalTimeSpentonCall; int TotalResolutionTime; 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[2].Text); objUser = objUser.Get_By_id(requesterid); if (objUser.Userid != 0) { e.Row.Cells[2].Text = objUser.Username.ToString(); } else { e.Row.Cells[2].Text = ""; } #endregion #region Bind Datarow at Run Time with Createdbyid to Created by name int createdbyid = Convert.ToInt32(e.Row.Cells[3].Text); objUser = objUser.Get_By_id(createdbyid); 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 technicianid to technician name int technicianid = Convert.ToInt32(e.Row.Cells[4].Text); objUser = objUser.Get_By_id(technicianid); 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 Statusid to Status int statusid = Convert.ToInt32(e.Row.Cells[5].Text); ObjChangeStatus = ObjChangeStatus.Get_By_id(statusid); if (ObjChangeStatus.ChangeStatusid != 0) { e.Row.Cells[5].Text = ObjChangeStatus.Statusname.ToString(); } else { e.Row.Cells[5].Text = ""; } #endregion #region Bind Datarow at run time with Priorityid to Priority int priorityid = Convert.ToInt32(e.Row.Cells[6].Text); objPriority = objPriority.Get_By_id(priorityid); if (objPriority.Priorityid != 0) { e.Row.Cells[6].Text = objPriority.Name.ToString(); } else { e.Row.Cells[6].Text = ""; } #endregion } } catch (Exception ex) { string myScript; myScript = "<script language=javascript>alert('Exception - '" + ex + "');</script>"; Page.RegisterClientScriptBlock("MyScript", myScript); return; } }
protected void ShowResolution() { IncidentResolution objIncidentResolution = new IncidentResolution(); #region Declaration of Dynamic Table,and Placeholder PlaceHolderResolution.Controls.Clear(); Table tbl = new Table(); PlaceHolderResolution.Controls.Add(tbl); int hdwidth = 1500; int height = 5; #endregion int incidentid = Convert.ToInt32(Session["incidentid"].ToString()); #region Get Collection of Log From IncidentLog table via incidentid colIncidentResolution = objIncidentResolution.Get_All_By_incidentid(incidentid); if (colIncidentResolution.Count == 0) { TableRow tabRow3 = new TableRow(); TableCell tbCell3 = new TableCell(); tbCell3.Width = hdwidth; tbCell3.Height = height; Label lbl3 = new Label(); lbl3.Text = "No Record Found"; lbl3.Font.Size = FontUnit.Smaller; tbCell3.Controls.Add(lbl3); tabRow3.Cells.Add(tbCell3); tbl.Rows.Add(tabRow3); } foreach (IncidentResolution obj in colIncidentResolution) { #region Fetch Username on the basis of Operationownerid,by calling Get_By_id() function of Userlogin_mst Instance string username; objUser = objUser.Get_By_id(obj.Userid); username = objUser.Username.ToString(); #endregion #region Declaration of Tablerow,TableCell and lable object TableRow tabRow = new TableRow(); TableCell tbCell = new TableCell(); tbCell.Width = hdwidth; Label lbl = new Label(); #endregion #region Print Each Operation Performed by User lbl.Font.Bold = true; lbl.Text = " " + username + " said on " + obj.Lastupdatetime.ToString(); #endregion #region Fix background color of Row tabRow.BackColor = System.Drawing.Color.Lavender; #endregion #region Add label,cell,and Row to tabel tbCell.Controls.Add(lbl); tabRow.Cells.Add(tbCell); tbl.Rows.Add(tabRow); #endregion #region Declaration of local variables,tablerow,tablecell and label TableRow tabRowInner = new TableRow(); TableCell tbCellInner = new TableCell(); tbCellInner.Width = hdwidth; Label lblinner = new Label(); lblinner.Font.Size = FontUnit.Smaller; #endregion #region Print Each Operation Performed by User lblinner.Font.Bold = true; lblinner.Text = " " + obj.Resolution.ToString(); #endregion #region Label,cells and rows to Tabel of inner loop tabRowInner.BackColor = System.Drawing.Color.White; tbCellInner.Controls.Add(lblinner); tabRowInner.Cells.Add(tbCellInner); tbl.Rows.Add(tabRowInner); #endregion } #endregion }
protected void BindGridForAllParameter() { #region Declaration of localvariable and table Variable int filterId; DataTable dtTable = new DataTable(); dtTable = CreateDataTable(); string userName = ""; int varTechnicianId = 0; if (drpTechnician.SelectedValue != "") { varTechnicianId = Convert.ToInt32(drpTechnician.SelectedValue); } string varSortParameter = ""; varSortParameter = drpSort.SelectedValue; if (varSortParameter == "0") { varSortParameter = "createdatetime"; } #endregion #region Get Current User and his Role MembershipUser User = Membership.GetUser(); string varUserRole = ""; string varRoleTechnician = ""; if (User != null) { userName = User.UserName.ToString(); string[] arrUserRole = Roles.GetRolesForUser(); varUserRole = arrUserRole[0].ToString(); varRoleTechnician = Resources.MessageResource.strTechnicianRole.ToString(); } #endregion #region Get User object by Calling Function Get_UserLogin_By_UserName() via passing parameter username and organizationid objOrganization = objOrganization.Get_Organization(); objUser = objUser.Get_UserLogin_By_UserName(userName, objOrganization.Orgid); #endregion #region If User Exist if (objUser.Userid != 0) { ViewState["Userid"] = objUser.Userid; string fromdate = null; string todate = null; if (ViewState["fromdate"] != null) { fromdate = ViewState["fromdate"].ToString(); } if (ViewState["todate"] != null) { todate = ViewState["todate"].ToString(); } if (fromdate == "") { fromdate = null; } if (todate == "") { todate = null; } #region Declare Local Variables and Collection of Incident_mst Type string Status; // int siteid; #endregion #region Get the Siteid and Filter Parameter //siteid = obj.Siteid; filterId = Convert.ToInt32(drpFilter.SelectedValue); #endregion #region If Role of User is Technician if (varUserRole == varRoleTechnician) { lblTechnician.Visible = false; drpTechnician.Visible = false; btnCancell.Visible = false; #region If Filter Variable is All if (filterId == 0) { // col = objIncident.Get_All_By_Siteid_Technicianid(siteid, objUser.Userid, fromdate, todate, varSortParameter); } #endregion #region If Filter Variable is Open else if (filterId == 1) { Status = Resources.MessageResource.strStatusOpen.ToString(); int statusid; statusid = objStatus.Get_By_StatusName(Status); col=ObjProblem.Get_All_By_Statusid_technicianid(statusid, objUser.Userid, fromdate, todate, varSortParameter); } #endregion #region If Filter variable is Onhold else if (filterId == 2) { Status = Resources.MessageResource.strStatusOnHold.ToString(); int statusid; statusid = objStatus.Get_By_StatusName(Status); col=ObjProblem.Get_All_By_Statusid_technicianid(statusid, objUser.Userid, fromdate, todate, varSortParameter); } #endregion #region If Filter Variable is Close else if (filterId == 3) { Status = Resources.MessageResource.strStatusClose.ToString(); int statusid; statusid = objStatus.Get_By_StatusName(Status); col=ObjProblem.Get_All_By_Statusid_technicianid(statusid, objUser.Userid, fromdate, todate, varSortParameter); } #endregion #region If filter variable is resolved else if (filterId == 4) { Status = Resources.MessageResource.strStatusResolved.ToString(); int statusid; statusid = objStatus.Get_By_StatusName(Status); col=ObjProblem.Get_All_By_Statusid_technicianid(statusid, objUser.Userid, fromdate, todate, varSortParameter); } #endregion } #endregion #region If User Role is other than Technician else { #region If Filter Variable is All if (filterId == 0) { //varSortParameter col=ObjProblem.Get_All_By_Createdbyid(fromdate, todate, varTechnicianId, varSortParameter); } #endregion #region If Filter Variable is Open else if (filterId == 1) { Status = Resources.MessageResource.strStatusOpen.ToString(); int statusid; statusid = objStatus.Get_By_StatusName(Status); col=ObjProblem.Get_All_By_Statusid(statusid, fromdate, todate, varTechnicianId, varSortParameter); } #endregion #region If Filter variable is Onhold else if (filterId == 2) { Status = Resources.MessageResource.strStatusOnHold.ToString(); int statusid; statusid = objStatus.Get_By_StatusName(Status); col=ObjProblem.Get_All_By_Statusid(statusid, fromdate, todate, varTechnicianId, varSortParameter); } #endregion #region If Filter Variable is Close else if (filterId == 3) { Status = Resources.MessageResource.strStatusClose.ToString(); int statusid; statusid = objStatus.Get_By_StatusName(Status); col=ObjProblem.Get_All_By_Statusid(statusid, fromdate, todate, varTechnicianId, varSortParameter); } #endregion #region If filter variable is resolved else if (filterId == 4) { Status = Resources.MessageResource.strStatusResolved.ToString(); int statusid; statusid = objStatus.Get_By_StatusName(Status); col=ObjProblem.Get_All_By_Statusid( statusid, fromdate, todate, varTechnicianId, varSortParameter); } #endregion #region If filter variable is UnAssigned else if (filterId == 5) { Status = Resources.MessageResource.strStatusOpen.ToString(); int statusid; statusid = objStatus.Get_By_StatusName(Status); col=ObjProblem.Get_All_By_Statusid_Unassigned(statusid, fromdate, todate, varSortParameter); } #endregion #region If filter variable is Assigned else if (filterId == 6) { col=ObjProblem.Get_All_By_Assigned(fromdate, todate, varSortParameter); } #endregion #region Else Condition will call using Filter variable all else { col=ObjProblem.Get_All_By_Createdbyid(fromdate, todate, varTechnicianId, varSortParameter); } #endregion } #endregion } #region Fetch Each object of type Incident_mst from Collection Incident_mst foreach (Problem_mst obj in col) { #region Create Table row and assign value to it DataRow row; row = dtTable.NewRow(); row["ProblemId"] = Convert.ToString(obj.ProblemId); row["title"] = obj.title; row["Requesterid"] = Convert.ToString(obj.Requesterid); row["CreatedByid"] = Convert.ToString(obj.CreatedByid); row["Technicianid"] = Convert.ToString(obj.Technicianid); row["Statusid"] = obj.Statusid; row["Priorityid"] = obj.Priorityid; row["CreateDatetime"] = obj.CreateDatetime; dtTable.Rows.Add(row); #endregion } //} #endregion #region Bind Grid from datasource dtTable grdvwProblem.DataSource = dtTable; grdvwProblem.DataBind(); #endregion #endregion if (varUserRole == varRoleTechnician) { ///RoleTechnician(); } }
protected void buttonadd_click(object sender, EventArgs e) { /////Add Exception handilng try catch change by vishal 21-05-2012 try { #region Find Userid of User who is Requesting to log a call #region If User Already Exist if (ViewState["UserCreate"].ToString() == "Exist") { objOrganization = objOrganization.Get_Organization(); ObjUserLogin = ObjUserLogin.Get_UserLogin_By_UserName(txtUsername.Text.ToString().Trim(), objOrganization.Orgid); if (ObjUserLogin.Userid != 0) { requesterid = ObjUserLogin.Userid; } } #endregion #region If New User is to be Created else if (ViewState["UserCreate"].ToString() == "create") { string varEmail = ""; string varRoleName = Resources.MessageResource.BasicUserRole.ToString(); if (txtEmail.Text == "") { varEmail = Resources.MessageResource.errMemshipCreateUserEmail.ToString(); } else { varEmail = txtEmail.Text; } int roleid = objRole.Get_By_RoleName(varRoleName); int status; objOrganization = objOrganization.Get_Organization(); objuser.Username = txtUsername.Text.ToString(); objuser.Password = Resources.MessageResource.strDefaultPassword.ToString(); objuser.Roleid = roleid; objuser.Orgid = objOrganization.Orgid; objuser.ADEnable = false; objuser.Enable = true; objuser.Createdatetime = DateTime.Now.ToString(); status = objuser.Insert(); if (status == 1) { // Create Mstatus field to send in Membership.CreateUser function as Out Variable for creating Membership User database MembershipCreateStatus Mstatus = default(MembershipCreateStatus); // Call Membership.CreateUser function to create Membership user Membership.CreateUser(txtUsername.Text.ToString().Trim(), Resources.MessageResource.strDefaultPassword.ToString(), varEmail, "Project Name", "Helpdesk", true, out Mstatus); // Call Roles.AddUserToRole Function to Add User To Role Roles.AddUserToRole(txtUsername.Text.ToString().Trim(), varRoleName); // Declare Local Variable Userid to fetch userid of newly created user // Create Object objUserLogin of UserLogin_mst()Class objuser = new UserLogin_mst(); // Fetch userid of Newly created user and assign to local variable userid by calling function objUserLogin.Get_By_UserName requesterid = objuser.Get_By_UserName(txtUsername.Text.ToString().Trim(), objOrganization.Orgid); // If userid not equal to 0 then we get userid of Newly created user otherwise error Occured ContactInfo_mst objContactInfo = new ContactInfo_mst(); objContactInfo.Userid = requesterid; objContactInfo.Emailid = varEmail; objContactInfo.Firstname = txtUsername.Text.ToString(); objContactInfo.Lastname = txtUsername.Text.ToString(); objContactInfo.Insert(); } } #endregion #region If User is Not to be Created else if (ViewState["UserCreate"].ToString() == "notcreate") { // FlagUserStatus = false; } #endregion #endregion ObjChange.Active = true; ObjChange.Statusid = Convert.ToInt32(drpStatus.SelectedValue); ObjChange.Categoryid = Convert.ToInt32(drpCategory.SelectedValue); ObjChange.Subcategoryid = Convert.ToInt32(drpSubcategory.SelectedValue); // ObjChange.Technician =Convert.ToInt32(drpTechnician.SelectedValue); ObjChange.Title = txtTitle.Text; ObjChange.Description = txtDescription.Text; ObjChange.Createdtime = DateTime.Now.ToString(); ObjChange.Changetype = Convert.ToInt32(drpchangetype.SelectedValue); ObjChange.Approvalstatus = "Send For Approval"; MembershipUser user = Membership.GetUser(); string username = user.UserName.ToString(); objOrganization = objOrganization.Get_Organization(); ObjUserLogin = ObjUserLogin.Get_UserLogin_By_UserName(username, objOrganization.Orgid); int userid = Convert.ToInt32(ObjUserLogin.Userid); ObjChange.CreatedByID = userid; ObjUserLogin = ObjUserLogin.Get_UserLogin_By_UserName(txtUsername.Text, objOrganization.Orgid); ObjChange.Requestedby = ObjUserLogin.Userid; // ObjChange.Priority = Convert.ToInt32(drpPriority.SelectedValue); ObjChange.Insert(); int changeid = ObjChange.Get_Current_Changeid(); for (int i = ListAsset.Items.Count - 1; i >= 0; i--) { if (ListAsset.Items[i].Selected == true) { Objincludeaasetchange.Assetid = Convert.ToInt32(ListAsset.Items[i].Value); Objincludeaasetchange.Changeid = changeid; Objincludeaasetchange.Insert(); } } ObjChangeHistory.Changeid = changeid; // ObjChangeHistory.Description = "create"; ObjChangeHistory.Operation = "create"; ObjChangeHistory.Operationownerid = ObjUserLogin.Userid; ObjChangeHistory.Insert(); int changetype = Convert.ToInt32(drpchangetype.SelectedValue); objSentEmailToChange.SentMailToChangeCommittee(changeid, changetype); Response.Redirect("~/Change/EditChange.aspx?" + changeid + " "); } catch (Exception ex) { string myScript; myScript = "<script language=javascript>alert('Exception - '" + ex + "');</script>"; Page.RegisterClientScriptBlock("MyScript", myScript); return; } }
protected void BindGridForSelectedParameter() { #region Declaration of localvariable and table Variable int filterId; DataTable dtTable = new DataTable(); dtTable = CreateDataTable(); string userName = ""; int varTechnicianId = Convert.ToInt32(drpTechnician.SelectedValue); string varSortParameter = ""; varSortParameter = drpSort.SelectedValue; if (varSortParameter == "0") { varSortParameter = "createdatetime"; } #endregion #region Get Current User and his Role MembershipUser User = Membership.GetUser(); string varUserRole = ""; string varRoleTechnician = ""; if (User != null) { userName = User.UserName.ToString(); string[] arrUserRole = Roles.GetRolesForUser(); varUserRole = arrUserRole[0].ToString(); varRoleTechnician = Resources.MessageResource.strTechnicianRole.ToString(); } #endregion #region Get User object by Calling Function Get_UserLogin_By_UserName() via passing parameter username and organizationid objOrganization = objOrganization.Get_Organization(); objUser = objUser.Get_UserLogin_By_UserName(userName, objOrganization.Orgid); #endregion #region If User Exist if (objUser.Userid != 0) { string fromdate = null; string todate = null; if (ViewState["fromdate"] != null) { fromdate = ViewState["fromdate"].ToString(); } if (ViewState["todate"] != null) { todate = ViewState["todate"].ToString(); } if (fromdate == "") { fromdate = null; } if (todate == "") { todate = null; } #region Declare Local Variables and Collection of Incident_mst Type string Status; BLLCollection<Incident_mst> col = new BLLCollection<Incident_mst>(); int siteid; #endregion #region Get the Siteid and Filter Parameter siteid = Convert.ToInt32(drpSite.SelectedValue); filterId = Convert.ToInt32(drpFilter.SelectedValue); #endregion #region If Role of User is Technician if (varUserRole == varRoleTechnician) { lblTechnician.Visible = false; drpTechnician.Visible = false; #region If Filter Variable is All if (filterId == 0) { col = objIncident.Get_All_By_Siteid_Technicianid(siteid, objUser.Userid, fromdate, todate, varSortParameter); } #endregion #region If Filter Variable is Open else if (filterId == 1) { Status = Resources.MessageResource.strStatusOpen.ToString(); int statusid; statusid = objStatus.Get_By_StatusName(Status); col = objIncident.Get_All_By_Siteid_Statusid_technicianid(siteid, statusid, objUser.Userid, fromdate, todate, varSortParameter); } #endregion #region If Filter variable is Onhold else if (filterId == 2) { Status = Resources.MessageResource.strStatusOnHold.ToString(); int statusid; statusid = objStatus.Get_By_StatusName(Status); col = objIncident.Get_All_By_Siteid_Statusid_technicianid(siteid, statusid, objUser.Userid, fromdate, todate, varSortParameter); } #endregion #region If Filter Variable is Close else if (filterId == 3) { Status = Resources.MessageResource.strStatusClose.ToString(); int statusid; statusid = objStatus.Get_By_StatusName(Status); col = objIncident.Get_All_By_Siteid_Statusid_technicianid(siteid, statusid, objUser.Userid, fromdate, todate, varSortParameter); } #endregion #region If filter variable is resolved else if (filterId == 4) { Status = Resources.MessageResource.strStatusResolved.ToString(); int statusid; statusid = objStatus.Get_By_StatusName(Status); col = objIncident.Get_All_By_Siteid_Statusid_technicianid(siteid, statusid, objUser.Userid, fromdate, todate, varSortParameter); } #endregion } #endregion #region If User Role is other than Technician else { #region If Filter Variable is All if (filterId == 0) { col = objIncident.Get_All_By_Siteid_Createdbyid(siteid, fromdate, todate, varTechnicianId, varSortParameter); } #endregion #region If Filter Variable is Open else if (filterId == 1) { Status = Resources.MessageResource.strStatusOpen.ToString(); int statusid; statusid = objStatus.Get_By_StatusName(Status); col = objIncident.Get_All_By_Siteid_Statusid(siteid, statusid, fromdate, todate, varTechnicianId, varSortParameter); } #endregion #region If Filter variable is Onhold else if (filterId == 2) { Status = Resources.MessageResource.strStatusOnHold.ToString(); int statusid; statusid = objStatus.Get_By_StatusName(Status); col = objIncident.Get_All_By_Siteid_Statusid(siteid, statusid, fromdate, todate, varTechnicianId, varSortParameter); } #endregion #region If Filter Variable is Close else if (filterId == 3) { Status = Resources.MessageResource.strStatusClose.ToString(); int statusid; statusid = objStatus.Get_By_StatusName(Status); col = objIncident.Get_All_By_Siteid_Statusid(siteid, statusid, fromdate, todate, varTechnicianId, varSortParameter); } #endregion #region If filter variable is resolved else if (filterId == 4) { Status = Resources.MessageResource.strStatusResolved.ToString(); int statusid; statusid = objStatus.Get_By_StatusName(Status); col = objIncident.Get_All_By_Siteid_Statusid(siteid, statusid, fromdate, todate, varTechnicianId, varSortParameter); } #endregion #region If filter variable is UnAssigned else if (filterId == 5) { Status = Resources.MessageResource.strStatusOpen.ToString(); int statusid; statusid = objStatus.Get_By_StatusName(Status); col = objIncident.Get_All_By_Siteid_Statusid_Unassigned(siteid, statusid, fromdate, todate, varSortParameter); } #endregion #region If filter variable is Assigned else if (filterId == 6) { col = objIncident.Get_All_By_Siteid_Assigned(siteid, fromdate, todate, varSortParameter); } #endregion #region Else Condition will call using Filter variable all else { col = objIncident.Get_All_By_Siteid_Createdbyid(siteid, fromdate, todate, varTechnicianId, varSortParameter); } #endregion } #endregion #region Fetch Each object of type Incident_mst from Collection Incident_mst foreach (Incident_mst objInc in col) { #region Create Table row and assign value to it DataRow row; row = dtTable.NewRow(); row["incidentid"] = Convert.ToString(objInc.Incidentid); row["title"] = objInc.Title; row["requesterid"] = Convert.ToString(objInc.Requesterid); row["createdbyid"] = Convert.ToString(objInc.Createdbyid); row["siteid"] = Convert.ToString(objInc.Siteid); row["createdatetime"] = Convert.ToString(objInc.Createdatetime); objIncidentStates = objIncidentStates.Get_By_id(objInc.Incidentid); row["statusid"] = objIncidentStates.Statusid; row["technicianid"] = objIncidentStates.Technicianid; row["priorityid"] = objIncidentStates.Priorityid; dtTable.Rows.Add(row); #endregion } #endregion } #endregion #region Bind Grid from datasource dtTable DataView dvData = new DataView(dtTable); string sortFormat = "{0} {1}"; String sortDirection = "DESC"; if (varSortParameter == "createdatetime") { //varSortParameter = "incidentid"; } if (varSortParameter == "incidentid") { } dvData.Sort = String.Format(sortFormat, varSortParameter, sortDirection); grdvwRequest.DataSource = null; grdvwRequest.DataBind(); grdvwRequest.DataSource = dvData; grdvwRequest.DataBind(); #endregion if (varUserRole == varRoleTechnician) { RoleTechnician(); } }
protected void btnAdd_Click(object sender, EventArgs e) {//Add Exception handilng try catch change by vishal 21-05-2012 try { bool FlagUserStatus = true; #region Find Userid of User who is Requesting to log a call #region If User Already Exist if (ViewState["UserCreate"].ToString() == "Exist") { objOrganization = objOrganization.Get_Organization(); ObjUserLogin = ObjUserLogin.Get_UserLogin_By_UserName(txtUsername.Text.ToString().Trim(), objOrganization.Orgid); if (ObjUserLogin.Userid != 0) { requesterid = ObjUserLogin.Userid; } } #endregion #region If New User is to be Created else if (ViewState["UserCreate"].ToString() == "create") { string varEmail = ""; string varRoleName = Resources.MessageResource.BasicUserRole.ToString(); if (txtEmail.Text == "") { varEmail = Resources.MessageResource.errMemshipCreateUserEmail.ToString(); } else { varEmail = txtEmail.Text; } int roleid = objRole.Get_By_RoleName(varRoleName); int status; objOrganization = objOrganization.Get_Organization(); objuser.Username = txtUsername.Text.ToString(); objuser.Password = Resources.MessageResource.strDefaultPassword.ToString(); objuser.Roleid = roleid; objuser.Orgid = objOrganization.Orgid; objuser.ADEnable = false; objuser.Enable = true; objuser.Createdatetime = DateTime.Now.ToString(); status = objuser.Insert(); if (status == 1) { // Create Mstatus field to send in Membership.CreateUser function as Out Variable for creating Membership User database MembershipCreateStatus Mstatus = default(MembershipCreateStatus); // Call Membership.CreateUser function to create Membership user Membership.CreateUser(txtUsername.Text.ToString().Trim(), Resources.MessageResource.strDefaultPassword.ToString(), varEmail, "Project Name", "Helpdesk", true, out Mstatus); // Call Roles.AddUserToRole Function to Add User To Role Roles.AddUserToRole(txtUsername.Text.ToString().Trim(), varRoleName); // Declare Local Variable Userid to fetch userid of newly created user // Create Object objUserLogin of UserLogin_mst()Class objuser = new UserLogin_mst(); // Fetch userid of Newly created user and assign to local variable userid by calling function objUserLogin.Get_By_UserName requesterid = objuser.Get_By_UserName(txtUsername.Text.ToString().Trim(), objOrganization.Orgid); // If userid not equal to 0 then we get userid of Newly created user otherwise error Occured ContactInfo_mst objContactInfo = new ContactInfo_mst(); objContactInfo.Userid = requesterid; objContactInfo.Emailid = varEmail; objContactInfo.Firstname = txtUsername.Text.ToString(); objContactInfo.Lastname = txtUsername.Text.ToString(); objContactInfo.Insert(); } } #endregion #region If User is Not to be Created else if (ViewState["UserCreate"].ToString() == "notcreate") { FlagUserStatus = false; } #endregion #endregion MembershipUser User = Membership.GetUser(); string userName; userName = User.UserName.ToString(); if (FlagUserStatus == true) { objOrganization = objOrganization.Get_Organization(); objuser = objuser.Get_UserLogin_By_UserName(userName, objOrganization.Orgid); ObjProblem.CreatedByid = objuser.Userid; ObjProblem.Requesterid = requesterid; ObjProblem.Categoryid = Convert.ToInt32(drpCategory.SelectedValue); ObjProblem.Subcategoryid = Convert.ToInt32(drpSubcategory.SelectedValue); ObjProblem.Priorityid = Convert.ToInt32(drpPriority.SelectedValue); ObjProblem.Statusid = Convert.ToInt32(drpStatus.SelectedValue); ObjProblem.Technicianid = Convert.ToInt32(drpTechnician.SelectedValue); ObjProblem.title = txtTitle.Text; ObjProblem.Description = txtDescription.Text; if (Convert.ToInt32(drpTechnician.SelectedValue) != 0) { ObjProblem.AssginedTime = DateTime.Now.ToString(); } ObjProblem.Insert(); int problemid = ObjProblem.Get_Current_Problemid(); ObjProblemHistory.Operationtime = DateTime.Now.ToString(); ObjProblemHistory.Problemid = problemid; ObjProblemHistory.Operation = "create"; ObjProblemHistory.Operationownerid = objuser.Userid; if (Session["IncidentToProblem"] != null) { int incidentid = Convert.ToInt32(Session["IncidentToProblem"].ToString()); Incident_To_Problem objIncToprob = new Incident_To_Problem(); objIncToprob.Incidentid = incidentid; objIncToprob.Problemid = problemid; objIncToprob.Insert(); } if (Convert.ToInt32(drpTechnician.SelectedValue) != 0) { objSentMailToUser.SentMailToTechnicianForProblemCall(problemid, Convert.ToInt32(drpTechnician.SelectedValue)); } ObjProblemHistory.Insert(); //ResetControls(); string myScript; myScript = "<script language=javascript>javascript:window.close();</script>"; Page.RegisterClientScriptBlock("MyScript", myScript); } } catch (Exception ex) { string myScript; myScript = "<script language=javascript>alert('Exception - '" + ex + "');</script>"; Page.RegisterClientScriptBlock("MyScript", myScript); return; } }
protected void btnResolution_Click(object sender, EventArgs e) { /////Add Exception handilng try catch change by vishal 21-05-2012 try { int userid = 0; string userName; MembershipUser User = Membership.GetUser(); userName = User.UserName.ToString(); if (userName != "") { objOrganization = objOrganization.Get_Organization(); objUser = objUser.Get_UserLogin_By_UserName(userName, objOrganization.Orgid); if (objUser.Userid != 0) { userid = objUser.Userid; } } IncidentResolution objIncidentResolution = new IncidentResolution(); #region Get incidentid from QueryString int incidentid = Convert.ToInt32(Request.QueryString[0]); #endregion #region Check Is Resolution Exist in Database objIncidentResolution = objIncidentResolution.Get_By_id(incidentid); #endregion #region Add Resolution in Database string varResolution; varResolution = Editor.Text; objIncidentResolution.Incidentid = incidentid; objIncidentResolution.Lastupdatetime = DateTime.Now.ToString(); objIncidentResolution.Resolution = varResolution; objIncidentResolution.Userid = userid; objIncidentResolution.Insert(); Editor.Text = ""; ShowResolution(); #endregion } catch (Exception ex) { string myScript; myScript = "<script language=javascript>alert('Exception - '" + ex + "');</script>"; Page.RegisterClientScriptBlock("MyScript", myScript); return; } }
protected void Bindgrid() { #region Declaration of localvariable and table Variable int filterId; DataTable dtTable = new DataTable(); dtTable = CreateDataTable(); string userName = ""; int varTechnicianId = 0; string varSortParameter = "createdatetime"; #endregion #region Get Current User and his Role MembershipUser User = Membership.GetUser(); string varUserRole = ""; string varRoleTechnician = ""; if (User != null) { userName = User.UserName.ToString(); string[] arrUserRole = Roles.GetRolesForUser(); varUserRole = arrUserRole[0].ToString(); varRoleTechnician = Resources.MessageResource.strTechnicianRole.ToString(); } #endregion #region Get User object by Calling Function Get_UserLogin_By_UserName() via passing parameter username and organizationid objOrganization = objOrganization.Get_Organization(); objUser = objUser.Get_UserLogin_By_UserName(userName, objOrganization.Orgid); #endregion #region If User Exist if (objUser.Userid != 0) { string fromdate = null; string todate = null; #region Find how many sites have been mapped to current user by calling function Get_All_By_userid() via passing parameter userid int userid = objUser.Userid; colUserToSite = ObjUserToSite.Get_All_By_userid(userid); #endregion #region Fetch each object from Collection of UserToSiteMapping foreach (UserToSiteMapping obj in colUserToSite) { #region Declare Local Variables and Collection of Incident_mst Type string Status; BLLCollection<Incident_mst> col = new BLLCollection<Incident_mst>(); int siteid; #endregion #region Get the Siteid and Filter Parameter siteid = obj.Siteid; filterId = 0; #endregion #region If Role of User is Technician #region If Filter Variable is All if (filterId == 0) { col = objIncident.Get_All_By_Siteid_Requesterid(siteid, objUser.Userid, fromdate, todate, varSortParameter); } #endregion #endregion #region Fetch Each object of type Incident_mst from Collection Incident_mst foreach (Incident_mst objInc in col) { #region Create Table row and assign value to it DataRow row; row = dtTable.NewRow(); row["incidentid"] = Convert.ToString(objInc.Incidentid); row["title"] = objInc.Title; row["requesterid"] = Convert.ToString(objInc.Requesterid); row["createdbyid"] = Convert.ToString(objInc.Createdbyid); row["siteid"] = Convert.ToString(objInc.Siteid); row["createdatetime"] = Convert.ToString(objInc.Createdatetime); objIncidentStates = objIncidentStates.Get_By_id(objInc.Incidentid); row["statusid"] = objIncidentStates.Statusid; row["technicianid"] = objIncidentStates.Technicianid; row["priorityid"] = objIncidentStates.Priorityid; dtTable.Rows.Add(row); #endregion } #endregion } #endregion #region Bind Grid from datasource dtTable DataView dvData = new DataView(dtTable); string sortFormat = "{0} {1}"; String sortDirection = "DESC"; if (varSortParameter == "createdatetime") { varSortParameter = "incidentid"; } dvData.Sort = String.Format(sortFormat, varSortParameter, sortDirection); grdvwRequest.DataSource = dvData; grdvwRequest.DataBind(); #endregion } #endregion }
protected void btnUpdate_Click(object sender, EventArgs e) { //Add Exception handilng try catch change by vishal 21-05-2012 try { # region Declare Local Variable string StrStatusRequested; string StrStatusRejected; string StrStatusApproval; string StrStatusApproved; string StrStatusPlanning; string StrStatusTesting; string StrStatusRelease; string StrStatusImplemented; string StrStatusCompleted; string StrStatusString = ""; int userid = 0; int changeid = Convert.ToInt32(Request.QueryString[0]); string userName = ""; #endregion #region Fetch the Status Value from Resource File StrStatusString = GetChangeStatusString(Convert.ToInt32(drpStatus.SelectedValue)); StrStatusRejected = Resources.MessageResource.StrRejected.ToString(); StrStatusApproval = Resources.MessageResource.StrApproval.ToString(); StrStatusRequested = Resources.MessageResource.StrRequested.ToString(); StrStatusApproved = Resources.MessageResource.StrApproved.ToString(); StrStatusPlanning = Resources.MessageResource.StrPlanning.ToString(); StrStatusTesting = Resources.MessageResource.StrTesting.ToString(); StrStatusRelease = Resources.MessageResource.StrRelease.ToString(); StrStatusImplemented = Resources.MessageResource.StrImplemented.ToString(); StrStatusCompleted = Resources.MessageResource.StrCompleted.ToString(); #endregion MembershipUser User = Membership.GetUser(); userName = User.UserName.ToString(); #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 Historyvalue in Change History Table int result = String.Compare(StrStatusString, StrStatusRequested, true); if (result == 0) { ObjChangeHistory.Changeid = changeid; ObjChangeHistory.Operationownerid = userid; ObjChangeHistory.Operation = "Requested"; ObjChangeHistory.Insert(); } result = String.Compare(StrStatusString, StrStatusRejected, true); if (result == 0) { ObjChangeHistory.Changeid = changeid; ObjChangeHistory.Operationownerid = userid; ObjChangeHistory.Operation = "Rejected"; ObjChangeHistory.Insert(); } result = String.Compare(StrStatusString, StrStatusApproval, true); if (result == 0) { ObjChangeHistory.Changeid = changeid; ObjChangeHistory.Operationownerid = userid; ObjChangeHistory.Operation = "Approval"; ObjChangeHistory.Insert(); } result = String.Compare(StrStatusString, StrStatusApproved, true); if (result == 0) { ObjChangeHistory.Changeid = changeid; ObjChangeHistory.Operationownerid = userid; ObjChangeHistory.Operation = "Approved"; ObjChangeHistory.Insert(); } result = String.Compare(StrStatusString, StrStatusPlanning, true); if (result == 0) { ObjChangeHistory.Changeid = changeid; ObjChangeHistory.Operationownerid = userid; ObjChangeHistory.Operation = "Planning"; ObjChangeHistory.Insert(); } result = String.Compare(StrStatusString, StrStatusTesting, true); if (result == 0) { ObjChangeHistory.Changeid = changeid; ObjChangeHistory.Operationownerid = userid; ObjChangeHistory.Operation = "Testing"; ObjChangeHistory.Insert(); } result = String.Compare(StrStatusString, StrStatusRelease, true); if (result == 0) { ObjChangeHistory.Changeid = changeid; ObjChangeHistory.Operationownerid = userid; ObjChangeHistory.Operation = "Release"; ObjChangeHistory.Insert(); } result = String.Compare(StrStatusString, StrStatusImplemented, true); if (result == 0) { ObjChangeHistory.Changeid = changeid; ObjChangeHistory.Operationownerid = userid; ObjChangeHistory.Operation = "Implemented"; ObjChangeHistory.Insert(); } result = String.Compare(StrStatusString, StrStatusCompleted, true); if (result == 0) { ObjChangeHistory.Changeid = changeid; ObjChangeHistory.Operationownerid = userid; ObjChangeHistory.Operation = "Completed"; ObjChangeHistory.Insert(); } #endregion #region Get the Current historyid by calling function Get_Current_ProblemHistoryid() int historyid = ObjChangeHistory.Get_Current_ChangeHistoryid(); #endregion #region Find Current value of Problem aBy Calling Function Get_By_id(),via passing problemid ObjChange = ObjChange.Get_By_id(changeid); #endregion #region Insert into ChangeHistoryDiff table ,By Comparing Current value and Updated Values if (ObjChange.Changeid != 0) { #region Declare local variable string columnName; string prev_value; string curnt_value; #endregion #region If Priority value is changed,Insert into ChangeHistoryDiff table if (ObjChange.Priority != Convert.ToInt32(drpPriority.SelectedValue)) { columnName = Resources.MessageResource.strColumnPriorityid.ToString(); prev_value = Convert.ToString(ObjChange.Priority); curnt_value = Convert.ToString(drpPriority.SelectedValue); ObjChangeHistoryDiff.Historyid = historyid; ObjChangeHistoryDiff.Columnname = columnName; ObjChangeHistoryDiff.Current_value = curnt_value; ObjChangeHistoryDiff.Prev_value = prev_value; ObjChangeHistoryDiff.Insert(); } #endregion #region If Technician value is changed,Insert into ChangeHistoryDiff table if (ObjChange.Technician != Convert.ToInt32(drpTechnician.SelectedValue)) { columnName = Resources.MessageResource.strColumnTechnicianid.ToString(); prev_value = Convert.ToString(ObjChange.Technician); curnt_value = Convert.ToString(drpTechnician.SelectedValue); ObjChangeHistoryDiff.Historyid = historyid; ObjChangeHistoryDiff.Columnname = columnName; ObjChangeHistoryDiff.Current_value = curnt_value; ObjChangeHistoryDiff.Prev_value = prev_value; ObjChangeHistoryDiff.Insert(); } #endregion #region If category value is changed,Insert into ChangeHistoryDiff table if (ObjChange.Categoryid != Convert.ToInt32(drpCategory.SelectedValue)) { columnName = Resources.MessageResource.strColumnCategoryid.ToString(); prev_value = Convert.ToString(ObjChange.Categoryid); curnt_value = Convert.ToString(drpCategory.SelectedValue); ObjChangeHistoryDiff.Historyid = historyid; ObjChangeHistoryDiff.Columnname = columnName; ObjChangeHistoryDiff.Current_value = curnt_value; ObjChangeHistoryDiff.Prev_value = prev_value; ObjChangeHistoryDiff.Insert(); } #endregion #region If Subcategory value is changed,Insert into ChangeHistoryDiff table if (ObjChange.Subcategoryid != Convert.ToInt32(drpSubcategory.SelectedValue)) { columnName = Resources.MessageResource.strColumnSubcategoryid.ToString(); prev_value = Convert.ToString(ObjChange.Subcategoryid); curnt_value = Convert.ToString(drpSubcategory.SelectedValue); ObjChangeHistoryDiff.Historyid = historyid; ObjChangeHistoryDiff.Columnname = columnName; ObjChangeHistoryDiff.Current_value = curnt_value; ObjChangeHistoryDiff.Prev_value = prev_value; ObjChangeHistoryDiff.Insert(); } #endregion #region If Changetype value is changed,Insert into ChangeHistoryDiff table if (ObjChange.Changetype != Convert.ToInt32(drpchangetype.SelectedValue)) { columnName = Resources.MessageResource.strColumnChangeType.ToString(); prev_value = Convert.ToString(ObjChange.Changetype); curnt_value = Convert.ToString(drpchangetype.SelectedValue); ObjChangeHistoryDiff.Historyid = historyid; ObjChangeHistoryDiff.Columnname = columnName; ObjChangeHistoryDiff.Current_value = curnt_value; ObjChangeHistoryDiff.Prev_value = prev_value; ObjChangeHistoryDiff.Insert(); } #endregion #region If Changestatus value is changed,Insert into ChangeHistoryDiff table if (ObjChange.Changetype != Convert.ToInt32(drpStatus.SelectedValue)) { columnName = Resources.MessageResource.strColumnstatusid.ToString(); prev_value = Convert.ToString(ObjChange.Statusid); curnt_value = Convert.ToString(drpStatus.SelectedValue); ObjChangeHistoryDiff.Historyid = historyid; ObjChangeHistoryDiff.Columnname = columnName; ObjChangeHistoryDiff.Current_value = curnt_value; ObjChangeHistoryDiff.Prev_value = prev_value; ObjChangeHistoryDiff.Insert(); } #endregion } #endregion #region Update the completed status #endregion #region update the data in change_mst table ObjChange.Technician = Convert.ToInt32(drpTechnician.SelectedValue); ObjChange.Categoryid = Convert.ToInt32(drpCategory.SelectedValue); ObjChange.Subcategoryid = Convert.ToInt32(drpSubcategory.SelectedValue); ObjChange.Priority = Convert.ToInt32(drpPriority.SelectedValue); ObjChange.Changetype = Convert.ToInt32(drpchangetype.SelectedValue); ObjChange.Statusid = Convert.ToInt32(drpStatus.SelectedValue); ObjChange.Changeid = Convert.ToInt32(Request.QueryString[0]); ObjChange.Active = true; #region If Current status is closed,then Assign Completed time result = String.Compare(StrStatusString, StrStatusCompleted, true); if (result == 0) { BLLCollection<Incident_To_Change> colincidentchnage = new BLLCollection<Incident_To_Change>(); colincidentchnage = Objincidenttochange.Get_All_By_Changeid(changeid); int id = 0; foreach (Incident_To_Change objitoc in colincidentchnage) { id = Convert.ToInt32(objitoc.Incidentid); } IncidentStates objstate = new IncidentStates(); objstate = objstate.Get_By_id(id); Status_mst objincidentstats = new Status_mst(); objincidentstats = objincidentstats.Get_By_id(objstate.Statusid); string currentincidentstatus = objincidentstats.Statusname.ToString(); int comparestatus = String.Compare(currentincidentstatus, Resources.MessageResource.strStatusClose.ToString(), true); if (comparestatus == 0) { ObjChange.Completedtime = DateTime.Now.ToString(); Change_mst Objcurrentchange = new Change_mst(); ChangeStatus_mst Objchangestatus = new ChangeStatus_mst(); Objcurrentchange = Objcurrentchange.Get_By_id(changeid); Objchangestatus = Objchangestatus.Get_By_id(Objcurrentchange.Statusid); string status = Objchangestatus.Statusname.ToString(); int result1 = String.Compare(status, StrStatusCompleted, true); if (result1 == 0) { ObjChange.Completedtime = Objcurrentchange.Completedtime; ObjChange.Update(); } else { ObjChange.Completedtime = DateTime.Now.ToString(); ObjChange.Update(); } } else { string myScript; //myScript = "<script language=javascript>javascript:alert('Please Close All the Attached Incident');</script>"; ScriptManager.RegisterStartupScript(this, this.GetType(), "Javascript:alert('Please Close Alll the attached incident');", "Javascript:alert('Please Close Alll the attached incident');", true); ///'''Page.RegisterClientScriptBlock("MyScript", myScript); } } else { #endregion ObjChange.Update(); } #endregion // #region Update Include Assets in Change value in IncludedAssetinchange //objincludeasset.Delete(changeid); //for (int i = lstassetupdate.Items.Count - 1; i >= 0; i--) //{ // if (lstassetupdate.Items[i].Selected == true) // { // objincludeasset.Assetid = Convert.ToInt32(lstassetupdate.Items[i].Value); // objincludeasset.Changeid = changeid; // objincludeasset.Insert(); // } //} //#endregion Showchangeinfo(); btnUpdate.Visible = false; btnCancel.Visible = false; }
protected void grdvwProblem_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; 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[2].Text); objUser = objUser.Get_By_id(requesterid); if (objUser.Userid != 0) { e.Row.Cells[2].Text = objUser.Username.ToString(); } else { e.Row.Cells[2].Text = ""; } #endregion #region Bind Datarow at Run Time with Createdbyid to Created by name int createdbyid = Convert.ToInt32(e.Row.Cells[3].Text); objUser = objUser.Get_By_id(createdbyid); 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 technicianid to technician name int technicianid = Convert.ToInt32(e.Row.Cells[4].Text); objUser = objUser.Get_By_id(technicianid); 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 Statusid to Status int statusid = Convert.ToInt32(e.Row.Cells[5].Text); objStatus = objStatus.Get_By_id(statusid); if (objStatus.Statusid != 0) { e.Row.Cells[5].Text = objStatus.Statusname.ToString(); } else { e.Row.Cells[5].Text = ""; } #endregion #region Bind Datarow at run time with Priorityid to Priority int priorityid = Convert.ToInt32(e.Row.Cells[6].Text); objPriority = objPriority.Get_By_id(priorityid); if (objPriority.Priorityid != 0) { e.Row.Cells[6].Text = objPriority.Name.ToString(); } else { e.Row.Cells[6].Text = ""; } #endregion } }
protected void BindIncidentToProblem() { if (Session["IncidentToProblem"] != null) { int incidentid = Convert.ToInt16(Session["IncidentToProblem"].ToString()); Incident_mst objIncident = new Incident_mst(); IncidentStates objIncidentStates = new IncidentStates(); objIncident = objIncident.Get_By_id(incidentid); objIncidentStates = objIncidentStates.Get_By_id(incidentid); objuser = objuser.Get_By_id(objIncident.Requesterid); if (objIncidentStates.Priorityid != 0) { drpPriority.SelectedValue = Convert.ToString(objIncidentStates.Priorityid); } if (objIncidentStates.Categoryid != 0) { drpCategory.SelectedValue = Convert.ToString(objIncidentStates.Categoryid); BindDropSubCategory(); } if (objIncidentStates.Subcategoryid != 0) { drpSubcategory.SelectedValue = Convert.ToString(objIncidentStates.Subcategoryid); } if (objIncidentStates.Technicianid != 0) { drpTechnician.SelectedValue = Convert.ToString(objIncidentStates.Technicianid); } txtDescription.Text = objIncident.Description; txtTitle.Text = objIncident.Title; if (objuser.Userid != 0) { ContactInfo_mst objInfo = new ContactInfo_mst(); objInfo = objInfo.Get_By_id(objuser.Userid); txtUsername.Text = objuser.Username; txtEmail.Text = objInfo.Emailid; ViewState["UserCreate"] = "Exist"; } } }
protected void buttonadd_click(object sender, EventArgs e) { /////Add Exception handilng try catch change by vishal 21-05-2012 try { #region Find Userid of User who is Requesting to log a call #region If User Already Exist if (ViewState["UserCreate"].ToString() == "Exist") { objOrganization = objOrganization.Get_Organization(); ObjUserLogin = ObjUserLogin.Get_UserLogin_By_UserName(txtUsername.Text.ToString().Trim(), objOrganization.Orgid); if (ObjUserLogin.Userid != 0) { requesterid = ObjUserLogin.Userid; } } #endregion #region If New User is to be Created else if (ViewState["UserCreate"].ToString() == "create") { string varEmail = ""; string varRoleName = Resources.MessageResource.BasicUserRole.ToString(); if (txtEmail.Text == "") { varEmail = Resources.MessageResource.errMemshipCreateUserEmail.ToString(); } else { varEmail = txtEmail.Text; } int roleid = objRole.Get_By_RoleName(varRoleName); int status; objOrganization = objOrganization.Get_Organization(); objuser.Username = txtUsername.Text.ToString(); objuser.Password = Resources.MessageResource.strDefaultPassword.ToString(); objuser.Roleid = roleid; objuser.Orgid = objOrganization.Orgid; objuser.ADEnable = false; objuser.Enable = true; objuser.Createdatetime = DateTime.Now.ToString(); status = objuser.Insert(); if (status == 1) { // Create Mstatus field to send in Membership.CreateUser function as Out Variable for creating Membership User database MembershipCreateStatus Mstatus = default(MembershipCreateStatus); // Call Membership.CreateUser function to create Membership user Membership.CreateUser(txtUsername.Text.ToString().Trim(), Resources.MessageResource.strDefaultPassword.ToString(), varEmail, "Project Name", "Helpdesk", true, out Mstatus); // Call Roles.AddUserToRole Function to Add User To Role Roles.AddUserToRole(txtUsername.Text.ToString().Trim(), varRoleName); // Declare Local Variable Userid to fetch userid of newly created user // Create Object objUserLogin of UserLogin_mst()Class objuser = new UserLogin_mst(); // Fetch userid of Newly created user and assign to local variable userid by calling function objUserLogin.Get_By_UserName requesterid = objuser.Get_By_UserName(txtUsername.Text.ToString().Trim(), objOrganization.Orgid); // If userid not equal to 0 then we get userid of Newly created user otherwise error Occured ContactInfo_mst objContactInfo = new ContactInfo_mst(); objContactInfo.Userid = requesterid; objContactInfo.Emailid = varEmail; objContactInfo.Firstname = txtUsername.Text.ToString(); objContactInfo.Lastname = txtUsername.Text.ToString(); objContactInfo.Insert(); } } #endregion #region If User is Not to be Created else if (ViewState["UserCreate"].ToString() == "notcreate") { // FlagUserStatus = false; } #endregion #endregion ObjChange.Active = true; ObjChange.Statusid = Convert.ToInt32(drpStatus.SelectedValue); ObjChange.Categoryid = Convert.ToInt32(drpCategory.SelectedValue); ObjChange.Subcategoryid = Convert.ToInt32(drpSubcategory.SelectedValue); ///ObjChange.Technician = ""; ObjChange.Title = txtTitle.Text; ObjChange.Description = txtDescription.Text; ObjChange.Createdtime = DateTime.Now.ToString(); ObjChange.Changetype = Convert.ToInt32(drpchangetype.SelectedValue); ObjChange.Approvalstatus = "Send For Approval"; MembershipUser user = Membership.GetUser(); string username = user.UserName.ToString(); objOrganization = objOrganization.Get_Organization(); ObjUserLogin = ObjUserLogin.Get_UserLogin_By_UserName(username, objOrganization.Orgid); int userid = Convert.ToInt32(ObjUserLogin.Userid); ObjChange.CreatedByID = userid; //////////change doneby meenakshi objservice = objservice.Get_By_id(Convert.ToInt32(drpservices.SelectedValue)); if (objservice.servicename != null) { ObjChange.servicename = objservice.servicename; } else { ObjChange.servicename = ""; } ////////end ObjUserLogin = ObjUserLogin.Get_UserLogin_By_UserName(txtUsername.Text, objOrganization.Orgid); ObjChange.Requestedby = ObjUserLogin.Userid; //ObjChange.Priority = Convert.ToInt32(drpPriority.SelectedValue); ObjChange.Insert(); int changeid = ObjChange.Get_Current_Changeid(); for (int i = ListAsset.Items.Count - 1; i >= 0; i--) { if (ListAsset.Items[i].Selected == true) { Objincludeaasetchange.Assetid = Convert.ToInt32(ListAsset.Items[i].Value); Objincludeaasetchange.Changeid = changeid; Objincludeaasetchange.Insert(); } } objIncidentToChange.Changeid = changeid; objIncidentToChange.Incidentid = Convert.ToInt32(Session["incidentid"]); objIncidentToChange.Insert(); int changetype = Convert.ToInt32(ObjChange.Changetype); objSentEmailToChange.SentMailToChangeCommittee(changeid, changetype); ScriptManager.RegisterStartupScript(this, this.GetType(), "Close()", "Close();", true); } catch (Exception ex) { string myScript; myScript = "<script language=javascript>alert('Exception - '" + ex + "');</script>"; Page.RegisterClientScriptBlock("MyScript", myScript); return; } }