protected void imgBtnCancel_Click(object sender, EventArgs e)
 {
     try
     {
         ddlProdDivision.Enabled       = true;
         ddlASC.Enabled                = true;
         imgBtnSubmit.Enabled          = false;
         lblMessage.Text               = "";
         ddlProdDivision.SelectedIndex = 0;
         ddlASC.SelectedIndex          = 0;
         GvRateMasterForASC.DataSource = null;
         GvRateMasterForASC.DataBind();
         //DTRateDetailsDivisionWise = (DataTable)ViewState["DTRateDetailsDivisionWise"];
         //if (DTRateDetailsDivisionWise.Rows.Count > 0)
         //{
         //    DTRateDetailsDivisionWise.Clear();
         //    DTRateDetailsDivisionWise.AcceptChanges();
         //    ViewState["DTRateDetailsDivisionWise"] = DTRateDetailsDivisionWise;
         //    GvRateMasterForASC.DataSource = DTRateDetailsDivisionWise;
         //    GvRateMasterForASC.DataBind();
         //}
     }
     catch (Exception ex)
     {
         SIMSCommonClass.WriteErrorErrFile(Request.RawUrl.ToString(), ex.StackTrace.ToString() + "-->" + ex.Message.ToString());
     }
 }
    //protected void ddlProdDivision_SelectedIndexChanged(object sender, EventArgs e)
    //{
    //    try
    //    {
    //        ProductDivision_Id = Convert.ToInt32(ddlProdDivision.SelectedValue);
    //        SqlParameter[] sqlParamSrh =
    //        {
    //            new SqlParameter("@Type", "SELECT_RATE_ACTIVITY_PRODUCT_DIVISION_WISE"),
    //            new SqlParameter("@ProductDivision_Id", ProductDivision_Id)
    //        };
    //        objCommonClass.BindDataGrid(GvRateMasterForASC, "uspRateMasterForASC", true, sqlParamSrh);
    //        imgBtnSubmit.Visible = true;
    //        imgBtnCancel.Visible = true;
    //        ProductDivision_Id = Convert.ToInt32(ddlProdDivision.SelectedValue);
    //        ViewState["DTRateDetailsDivisionWise"] = objRateMasterForASC.GetAllRateAccordingToDivision(ProductDivision_Id);
    //        DTRateDetailsDivisionWise = (DataTable)ViewState["DTRateDetailsDivisionWise"];
    //        DTRateDetailsDivisionWise.Columns.Add("Rate");
    //        DTRateDetailsDivisionWise.Columns.Add("SC_SNo");
    //        DTRateDetailsDivisionWise.AcceptChanges();
    //        ViewState["DTRateDetailsDivisionWise"] = DTRateDetailsDivisionWise;
    //    }
    //    catch (Exception ex)
    //    {
    //        SIMSCommonClass.WriteErrorErrFile(Request.RawUrl.ToString(), ex.StackTrace.ToString() + "-->" + ex.Message.ToString());
    //    }
    //}
    protected void imgBtnGo_Click(object sender, EventArgs e)
    {
        try
        {
            GvRateMasterForASC.DataSource = null;
            GvRateMasterForASC.DataBind();
            ProductDivision_Id = Convert.ToInt32(ddlProdDivision.SelectedValue);
            SqlParameter[] sqlParamSrh =
            {
                new SqlParameter("@Type",                 "SELECT_RATE_ACTIVITY_PRODUCT_DIVISION_AND_ASC_WISE"),
                new SqlParameter("@ProductDivision_Id",   ProductDivision_Id),
                new SqlParameter("@ServiceContractor_Id", ddlASC.SelectedItem.Value)
            };
            ds = objCommonClass.BindDataGrid1(GvRateMasterForASC, "uspRateMasterForASC", true, sqlParamSrh);
            ViewState["dsActual"] = ds;


            imgBtnSubmit.Visible = true;
            imgBtnCancel.Visible = true;
            ProductDivision_Id   = Convert.ToInt32(ddlProdDivision.SelectedValue);
            //ViewState["DTRateDetailsDivisionWise"] = objRateMasterForASC.GetAllRateAccordingToDivision_And_ASC(ProductDivision_Id,Convert.ToInt32(ddlASC.SelectedItem.Value));
            //DTRateDetailsDivisionWise = (DataTable)ViewState["DTRateDetailsDivisionWise"];
            //DTRateDetailsDivisionWise.Columns.Add("Rate");
            //DTRateDetailsDivisionWise.Columns.Add("SC_SNo");
            //DTRateDetailsDivisionWise.AcceptChanges();
            //ViewState["DTRateDetailsDivisionWise"] = DTRateDetailsDivisionWise;
        }
        catch (Exception ex)
        {
            SIMSCommonClass.WriteErrorErrFile(Request.RawUrl.ToString(), ex.StackTrace.ToString() + "-->" + ex.Message.ToString());
        }
        ddlProdDivision.Enabled = false;
        ddlASC.Enabled          = false;
        imgBtnSubmit.Enabled    = true;
    }
    protected void imgBtnSubmit_Click(object sender, EventArgs e)
    {
        try
        {
            if (ddlASC.SelectedIndex > 0 && ddlProdDivision.SelectedIndex > 0)
            {
                int intProductDivision_Id   = Convert.ToInt32(ddlProdDivision.SelectedItem.Value);
                int intServiceContractor_Id = Convert.ToInt32(ddlASC.SelectedItem.Value);
                for (int i = 0; i < GvRateMasterForASC.Rows.Count; i++)
                {
                    HiddenField hdnCheckUp = (HiddenField)GvRateMasterForASC.Rows[i].FindControl("hdnCheckUpdate");
                    if (hdnCheckUp.Value == "U")
                    {
                        TextBox  txtRate   = (TextBox)GvRateMasterForASC.Rows[i].FindControl("txtRate");
                        CheckBox ChkActual = (CheckBox)GvRateMasterForASC.Rows[i].FindControl("ChkActual");
                        double   strRate   = string.IsNullOrEmpty(txtRate.Text) ? 0.0 : Convert.ToDouble(txtRate.Text.Trim());
                        if (ChkActual.Checked == true)
                        {
                            objRateMasterForASC.Actual = 1;
                        }
                        else
                        {
                            objRateMasterForASC.Actual = 0;
                        }
                        int    intActivityParameter_SNo = Convert.ToInt32(GvRateMasterForASC.Rows[i].Cells[15].Text);
                        string strMessage = objRateMasterForASC.SaveData(strRate, intActivityParameter_SNo, intProductDivision_Id, intServiceContractor_Id);
                        if (strMessage != "")
                        {
                            lblMessage.Text += strMessage;
                        }
                    }
                }
                ddlProdDivision.Enabled = true;
                ddlASC.Enabled          = true;
                imgBtnSubmit.Enabled    = false;
                ScriptManager.RegisterClientScriptBlock(imgBtnSubmit, GetType(), "", "window.close();window.opener.SearchPostBack();", true);
            }
            else
            {
                lblMessage.Text               = "Please select Product Division and Service Contractor!";
                ddlProdDivision.Enabled       = true;
                ddlASC.Enabled                = true;
                GvRateMasterForASC.DataSource = null;
                GvRateMasterForASC.DataBind();
                imgBtnSubmit.Enabled = false;
            }
            //if (GvRateMasterForASC.Rows.Count > 0)
            //{
            //    if (ViewState["DTRateDetailsDivisionWise"] != null)
            //    {
            //        DTRateDetailsDivisionWise = (DataTable)ViewState["DTRateDetailsDivisionWise"];

            //        objRateMasterForASC.DataTableAllRateDetailsDivisionWise = DTRateDetailsDivisionWise;
            //        objRateMasterForASC.EmpCode = Membership.GetUser().UserName.ToString();
            //        objRateMasterForASC.SaveData();
            //        if (objRateMasterForASC.ReturnValue == 1)
            //        {
            //            lblMessage.Visible = true;
            //            lblMessage.Text = objRateMasterForASC.MessageOut;
            //            ScriptManager.RegisterClientScriptBlock(imgBtnSubmit, GetType(), "", "window.close();window.opener.SearchPostBack();", true);
            //            if (GvRateMasterForASC.Rows.Count > 0)
            //            {
            //                for (int i = 0; i < GvRateMasterForASC.Rows.Count; i++)
            //                {
            //                    //GvRateMasterForASC.Rows[i].Cells[8].Enabled = false;
            //                    GvRateMasterForASC.Rows[i].Cells[13].Enabled = false;
            //                }
            //            }
            //        }
            //        else
            //        {
            //            lblMessage.Visible = true;
            //            lblMessage.Text = objRateMasterForASC.MessageOut;
            //        }

            //    }
            //}
            //else
            //{
            //    imgBtnSubmit.Enabled = false;
            //    lblMessage.Visible = true;
            //    lblMessage.Text = SIMSCommonClass.getErrorWarrning(SIMSenuErrorWarrning.AddRecord, SIMSenuMessageType.UserMessage, true, "No row exists to submit!");
            //}
        }
        catch (Exception ex)
        {
            SIMSCommonClass.WriteErrorErrFile(Request.RawUrl.ToString(), ex.StackTrace.ToString() + "-->" + ex.Message.ToString());
        }
    }