//protected void dropdown()
//{
// string sqlquery = "SELECT ProductCode,ProductCode from A2ZACCCTRL group by ProductCode";
// ddlAccount = DataAccessLayer.BLL.CommonManager.Instance.FillDropDownList(sqlquery, ddlAccount, "A2ZCSMCUS");
//}
protected void BtnAccountOpenSubmit_Click(object sender, EventArgs e)
{
try
{
A2ZACCCTRLDTO objDTO = new A2ZACCCTRLDTO();
objDTO.ProductCode = Converter.GetSmallInteger(txtAccType.Text);
objDTO.ControlCode = Converter.GetSmallInteger(ddlFlagCheck.SelectedValue);
int roweffect = 0;
CheckBox chk = new CheckBox();
for (int i = 0; i < gvDescription.Rows.Count; i++)
{
chk = (CheckBox)gvDescription.Rows[i].Cells[0].FindControl("chkDescription");
int flag = 1;
if (chk.Checked)
{
Label2.Text = Convert.ToString(flag);
Label1.Text = Converter.GetString(gvDescription.Rows[i].Cells[0].Text);
Label3.Text = Converter.GetString(gvDescription.Rows[i].Cells[1].Text);
objDTO.Description = Converter.GetString(Label3.Text);
objDTO.RecordCode = Converter.GetSmallInteger(Label1.Text);
objDTO.RecordFlag = Converter.GetSmallInteger(Label2.Text);
roweffect = A2ZACCCTRLDTO.InsertInformation(objDTO);
chk.Checked = false;
}
else
{
flag = 0;
Label2.Text = Convert.ToString(flag);
Label1.Text = Converter.GetString(gvDescription.Rows[i].Cells[0].Text);
Label3.Text = Converter.GetString(gvDescription.Rows[i].Cells[1].Text);
objDTO.Description = Converter.GetString(Label3.Text);
objDTO.RecordCode = Converter.GetSmallInteger(Label1.Text);
objDTO.RecordFlag = Converter.GetSmallInteger(Label2.Text);
roweffect = A2ZACCCTRLDTO.InsertInformation(objDTO);
chk.Checked = false;
}
}
if (roweffect > 0)
{
txtAccType.Focus();
clearinfo();
}
}
catch (Exception ex)
{
throw ex;
}
}
protected void btnAccountUpdate_Click(object sender, EventArgs e)
{
try
{
string qry = "DELETE FROM A2ZACCCTRL WHERE ProductCode = '" + txtAccType.Text + "' AND ControlCode = 2";
int row = Converter.GetInteger(DataAccessLayer.BLL.CommonManager.Instance.ExecuteNonQuery(qry, "A2ZCSMCUS"));
A2ZACCCTRLDTO objDTO = new A2ZACCCTRLDTO();
//objDTO.ProductCode = Converter.GetSmallInteger(ddlAccount.SelectedValue);
objDTO.ProductCode = Converter.GetSmallInteger(txtAccType.Text);
objDTO.ControlCode = Converter.GetSmallInteger(ddlFlagCheck.SelectedValue);
int roweffect = 0;
for (int i = 0; i < gvDescription.Rows.Count; i++)
{
CheckBox chk = (CheckBox)gvDescription.Rows[i].Cells[0].FindControl("chkDescription");
int flag = 1;
if (chk.Checked)
{
Label2.Text = Convert.ToString(flag);
}
else
{
flag = 0;
Label2.Text = Convert.ToString(flag);
}
Label1.Text = Converter.GetString(gvDescription.Rows[i].Cells[0].Text);
objDTO.RecordCode = Converter.GetSmallInteger(Label1.Text);
Label3.Text = Converter.GetString(gvDescription.Rows[i].Cells[1].Text);
objDTO.Description = Converter.GetString(Label3.Text);
objDTO.RecordFlag = Converter.GetSmallInteger(Label2.Text);
roweffect = A2ZACCCTRLDTO.InsertInformation(objDTO);
chk.Checked = false;
}
if (roweffect > 0)
{
txtAccType.Focus();
//ddlAccount.SelectedValue = "-Select-";
clearinfo();
}
}
catch (Exception ex)
{
throw ex;
}
}
//protected void dropdown()
//{
// string sqlquery = "SELECT ProductCode,ProductCode from A2ZACCCTRL group by ProductCode";
// ddlAccount = DataAccessLayer.BLL.CommonManager.Instance.FillDropDownList(sqlquery, ddlAccount, "A2ZCSMCUS");
//}
protected void BtnAccountOpenSubmit_Click(object sender, EventArgs e)
{
try
{
A2ZACCCTRLDTO objDTO = new A2ZACCCTRLDTO();
objDTO.ProductCode = Converter.GetSmallInteger(txtAccType.Text);
objDTO.ControlCode = Converter.GetSmallInteger(ddlFlagCheck.SelectedValue);
int roweffect = 0;
CheckBox chk = new CheckBox();
CheckBox chk1 = new CheckBox();
for (int i = 0; i < gvDescription.Rows.Count; i++)
{
chk = (CheckBox)gvDescription.Rows[i].Cells[0].FindControl("chkDescription");
chk1 = (CheckBox)gvDescription.Rows[i].Cells[0].FindControl("chk1Description");
int flag = 1;
int flag1 = 1;
if (chk.Checked)
{
Label2.Text = Convert.ToString(flag);
Label5.Text = Convert.ToString(flag1);
Label1.Text = Converter.GetString(gvDescription.Rows[i].Cells[0].Text);
Label3.Text = Converter.GetString(gvDescription.Rows[i].Cells[1].Text);
objDTO.Description = Converter.GetString(Label3.Text);
objDTO.RecordCode = Converter.GetSmallInteger(Label1.Text);
objDTO.RecordFlag = Converter.GetSmallInteger(Label2.Text);
chk.Checked = false;
if (chk1.Checked)
{
objDTO.FuncFlag = Converter.GetSmallInteger(Label5.Text);
chk1.Checked = false;
}
roweffect = A2ZACCCTRLDTO.InsertInformation(objDTO);
}
else
{
flag = 0;
flag1 = 0;
Label2.Text = Convert.ToString(flag);
Label5.Text = Convert.ToString(flag1);
Label1.Text = Converter.GetString(gvDescription.Rows[i].Cells[0].Text);
Label3.Text = Converter.GetString(gvDescription.Rows[i].Cells[1].Text);
objDTO.Description = Converter.GetString(Label3.Text);
objDTO.RecordCode = Converter.GetSmallInteger(Label1.Text);
objDTO.RecordFlag = Converter.GetSmallInteger(Label2.Text);
objDTO.FuncFlag = Converter.GetSmallInteger(Label5.Text);
roweffect = A2ZACCCTRLDTO.InsertInformation(objDTO);
chk.Checked = false;
chk1.Checked = false;
}
}
if (roweffect > 0)
{
txtAccType.Focus();
clearinfo();
}
}
catch (Exception ex)
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "scriptkey", "<script>alert('System Error.BtnAccountOpenSubmit_Click Problem');</script>");
//throw ex;
}
}