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