/// <summary> /// /// </summary> public void BindCashBookGrid() { ObjCashBook = new clsCashBookEntry(); DataTable dtCashBook = new DataTable(); try { if (!string.IsNullOrEmpty(txtSearchEXP.Text) && !string.IsNullOrEmpty(ddlEXPSearch.SelectedValue)) { string strsearch = ddlEXPSearch.SelectedValue.ToString(); switch (strsearch) { case "VoucherNumber": ObjCashBook.VoucherNumber = Convert.ToInt32(txtSearchEXP.Text); dtCashBook = ObjCashBook.GetCashBookDetailsByVoucherNumber(); break; } } else { dtCashBook = ObjCashBook.SearchAllCashBook(); } if (dtCashBook.Rows.Count > 0) { gvCashBook.DataSource = dtCashBook; } else { gvCashBook.DataSource = null; } gvCashBook.PageSize = Convert.ToInt32(ddlEXPPager.SelectedValue.ToString()); gvCashBook.DataBind(); } catch { } finally { ObjCashBook = null; dtCashBook = null; } }
/// <summary> /// /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void gvCashBook_RowEditing(object sender, GridViewEditEventArgs e) { ObjCashBook = new clsCashBookEntry(); DataTable dtCashBook = new DataTable(); int iVoucherNumber; try { iVoucherNumber = Convert.ToInt32(((Label)gvCashBook.Rows[e.NewEditIndex].FindControl("lblExpenditureId")).Text); if (iVoucherNumber > 0) { ObjCashBook.VoucherNumber = iVoucherNumber; dtCashBook = ObjCashBook.GetCashBookDetailsByVoucherNumber(); if (dtCashBook.Rows.Count > 0) { //Fill Cash Bokk Information txtVoucherNo.Text = dtCashBook.Rows[0]["ExpenditureId"].ToString(); txtDate.Text = dtCashBook.Rows[0]["ExpenditureDate"].ToString(); ddlExpanditureType.SelectedIndex = ddlExpanditureType.Items.IndexOf(ddlExpanditureType.Items.FindByValue(dtCashBook.Rows[0]["ExpenditureTypeId"].ToString())); txtAmount.Text = CommonFunctions.FormatMoneyString(Convert.ToDecimal(dtCashBook.Rows[0]["ExpenditureAmount"].ToString())); //string popupScript = string.Concat("<script language='javascript' type='text/javascript'>", "alert('Hello World');</script>"); if (Convert.ToBoolean(dtCashBook.Rows[0]["IsPaidByCash"].ToString())) { chkCash.Checked = Convert.ToBoolean(dtCashBook.Rows[0]["IsPaidByCash"].ToString()); ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "PopupScript", "<script>HideShowBankDetails('0');</script>", false); } else if (Convert.ToBoolean(dtCashBook.Rows[0]["IsPaidByCheque"].ToString())) { chkCheque.Checked = Convert.ToBoolean(dtCashBook.Rows[0]["IsPaidByCheque"].ToString()); ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "PopupScript", "<script>HideShowBankDetails('1');</script>", false); } txtBank.Text = dtCashBook.Rows[0]["BankName"].ToString(); txtChequeno.Text = dtCashBook.Rows[0]["ChequeNumber"].ToString(); txtDescription.Text = dtCashBook.Rows[0]["ExpanditureDescription"].ToString(); txtAuthorizedby.Text = dtCashBook.Rows[0]["ApprovedBy"].ToString(); EnableDisableCashBookEnriesControls(false); } ShowHideCashBookGrid(false); } } catch { } finally { ObjCashBook = null; dtCashBook = null; } }
/// <summary> /// /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void gvCashBook_RowDeleting(object sender, GridViewDeleteEventArgs e) { ObjCashBook = new clsCashBookEntry(); DataTable dtCashBook = new DataTable(); int iVoucherNumber; try { iVoucherNumber = Convert.ToInt32(((Label)gvCashBook.Rows[e.RowIndex].FindControl("lblVoucherNumber")).Text); if (iVoucherNumber > 0) { ObjCashBook.VoucherNumber = iVoucherNumber; dtCashBook = ObjCashBook.GetCashBookDetailsByVoucherNumber(); if (dtCashBook.Rows.Count > 0) { ObjCashBook.ExpenditureId = !string.IsNullOrEmpty(dtCashBook.Rows[0]["ExpenditureId"].ToString()) ? Convert.ToInt32(dtCashBook.Rows[0]["ExpenditureId"].ToString()) : 0; ObjCashBook.ExpenditureDate = !string.IsNullOrEmpty(dtCashBook.Rows[0]["ExpenditureDate"].ToString()) ? dtCashBook.Rows[0]["ExpenditureDate"].ToString() : string.Empty; ObjCashBook.ExpenditureAmount = !string.IsNullOrEmpty(dtCashBook.Rows[0]["ExpenditureAmount"].ToString()) ? Convert.ToDecimal(dtCashBook.Rows[0]["ExpenditureAmount"].ToString()) : 0; ObjCashBook.ExpanditureDescription = !string.IsNullOrEmpty(dtCashBook.Rows[0]["ExpanditureDescription"].ToString()) ? dtCashBook.Rows[0]["ExpanditureDescription"].ToString() : string.Empty; ObjCashBook.ExpenditureTypeId = !string.IsNullOrEmpty(dtCashBook.Rows[0]["ExpenditureTypeId"].ToString()) ? Convert.ToInt32(dtCashBook.Rows[0]["ExpenditureTypeId"].ToString()) : 0; ObjCashBook.IsPaidByCash = (dtCashBook.Rows[0]["IsPaidByCash"].ToString().Equals("True")) ? true : false; ObjCashBook.IsPaidByCheque = (dtCashBook.Rows[0]["IsPaidByCheque"].ToString().Equals("True")) ? true : false; ObjCashBook.ChequeNumber = !string.IsNullOrEmpty(dtCashBook.Rows[0]["ChequeNumber"].ToString()) ? Convert.ToInt32(dtCashBook.Rows[0]["ChequeNumber"].ToString()) : 0; ObjCashBook.BankName = !string.IsNullOrEmpty(dtCashBook.Rows[0]["BankName"].ToString()) ? dtCashBook.Rows[0]["BankName"].ToString() : string.Empty; ObjCashBook.ApprovedBy = !string.IsNullOrEmpty(dtCashBook.Rows[0]["ApprovedBy"].ToString()) ? dtCashBook.Rows[0]["ApprovedBy"].ToString() : string.Empty; ObjCashBook.CreatedBy = Convert.ToInt32(AppSessions.GetSession(AppSessions.UDFSessionName._user_id.ToString())); ObjCashBook.CreatedDate = Convert.ToDateTime(txtDate.Text); ObjCashBook.UpdatedBy = Convert.ToInt32(AppSessions.GetSession(AppSessions.UDFSessionName._user_id.ToString())); ObjCashBook.UpdatedDate = Convert.ToDateTime(txtDate.Text); ObjCashBook.IsActive = false; } if (ObjCashBook.Update()) { lblCashbookMessage.CssClass = "SuccessfulMessage"; lblCashbookMessage.Text = (String)GetGlobalResourceObject("SharedResource", "RecordSavedSuccessfully"); } } else { lblCashbookMessage.CssClass = "FailureMessage"; lblCashbookMessage.Text = (String)GetGlobalResourceObject("SharedResource", "LoginSessionExpire"); } ClearCashbookEnriesControls(); BindCashBookGrid(); ShowHideCashBookGrid(true); } catch { lblCashbookMessage.CssClass = "FailureMessage"; lblCashbookMessage.Text = (String)GetGlobalResourceObject("SharedResource", "RecordSavingFailure"); } finally { ObjCashBook = null; } }
/// <summary> /// Added By: pradip pawar /// Date :02-04-2013 /// Description:Update Expendure /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnUpdate_Click(object sender, EventArgs e) { ObjCashBook = new clsCashBookEntry(); try { if (!string.IsNullOrEmpty(AppSessions.GetSession(AppSessions.UDFSessionName._user_id.ToString()))) { ObjCashBook.ExpenditureId = !string.IsNullOrEmpty(txtVoucherNo.Text) ? Convert.ToInt32(txtVoucherNo.Text.ToString()) : 0; ObjCashBook.ExpenditureDate = !string.IsNullOrEmpty(txtDate.Text) ? txtDate.Text.ToString() : string.Empty; ObjCashBook.ExpenditureAmount = !string.IsNullOrEmpty(txtAmount.Text) ? Convert.ToDecimal(txtAmount.Text.ToString()) : 0; ObjCashBook.ExpanditureDescription = !string.IsNullOrEmpty(txtDescription.Text) ? txtDescription.Text.ToString() : string.Empty; ObjCashBook.ExpenditureTypeId = !string.IsNullOrEmpty(ddlExpanditureType.SelectedValue) ? Convert.ToInt32(ddlExpanditureType.SelectedValue.ToString()) : 0; ObjCashBook.IsPaidByCash = (chkCash.Checked) ? true : false; ObjCashBook.IsPaidByCheque = (chkCheque.Checked) ? true : false; ObjCashBook.ChequeNumber = !string.IsNullOrEmpty(txtChequeno.Text) ? Convert.ToInt32(txtChequeno.Text.ToString()) : 0; ObjCashBook.BankName = !string.IsNullOrEmpty(txtBank.Text) ? txtBank.Text.ToString() : string.Empty; ObjCashBook.ApprovedBy = !string.IsNullOrEmpty(txtAuthorizedby.Text) ? txtAuthorizedby.Text.ToString() : string.Empty; ObjCashBook.CreatedBy = Convert.ToInt32(AppSessions.GetSession(AppSessions.UDFSessionName._user_id.ToString())); ObjCashBook.CreatedDate = Convert.ToDateTime(txtDate.Text); ObjCashBook.UpdatedBy = Convert.ToInt32(AppSessions.GetSession(AppSessions.UDFSessionName._user_id.ToString())); ObjCashBook.UpdatedDate = Convert.ToDateTime(txtDate.Text); ObjCashBook.IsActive = true; if (ObjCashBook.Update()) { lblCashbookMessage.CssClass = "SuccessfulMessage"; lblCashbookMessage.Text = (String)GetGlobalResourceObject("SharedResource", "RecordSavedSuccessfully"); } } else { lblCashbookMessage.CssClass = "FailureMessage"; lblCashbookMessage.Text = (String)GetGlobalResourceObject("SharedResource", "LoginSessionExpire"); } ClearCashbookEnriesControls(); BindCashBookGrid(); EnableDisableCashBookEnriesControls(true); ShowHideCashBookGrid(true); } catch { lblCashbookMessage.CssClass = "FailureMessage"; lblCashbookMessage.Text = (String)GetGlobalResourceObject("SharedResource", "RecordSavingFailure"); } finally { ObjCashBook = null; } }