Пример #1
0
    //public void BindEdit()
    //{
    //    //int VoucherNO = Convert.ToInt32(txtVoucher.Text);

    //    DataSet ds4 = new DataSet();
    //    ds4 = PettyBillMaster.Idv_Chetana_Petty_VoucherDetails_Edit(VoucherNO);
    //    if (ds.Tables[0].Rows.Count != 0)
    //    {


    //        PettyCash editpet = new PettyCash();
    //        lblID.Text = ds4.Tables[0].Rows[0]["VoucherNo"].ToString();
    //        txtEMcode.Text = ds4.Tables[0].Rows[0]["PartyCode"].ToString();
    //        lblshow.Text = ds4.Tables[0].Rows[0]["PartyName"].ToString();
    //        txtRemark.Text = ds4.Tables[0].Rows[0]["MainRemark"].ToString();
    //        //txtVoucherBill.Text = ds.Tables[0].Rows[0]["VoucherDate"].ToString();
    //        //txtRemark.Text = ds.Tables[0].Rows[0]["Remark"].ToString();
    //        //Idtotalamount.Text = ds.Tables[0].Rows[0]["TotalAmount"].ToString();
    //        // lblfromdate.Text = ds.Tables[0].Rows[0]["FinancialYearFrom"].ToString();
    //        //lbltodate.Text = ds.Tables[0].Rows[0]["FinancialYearTo"].ToString();
    //        editpet.Updated_By = Session["UserName"].ToString();
    //        editpet.Updated_On = Convert.ToDateTime(DateTime.Now.ToString());
    //        pnlCust.Visible = true;

    //        btn_Save.Visible = true;
    //        lblshow.Visible = true;

    //        DataTable dt12 = new DataTable();
    //        dt12 = PettyCashExpence.Idv_Chetana_Get_Petty_Expence_View_by_VoucherNo(VoucherNo).Tables[0];
    //        if (dt12.Rows.Count != 0)
    //        {
    //            gvExpense.DataSource = dt12;
    //            gvExpense.DataBind();
    //            gvExpense.Visible = true;

    //        }
    //        else
    //        {
    //            gvExpense.Visible = false;
    //            message("No Records Found");
    //        }
    //    }
    //}

    protected void gvExpDelete_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {
        try
        {
            PettyCashExpence pvdetail = new PettyCashExpence();
            pvdetail.Voucher_Detail = Convert.ToInt32(((Label)gvExpDelete.Rows[e.RowIndex].FindControl("lblvoucher_detail")).Text);
            pvdetail.VoucherNo      = Convert.ToInt32(((Label)gvExpDelete.Rows[e.RowIndex].FindControl("lblVoucherNo")).Text);
            pvdetail.ExpenceName    = ((Label)gvExpDelete.Rows[e.RowIndex].FindControl("lblExpName")).Text;
            pvdetail.Amount         = Convert.ToDecimal(((Label)gvExpDelete.Rows[e.RowIndex].FindControl("lblAmount")).Text);
            pvdetail.Date           = Convert.ToDateTime(((Label)gvExpDelete.Rows[e.RowIndex].FindControl("lblDate")).Text);
            pvdetail.Remark         = ((Label)gvExpDelete.Rows[e.RowIndex].FindControl("lblRemark")).Text;
            pvdetail.UpdatedBy      = Session["UserName"].ToString();
            pvdetail.IsActive       = Convert.ToBoolean(false);
            pvdetail.UpdatedOn      = Convert.ToDateTime(DateTime.Now.ToString());
            pvdetail.Save();
            bindforedit();

            //   gvExpDelete.BottomPagerRow.Cells.Remove();
            gvExpDelete.Visible = true;
            pnlCust.Visible     = true;
        }
        catch (Exception ex)
        {
        }
    }
Пример #2
0
    public void SaveDetails(int IDNo)
    {
        try
        {
            if (Session["UserName"] != null)
            {
                PettyCashExpence pte = new PettyCashExpence();

                pte.VoucherNo = IDNo;
                pte.CreatedBy = Session["UserName"].ToString();
                foreach (GridViewRow gv in gvExpense.Rows)
                {
                    pte.IsActive       = Convert.ToBoolean(true);
                    pte.Voucher_Detail = Convert.ToInt32(lblID1.Text);
                    pte.ExpenseCode    = ((Label)gv.FindControl("lblExpenseHead")).Text;
                    pte.ExpenceName    = ((Label)gv.FindControl("lblExpenseValuesave")).Text;
                    pte.Date           = Convert.ToDateTime(((Label)gv.FindControl("lbldatesave")).Text);
                    pte.Remark         = ((Label)gv.FindControl("lblRemarksave")).Text;
                    pte.Amount         = Convert.ToDecimal(((Label)gv.FindControl("lblAmountsave")).Text);

                    pte.Save();
                }
            }
        }
        catch
        { }
    }
Пример #3
0
    public void bindforedit()
    {
        int       VoucherNo = Convert.ToInt32(lblID.Text);
        DataTable dt12      = new DataTable();

        dt12 = PettyCashExpence.Idv_Chetana_Get_Petty_Expence_View_by_VoucherNo(VoucherNo).Tables[0];
        if (dt12.Rows.Count != 0)
        {
            gvExpDelete.DataSource = dt12;
            gvExpDelete.DataBind();
            gvExpDelete.Visible = true;
        }
        else
        {
            amount2 = Convert.ToDecimal(0);
            gvExpDelete.DataSource = dt12;
            gvExpDelete.DataBind();
            gvExpDelete.Visible = true;
            message("No Records Found");
        }
    }
Пример #4
0
    protected void viewexp_Click(object sender, EventArgs e)
    {
        LinkButton  viewexp   = (LinkButton)sender;
        GridViewRow row       = (GridViewRow)viewexp.NamingContainer;
        int         VoucherNo = Convert.ToInt32(viewexp.CommandArgument.ToString());

        DataTable dt12 = new DataTable();

        dt12 = PettyCashExpence.Idv_Chetana_Get_Petty_Expence_View_by_VoucherNo(VoucherNo).Tables[0];
        if (dt12.Rows.Count != 0)
        {
            gvVoucher.DataSource = dt12;
            gvVoucher.DataBind();
            gvVoucher.Visible = true;
        }
        else
        {
            gvVoucher.Visible = false;
            message("No Records Found");
        }
    }