public bool UpdateComplainDetails(int CompID) { //--------------------- try { int ComplainID = CompID; string TicketNo = tbComplainTicketNo.Text; int ComplaintStatusID = Convert.ToInt32(cmbComplainStatus.SelectedValue); int AssignedByDeptID = DeptID; int AssignedToDeptID = 61; string AssignedToPersonName = tbPersonSolvingComplain.Text; string AssignedByPersonName = tbPersonSolvingComplain.Text; //DateTime LastUpdatedDate = AppDomain.CurrentDomain.GetData("LastUpdatedDate"); DateTime LastUpdatedDate = DateTime.Now; DateTime ETA = Convert.ToDateTime("1/1/1990"); string PersonGivenETA = ""; DateTime ETTR = Convert.ToDateTime("1/1/1990"); string PersonSolving = ""; //DateTime ComplainSolvingDate = dtComplainSolving.Value; DateTime ComplainSolvingDate = dtSolving.SelectedDate.Value; string FCR = (rbFCRYes.Checked == false ? "Yes" : "No"); int ProblemDignoseEndID = Convert.ToInt32(cmbProblemDiagnosedat.SelectedValue); int ReasonOutageID = Convert.ToInt32(cmbReasonofOutage.SelectedValue); string Dignose_Causes = tbCauses.Text; string Dignose_RootCauseAnalysis = tbRootCauseAnalysis.Text; string Dignose_PreventativeMeasureTake = tbPreventiveMeasures.Text; string LastMileInfraID = cmbLastMileInfra.SelectedValue; string CustomerFeedBack = ""; string FurtherAction = ""; string NewComplainRef = ""; string QueryResponses = ""; string strWithTabsQR = tbRemarks.Text; string lineQR = strWithTabsQR.Replace("\t", " "); tbRemarks.Text = lineQR.Replace("\r\n", " "); string Remarks = tbRemarks.Text; int TransactionBy = UserID; objBSS.UpdateComplain(ComplainID, TicketNo, ComplaintStatusID, AssignedByDeptID, AssignedToDeptID, AssignedToPersonName, AssignedByPersonName, LastUpdatedDate, ETA, PersonGivenETA, ETTR, PersonSolving, ComplainSolvingDate, FCR, ProblemDignoseEndID, ReasonOutageID, Dignose_Causes, Dignose_RootCauseAnalysis, Dignose_PreventativeMeasureTake, Convert.ToInt32(LastMileInfraID), CustomerFeedBack, FurtherAction, NewComplainRef, QueryResponses, Remarks, "", "", "", 1, 0, TransactionBy); return(true); } catch (Exception ex) { throw ex; } return(true); }
private bool UpdateComplainDetails(int CompID) { try { int ComplainID = CompID; string TicketNo = tbComplainTicketNo.Text; int ComplaintStatusID = Convert.ToInt32(cmbComplainStatus.SelectedValue); int AssignedByDeptID = DeptID; int AssignedToDeptID = Convert.ToInt32(cmbAssignedDepartment.SelectedValue); string AssignedToPersonName = tbLoggedBy0.Text; string AssignedByPersonName = tbLoggedBy0.Text; DateTime LastUpdatedDate = Convert.ToDateTime(AppDomain.CurrentDomain.GetData("LastUpdatedDate")); DateTime ETA = Convert.ToDateTime(RadDateTimePicker1.SelectedDate); string PersonGivenETA = tbLoggedBy0.Text; DateTime ETTR = Convert.ToDateTime(RadDateTimePicker3.SelectedDate); string PersonSolving = ""; DateTime ComplainSolvingDate = Convert.ToDateTime("1/1/1990"); string FCR = ""; int ProblemDignoseEndID = 5; int ReasonOutageID = 187; string Dignose_Causes = ""; string Dignose_RootCauseAnalysis = ""; string Dignose_PreventativeMeasureTake = ""; string LastMileInfraID = "29"; string CustomerFeedBack = ""; string FurtherAction = ""; string NewComplainRef = ""; string strWithTabsQR = tbIPResponses.Text; string lineQR = strWithTabsQR.Replace("\t", " "); tbIPResponses.Text = lineQR.Replace("\r\n", " "); string QueryResponses = tbIPResponses.Text; string strWithTabs = tbInternalRemarks.Text; string line = strWithTabsQR.Replace("\t", " "); tbInternalRemarks.Text = line.Replace("\r\n", " "); string Remarks = tbInternalRemarks.Text; if (SupportRequest.Checked == true) { RequestTypeAtNE = "Support Request"; } else if (ServiceRequest.Checked == true) { RequestTypeAtNE = "Service Request"; } else if (SupportRequest.Checked == false & ServiceRequest.Checked == false) { RequestTypeAtNE = ""; } int TransactionBy = Convert.ToInt32(Session["UserID"]); /*if (objBSS.UpdateComplain(ComplainID, TicketNo, ComplaintStatusID, AssignedByDeptID, AssignedToDeptID, AssignedToPersonName, AssignedByPersonName, LastUpdatedDate, ETA, PersonGivenETA, * ETTR, PersonSolving, ComplainSolvingDate, FCR, ProblemDignoseEndID, ReasonOutageID, Dignose_Causes, Dignose_RootCauseAnalysis, Dignose_PreventativeMeasureTake, Convert.ToInt32(LastMileInfraID), * * CustomerFeedBack, FurtherAction, NewComplainRef, QueryResponses, Remarks, RequestTypeAtNE, "" ,"",1,0, TransactionBy))*/ if (objBSS.UpdateComplain(ComplainID, TicketNo, ComplaintStatusID, AssignedByDeptID, AssignedToDeptID, AssignedToPersonName, AssignedByPersonName, LastUpdatedDate, ETA, PersonGivenETA, ETTR, PersonSolving, ComplainSolvingDate, FCR, ProblemDignoseEndID, ReasonOutageID, Dignose_Causes, Dignose_RootCauseAnalysis, Dignose_PreventativeMeasureTake, Convert.ToInt32(LastMileInfraID), CustomerFeedBack, FurtherAction, NewComplainRef, QueryResponses, Remarks, RequestTypeAtNE, ViewState["Pic1"].ToString(), ViewState["Pic2"].ToString(), Convert.ToInt32(cmbTeam.SelectedValue), Convert.ToInt32(cmbPriority.SelectedValue), TransactionBy)) // if (objBSS.UpdateComplain(ComplainID, TicketNo, ComplaintStatusID, AssignedByDeptID, AssignedToDeptID, AssignedToPersonName, AssignedByPersonName, LastUpdatedDate, ETA, PersonGivenETA, //ETTR, PersonSolving, ComplainSolvingDate, FCR, ProblemDignoseEndID, ReasonOutageID, Dignose_Causes, Dignose_RootCauseAnalysis, Dignose_PreventativeMeasureTake, Convert.ToInt32(LastMileInfraID), //CustomerFeedBack, FurtherAction, NewComplainRef, QueryResponses, Remarks, RequestTypeAtNE, ViewState["Pic1"].ToString(), ViewState["Pic2"].ToString(), Convert.ToInt32(ViewState["TeamID"]), Convert.ToInt32(ViewState["PriorityID"]), TransactionBy)) { return(true); } else { return(false); } } catch (Exception ex) { throw ex; } return(true); }
public bool UpdateComplainDetails(int CompID) { try { int ComplainID = CompID; string TicketNo = tbComplainTicketNo.Text; int ComplaintStatusID = ComplainStatusID; int AssignedByDeptID = DeptID; int AssignedToDeptID = AssginedDepart; string AssignedToPersonName = Session["Name"].ToString(); string AssignedByPersonName = Session["Name"].ToString(); DateTime LastUpdatedDate = DateTime.Now; DateTime ETA = DateTime.Now; string PersonGivenETA = ""; DateTime ETTR = DateTime.Now; string PersonSolving = ""; DateTime ComplainSolvingDate = DateTime.Now; string FCR = ""; int ProblemDignoseEndID = 5; int ReasonOutageID = 187; string Dignose_Causes = ""; string Dignose_RootCauseAnalysis = ""; string Dignose_PreventativeMeasureTake = ""; string LastMileInfraID = "29"; string CustomerFeedBack = rbCustomerFeedback.SelectedValue; string FurtherAction = (rbRe.Checked == true ? "Re-Initiated" : (rbNewComplaintLogged.Checked == true ? "New Complaint Logged" : "N/A")); string NewComplainRef = tbNewComplaintReference.Text; string QueryResponses = ""; string strWithTabsQR = tbRemarks.Text; string lineQR = strWithTabsQR.Replace("\t", " "); tbRemarks.Text = lineQR.Replace("\r\n", " "); string Remarks = tbRemarks.Text; int TransactionBy = UserID; //if(rbN.Checked==true) //{ // FurtherAction="N/A"; //} //else if (rbRe.Checked == true) //{ // FurtherAction = "Re-Initiated"; //} //else if (rbNewComplaintLogged.Checked == true) //{ // FurtherAction = "New Complaint Logged"; //} if (objBSS.UpdateComplain(ComplainID, TicketNo, ComplaintStatusID, AssignedByDeptID, AssignedToDeptID, AssignedToPersonName, AssignedByPersonName, LastUpdatedDate, ETA, PersonGivenETA, ETTR, PersonSolving, ComplainSolvingDate, FCR, ProblemDignoseEndID, ReasonOutageID, Dignose_Causes, Dignose_RootCauseAnalysis, Dignose_PreventativeMeasureTake, Convert.ToInt32(LastMileInfraID), CustomerFeedBack, FurtherAction, NewComplainRef, QueryResponses, Remarks, "", "", "", 1, 0, TransactionBy)) { return(true); } else { return(false); } } catch (Exception ex) { throw ex; } }