//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; } }