private void PreviousChqBook()
{
try
{
string sqlquery = "SELECT * FROM A2ZCHQBOOK WHERE AccType = '" + txtAccType.Text + "' AND AccNo = '" + txtAccNo.Text + "' AND MemNo='" + txtMemNo.Text + "' AND ChqBStat='" + "1" + "'";
int result1 = Converter.GetSmallInteger(DataAccessLayer.BLL.CommonManager.Instance.GetScalarValueByQuery(sqlquery, "A2ZCSMCUS"));
if (result1 > 0)
{
ValidityChkPrfx1();
A2ZCHQBOOKDTO objDTO = new A2ZCHQBOOKDTO();
var value = "ChqPStat".ToString();
string pa = value.Replace("1", "3");
objDTO.ChqBStatus = 3;
objDTO.ChqPStatus = Converter.GetString(pa);
int roweffect = A2ZCHQBOOKDTO.UpdateInformation(objDTO);
}
else
{
}
}
catch (Exception ex)
{
throw ex;
}
}
protected void BtnSubmit_Click(object sender, EventArgs e)
{
PreviousChqBook();
A2ZCHQBOOKDTO objDTO = new A2ZCHQBOOKDTO();
objDTO.MemberNo = Converter.GetInteger(txtMemNo.Text);
objDTO.AccType = Converter.GetSmallInteger(txtAccType.Text);
objDTO.AccNo = Converter.GetLong(txtAccNo.Text);
objDTO.ChqPrefix = Converter.GetString(txtChqprefix.Text);
objDTO.ChqSerialNo = Converter.GetInteger(txtEndNo.Text);
objDTO.ChqPage = Converter.GetSmallInteger(txtNumPage.Text);
objDTO.ChqBStatus = 1;
int num = 1;
int a = Converter.GetInteger(txtNumPage.Text);
int[] p = new int[a];
string pa = "";
for (int i = 0; i <= (a - 1); i = i + 1)
{
p[(a - 1) - i] = num % 2;
num = num % 2;
}
for (int i = 0; i <= (a - 1); i = i + 1)
{
pa += p[i].ToString();
}
string cx = " ";
string dat = Converter.GetString(txtIssueDate.Text);
string[] datetime = new string[a];
foreach (string x in datetime)
{
cx += dat.ToString();
}
A2ZCSPARAMETERDTO dto = A2ZCSPARAMETERDTO.GetParameterValue();
objDTO.ChqPStatus = Converter.GetString(pa);
objDTO.ChqBStatusDate = Convert.ToDateTime(dto.ProcessDate);
objDTO.ChqPDate = Converter.GetString(cx);
objDTO.ChqBIssueDate = Converter.GetDateTime(dto.ProcessDate);
int roweffect = A2ZCHQBOOKDTO.InsertInformation(objDTO);
if (roweffect > 0)
{
clearinfo();
}
}
protected void BtnUpdate_Click(object sender, EventArgs e)
{
try
{
if (ddlCheBook.SelectedIndex == 1)
{
A2ZCHQBOOKDTO objDTO = new A2ZCHQBOOKDTO();
int page = Converter.GetSmallInteger(txtNumPage.Text);
int leafNo = Converter.GetSmallInteger(txtCheqLeafNo.Text);
int opt = Converter.GetSmallInteger(ddlChqOption.SelectedValue);
string optvalue = Converter.GetString(opt);
DataTable dt = new DataTable();
string qry = "SELECT * from A2ZCHQBOOK where MemNo='" + txtMemNo.Text + "' and AccType='" + txtAccType.Text + "' and AccNo='" + txtAccNo.Text + "'";
dt = DataAccessLayer.BLL.CommonManager.Instance.GetDataTableByQuery(qry, "A2ZCSMCUS");
if (dt.Rows.Count > 0)
{
string value = Converter.GetString(dt.Rows[0]["ChqPStat"]).TrimEnd();
string datevalue = Converter.GetString(dt.Rows[0]["ChqPDt"]).TrimStart();
DateTime issuedt = Converter.GetDateTime(dt.Rows[0]["ChqBIssDt"]);
string IssueResultdt = issuedt.ToString("dd/MM/yyyy");
for (int i = 0; i <= page; i++)
{
string dtsub = datevalue.Substring(i, 10);
if (i == leafNo)
{
string sub4 = datevalue.Replace(dtsub, IssueResultdt);
lblvalue.Text = Converter.GetString(sub4);
}
}
value = DataAccessLayer.Utility.AtoZUtility.ConvertTextArray(leafNo, value, optvalue, page, 1, page, 0);
//datevalue = DataAccessLayer.Utility.AtoZUtility.ConvertTextArray(leafNo, datevalue, IssueResultdt, page, 1, page, 0);
lblvalue2.Text = Converter.GetString(value);
}
objDTO.MemberNo = Converter.GetInteger(txtMemNo.Text);
objDTO.AccNo = Converter.GetLong(txtAccNo.Text);
objDTO.AccType = Converter.GetSmallInteger(txtAccType.Text);
objDTO.ChqPStatus = Converter.GetString(lblvalue2.Text);
objDTO.ChqPDate = Converter.GetString(lblvalue.Text);
int roweffect = A2ZCHQBOOKDTO.UpdateInformation(objDTO);
if (roweffect > 0)
{
clearinfo();
}
}
else
{
A2ZCHQBOOKDTO objDTO = new A2ZCHQBOOKDTO();
int page = Converter.GetSmallInteger(txtNumPage.Text);
int opt = Converter.GetSmallInteger(ddlChqOption.SelectedValue);
string optvalue = Converter.GetString(opt);
DataTable dt = new DataTable();
string qry = "SELECT * from A2ZCHQBOOK where MemNo='" + txtMemNo.Text + "' and AccType='" + txtAccType.Text + "' and AccNo='" + txtAccNo.Text + "'";
dt = DataAccessLayer.BLL.CommonManager.Instance.GetDataTableByQuery(qry, "A2ZCSMCUS");
if (dt.Rows.Count > 0)
{
string value = Converter.GetString(dt.Rows[0]["ChqPStat"]);
string datevalue = Converter.GetString(dt.Rows[0]["ChqPDt"]).TrimStart();
DateTime issuedt = Converter.GetDateTime(dt.Rows[0]["ChqBIssDt"]);
string IssueResultdt = issuedt.ToString("dd/MM/yyyy");
for (int i = 0; i <= page; i++)
{
string sub2 = value.Substring(i, 1);
string dtsub = datevalue.Substring(i, 10);
if (dtsub != "0")
{
string sub4 = datevalue.Replace(dtsub, IssueResultdt);
lblvalue.Text = Converter.GetString(sub4);
}
if (sub2 == "1")
{
string sub3 = value.Replace(sub2, optvalue);
lblvalue2.Text = Converter.GetString(sub3);
}
}
}
objDTO.MemberNo = Converter.GetInteger(txtMemNo.Text);
objDTO.AccNo = Converter.GetLong(txtAccNo.Text);
objDTO.AccType = Converter.GetSmallInteger(txtAccType.Text);
objDTO.ChqPStatus = Converter.GetString(lblvalue2.Text);
objDTO.ChqPDate = Converter.GetString(lblvalue.Text);
int roweffect = A2ZCHQBOOKDTO.UpdateInformation(objDTO);
if (roweffect > 0)
{
clearinfo();
}
}
}
catch (Exception ex)
{
throw ex;
}
}
