/// <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)
        {
        }
    }