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(); } }