Ejemplo n.º 1
0
 protected void Submit_Click(object sender, EventArgs e)
 {
     try
     {
         if (TxtBRCD.Text.ToString() == "")
         {
             TxtBRCD.Focus();
             WebMsgBox.Show("Enter branch code first ...!!", this.Page);
             return;
         }
         else if (TxtAccType.Text.ToString() == "")
         {
             TxtAccType.Focus();
             WebMsgBox.Show("Enter agent code first ...!!", this.Page);
             return;
         }
         else if (txtMonth.Text.ToString() == "")
         {
             txtMonth.Focus();
             WebMsgBox.Show("Enter selected month first ...!!", this.Page);
             return;
         }
         else if (txtYear.Text.ToString() == "")
         {
             txtYear.Focus();
             WebMsgBox.Show("Enter selected year first ...!!", this.Page);
             return;
         }
         else
         {
             DT = CS.GetAllData(TxtBRCD.Text.ToString(), TxtAccType.Text.ToString(), txtMonth.Text.ToString(), txtYear.Text.ToString());
             if (DT.Rows.Count > 0)
             {
                 divGridDetails.Visible = true;
                 GrdDaily.DataSource    = DT;
                 GrdDaily.DataBind();
             }
             else
             {
                 divGridDetails.Visible = false;
                 GrdDaily.DataSource    = null;
                 GrdDaily.DataBind();
             }
         }
     }
     catch (Exception Ex)
     {
         ExceptionLogging.SendErrorToText(Ex);
     }
 }
Ejemplo n.º 2
0
    protected void btnClearAll_Click(object sender, EventArgs e)
    {
        try
        {
            divGridDetails.Visible = false;

            GrdDaily.DataSource = null;
            GrdDaily.DataBind();
        }
        catch (Exception Ex)
        {
            ExceptionLogging.SendErrorToText(Ex);
        }
    }
Ejemplo n.º 3
0
    public void CLearAll()
    {
        try
        {
            TxtAccType.Text = "";
            TxtATName.Text  = "";
            txtMonth.Text   = "";
            txtYear.Text    = "";

            divGridDetails.Visible = false;
            GrdDaily.DataSource    = null;
            GrdDaily.DataBind();
        }
        catch (Exception Ex)
        {
            ExceptionLogging.SendErrorToText(Ex);
        }
    }
Ejemplo n.º 4
0
    protected void BtnCreate_Click(object sender, EventArgs e)
    {
        try
        {
            //  Before insert delete all existing data for that agent only
            CS.DeletePassBook(TxtBRCD.Text.ToString(), TxtAccType.Text.ToString(), txtMonth.Text.ToString(), txtYear.Text.ToString());

            //  Insert new data
            foreach (GridViewRow gvRow in this.GrdDaily.Rows)
            {
                string Check      = Convert.ToString(((DropDownList)gvRow.FindControl("ddlChecking")).SelectedValue).ToString();
                string SrNo       = Convert.ToString(((TextBox)gvRow.FindControl("TxtSrno")).Text).ToString();
                string Accno      = Convert.ToString(((TextBox)gvRow.FindControl("txtAccNo")).Text == "" ? "0" : ((TextBox)gvRow.FindControl("txtAccNo")).Text).ToString();
                string Custname   = Convert.ToString(((TextBox)gvRow.FindControl("txtName")).Text == "" ? "0" : ((TextBox)gvRow.FindControl("txtName")).Text);
                double Opening    = Convert.ToDouble(((TextBox)gvRow.FindControl("TxtOpening")).Text == "" ? "0" : ((TextBox)gvRow.FindControl("TxtOpening")).Text);
                double Collection = Convert.ToDouble(((TextBox)gvRow.FindControl("TxtCollection")).Text == "" ? "0" : ((TextBox)gvRow.FindControl("TxtCollection")).Text);
                double Psk        = Convert.ToDouble(((TextBox)gvRow.FindControl("Txtpassbook")).Text == "" ? "0" : ((TextBox)gvRow.FindControl("Txtpassbook")).Text);
                double Diif       = Convert.ToDouble(((TextBox)gvRow.FindControl("txtDiff")).Text == "" ? "0" : ((TextBox)gvRow.FindControl("txtDiff")).Text);

                Result = CS.InsertPassBook(TxtBRCD.Text, TxtAccType.Text, txtYear.Text, txtMonth.Text, SrNo.ToString(), Accno.ToString(), Custname.ToString(),
                                           Opening.ToString(), Collection.ToString(), Psk.ToString(), (Collection - Psk).ToString(), Session["MID"].ToString(), Check.ToString());
            }

            if (Result > 0)
            {
                CLearAll();
                WebMsgBox.Show("Data Saved Successfully ...!!", this.Page);
                divGridDetails.Visible = false;
                GrdDaily.DataSource    = null;
                GrdDaily.DataBind();
                return;
            }
        }
        catch (Exception Ex)
        {
            ExceptionLogging.SendErrorToText(Ex);
        }
    }