public void loadLegders(int id) { try { adminTableAdapters.LegdersTableAdapter ledger = new adminTableAdapters.LegdersTableAdapter(); admin.LegdersDataTable tblLedger = ledger.GetLedger(id); if (tblLedger.Rows.Count > 0) { txtDescription.Value = tblLedger[0].datDescription.ToString(); txtcode.Value = tblLedger[0].datLedgerCode.ToString(); if (tblLedger[0].IsdatCategoryNull() == false) { ddlCategory.SelectedValue = tblLedger[0].datCategory.ToString(); } if (tblLedger[0].IsdatProductNull() == false) { ddlProduct.SelectedValue = tblLedger[0].datProduct.ToString(); } if (tblLedger[0].IsdatProductNull() == false) { ddlCategory.SelectedValue = tblLedger[0].datProduct.ToString(); } if (tblLedger[0].IsdatInterestNull() == false && tblLedger[0].datInterest > 0) { chkInterestApplied.Checked = true; } if (tblLedger[0].IsdatFeeNull() == false && tblLedger[0].datFee > 0) { chkFees.Checked = true; } if (tblLedger[0].IsdatVisibleNull() == false && tblLedger[0].datVisible > 0) { chkVisible.Checked = true; } if (tblLedger[0].IsdatClientStatementNull() == false && tblLedger[0].datClientStatement > 0) { chkClientStatement.Checked = true; } } } catch (Exception ex) { } }
protected void btnSave_Click(object sender, EventArgs e) { int clientstatement = 0; int fee = 0; int interest = 0; int visible = 0; if (chkInterestApplied.Checked == true) { interest = 1; } if (chkClientStatement.Checked == true) { clientstatement = 1; } if (chkVisible.Checked == true) { visible = 1; } if (chkFees.Checked == true) { fee = 1; } try { adminTableAdapters.LegdersTableAdapter ledger = new adminTableAdapters.LegdersTableAdapter(); if (!(type == "update")) { ledger.InsertLedgers(txtDescription.Value, txtcode.Value, Convert.ToInt32(ddlCategory.SelectedValue), interest, Convert.ToInt32(ddlProduct.SelectedValue), fee, visible, clientstatement); } else if (type == "update") { ledger.UpdateLedger(txtDescription.Value, txtcode.Value, Convert.ToInt32(ddlCategory.SelectedValue), interest, Convert.ToInt32(ddlProduct.SelectedValue), fee, visible, clientstatement, id); } } catch (Exception ex) { } Page.Response.Redirect(util.RemoveQueryStringByKey(HttpContext.Current.Request.Url.AbsoluteUri, "ledit")); }
protected void btnSave_Click(object sender, EventArgs e) { int clientstatement=0; int fee=0; int interest=0; int visible=0; if (chkInterestApplied.Checked == true) {interest=1;} if (chkClientStatement.Checked == true) {clientstatement=1;} if (chkVisible.Checked == true) { visible = 1; } if (chkFees.Checked == true) { fee = 1; } try { adminTableAdapters.LegdersTableAdapter ledger = new adminTableAdapters.LegdersTableAdapter(); if (!(type == "update")) { ledger.InsertLedgers(txtDescription.Value, txtcode.Value, Convert.ToInt32(ddlCategory.SelectedValue), interest, Convert.ToInt32(ddlProduct.SelectedValue), fee, visible, clientstatement); } else if (type == "update") { ledger.UpdateLedger(txtDescription.Value, txtcode.Value, Convert.ToInt32(ddlCategory.SelectedValue), interest, Convert.ToInt32(ddlProduct.SelectedValue), fee, visible, clientstatement, id); } } catch (Exception ex) { } Page.Response.Redirect(util.RemoveQueryStringByKey(HttpContext.Current.Request.Url.AbsoluteUri, "ledit")); }