//#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 grdvwChange.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 Changeid; // int varSiteid; // int oldtechnicianvalue; // #endregion // #region Get the Problemid from variable of Label type declare in GridView of grdvwSite // gvIDs = ((Label)gv.FindControl("Changeid")).Text.ToString(); // #endregion // #region Convert to incident id into integer // Changeid = Convert.ToInt16(gvIDs); // #endregion // #region If Incident id in Not Null // if (gvIDs != "") // { // Change_mst Obj = new Change_mst(); // Obj = ObjChange.Get_By_id(Changeid); // if (Obj.Changeid!= 0) // { // int technicianid = Convert.ToInt16(drpTechnician1.SelectedValue); // if (technicianid != 0) // { // Obj.Technician= technicianid; // Obj.Update(); // } // } // } // #endregion // } // #endregion // } // BindGridForAllParameter(); // #endregion //} //#endregion #region Handle Button btnCancell Click Event protected void btnCancell_Click(object sender, EventArgs e) { #region Fetch Each Row from GridView,and Check Which Check Box is Selected foreach (GridViewRow gv in grdvwChange.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 Changeid; int varSiteid; int oldtechnicianvalue; #endregion #region Get the Problemid from variable of Label type declare in GridView of grdvwSite gvIDs = ((Label)gv.FindControl("Changeid")).Text.ToString(); #endregion #region Convert to incident id into integer Changeid = Convert.ToInt16(gvIDs); #endregion #region If Incident id in Not Null if (gvIDs != "") { Change_mst Obj = new Change_mst(); Obj = ObjChange.Get_By_id(Changeid); if (Obj.Changeid != 0) { Obj.Active = false; Obj.Update(); } } #endregion } #endregion } BindGridForAllParameter(); #endregion }
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(); } }
protected void showCMDBValues() { panalupdatecmdb.Visible = true; int Incidentidforchange = Convert.ToInt32(Session["Incidentidforchange"]); ObjIncidentochange = ObjIncidentochange.Get_By_Incidentid(Incidentidforchange); int changeid = Convert.ToInt32(ObjIncidentochange.Changeid); Objincludeasset = Objincludeasset.Get_By_Changeid(changeid); int Assetid = Convert.ToInt32(Objincludeasset.Assetid); ObjConfiguration = ObjConfiguration.Get_By_id(Assetid); int itemid = Convert.ToInt32(ObjConfiguration.Itemid); ObjConfigurableitem = ObjConfigurableitem.Get_By_id(itemid); ObjCMDB = ObjCMDB.Get_By_id(Assetid); Objchange = Objchange.Get_By_id(changeid); int categoryid = Convert.ToInt32(Objchange.Categoryid); Objcategory = Objcategory.Get_By_id(categoryid); if (categoryid != 0) { lblcategory.Text = Objcategory.CategoryName.ToString(); } int Subcategoryid = Convert.ToInt32(Objchange.Subcategoryid); Objsubcategory = Objsubcategory.Get_By_id(Subcategoryid); if (Subcategoryid != 0) { lblsubcategory.Text = Objsubcategory.Subcategoryname.ToString(); } lblassetid.Text = ObjConfiguration.Assetid.ToString(); int itemid1 = Convert.ToInt32(ObjConfiguration.Itemid); Objcategory = Objcategory.Get_By_id(itemid1); lblitemname.Text = Objcategory.CategoryName.ToString(); Objvendor = Objvendor.Get_By_id(ObjConfiguration.Vendorid); lblvendor.Text = Objvendor.Vendorname.ToString(); lblchangeid.Text = Objchange.Changeid.ToString(); lblserialno.Text = ObjConfiguration.Serialno.ToString(); int changetypid = Convert.ToInt32(Objchange.Changetype); Objchangetype = Objchangetype.Get_By_id(changetypid); lblchangetype.Text = Objchangetype.Changetypename.ToString(); lbltitle.Text = Objchange.Title.ToString(); if (ObjConfigurableitem.Param1 != "") { txtparam1.Visible = true; lblparam1.Text = ObjConfigurableitem.Param1.ToString(); txtparam1.Text = ObjCMDB.Param1.ToString(); } if (ObjConfigurableitem.Param2 != "") { txtparam2.Visible = true; lblparam2.Text = ObjConfigurableitem.Param2.ToString(); txtparam2.Text = ObjCMDB.Param2.ToString(); } if (ObjConfigurableitem.Param3 != "") { txtparam3.Visible = true; lblparam3.Text = ObjConfigurableitem.Param3.ToString(); txtparam3.Text = ObjCMDB.Param3.ToString(); } if (ObjConfigurableitem.Param4 != "") { txtparam4.Visible = true; lblparam4.Text = ObjConfigurableitem.Param4.ToString(); txtparam4.Text = ObjCMDB.Param4.ToString(); } if (ObjConfigurableitem.Param5 != "") { txtparam5.Visible = true; lblparam5.Text = ObjConfigurableitem.Param5.ToString(); txtparam5.Text = ObjCMDB.Param5.ToString(); } if (ObjConfigurableitem.Param6 != "") { txtparam6.Visible = true; lblparam6.Text = ObjConfigurableitem.Param6.ToString(); txtparam6.Text = ObjCMDB.Param6.ToString(); } if (ObjConfigurableitem.Param7 != "") { txtparam7.Visible = true; lblparam7.Text = ObjConfigurableitem.Param7.ToString(); txtparam7.Text = ObjCMDB.Param7.ToString(); } if (ObjConfigurableitem.Param8 != "") { txtparam8.Visible = true; lblparam8.Text = ObjConfigurableitem.Param8.ToString(); txtparam8.Text = ObjCMDB.Param8.ToString(); } if (ObjConfigurableitem.Param9 != "") { txtparam9.Visible = true; lblparam9.Text = ObjConfigurableitem.Param9.ToString(); txtparam9.Text = ObjCMDB.Param9.ToString(); } if (ObjConfigurableitem.Param10 != "") { txtparam10.Visible = true; lblparam10.Text = ObjConfigurableitem.Param10.ToString(); txtparam10.Text = ObjCMDB.Param10.ToString(); } }
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 Showchangeinfo() { Approvalpanal.Visible = true; btnApprove.Visible = true; btnReject.Visible = true; Alreadyapprovedpanal.Visible = false; NameValueCollection n = Request.QueryString; int changeid = Convert.ToInt32(Request.QueryString[0]); //lblchangeid.Text = changeid.ToString(); ObjChange = ObjChange.Get_By_id(changeid); lblchangeid.Text = ObjChange.Changeid.ToString(); lbltitle.Text = ObjChange.Title; lbldescription.Text = ObjChange.Description; //lblDateDisp.Text = ObjChange.Createdtime.ToString(); int requesterid = Convert.ToInt32(ObjChange.Requestedby); //lblTitle.Text = ObjChange.Title.ToString(); //lblDescription.Text = ObjChange.Description.ToString(); lblserviceeffected.Text = "Email"; int chantypeid = Convert.ToInt32(ObjChange.Changetype); ObjChangeType = ObjChangeType.Get_By_id(chantypeid); if (chantypeid != 0) { lblchangetype.Text = ObjChangeType.Changetypename.ToString(); } int changestatus = Convert.ToInt32(ObjChange.Statusid); Objchangestatus = Objchangestatus.Get_By_id(changestatus); if (changestatus != 0) { lblStatus.Text = Objchangestatus.Statusname; } int priorityid = Convert.ToInt32(ObjChange.Priority); ObjPriority = ObjPriority.Get_By_id(priorityid); if (priorityid != 0) { lblpriority.Text = ObjPriority.Name.ToString(); } else { lblpriority.Text = ""; } int category = Convert.ToInt32(ObjChange.Categoryid); ObjCategory = ObjCategory.Get_By_id(category); if (category != 0) { lblcategory.Text = ObjCategory.CategoryName.ToString(); } else { lblcategory.Text = ""; } int subcategory = Convert.ToInt32(ObjChange.Subcategoryid); Objsubcategory = Objsubcategory.Get_By_id(subcategory); if (subcategory != 0) { lblsubcategory.Text = Objsubcategory.Subcategoryname.ToString(); } else { lblsubcategory.Text = ""; } int creator = Convert.ToInt32(ObjChange.CreatedByID); ObjUser = ObjUser.Get_By_id(creator); lblCreatedby.Text = ObjUser.Username.ToString(); lblCreatedDate.Text = ObjChange.Createdtime.ToString(); int techid = Convert.ToInt32(ObjChange.Technician); ObjUser = ObjUser.Get_By_id(techid); if (techid != 0) { lbltechid.Text = ObjUser.Username.ToString(); } else { lbltechid.Text = ""; } colassetincludeinchange = objincludeasset.Get_All_IncludeAssetinchange(changeid); BLLCollection <Configuration_mst> colasset = new BLLCollection <Configuration_mst>(); Configuration_mst ObjAsset = new Configuration_mst(); foreach (IncludedAssetinchange obj in colassetincludeinchange) { ObjAsset = ObjAsset.Get_By_id(obj.Assetid); colasset.Add(ObjAsset); } lstAsset.DataTextField = "Serialno"; lstAsset.DataValueField = "assetid"; lstAsset.DataSource = colasset; lstAsset.DataBind(); }
protected void btnApprove_Click(object sender, EventArgs e) { ObjChangeApproveTrans.Changeid =Convert.ToInt16(Request.QueryString[0]); ObjChangeApproveTrans.Approvalcomment = txtcomment.Text.ToString(); ObjChangeApproveTrans.ApproverName =Request.QueryString[1]; int changestatusid=Objchangestatus.Get_By_StatusName(Resources.MessageResource.StrApproved); ObjChangeApproveTrans.Approvestatus=changestatusid; ObjChangeApproveTrans.Insert(); Change_mst Obj = new Change_mst(); Obj=Obj.Get_By_id(Convert.ToInt16(Request.QueryString[0])); ObjChange.Statusid = changestatusid; ObjChange.Changeid = Convert.ToInt16(Request.QueryString[0]); ObjChange.Active =true; ObjChange.Assignetime = Obj.Assignetime; ObjChange.Categoryid =Obj.Categoryid ; ObjChange.Changetype = Obj.Changetype; ObjChange.Subcategoryid = Obj.Subcategoryid; ObjChange.Technician = Obj.Technician; ObjChange.Title = Obj.Title; //ObjChange.Completedtime = ""; ObjChange.CreatedByID = Obj.CreatedByID; ObjChange.Description = Obj.Description; ObjChange.Priority = Obj.Priority; ObjChange.Requestedby = Obj.Requestedby; ObjChange.Sceduledstarttime = Obj.Sceduledstarttime; ObjChange.Sceduledendtime = Obj.Sceduledendtime; ObjChange.Approvalstatus = Obj.Approvalstatus; ObjChange.Impact = Obj.Impact; ObjChange.Update(); Change_mst ObjNewChange = new Change_mst(); ObjNewChange = ObjNewChange.Get_By_id(Convert.ToInt16(Request.QueryString[0])); string approvalrequest=Resources.MessageResource.StrApproved.ToString(); int modeid = ObjMode.Get_Mode_By_Mname("Email"); if(approvalrequest=="Approved") { BLLCollection<Incident_To_Change> colIncToChng = new BLLCollection<Incident_To_Change>(); colIncToChng=Objincidenttochange.Get_All_By_Changeid(ObjNewChange.Changeid); int FlagStatus=0; foreach (Incident_To_Change obj in colIncToChng) { FlagStatus = FlagStatus + 1; } if (FlagStatus == 0) { string statusname = Resources.MessageResource.strStatusOpen.ToString(); int statusid = Convert.ToInt16(Objstatus.Get_By_StatusName(statusname)); Objincludeassetinchange = Objincludeassetinchange.Get_By_Changeid(ObjNewChange.Changeid); Objconfiguration = Objconfiguration.Get_By_id(Objincludeassetinchange.Assetid); int priorityid = Convert.ToInt16(Objconfiguration.Severity); Incident_mst Objincident = new Incident_mst(); int slaid = Objincident.Get_By_SLAid(Objconfiguration.Siteid, priorityid); Objincident.Requesterid = ObjNewChange.Requestedby; Objincident.Title = ObjNewChange.Title; Objincident.Siteid = Objconfiguration.Siteid; Objincident.Createdbyid = ObjNewChange.CreatedByID; Objincident.Slaid = Convert.ToInt16(slaid); Objincident.Modeid = modeid; Objincident.Insert(); int incidentid = Objincident.Get_Current_Incidentid(); IncidentStates Objincidentstattes = new IncidentStates(); Objincidentstattes.Incidentid = incidentid; Objincidentstattes.Priorityid = Convert.ToInt16(Objconfiguration.Severity); Objincidentstattes.Subcategoryid = ObjNewChange.Subcategoryid; Objincidentstattes.Categoryid = ObjNewChange.Categoryid; Objincidentstattes.Statusid = statusid; Objincidentstattes.Requesttypeid = 2; Objincidentstattes.Insert(); objincidenthistory.Incidentid = incidentid; objincidenthistory.Operation = "create"; objincidenthistory.Operationownerid = ObjNewChange.CreatedByID; objincidenthistory.Insert(); Objincidenttochange.Changeid = ObjNewChange.Changeid; Objincidenttochange.Incidentid = incidentid; Objincidenttochange.Insert(); string myScript; myScript = "<script language=javascript>CloseWindow();</script>"; Page.RegisterClientScriptBlock("MyScript", myScript); } } }
protected void btnReject_Click(object sender, EventArgs e) { ObjChangeApproveTrans.Changeid = Convert.ToInt16(Request.QueryString[0]); ObjChangeApproveTrans.Approvalcomment = txtcomment.Text.ToString(); ObjChangeApproveTrans.ApproverName = Request.QueryString[1]; int changestatusid = Objchangestatus.Get_By_StatusName(Resources.MessageResource.StrRejected); ObjChangeApproveTrans.Approvestatus = changestatusid; ObjChangeApproveTrans.Insert(); ObjChangeApproveTrans.Approvestatus = changestatusid; ObjChangeApproveTrans.Insert(); Change_mst Obj = new Change_mst(); Obj = Obj.Get_By_id(Convert.ToInt16(Request.QueryString[0])); ObjChange.Statusid = changestatusid; ObjChange.Changeid = Convert.ToInt16(Request.QueryString[0]); ObjChange.Active = true; ObjChange.Assignetime = Obj.Assignetime; ObjChange.Categoryid = Obj.Changetype; ObjChange.Subcategoryid = Obj.Subcategoryid; ObjChange.Technician = Obj.Technician; ObjChange.Title = Obj.Title; ObjChange.Completedtime = Obj.Createdtime; ObjChange.CreatedByID = Obj.CreatedByID; ObjChange.Description = Obj.Description; ObjChange.Priority = Obj.Priority; ObjChange.Requestedby = Obj.Requestedby; ObjChange.Sceduledstarttime = Obj.Sceduledstarttime; ObjChange.Sceduledendtime = Obj.Sceduledendtime; ObjChange.Approvalstatus = Obj.Approvalstatus; ObjChange.Impact = Obj.Impact; ObjChange.Update(); string myScript; myScript = "<script language=javascript>CloseWindow();</script>"; Page.RegisterClientScriptBlock("MyScript", myScript); }