protected void BtnSubmit_Click(object sender, EventArgs e)
{
A2ZTRNLIMITDTO objDTO = new A2ZTRNLIMITDTO();
objDTO.IdsNo = Converter.GetInteger(txtIdsNo.Text);
objDTO.LIdsCashCredit = Converter.GetDouble(txtLIdsCashCredit.Text);
objDTO.LIdsCashDebit = Converter.GetDouble(txtLIdsCashDebit.Text);
objDTO.LIdsTrfCredit = Converter.GetDouble(txtLIdsTrfCredit.Text);
objDTO.LIdsTrfDebit = Converter.GetDouble(txtLIdsTrfDebit.Text);
int roweffect = A2ZTRNLIMITDTO.InsertInformation(objDTO);
if (roweffect > 0)
{
txtIdsNo.Text = string.Empty;
clearinfo();
ddlIdsNo.SelectedValue = "-Select-";
txtIdsNo.Focus();
}
}
protected void BtnAll_Click(object sender, EventArgs e)
{
string delqry = "DELETE FROM A2ZTRNLIMIT";
int row1Effect = Converter.GetInteger(DataAccessLayer.BLL.CommonManager.Instance.ExecuteNonQuery(delqry, "A2ZACGMS"));
//if (row1Effect > 0)
//{
string qry = "SELECT IdsNo,IdsLevel FROM A2ZSYSIDS";
DataTable dt = DataAccessLayer.BLL.CommonManager.Instance.GetDataTableByQuery(qry, "A2ZHKGMS");
int totrec = dt.Rows.Count;
if (dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
var ids = dr["IdsNo"].ToString();
var level = dr["IdsLevel"].ToString();
txtIdsNo.Text = ids;
txtLIdsCashCredit.Text = "99999999999.99";
txtLIdsCashDebit.Text = "99999999999.99";
txtLIdsTrfCredit.Text = "99999999999.99";
txtLIdsTrfDebit.Text = "99999999999.99";
A2ZTRNLIMITDTO objDTO = new A2ZTRNLIMITDTO();
objDTO.IdsNo = Converter.GetInteger(txtIdsNo.Text);
objDTO.LIdsCashCredit = Converter.GetDouble(txtLIdsCashCredit.Text);
objDTO.LIdsCashDebit = Converter.GetDouble(txtLIdsCashDebit.Text);
objDTO.LIdsTrfCredit = Converter.GetDouble(txtLIdsTrfCredit.Text);
objDTO.LIdsTrfDebit = Converter.GetDouble(txtLIdsTrfDebit.Text);
int roweffect = A2ZTRNLIMITDTO.InsertInformation(objDTO);
if (roweffect > 0)
{
}
}
DoneMsg();
}
}
