protected void imgBtnSave_Click(object sender, ImageClickEventArgs e)
        {
            DtTemp = (DataTable)ViewState["dt"];
            if (DtTemp == null && DtTemp.Rows.Count > 0)
            {
                ShowMessage("Please enter details");
                return;
            }

            Int64         HeadId = 0;
            PaymentRecDAL obj    = new PaymentRecDAL();


            HeadId = obj.Insert(DtTemp, Convert.ToInt32(drpChallanDetail.SelectedValue), Convert.ToDouble(txtNetAmnt.Text));

            obj = null;
            if (HeadId > 0)
            {
                ShowMessage("Record save successfully");
            }
            else if (HeadId < 0)
            {
                ShowMessage("Summary No already exists");
            }
            else
            {
                ShowMessage("Record not saved successfully");
            }
            this.ClearAll();
        }
        public void ChallanDetail()
        {
            PaymentRecDAL obj = new PaymentRecDAL();
            DataTable     lst = obj.FetchChallanDetail(constring, Convert.ToInt32(ddlDateRange.SelectedValue));

            if (lst.Rows.Count > 0)
            {
                drpChallanDetail.DataSource     = lst;
                drpChallanDetail.DataTextField  = "chln_Detl";
                drpChallanDetail.DataValueField = "Chln_Idno";
                drpChallanDetail.DataBind();
                drpChallanDetail.Items.Insert(0, new ListItem("--Select--", "0"));
            }
        }
        protected void drpChallanDetail_SelectedIndexChanged(object sender, EventArgs e)
        {
            try
            {
                if (drpChallanDetail.SelectedIndex >= 0)
                {
                    PaymentRecDAL obj = new PaymentRecDAL();



                    DataTable DsChlnDetMst = obj.FillChlnDetMast(ApplicationFunction.ConnectionString(), Convert.ToInt32(drpChallanDetail.SelectedValue));
                    Gridmainhead.DataSource = null;
                    Gridmainhead.DataSource = DsChlnDetMst;
                    Gridmainhead.DataBind();
                    txtNetAmnt.Text = Convert.ToDouble(obj.FillChlnDetNetAmnt(ApplicationFunction.ConnectionString(), Convert.ToInt32(drpChallanDetail.SelectedValue))).ToString("N2");

                    DataTable DtPay = obj.SelectPayDet(ApplicationFunction.ConnectionString(), Convert.ToInt32(drpChallanDetail.SelectedValue));
                    grdMain.DataSource = null;
                    grdMain.DataSource = DtPay;
                    grdMain.DataBind();
                    ViewState["dt"] = (DataTable)DtPay;
                }
                else
                {
                    Gridmainhead.DataSource = null;

                    Gridmainhead.DataBind();


                    grdMain.DataSource = null;
                    grdMain.DataBind();
                    txtNetAmnt.Text = "0.00";
                }
            }
            catch (Exception Ex)
            {
            }
        }
 protected void imgBtnDelete_Click(object sender, ImageClickEventArgs e)
 {
     try
     {
         if (drpChallanDetail.SelectedIndex > 0)
         {
             PaymentRecDAL obj   = new PaymentRecDAL();
             int           value = 0;
             value = obj.Delete(Convert.ToInt32(drpChallanDetail.SelectedValue));
             if (value > 0)
             {
                 ShowMessage("Record  delete successfully");
             }
             else
             {
                 ShowMessage("Record not delete successfully");
             }
         }
     }
     catch (Exception ex)
     {
     }
 }