/// <summary> /// Added By Ashok Kumar and Above Method /// </summary> /// <param name="objRSMCancellation"></param> /// <returns></returns> public int ApproveDisapproveComplaintByRsm(RSMCancellation objRSMCancellation) { int suc = 0; string msg = ""; SqlParameter[] param = { new SqlParameter("@Type", this.Type), new SqlParameter("@Id", this.Id), new SqlParameter("@CreatedBy", this.CreatedBy), new SqlParameter("@RsmComment", this.RsmComment), new SqlParameter("@Status", this.Status), new SqlParameter("@MessageOut", SqlDbType.NVarChar, 1000), new SqlParameter("@BaselineId", this.BaselineId), new SqlParameter("@ComplaintNo", this.ComplaintNo), new SqlParameter("@SplitComplaintRefNo", this.SplitComplaintRefNo), new SqlParameter("@AscName", this.AscName), }; param[5].Direction = ParameterDirection.Output; suc = objSql.ExecuteNonQuery(CommandType.StoredProcedure, "uspGetComplaintForRSM", param); msg = param[5].Value.ToString(); return(Convert.ToInt32(msg)); }
public string SaveComplaintDetails(RSMCancellation objRSMCancellation) { string msg = ""; SqlParameter[] param = { new SqlParameter("@Type", this.Type), new SqlParameter("@BaselineId", this.BaselineId), new SqlParameter("@ComplaintNo", this.ComplaintNo), new SqlParameter("@ComplaintRefNo", this.ComplaintRefNo), new SqlParameter("@SplitComplaintRefNo", this.SplitComplaintRefNo), new SqlParameter("@CallStatus", this.CallStatus), new SqlParameter("@CallStatusNew", this.CallStatusNew), new SqlParameter("@Sc_Sno", this.SCSNo), new SqlParameter("@Comment", this.Comment), new SqlParameter("@CreatedBy", this.CreatedBy), new SqlParameter("@Status", this.Status), new SqlParameter("@MessageOut", SqlDbType.NVarChar, 1000) }; param[11].Direction = ParameterDirection.Output; objSql.ExecuteNonQuery(CommandType.StoredProcedure, "uspGetComplaintForRSM", param); msg = param[10].Value.ToString(); return(msg); }
private void PostPutDetails(string strFlag, string sortOrder) { try { if (gvDetails.Rows.Count > 0) { foreach (GridViewRow gvr in gvDetails.Rows) { CheckBox chkChild = (CheckBox)gvr.FindControl("chkChild"); if (chkChild != null && chkChild.Checked) { RSMCancellation objRSMCancellation = new RSMCancellation(); int id = 0; bool status = false; string comment = string.Empty; status = true; HiddenField hdnId = (HiddenField)gvr.FindControl("hdnId"); HiddenField hdnBaselineId = (HiddenField)gvr.FindControl("hdnBaselineid"); HiddenField hdnComplaintNo = (HiddenField)gvr.FindControl("hndComplaintNo"); HiddenField hdnSplitNo = (HiddenField)gvr.FindControl("hdnSplitNo"); HiddenField hdnAscName = (HiddenField)gvr.FindControl("hdnAscName"); if (hdnId != null) { id = int.Parse(hdnId.Value); } TextBox txtComment = (TextBox)gvr.FindControl("txtComment"); if (txtComment != null) { comment = txtComment.Text.Trim(); } objRSMCancellation.AscName = hdnAscName != null ? hdnAscName.Value : ""; objRSMCancellation.SplitComplaintRefNo = hdnSplitNo != null?int.Parse(hdnSplitNo.Value) : 1; objRSMCancellation.ComplaintNo = hdnComplaintNo.Value != null ? hdnComplaintNo.Value : ""; objRSMCancellation.Id = id; if (strFlag.Equals("APPROVE", StringComparison.CurrentCultureIgnoreCase)) { objRSMCancellation.RsmComment = "Approved : " + comment; } else { objRSMCancellation.RsmComment = "Rejected : " + comment; } objRSMCancellation.Status = status; objRSMCancellation.CreatedBy = Membership.GetUser().UserName.ToString(); objRSMCancellation.BaselineId = int.Parse(hdnBaselineId.Value); objRSMCancellation.Type = strFlag; int success = objRSMCancellation.ApproveDisapproveComplaintByRsm(objRSMCancellation); if (success > 0) { BindGrid(sortOrder); lblMsg.Text = strFlag.Equals("APPROVE") ? "Selected Complaint Closed." : "Selected Complaint Canceled"; } else { lblMsg.Text = "Unable To Process, Please Try Again..!"; } } } } } catch (Exception ex) { } }
//protected void ddlAsc_SelectedIndexChanged(object sender, EventArgs e) //{ // objRSMCancellation.SCSNo =int.Parse(ddlAsc.SelectedValue); // if(objRSMCancellation.SCSNo!=0) // objRSMCancellation.BindSCProductDivision(ddlProductDivision); // else // //objCommonClass.BindProductDivision(ddlProductDivision); // objRSMCancellation.GetUserProductDivisions(ddlProductDivision);// Added on 16.04.15 By Ashok Kumar // if (ddlProductDivision.Items.FindByText("Select") != null) // { // ddlProductDivision.Items.FindByText("Select").Text = "All"; // } //} protected void BindGrid(string strOrder) { try { // get the complaint details on the bais RSMCancellation objRSMCancellation = new RSMCancellation(); objRSMCancellation.EmpId = Membership.GetUser().UserName; if (ddlRegion.SelectedIndex != 0) { objRSMCancellation.RegionSno = int.Parse(ddlRegion.SelectedItem.Value); } if (ddlBranch.SelectedIndex != 0) { objRSMCancellation.BranchSno = int.Parse(ddlBranch.SelectedItem.Value); } if (ddlAsc.SelectedIndex != 0) { objRSMCancellation.SCSNo = int.Parse(ddlAsc.SelectedItem.Value); } if (ddlProductDivision.SelectedIndex != 0) { objRSMCancellation.ProductDiv_Sno = int.Parse(ddlProductDivision.SelectedItem.Value); } if (!string.IsNullOrEmpty(Convert.ToString(txtFromDate.Text.Trim()))) { objRSMCancellation.FromDate = txtFromDate.Text.Trim(); } if (!string.IsNullOrEmpty(Convert.ToString(txtToDate.Text.Trim()))) { objRSMCancellation.ToDate = txtToDate.Text.Trim(); } objRSMCancellation.Type = "SELECT_COMPLAINT"; objRSMCancellation.RoleType = this.Role; //Added By Mukesh on 4.5.15 DataSet ds = objRSMCancellation.BindCompGrid(gvDetails); if (ds != null && ds.Tables.Count > 0) { if (ds.Tables[0].Rows.Count > 0) { if (!string.IsNullOrEmpty(strOrder.Trim())) { DataView dvSource = default(DataView); dvSource = ds.Tables[0].DefaultView; dvSource.Sort = strOrder; gvDetails.DataSource = dvSource; gvDetails.DataBind(); ds = null; dvSource.Dispose(); dvSource = null; } else { gvDetails.DataSource = ds.Tables[0]; gvDetails.DataBind(); } trSubmit.Visible = true; } else { trSubmit.Visible = false; gvDetails.DataSource = ds; gvDetails.DataBind(); } if (ds.Tables[1] != null) { lblTotalComplaintCount.Text = string.IsNullOrEmpty(ds.Tables[1].Rows[0][0].ToString()) ? "0" : ds.Tables[1].Rows[0][0].ToString(); } else { lblTotalComplaintCount.Text = "0"; } } else { trSubmit.Visible = false; gvDetails.DataSource = ds; gvDetails.DataBind(); lblTotalComplaintCount.Text = "0"; } } catch (Exception ex) { } }