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