protected void txtMemNo_TextChanged(object sender, EventArgs e) { try { if (txtMemNo.Text != string.Empty) { Int16 CuType = Converter.GetSmallInteger(lblCuType.Text); int CNo = Converter.GetInteger(lblCuNo.Text); int MemNumber = Converter.GetInteger(txtMemNo.Text); A2ZMEMBERDTO getDTO = new A2ZMEMBERDTO(); getDTO = (A2ZMEMBERDTO.GetInformation(CuType, CNo, MemNumber)); if (getDTO.NoRecord > 0) { lblMemName.Text = getDTO.MemberName; } } } catch (Exception ex) { Page.ClientScript.RegisterStartupScript(this.GetType(), "scriptkey", "<script>alert('System Error.txtCrUnion_TextChanged Problem');</script>"); //throw ex; } }
protected void BtnProceed_Click(object sender, EventArgs e) { CPSMEMBER(); string qry3 = "SELECT Id,MemNo,MemType FROM A2ZMEMBER "; DataTable dt3 = DataAccessLayer.BLL.CommonManager.Instance.GetDataTableByQuery(qry3, "A2ZCSMCUS"); if (dt3.Rows.Count > 0) { foreach (DataRow dr3 in dt3.Rows) { var ParentId = dr3["Id"].ToString(); var MemNo = dr3["MemNo"].ToString(); A2ZMEMBERDTO objDTO = new A2ZMEMBERDTO(); objDTO.ID = Converter.GetSmallInteger(ParentId); if (MemNo == "0") { objDTO.MemType = Converter.GetSmallInteger(1); } else { objDTO.MemType = Converter.GetSmallInteger(2); } int row2 = A2ZMEMBERDTO.Update2(objDTO); } } }
protected void txtLoanMemNo_TextChanged(object sender, EventArgs e) { if (ddlLoanMemNo.SelectedValue == "-Select-") { txtLoanMemNo.Focus(); } if (txtLoanMemNo.Text != string.Empty) { int MemNumber = Converter.GetInteger(txtLoanMemNo.Text); A2ZMEMBERDTO getDTO = new A2ZMEMBERDTO(); getDTO = (A2ZMEMBERDTO.GetInformation(0, 0, MemNumber)); if (getDTO.NoRecord > 0) { ddlLoanMemNo.SelectedValue = Converter.GetString(getDTO.MemberNo); } else { //String csname1 = "PopupScript"; //Type cstype = GetType(); //ClientScriptManager cs = Page.ClientScript; //if (!cs.IsStartupScriptRegistered(cstype, csname1)) //{ // String cstext1 = "alert('Depositor No does not exist in file');"; // cs.RegisterStartupScript(cstype, csname1, cstext1, true); // txtLoanMemNo.Focus(); //} ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Depositor No does not exist in file');", true); return; } } }
protected void txtMemNo_TextChanged(object sender, EventArgs e) { try { if (ddlMemNo.SelectedValue == "-Select-") { } if (txtMemNo.Text != string.Empty && ddlCreditUNo.SelectedValue != "-Select-") { Int16 CuType = Converter.GetSmallInteger(lblCuType.Text); int CNo = Converter.GetSmallInteger(lblCuNo.Text); int MemNumber = Converter.GetInteger(txtMemNo.Text); A2ZMEMBERDTO getDTO = new A2ZMEMBERDTO(); getDTO = (A2ZMEMBERDTO.GetInformation(CuType, CNo, MemNumber)); if (getDTO.NoRecord > 0) { ddlMemNo.SelectedValue = Converter.GetString(getDTO.MemberNo); } else { ddlMemNo.SelectedValue = "-Select-"; } } } catch (Exception ex) { throw ex; } }
protected void ddlMemNo_SelectedIndexChanged(object sender, EventArgs e) { if (ddlMemNo.SelectedValue == "-Select-") { txtMemNo.Text = string.Empty; txtMemNo.Focus(); } if (ddlMemNo.SelectedValue != "-Select-") { A2ZMEMBERDTO getDTO = new A2ZMEMBERDTO(); Int16 CuType = 0; int CreditNumber = 0; int MemNumber = Converter.GetInteger(ddlMemNo.SelectedValue); getDTO = (A2ZMEMBERDTO.GetInformation(CuType, CreditNumber, MemNumber)); if (getDTO.NoRecord > 0) { txtMemNo.Text = Converter.GetString(getDTO.MemberNo); txtAccType.Focus(); } else { txtMemNo.Text = string.Empty; } } }
protected void BtnSearch_Click(object sender, EventArgs e) { if (txtMemNo.Text != string.Empty) { lblCuType.Text = "0"; lblCuNo.Text = "0"; Int16 CUType = Converter.GetSmallInteger(lblCuType.Text); int CUNo = Converter.GetInteger(lblCuNo.Text); int MNo = Converter.GetInteger(txtMemNo.Text); A2ZMEMBERDTO get6DTO = (A2ZMEMBERDTO.GetInformation(CUType, CUNo, MNo)); if (get6DTO.NoRecord > 0) { lblMemName.Text = Converter.GetString(get6DTO.MemberName); gvDetailInfo.Visible = true; gvDetail(); //MoveAccDescription(); } else { InvalidStaffNo(); txtMemNo.Text = string.Empty; txtMemNo.Focus(); return; } } }
protected void BtnCreUnionSubmit_Click(object sender, EventArgs e) { try { A2ZCUNIONDTO objDTO = new A2ZCUNIONDTO(); A2ZMEMBERDTO MemDTO = new A2ZMEMBERDTO(); MemDTO.CreditUnionNo = Converter.GetInteger(txtCreditUNo.Text); MemDTO.MemberName = Converter.GetString(txtCreUName.Text); MemDTO.MemType = 1; objDTO.CreditUnionNo = Converter.GetInteger(txtCreditUNo.Text); objDTO.CreditUnionName = Converter.GetString(txtCreUName.Text); //DateTime date = DateTime.ParseExact(txtCuOpenDate.Text, "MM/dd/yyyy", System.Globalization.CultureInfo.InvariantCulture); if (txtCuOpenDate.Text != string.Empty) { DateTime opdate = DateTime.ParseExact(txtCuOpenDate.Text, "dd/MM/yyyy", System.Globalization.CultureInfo.InvariantCulture); objDTO.opendate = opdate; MemDTO.OpenDate = opdate; } else { objDTO.opendate = Converter.GetDateTime(System.DateTime.Now.ToLongDateString()); } //objDTO.opendate = Converter.GetDateTime(System.DateTime.Now.ToLongDateString()); objDTO.MemberFlag = Converter.GetSmallInteger(ddlCuMemberFlag.SelectedValue); objDTO.MemberType = Converter.GetSmallInteger(ddlCuMemberType.SelectedValue); objDTO.CertificateNo = Converter.GetInteger(txtCuCertificateNo.Text); objDTO.AddressL1 = Converter.GetString(txtCuAddressL1.Text); objDTO.AddressL2 = Converter.GetString(txtCuAddressL2.Text); objDTO.AddressL3 = Converter.GetString(txtCuAddressL3.Text); objDTO.TelephoneNo = Converter.GetString(txtCuTelNo.Text); objDTO.MobileNo = Converter.GetString(txtCuMobileNo.Text); objDTO.Fax = Converter.GetString(txtCuFax.Text); objDTO.email = Converter.GetString(txtCuEmail.Text); objDTO.Division = Converter.GetInteger(ddlDivision.SelectedValue); objDTO.District = Converter.GetInteger(ddlDistrict.SelectedValue); objDTO.Thana = Converter.GetInteger(ddlThana.SelectedValue); int row = A2ZMEMBERDTO.Insert(MemDTO); int roweffect = A2ZCUNIONDTO.InsertInformation(objDTO); if (roweffect > 0) { CreditUnionDropdown(); txtCreditUNo.Text = string.Empty; ddlCuMemberFlag.SelectedValue = "0"; ddlCuMemberType.SelectedValue = "0"; clearInfo(); txtCreditUNo.Focus(); } } catch (Exception ex) { throw ex; } }
protected void txtMemNo_TextChanged(object sender, EventArgs e) { try { if (txtMemNo.Text != string.Empty) { A2ZMEMBERDTO getDTO = new A2ZMEMBERDTO(); if (chkOldSearch.Checked == true) { int MemNumber = Converter.GetInteger(txtMemNo.Text); int CuNumber = Converter.GetInteger(hdnCuNumber.Text); getDTO = (A2ZMEMBERDTO.GetInfoOldMember(CuNumber, MemNumber)); } else { Int16 CUType = Converter.GetSmallInteger(lblCuType.Text); int CUNo = Converter.GetInteger(lblCuNo.Text); int MNo = Converter.GetInteger(txtMemNo.Text); getDTO = (A2ZMEMBERDTO.GetInformation(CUType, CUNo, MNo)); } //Int16 CuType = Converter.GetSmallInteger(lblCuType.Text); //int CNo = Converter.GetSmallInteger(lblCuNo.Text); //int MemNumber = Converter.GetInteger(txtMemNo.Text); //A2ZMEMBERDTO getDTO = new A2ZMEMBERDTO(); //getDTO = (A2ZMEMBERDTO.GetInformation(CuType, CNo, MemNumber)); if (getDTO.NoRecord > 0) { txtMemNo.Text = Converter.GetString(getDTO.MemberNo); lblMemName.Text = Converter.GetString(getDTO.MemberName); } else { txtMemNo.Text = string.Empty; lblMemName.Text = string.Empty; txtMemNo.Focus(); InvalidMemNoMSG(); } } } catch (Exception ex) { throw ex; } }
protected void txtMemNo_TextChanged(object sender, EventArgs e) { A2ZACCOUNTDTO GetAccount = new A2ZACCOUNTDTO(); Int16 CuType = Converter.GetSmallInteger(lblCuType.Text); int AccType = Converter.GetInteger(ddlAcType.SelectedValue); int CreditNo = Converter.GetInteger(lblCuNo.Text); int MemberNo = Converter.GetInteger(txtMemNo.Text); GetAccount = (A2ZACCOUNTDTO.GetInfo(AccType, CuType, CreditNo, MemberNo)); if (GetAccount.AccNo > 0 && GetAccount.AccStatus < 98) { txtAccNo.Text = Converter.GetString(GetAccount.AccNo); } else { txtAccNo.Text = string.Empty; txtMemNo.Text = string.Empty; txtMemNo.Focus(); return; } A2ZMEMBERDTO getDTO = new A2ZMEMBERDTO(); if (chkOldSearch.Checked == true) { int MemNumber = Converter.GetInteger(txtMemNo.Text); int CuNumber = Converter.GetInteger(hdnCuNumber.Text); getDTO = (A2ZMEMBERDTO.GetInfoOldMember(CuNumber, MemNumber)); } else { Int16 CUType = Converter.GetSmallInteger(lblCuType.Text); int CUNo = Converter.GetInteger(lblCuNo.Text); int MNo = Converter.GetInteger(txtMemNo.Text); getDTO = (A2ZMEMBERDTO.GetInformation(CUType, CUNo, MNo)); } if (getDTO.NoRecord > 0) { lblMemName.Text = Converter.GetString(getDTO.MemberName); txtAmount.Focus(); } else { lblMemName.Text = string.Empty; txtMemNo.Focus(); } }
protected void txtTrnMemNo_TextChanged(object sender, EventArgs e) { try { if (txtTrnMemNo.Text != string.Empty) { BtnTransfer.Visible = false; A2ZMEMBERDTO getDTO = new A2ZMEMBERDTO(); if (chkOldSearch.Checked == true) { int MemNumber = Converter.GetInteger(txtTrnMemNo.Text); int CuNumber = Converter.GetInteger(hdnCuNumber.Text); getDTO = (A2ZMEMBERDTO.GetInfoOldMember(CuNumber, MemNumber)); } else { Int16 CUType = Converter.GetSmallInteger(lblCuType.Text); int CUNo = Converter.GetInteger(lblCuNo.Text); int MNo = Converter.GetInteger(txtTrnMemNo.Text); getDTO = (A2ZMEMBERDTO.GetInformation(CUType, CUNo, MNo)); } if (getDTO.NoRecord > 0) { txtTrnMemNo.Text = Converter.GetString(getDTO.MemberNo); lblMemName.Text = Converter.GetString(getDTO.MemberName); BtnTrfSearch.Visible = true; } else { InvalidMemNo(); BtnTrfSearch.Visible = false; txtTrnMemNo.Text = string.Empty; txtTrnMemNo.Focus(); } } } catch (Exception ex) { Page.ClientScript.RegisterStartupScript(this.GetType(), "scriptkey", "<script>alert('System Error.txtTrnMemNo_TextChanged Problem');</script>"); //throw ex; } }
protected void ddlLoanMemNo_SelectedIndexChanged(object sender, EventArgs e) { if (ddlLoanMemNo.SelectedValue != "-Select-") { int MemNumber = Converter.GetInteger(ddlLoanMemNo.SelectedValue); A2ZMEMBERDTO getDTO = new A2ZMEMBERDTO(); getDTO = (A2ZMEMBERDTO.GetInformation(0, 0, MemNumber)); if (getDTO.NoRecord > 0) { ItxtMemNo.Text = Converter.GetString(getDTO.MemberNo); txtAccType.Focus(); } } }
protected void ddlMemNo_SelectedIndexChanged(object sender, EventArgs e) { if (ddlMemNo.SelectedValue != "-Select-" && ddlCreditUNo.SelectedValue != "-Select-") { Int16 CuType = Converter.GetSmallInteger(lblCuType.Text); int CNo = Converter.GetSmallInteger(lblCuNo.Text); int MemNumber = Converter.GetInteger(ddlMemNo.SelectedValue); A2ZMEMBERDTO getDTO = new A2ZMEMBERDTO(); getDTO = (A2ZMEMBERDTO.GetInformation(CuType, CNo, MemNumber)); if (getDTO.NoRecord > 0) { txtMemNo.Text = Converter.GetString(getDTO.MemberNo); } } }
protected void txtLoanMemNo_TextChanged(object sender, EventArgs e) { if (ddlLoanMemNo.SelectedValue == "-Select-") { txtLoanMemNo.Focus(); } if (txtLoanMemNo.Text != string.Empty) { int MemNumber = Converter.GetInteger(txtLoanMemNo.Text); A2ZMEMBERDTO getDTO = new A2ZMEMBERDTO(); getDTO = (A2ZMEMBERDTO.GetInformation(0, 0, MemNumber)); if (getDTO.NoRecord > 0) { ddlLoanMemNo.SelectedValue = Converter.GetString(getDTO.MemberNo); AccountOpenCheck(); if (MsgFlag.Text == "1") { txtLoanMemNo.Text = string.Empty; ddlLoanMemNo.SelectedIndex = 0; txtLoanMemNo.Focus(); return; } else { txtLoanAppAmount.Focus(); } } else { txtLoanMemNo.Focus(); ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Staff No. does not exist in file');", true); return; } } }
protected void ItxtMemNo_TextChanged(object sender, EventArgs e) { try { if (ItxtMemNo.Text != string.Empty) { Int16 CuType = Converter.GetSmallInteger(lblCuType.Text); int CNo = Converter.GetSmallInteger(lblCuNo.Text); int MemNumber = Converter.GetInteger(ItxtMemNo.Text); int CuNumber = Converter.GetInteger(hdnCuNumber.Text); A2ZMEMBERDTO getDTO = new A2ZMEMBERDTO(); getDTO = (A2ZMEMBERDTO.GetInformation(CuType, CNo, MemNumber)); //A2ZMEMBERDTO getDTO = new A2ZMEMBERDTO(); //getDTO = (A2ZMEMBERDTO.GetInfoMember(CuType, CNo, CuNumber, MemNumber)); if (getDTO.NoRecord > 0) { ItxtMemNo.Text = Converter.GetString(getDTO.MemberNo); ddlLoanMemNo.SelectedValue = Converter.GetString(getDTO.MemberNo); txtAccType.Focus(); } else { ItxtMemNo.Text = string.Empty; ddlLoanMemNo.SelectedIndex = 0; ItxtMemNo.Focus(); InvalidMemMSG(); } } } catch (Exception ex) { Page.ClientScript.RegisterStartupScript(this.GetType(), "scriptkey", "<script>alert('System Error.txtMemNo_TextChanged Problem');</script>"); //throw ex; } }
protected void txtMemNo_TextChanged(object sender, EventArgs e) { if (txtMemNo.Text != string.Empty) { A2ZMEMBERDTO getDTO = new A2ZMEMBERDTO(); Int16 CuType = Converter.GetSmallInteger(lblhideCutype.Text); int CreditNumber = Converter.GetInteger(lblhideCuNo.Text); int MemNumber = Converter.GetInteger(txtMemNo.Text); getDTO = (A2ZMEMBERDTO.GetInformation(CuType, CreditNumber, MemNumber)); if (getDTO.NoRecord > 0) { ddlMemNo.SelectedValue = Converter.GetString(getDTO.MemberNo); txtMemNo.Focus(); } else { ddlMemNo.SelectedValue = "-Select-"; } } }
protected void ddlMemNo_SelectedIndexChanged(object sender, EventArgs e) { if (ddlMemNo.SelectedValue == "-Select-") { txtMemNo.Text = string.Empty; txtMemNo.Focus(); } if (ddlMemNo.SelectedValue != "-Select-") { A2ZMEMBERDTO getDTO = new A2ZMEMBERDTO(); Int16 CuType = Converter.GetSmallInteger(0); int CreditNumber = Converter.GetInteger(0); int MemNumber = Converter.GetInteger(ddlMemNo.SelectedValue); getDTO = (A2ZMEMBERDTO.GetInformation(CuType, CreditNumber, MemNumber)); if (getDTO.NoRecord > 0) { txtMemNo.Text = Converter.GetString(ddlMemNo.SelectedValue); string qry = "SELECT Image,MemNo FROM uploadImg WHERE CuType='0' and CuNo='0' and MemNo = '" + txtMemNo.Text + "'"; DataTable dt = DataAccessLayer.BLL.CommonManager.Instance.GetDataTableByQuery(qry, "A2ZIMAGEMCUS"); if (dt.Rows.Count > 0) { CheckCU(); con.Open(); using (SqlCommand cmd = new SqlCommand("SELECT CuType,CuNo,MemNo,Image FROM uploadImg WHERE CuType='0' and CuNo='0' and MemNo = '" + txtMemNo.Text + "'", con)) using (SqlDataReader reader = cmd.ExecuteReader()) { if (reader.Read()) { byte[] picData = reader["Image"] as byte[] ?? null; if (picData != null) { using (MemoryStream ms = new MemoryStream(picData)) { string base64String = Convert.ToBase64String(picData, 0, picData.Length); ImgPicture.ImageUrl = "data:image/png;base64," + base64String; } } } } ibtnUpload.Visible = false; BtnUpdate.Visible = true; return; } else { ibtnUpload.Visible = true; BtnUpdate.Visible = false; ImgPicture.ImageUrl = "~/Images/index.jpg"; return; } } else { ddlMemNo.SelectedValue = "-Select-"; txtMemNo.Text = string.Empty; ImgPicture.ImageUrl = "~/Images/index.jpg"; ibtnUpload.Visible = true; BtnUpdate.Visible = false; } } else { txtMemNo.Text = string.Empty; } }
protected void BtnProceed_Click(object sender, EventArgs e) { string sqlquery4 = "Truncate table dbo.A2ZMEMBER "; int resultM = Converter.GetInteger(DataAccessLayer.BLL.CommonManager.Instance.ExecuteNonQuery(sqlquery4, "A2ZCSMCUS")); string qry = "SELECT CuType,CuNo FROM WFCUNO"; DataTable dt = DataAccessLayer.BLL.CommonManager.Instance.GetDataTableByQuery(qry, "A2ZCSMCUS"); int totrec = dt.Rows.Count; if (dt.Rows.Count > 0) { foreach (DataRow dr in dt.Rows) { var CuType = dr["CuType"].ToString(); var CuNo = dr["CuNo"].ToString(); SqlCommand cmd1 = new SqlCommand("INSERT INTO A2ZCSMCUS.dbo.A2ZMEMBER(CuType,CuNo,MemNo,MemName,MemOpenDate,MemOldCuNo,MemOldMemNo) SELECT MEMTYPE,CUNO,MEMNO,MEMNAME,MEMOPDT,CUNO,MEMNO FROM A2ZCCULB.dbo.A2ZMEMBER WHERE CUNO = '" + CuNo + "'", con); con.Open(); int result2 = cmd1.ExecuteNonQuery(); if (result2 > 0) { string strQuery = "UPDATE A2ZMEMBER SET CuType = '" + CuType + "' WHERE CuNo='" + CuNo + "' "; int rowEffect = Converter.GetInteger(DataAccessLayer.BLL.CommonManager.Instance.ExecuteNonQuery(strQuery, "A2ZCSMCUS")); Successful(); } con.Close(); } } OLDLASTMEMBERNO(); OLDMEMBER(); OLD5000LASTMEMBERNO(); OLD5000MEMBER(); AddStaffMemberUpd(); CPSMEMBER(); string qry3 = "SELECT Id,MemNo,MemType FROM A2ZMEMBER "; DataTable dt3 = DataAccessLayer.BLL.CommonManager.Instance.GetDataTableByQuery(qry3, "A2ZCSMCUS"); if (dt3.Rows.Count > 0) { foreach (DataRow dr3 in dt3.Rows) { var ParentId = dr3["Id"].ToString(); var MemNo = dr3["MemNo"].ToString(); A2ZMEMBERDTO objDTO = new A2ZMEMBERDTO(); objDTO.ID = Converter.GetSmallInteger(ParentId); if (MemNo == "0") { objDTO.MemType = Converter.GetSmallInteger(1); } else { objDTO.MemType = Converter.GetSmallInteger(2); } int row2 = A2ZMEMBERDTO.Update2(objDTO); } } string strQry = "DELETE A2ZMEMBER WHERE CuType= 3 AND CuNo = 534 AND MemNo = 1 AND MemOldMemNo = 1"; int rowEff = Converter.GetInteger(DataAccessLayer.BLL.CommonManager.Instance.ExecuteNonQuery(strQry, "A2ZCSMCUS")); }
protected void BtnProcess_Click(object sender, EventArgs e) { if (txtProcessDate.Text == string.Empty) { //String csname1 = "PopupScript"; //Type cstype = GetType(); //ClientScriptManager cs = Page.ClientScript; //if (!cs.IsStartupScriptRegistered(cstype, csname1)) //{ // String cstext1 = "alert('Please fill up the process date!' );"; // cs.RegisterStartupScript(cstype, csname1, cstext1, true); //} ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Please fill up the Process Date');", true); return; } if (txtVchNo.Text == string.Empty && ddlFuncType.SelectedValue == "99") { //String csname1 = "PopupScript"; //Type cstype = GetType(); //ClientScriptManager cs = Page.ClientScript; //if (!cs.IsStartupScriptRegistered(cstype, csname1)) //{ // String cstext1 = "alert('Please Input Voucher No.' );"; // cs.RegisterStartupScript(cstype, csname1, cstext1, true); //} ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Please Input Voucher No.');", true); return; } DateTime fdate = DateTime.ParseExact(txtProcessDate.Text, "dd/MM/yyyy", System.Globalization.CultureInfo.InvariantCulture); ////if(lblProcDate.Text != txtProcessDate.Text) ////{ //// lblVchFlag.Text = "1"; //// lblVchYear.Text = Converter.GetString(fdate.Year); ////} ////else ////{ lblVchFlag.Text = "0"; ////} string qry; if (ddlFuncType.SelectedValue == "99") { if (lblVchFlag.Text == "0") { if (CtrlModule.Text == "1") { qry = "SELECT Id,CuType,CuNo,MemNo,FuncOpt,TrnType,ValueDate,UserID,FromCashCode FROM A2ZTRANSACTION WHERE VchNo = '" + txtVchNo.Text + "' AND TrnDate='" + fdate + "' AND TrnFlag= 0 AND TrnCSGL= 0"; } else { qry = "SELECT Id,CuType,CuNo,MemNo,FuncOpt,TrnType,ValueDate,UserID,FromCashCode FROM A2ZTRANSACTION WHERE VchNo = '" + txtVchNo.Text + "' AND TrnDate='" + fdate + "' AND FromCashCode='" + lblCashCode.Text + "' AND TrnFlag= 0 AND TrnCSGL= 0"; } } else { if (CtrlModule.Text == "1") { qry = "SELECT Id,CuType,CuNo,MemNo,FuncOpt,TrnType,ValueDate,UserID,FromCashCode FROM A2ZCSMCUST" + lblVchYear.Text + "..A2ZTRANSACTION WHERE VchNo = '" + txtVchNo.Text + "' AND TrnDate='" + fdate + "' AND TrnFlag= 0 AND TrnCSGL= 0"; } else { qry = "SELECT Id,CuType,CuNo,MemNo,FuncOpt,TrnType,ValueDate,UserID,FromCashCode FROM A2ZCSMCUST" + lblVchYear.Text + "..A2ZTRANSACTION WHERE VchNo = '" + txtVchNo.Text + "' AND TrnDate='" + fdate + "' AND FromCashCode='" + lblCashCode.Text + "' AND TrnFlag= 0 AND TrnCSGL= 0"; } } } else { if (lblVchFlag.Text == "0") { if (CtrlModule.Text == "1") { qry = "SELECT Id,CuType,CuNo,MemNo,FuncOpt,TrnType,ValueDate,UserID,FromCashCode FROM A2ZTRANSACTION WHERE VchNo = '" + lblAutoVchNo.Text + "' AND TrnDate='" + fdate + "' AND TrnFlag= 0 AND TrnCSGL= 0"; } else { qry = "SELECT Id,CuType,CuNo,MemNo,FuncOpt,TrnType,ValueDate,UserID,FromCashCode FROM A2ZTRANSACTION WHERE VchNo = '" + lblAutoVchNo.Text + "' AND TrnDate='" + fdate + "' AND FromCashCode='" + lblCashCode.Text + "' AND TrnFlag= 0 AND TrnCSGL= 0"; } } else { if (CtrlModule.Text == "1") { qry = "SELECT Id,CuType,CuNo,MemNo,FuncOpt,TrnType,ValueDate,UserID,FromCashCode FROM A2ZCSMCUST" + lblVchYear.Text + "..A2ZTRANSACTION WHERE VchNo = '" + lblAutoVchNo.Text + "' AND TrnDate='" + fdate + "' AND TrnFlag= 0 AND TrnCSGL= 0"; } else { qry = "SELECT Id,CuType,CuNo,MemNo,FuncOpt,TrnType,ValueDate,UserID,FromCashCode FROM A2ZCSMCUST" + lblVchYear.Text + "..A2ZTRANSACTION WHERE VchNo = '" + lblAutoVchNo.Text + "' AND TrnDate='" + fdate + "' AND FromCashCode='" + lblCashCode.Text + "' AND TrnFlag= 0 AND TrnCSGL= 0"; } } } DataTable dt = DataAccessLayer.BLL.CommonManager.Instance.GetDataTableByQuery(qry, "A2ZCSMCUS"); if (dt.Rows.Count > 0) { lblCuType.Text = Converter.GetString(dt.Rows[0]["CuType"]); lblCuNo.Text = Converter.GetString(dt.Rows[0]["CuNo"]); lblMemNo.Text = Converter.GetString(dt.Rows[0]["MemNo"]); lblFuncOpt.Text = Converter.GetString(dt.Rows[0]["FuncOpt"]); lblTrnType.Text = Converter.GetString(dt.Rows[0]["TrnType"]); lblValueDate.Text = Converter.GetString(dt.Rows[0]["ValueDate"]); lblUserID.Text = Converter.GetString(dt.Rows[0]["UserID"]); lblFromCashCode.Text = Converter.GetString(dt.Rows[0]["FromCashCode"]); string qry1 = "SELECT IdsNo,IdsName from A2ZSYSIDS WHERE IdsNo = '" + lblUserID.Text + "'"; DataTable dt1 = DataAccessLayer.BLL.CommonManager.Instance.GetDataTableByQuery(qry1, "A2ZCSMCUS"); if (dt1.Rows.Count > 0) { lblUserIDName.Text = Converter.GetString(dt1.Rows[0]["IdsName"]); } string qry3 = "SELECT GLAccDesc FROM A2ZCGLMST where GLAccNo='" + lblFromCashCode.Text + "'"; DataTable dt3 = DataAccessLayer.BLL.CommonManager.Instance.GetDataTableByQuery(qry3, "A2ZGLMCUS"); if (dt3.Rows.Count > 0) { lblBoothNo.Text = lblFromCashCode.Text; lblBoothName.Text = Converter.GetString(dt3.Rows[0]["GLAccDesc"]); } } else { txtVchNo.Text = string.Empty; txtVchNo.Focus(); InvalidVoucherMSG(); return; } Int16 CUType = Converter.GetSmallInteger(lblCuType.Text); int CUNo = Converter.GetInteger(lblCuNo.Text); int MNo = Converter.GetInteger(lblMemNo.Text); A2ZMEMBERDTO get6DTO = (A2ZMEMBERDTO.GetInformation(CUType, CUNo, MNo)); if (get6DTO.NoRecord > 0) { lblMemName.Text = Converter.GetString(get6DTO.MemberName); } if (lblTrnType.Text == "1") { lblTrnTypeTitle.Text = "CASH"; } else { lblTrnTypeTitle.Text = "TRANSFER"; } if (lblFuncOpt.Text == "1" || lblFuncOpt.Text == "2" || lblFuncOpt.Text == "11") { lblFuncTitle.Text = "DEPOSIT"; } else { lblFuncTitle.Text = "WITHDRAWAL"; } if (ddlFuncType.SelectedValue == "99") { PrintTrnVoucher1(); } else { PrintTrnVoucher2(); } }
public void GetAccInfo() { try { Int64 AccNumber = Converter.GetLong(txtAccNo.Text); A2ZACCOUNTDTO accgetDTO = (A2ZACCOUNTDTO.GetInfoAccNo(AccNumber)); if (accgetDTO.a == 0) { InvalidAccMSG(); txtAccNo.Text = string.Empty; txtAccNo.Focus(); return; } else { lblAccBalance.Text = Converter.GetString(String.Format("{0:0,0.00}", accgetDTO.AccBalance)); lblBalance.Text = Converter.GetString(String.Format("{0:0,0.00}", accgetDTO.AccBalance)); lblBalLienAmount.Text = Converter.GetString(String.Format("{0:0,0.00}", accgetDTO.AccLienAmt)); lblStatP.Text = Converter.GetString(accgetDTO.AccStatus); DateTime dt = Converter.GetDateTime(accgetDTO.AccStatusDate); string date = dt.ToString("dd/MM/yyyy"); lblCurrRef.Text = Converter.GetString(accgetDTO.AccStatusNote); if (lblStatP.Text == "98") { txtAccNo.Text = string.Empty; txtAccNo.Focus(); InvalidAccStatusChg(); return; } if (lblStatP.Text == "50") { lblBalLien.Visible = true; lblBalLienAmount.Visible = true; } if (date == "01/01/0001") { lblCurrStatDt.Text = string.Empty; } else { lblCurrStatDt.Text = date; } string qry1 = "SELECT AccStatusDescription FROM A2ZACCSTATUS where AccStatusCode='" + lblStatP.Text + "'"; DataTable dt1 = DataAccessLayer.BLL.CommonManager.Instance.GetDataTableByQuery(qry1, "A2ZCSMCUS"); if (dt1.Rows.Count > 0) { lblCurrStatus.Text = Converter.GetString(dt1.Rows[0]["AccStatusDescription"]); } lblCuType.Text = Converter.GetString(accgetDTO.CuType); lblCuNo.Text = Converter.GetString(accgetDTO.CuNo); txtCreditUNo.Text = (lblCuType.Text + "-" + lblCuNo.Text); txtMemNo.Text = Converter.GetString(accgetDTO.MemberNo); CtrlAccType.Text = Converter.GetString(accgetDTO.AccType); lblcls.Text = Converter.GetString(accgetDTO.AccAtyClass); Int16 AccType = Converter.GetSmallInteger(CtrlAccType.Text); A2ZACCTYPEDTO get3DTO = (A2ZACCTYPEDTO.GetInformation(AccType)); if (get3DTO.AccTypeCode > 0) { lblAccTitle.Text = Converter.GetString(get3DTO.AccTypeDescription); } Int16 CType = Converter.GetSmallInteger(lblCuType.Text); int CNo = Converter.GetInteger(lblCuNo.Text); A2ZCUNIONDTO get5DTO = (A2ZCUNIONDTO.GetInformation(CType, CNo)); if (get5DTO.NoRecord > 0) { lblCuName.Text = Converter.GetString(get5DTO.CreditUnionName); } Int16 CUType = Converter.GetSmallInteger(lblCuType.Text); int CUNo = Converter.GetInteger(lblCuNo.Text); int MNo = Converter.GetInteger(txtMemNo.Text); A2ZMEMBERDTO get6DTO = (A2ZMEMBERDTO.GetInformation(CUType, CUNo, MNo)); if (get6DTO.NoRecord > 0) { lblMemName.Text = Converter.GetString(get6DTO.MemberName); } } } catch (Exception ex) { Page.ClientScript.RegisterStartupScript(this.GetType(), "scriptkey", "<script>alert('System Error.GetAccInfo Problem');</script>"); //throw ex; } }
protected void BtnSearch_Click(object sender, EventArgs e) { if (txtSearchCuName.Text != string.Empty) { txtSearchCuName_TextChanged(this, EventArgs.Empty); return; } if (txtSearchMemName.Text != string.Empty) { txtSearchMemName_TextChanged(this, EventArgs.Empty); return; } if (txtCreditUNo.Text != string.Empty && txtMemNo.Text == string.Empty && txtOldCuNo.Text == string.Empty) { NewMemberInfoHelp(); return; } else if (txtOldCuNo.Text != string.Empty && txtOldMemNo.Text == string.Empty) { OldMemberInfoHelp(); return; } else { if (lblModule.Text == "4" && txtMemNo.Text != string.Empty) { lblCuType.Text = "0"; lblCuNo.Text = "0"; Int16 CUType = Converter.GetSmallInteger(lblCuType.Text); int CUNo = Converter.GetInteger(lblCuNo.Text); int MNo = Converter.GetInteger(txtMemNo.Text); A2ZMEMBERDTO get6DTO = (A2ZMEMBERDTO.GetInformation(CUType, CUNo, MNo)); if (get6DTO.NoRecord > 0) { lblMemName.Text = Converter.GetString(get6DTO.MemberName); gvGetMEMDetail(); gvSearchMEMInfo.Visible = true; txtSearchMemName.ReadOnly = false; } else { InvalidStaffNo(); txtMemNo.Text = string.Empty; txtMemNo.Focus(); return; } } else { if (txtCreditUNo.Text != string.Empty) { string c = ""; int a = txtCreditUNo.Text.Length; string b = txtCreditUNo.Text; c = b.Substring(0, 1); int re = Converter.GetSmallInteger(c); int dd = a - 1; string d = b.Substring(1, dd); int re1 = Converter.GetSmallInteger(d); Int16 CType = Converter.GetSmallInteger(re); lblCuType.Text = Converter.GetString(CType); int CNo = Converter.GetSmallInteger(re1); lblCuNo.Text = Converter.GetString(CNo); A2ZCUNIONDTO get5DTO = (A2ZCUNIONDTO.GetInformation(CType, CNo)); if (get5DTO.NoRecord > 0) { lblCuName.Text = Converter.GetString(get5DTO.CreditUnionName); lblCuNumber.Text = lblCuType.Text + lblCuNo.Text; txtCreditUNo.Text = (lblCuType.Text + "-" + lblCuNo.Text); lblCType.Text = Converter.GetString(get5DTO.CuType); lblCTypeName.Text = Converter.GetString(get5DTO.CreditUnionName); lblCNo.Text = Converter.GetString(get5DTO.CreditUnionNo); if (get5DTO.CuStatus == 9) { if (get5DTO.CuReguCuType == 0) { lblCTypeName.Text = Converter.GetString(get5DTO.CuAssoCuTypeName); lblCNo.Text = Converter.GetString(get5DTO.CuAssoCuNo); lblCType.Text = Converter.GetString(get5DTO.CuAssoCuType); } else { lblCTypeName.Text = Converter.GetString(get5DTO.CuReguCuTypeName); lblCNo.Text = Converter.GetString(get5DTO.CuReguCuNo); lblCType.Text = Converter.GetString(get5DTO.CuReguCuType); } DisplayMessage(); txtCreditUNo.Text = string.Empty; txtCreditUNo.Focus(); return; } Int16 CUType = Converter.GetSmallInteger(lblCuType.Text); int CUNo = Converter.GetInteger(lblCuNo.Text); int MNo = Converter.GetInteger(txtMemNo.Text); A2ZMEMBERDTO get6DTO = (A2ZMEMBERDTO.GetInformation(CUType, CUNo, MNo)); if (get6DTO.NoRecord > 0) { lblMemName.Text = Converter.GetString(get6DTO.MemberName); gvSearchCUInfo.Visible = false; gvGetMEMDetail(); gvSearchMEMInfo.Visible = true; txtSearchMemName.ReadOnly = false; } else { InvalidMemNo(); txtMemNo.Text = string.Empty; txtMemNo.Focus(); return; } } else { InvalidCuNo(); txtCreditUNo.Text = string.Empty; txtCreditUNo.Focus(); return; } } if (txtOldCuNo.Text != string.Empty) { int CN = Converter.GetInteger(txtOldCuNo.Text); hdnCuNumber.Text = Converter.GetString(CN); A2ZCUNIONDTO getDTO = (A2ZCUNIONDTO.GetOldInfo(CN)); //A2ZCUNIONDTO getDTO = (A2ZCUNIONDTO.GetInformation(CuType, CNo)); if (getDTO.NoRecord > 0) { lblCuType.Text = Converter.GetString(getDTO.CuType); lblCuNo.Text = Converter.GetString(getDTO.CreditUnionNo); lblCuNumber.Text = lblCuType.Text + lblCuNo.Text; lblCuName.Text = Converter.GetString(getDTO.CreditUnionName); txtCreditUNo.Text = (lblCuType.Text + "-" + lblCuNo.Text); lblCType.Text = Converter.GetString(getDTO.CuType); lblCTypeName.Text = Converter.GetString(getDTO.CreditUnionName); lblCNo.Text = Converter.GetString(getDTO.CreditUnionNo); if (getDTO.CuStatus == 9) { if (getDTO.CuReguCuType == 0) { lblCTypeName.Text = Converter.GetString(getDTO.CuAssoCuTypeName); lblCNo.Text = Converter.GetString(getDTO.CuAssoCuNo); lblCType.Text = Converter.GetString(getDTO.CuAssoCuType); } else { lblCTypeName.Text = Converter.GetString(getDTO.CuReguCuTypeName); lblCNo.Text = Converter.GetString(getDTO.CuReguCuNo); lblCType.Text = Converter.GetString(getDTO.CuReguCuType); } DisplayMessage(); txtCreditUNo.Text = string.Empty; txtCreditUNo.Focus(); return; } int MemNumber = Converter.GetInteger(txtOldMemNo.Text); int CuNumber = Converter.GetInteger(hdnCuNumber.Text); A2ZMEMBERDTO get1DTO = new A2ZMEMBERDTO(); get1DTO = (A2ZMEMBERDTO.GetInfoOldMember(CuNumber, MemNumber)); if (get1DTO.NoRecord > 0) { txtMemNo.Text = Converter.GetString(get1DTO.MemberNo); lblMemName.Text = Converter.GetString(get1DTO.MemberName); gvSearchCUInfo.Visible = false; gvGetMEMDetail(); gvSearchMEMInfo.Visible = true; txtSearchMemName.ReadOnly = false; } else { InvalidMemNo(); txtMemNo.Text = string.Empty; txtMemNo.Focus(); return; } } else { InvalidCuNo(); txtOldCuNo.Text = string.Empty; txtOldCuNo.Focus(); return; } } } } }
protected void BtnApprove_Click(object sender, EventArgs e) { try { A2ZRECCTRLDTO getDTO = (A2ZRECCTRLDTO.GetLastRecords(1)); lblNewSRL.Text = Converter.GetString(getDTO.CtrlRecLastNo); A2ZCUNIONDTO MemDTO = new A2ZCUNIONDTO(); A2ZMEMBERDTO Mem1DTO = new A2ZMEMBERDTO(); A2ZACCOUNTDTO Mem2DTO = new A2ZACCOUNTDTO(); Button b = (Button)sender; GridViewRow r = (GridViewRow)b.NamingContainer; Label CTyNo = (Label)gvCUInfo.Rows[r.RowIndex].Cells[5].FindControl("lblcutype"); Label CrNo = (Label)gvCUInfo.Rows[r.RowIndex].Cells[6].FindControl("lblcno"); int a = Converter.GetSmallInteger(CTyNo.Text); int c = Converter.GetSmallInteger(CrNo.Text); Int16 CuType = Converter.GetSmallInteger(a); int CNo = Converter.GetSmallInteger(c); lblCuType.Text = Converter.GetString(CuType); lblCuNo.Text = Converter.GetString(CNo); A2ZCUAPPLICATIONDTO objDTO = (A2ZCUAPPLICATIONDTO.GetInformation(CuType, CNo)); if (objDTO.CreditUnionNo > 0) { objDTO.CuType = CuType; objDTO.CreditUnionNo = CNo; MemDTO.CuType = Converter.GetSmallInteger(objDTO.CuType); MemDTO.CuTypeName = Converter.GetString(objDTO.CuTypeName); MemDTO.CreditUnionNo = Converter.GetInteger(lblNewSRL.Text); MemDTO.CreditUnionName = Converter.GetString(objDTO.CreditUnionName); MemDTO.opendate = Converter.GetDateTime(objDTO.opendate); MemDTO.MemberFlag = Converter.GetSmallInteger(objDTO.MemberFlag); MemDTO.CertificateNo = Converter.GetInteger(objDTO.CertificateNo); MemDTO.AddressL1 = Converter.GetString(objDTO.AddressL1); MemDTO.AddressL2 = Converter.GetString(objDTO.AddressL2); MemDTO.AddressL3 = Converter.GetString(objDTO.AddressL3); MemDTO.TelephoneNo = Converter.GetString(objDTO.TelephoneNo); MemDTO.MobileNo = Converter.GetString(objDTO.MobileNo); MemDTO.Fax = Converter.GetString(objDTO.Fax); MemDTO.email = Converter.GetString(objDTO.email); MemDTO.Division = Converter.GetInteger(objDTO.Division); MemDTO.District = Converter.GetInteger(objDTO.District); MemDTO.Upzila = Converter.GetInteger(objDTO.Upzila); MemDTO.Thana = Converter.GetInteger(objDTO.Thana); MemDTO.GLCashCode = Converter.GetInteger(objDTO.GLCashCode); MemDTO.CuStatusDate = Converter.GetDateTime(objDTO.CuStatusDate); MemDTO.ValueDate = Converter.GetDateTime(objDTO.ValueDate); MemDTO.CreateDate = Converter.GetDateTime(objDTO.CreateDate); objDTO.CuProcFlag = Converter.GetSmallInteger(13); objDTO.CuProcDesc = "Approved"; objDTO.ApprovBy = Converter.GetSmallInteger(SessionStore.GetValue(Params.SYS_USER_ID)); A2ZCSPARAMETERDTO dto = A2ZCSPARAMETERDTO.GetParameterValue(); objDTO.ApprovByDate = Converter.GetDateTime(dto.ProcessDate); MemDTO.CuProcFlag = Converter.GetSmallInteger(objDTO.CuProcFlag); MemDTO.ApprovBy = Converter.GetSmallInteger(objDTO.ApprovBy); MemDTO.ApprovByDate = Converter.GetDateTime(objDTO.ApprovByDate); MemDTO.InputBy = Converter.GetSmallInteger(objDTO.InputBy); MemDTO.VerifyBy = Converter.GetSmallInteger(objDTO.VerifyBy); MemDTO.InputByDate = Converter.GetDateTime(objDTO.InputByDate); MemDTO.VerifyByDate = Converter.GetDateTime(objDTO.VerifyByDate); objDTO.VerifyBy = Converter.GetSmallInteger(MemDTO.VerifyBy); objDTO.VerifyByDate = Converter.GetDateTime(MemDTO.VerifyByDate); Mem1DTO.CuType = Converter.GetSmallInteger(MemDTO.CuType); Mem1DTO.CreditUnionNo = Converter.GetInteger(MemDTO.CreditUnionNo); Mem1DTO.MemberName = Converter.GetString(MemDTO.CreditUnionName); Mem1DTO.OpenDate = Converter.GetDateTime(MemDTO.opendate); Mem1DTO.MemType = 1; Mem2DTO.CuType = Converter.GetSmallInteger(MemDTO.CuType); Mem2DTO.CuNo = Converter.GetInteger(MemDTO.CreditUnionNo); Mem2DTO.AccType = 99; Mem2DTO.AccNo = 0; Mem2DTO.MemberNo = 0; Mem2DTO.Opendate = Converter.GetDateTime(MemDTO.opendate); Mem2DTO.AccStatus = 1; Mem2DTO.AccAtyClass = 6; int roweffect = A2ZCUAPPLICATIONDTO.UpdateInformation2(objDTO); if (roweffect > 0) { int row = A2ZCUNIONDTO.InsertInformation(MemDTO); int row1 = A2ZMEMBERDTO.Insert(Mem1DTO); InsertMiscRecord(); //int row2 = A2ZACCOUNTDTO.Insert(Mem2DTO); DisplayMessage(); gvVerify(); string CheckQuery = "SELECT CuType,CuTypeName,CuNo,CuName,CuOpDt,CuProcDesc FROM A2ZCUAPPLICATION Where CuProcFlag = '12' OR CuProcFlag = '22' and CuStatus !='99'"; DataTable dt = new DataTable(); dt = CommonManager.Instance.GetDataTableByQuery(CheckQuery, "A2ZCSMCUS"); if (dt.Rows.Count <= 0) { DivGridViewCancle.Visible = false; lblmsg1.Visible = true; lblmsg2.Visible = true; } } } } catch (Exception ex) { Page.ClientScript.RegisterStartupScript(this.GetType(), "scriptkey", "<script>alert('System Error.BtnApprove_Click Problem');</script>"); //throw ex; } }
protected void BtnCreUnionUpdate_Click(object sender, EventArgs e) { Int16 CuType = Converter.GetSmallInteger(lblNewCuType.Text); int CNo = Converter.GetSmallInteger(lblNewCuNo.Text); A2ZCUNIONDTO UpDTO = new A2ZCUNIONDTO(); A2ZMEMBERDTO MemDTO = new A2ZMEMBERDTO(); MemDTO.CreditUnionNo = Converter.GetInteger(CNo); MemDTO.MemberName = Converter.GetString(txtCreUName.Text); MemDTO.MemType = Converter.GetSmallInteger(CuType); UpDTO.CuType = Converter.GetSmallInteger(CuType); UpDTO.CreditUnionNo = Converter.GetInteger(CNo); UpDTO.CreditUnionName = Converter.GetString(txtCreUName.Text); UpDTO.CuProcFlag = 13; UpDTO.CuTypeName = Converter.GetString("Affiliate"); UpDTO.InputBy = Converter.GetSmallInteger(SessionStore.GetValue(Params.SYS_USER_ID)); if (txtCuOpenDate.Text != string.Empty) { DateTime opdate = DateTime.ParseExact(txtCuOpenDate.Text, "dd/MM/yyyy", System.Globalization.CultureInfo.InvariantCulture); UpDTO.opendate = opdate; // MemDTO.OpenDate = opdate; } else { UpDTO.opendate = Converter.GetDateTime(System.DateTime.Now.ToLongDateString()); } //UpDTO.MemberFlag = Converter.GetSmallInteger(ddlCuMemberFlag.SelectedValue); UpDTO.CertificateNo = Converter.GetInteger(txtCuCertificateNo.Text); UpDTO.AddressL1 = Converter.GetString(txtCuAddressL1.Text); UpDTO.AddressL2 = Converter.GetString(txtCuAddressL2.Text); UpDTO.AddressL3 = Converter.GetString(txtCuAddressL3.Text); UpDTO.TelephoneNo = Converter.GetString(txtCuTelNo.Text); UpDTO.MobileNo = Converter.GetString(txtCuMobileNo.Text); UpDTO.Fax = Converter.GetString(txtCuFax.Text); UpDTO.email = Converter.GetString(txtCuEmail.Text); UpDTO.Division = Converter.GetInteger(ddlDivision.SelectedValue); UpDTO.District = Converter.GetInteger(ddlDistrict.SelectedValue); UpDTO.Upzila = Converter.GetInteger(ddlUpzila.SelectedValue); UpDTO.Thana = Converter.GetInteger(ddlThana.SelectedValue); A2ZCSPARAMETERDTO dto = A2ZCSPARAMETERDTO.GetParameterValue(); UpDTO.InputByDate = Converter.GetDateTime(dto.ProcessDate); UpDTO.VerifyByDate = Converter.GetDateTime(dto.ProcessDate); UpDTO.ApprovByDate = Converter.GetDateTime(dto.ProcessDate); UpDTO.CuStatusDate = Converter.GetDateTime(dto.ProcessDate); UpDTO.GLCashCode = Converter.GetInteger(txtGLCashCode.Text); // int row = A2ZMEMBERDTO.Update(MemDTO); int roweffect = A2ZCUNIONDTO.UpdateInformation(UpDTO); if (roweffect > 0) { clearInfo(); txtCreditUNo.Text = string.Empty; //ddlCuMemberFlag.SelectedIndex = 0; ddlGLCashCode.SelectedIndex = 0; ddlCreditUNo.SelectedValue = "-Select-"; BtnCreUnionUpdate.Visible = false; ddlDivision.SelectedIndex = 0; ddlDistrict.SelectedIndex = 0; ddlUpzila.SelectedIndex = 0; ddlThana.SelectedIndex = 0; ddlDivision.Enabled = false; ddlDistrict.Enabled = false; ddlUpzila.Enabled = false; ddlThana.Enabled = false; //ddlCuMemberFlag.Enabled = false; ddlGLCashCode.Enabled = false; txtCreditUNo.Focus(); DivisionDropdown(); DistrictInFo(); UpzilaInfo(); ThanaInfo(); } }
protected void BtnSearch_Click(object sender, EventArgs e) { if (lblModule.Text == "4" && txtMemNo.Text != string.Empty) { lblCuType.Text = "0"; lblCuNo.Text = "0"; Int16 CUType = Converter.GetSmallInteger(lblCuType.Text); int CUNo = Converter.GetInteger(lblCuNo.Text); int MNo = Converter.GetInteger(txtMemNo.Text); A2ZMEMBERDTO get6DTO = (A2ZMEMBERDTO.GetInformation(CUType, CUNo, MNo)); if (get6DTO.NoRecord > 0) { lblMemName.Text = Converter.GetString(get6DTO.MemberName); gvDetail(); //MoveAccDescription(); } else { InvalidStaffNo(); txtMemNo.Text = string.Empty; txtMemNo.Focus(); return; } } else { if (txtCreditUNo.Text != string.Empty) { string c = ""; int a = txtCreditUNo.Text.Length; string b = txtCreditUNo.Text; c = b.Substring(0, 1); int re = Converter.GetSmallInteger(c); int dd = a - 1; string d = b.Substring(1, dd); int re1 = Converter.GetSmallInteger(d); Int16 CType = Converter.GetSmallInteger(re); lblCuType.Text = Converter.GetString(CType); int CNo = Converter.GetSmallInteger(re1); lblCuNo.Text = Converter.GetString(CNo); A2ZCUNIONDTO get5DTO = (A2ZCUNIONDTO.GetInformation(CType, CNo)); if (get5DTO.NoRecord > 0) { lblCuName.Text = Converter.GetString(get5DTO.CreditUnionName); lblCuNumber.Text = lblCuType.Text + lblCuNo.Text; txtCreditUNo.Text = (lblCuType.Text + "-" + lblCuNo.Text); Int16 CUType = Converter.GetSmallInteger(lblCuType.Text); int CUNo = Converter.GetInteger(lblCuNo.Text); int MNo = Converter.GetInteger(txtMemNo.Text); A2ZMEMBERDTO get6DTO = (A2ZMEMBERDTO.GetInformation(CUType, CUNo, MNo)); if (get6DTO.NoRecord > 0) { lblMemName.Text = Converter.GetString(get6DTO.MemberName); gvDetail(); //MoveAccDescription(); } else { InvalidMemNo(); txtMemNo.Text = string.Empty; txtMemNo.Focus(); return; } } else { InvalidCuNo(); txtCreditUNo.Text = string.Empty; txtCreditUNo.Focus(); return; } } if (txtOldCuNo.Text != string.Empty) { int CN = Converter.GetInteger(txtOldCuNo.Text); hdnCuNumber.Text = Converter.GetString(CN); A2ZCUNIONDTO getDTO = (A2ZCUNIONDTO.GetOldInfo(CN)); //A2ZCUNIONDTO getDTO = (A2ZCUNIONDTO.GetInformation(CuType, CNo)); if (getDTO.NoRecord > 0) { lblCuType.Text = Converter.GetString(getDTO.CuType); lblCuNo.Text = Converter.GetString(getDTO.CreditUnionNo); lblCuName.Text = Converter.GetString(getDTO.CreditUnionName); txtCreditUNo.Text = (lblCuType.Text + "-" + lblCuNo.Text); int MemNumber = Converter.GetInteger(txtOldMemNo.Text); int CuNumber = Converter.GetInteger(hdnCuNumber.Text); A2ZMEMBERDTO get1DTO = new A2ZMEMBERDTO(); get1DTO = (A2ZMEMBERDTO.GetInfoOldMember(CuNumber, MemNumber)); if (get1DTO.NoRecord > 0) { txtMemNo.Text = Converter.GetString(get1DTO.MemberNo); lblMemName.Text = Converter.GetString(get1DTO.MemberName); gvDetail(); //MoveAccDescription(); } else { InvalidMemNo(); txtMemNo.Text = string.Empty; txtMemNo.Focus(); return; } } else { InvalidCuNo(); txtOldCuNo.Text = string.Empty; txtOldCuNo.Focus(); return; } } } }
protected void BtnSubmit_Click(object sender, EventArgs e) { try { if (ddlMemType.SelectedValue == "0") { ddlMemType.Focus(); ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Please Select Depositor Type');", true); return; } if (txtCULBMemName.Text == string.Empty) { txtCULBMemName.Focus(); ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Please Input Depositor Name');", true); return; } MemlastRecord(); A2ZMEMBERDTO objDTO = new A2ZMEMBERDTO(); objDTO.CuType = Converter.GetSmallInteger(lblCUType.Text); objDTO.CreditUnionNo = Converter.GetInteger(lblCUNumber.Text); objDTO.MemberNo = Converter.GetInteger(lbllastMemno.Text); objDTO.MemberName = Converter.GetString(txtCULBMemName.Text); objDTO.FatherName = Converter.GetString(txtFatherName.Text); objDTO.MotherName = Converter.GetString(txtMotherName.Text); objDTO.SpouseName = Converter.GetString(txtSpouseName.Text); objDTO.Occupation = Converter.GetSmallInteger(ddlOccupation.SelectedValue); objDTO.Nationality = Converter.GetSmallInteger(ddlNationality.SelectedValue); objDTO.Gender = Converter.GetSmallInteger(ddlGender.SelectedValue); objDTO.MemType = Converter.GetSmallInteger(ddlMemType.SelectedValue); objDTO.Religion = Converter.GetSmallInteger(ddlReligion.SelectedValue); objDTO.Nature = Converter.GetSmallInteger(ddlNature.SelectedValue); objDTO.MaritalStatus = Converter.GetSmallInteger(ddlMaritalStatus.SelectedValue); if (txtOpenDate.Text != string.Empty) { DateTime opdate = DateTime.ParseExact(txtOpenDate.Text, "dd/MM/yyyy", System.Globalization.CultureInfo.InvariantCulture); objDTO.OpenDate = opdate; } else { string CheckOpDtNull = ""; objDTO.OpenNullDate = CheckOpDtNull; } if (txtDateOfBirth.Text != string.Empty) { DateTime datebirth = DateTime.ParseExact(txtDateOfBirth.Text, "dd/MM/yyyy", System.Globalization.CultureInfo.InvariantCulture); objDTO.DateOfBirth = datebirth; } else { string checkDOBNull = ""; objDTO.DOBNullDate = checkDOBNull; } objDTO.PlaceofBirth = Converter.GetString(txtPlaceOfBirth.Text); objDTO.PreAddressLine1 = Converter.GetString(txtAddressL1.Text); objDTO.PreAddressLine2 = Converter.GetString(txtAddressL2.Text); objDTO.PreAddressLine3 = Converter.GetString(txtAddressL3.Text); objDTO.PreDivision = Converter.GetInteger(ddlDivision.SelectedValue); objDTO.PreDistrict = Converter.GetInteger(ddlDistrict.SelectedValue); objDTO.preThana = Converter.GetInteger(ddlThana.SelectedValue); objDTO.preUpzila = Converter.GetInteger(ddlUpzila.SelectedValue); objDTO.PreTelephone = Converter.GetString(txtTelNo.Text); objDTO.PreMobile = Converter.GetString(txtMobileNo.Text); objDTO.PreEmail = Converter.GetString(txtEmail.Text); objDTO.PerAddressLine1 = Converter.GetString(txtPerAddL1.Text); objDTO.PerAddressLine2 = Converter.GetString(txtPerAddL2.Text); objDTO.PerAddressLine3 = Converter.GetString(txtPerAddL3.Text); objDTO.PerDivision = Converter.GetInteger(ddlPerDivision.SelectedValue); objDTO.PerDistrict = Converter.GetInteger(ddlPerDistrict.SelectedValue); objDTO.PerUpzila = Converter.GetInteger(ddlPerUpzila.SelectedValue); objDTO.PerThana = Converter.GetInteger(ddlPerThana.SelectedValue); objDTO.PerTelephone = Converter.GetString(txtPerTelNo.Text); objDTO.PerMobile = Converter.GetString(txtPerMobNo.Text); objDTO.PerEmail = Converter.GetString(txtPerEmail.Text); objDTO.EmployerName = Converter.GetString(txtEmpName.Text); objDTO.EmployerAddress = Converter.GetString(txtEmpAddress.Text); objDTO.IntroducerNo1 = Converter.GetString(txtIntroducerMem1.Text); objDTO.IntroducerName1 = Converter.GetString(txtIntroducerName1.Text); objDTO.IntroducerNo2 = Converter.GetString(txtIntroduceMem2.Text); objDTO.IntroducerName2 = Converter.GetString(txtIntroducerName2.Text); objDTO.NationalIdNo = Converter.GetString(txtNationalID.Text); objDTO.PassportNo = Converter.GetString(txtPassportNo.Text); if (txtPassportIssueDate.Text != string.Empty) { DateTime Issuedate = DateTime.ParseExact(txtPassportIssueDate.Text, "dd/MM/yyyy", System.Globalization.CultureInfo.InvariantCulture); objDTO.PassportIssueDate = Issuedate; } else { string checkPPIssDtNull = ""; objDTO.PPIssueNullDate = checkPPIssDtNull; } if (txtPassportExpdate.Text != string.Empty) { DateTime Expdate = DateTime.ParseExact(txtPassportExpdate.Text, "dd/MM/yyyy", System.Globalization.CultureInfo.InvariantCulture); objDTO.PassportExpiryDate = Expdate; } else { string checkPPExpDtNull = ""; objDTO.PPExpNullDate = checkPPExpDtNull; } objDTO.PassportIssuePlace = Converter.GetString(txtPassportIssuePlace.Text); objDTO.TIN = Converter.GetString(txtTIN.Text); if (txtLastTaxPdate.Text != string.Empty) { DateTime LTPaydate = DateTime.ParseExact(txtLastTaxPdate.Text, "dd/MM/yyyy", System.Globalization.CultureInfo.InvariantCulture); objDTO.LastTaxPayDate = LTPaydate; } else { string checkLastPayDtNull = ""; objDTO.LTaxPayNullDate = checkLastPayDtNull; } int roweffect = A2ZMEMBERDTO.InsertInformation(objDTO); if (roweffect > 0) { //txtCULBMemNo.Text = string.Empty; //txtCULBMemNo.Focus(); //if (CtrlModule.Text == "1") //{ // string sqquery = @"SELECT MemNo,MemName FROM A2ZMEMBER WHERE CuNo='" + lblCUNumber.Text + "'and CuType='" + lblCUType.Text + "' GROUP BY MemNo,MemName"; // ddlCULBMemNo = DataAccessLayer.BLL.CommonManager.Instance.FillDropDownListWithSelect(sqquery, ddlCULBMemNo, "A2ZCSMCUS"); //} InsertMiscRecord(); ddlDivision.SelectedValue = "-Select-"; ddlDistrict.SelectedValue = "-Select-"; ddlThana.SelectedValue = "-Select-"; ddlUpzila.SelectedValue = "-Select-"; ddlPerDivision.SelectedValue = "-Select-"; ddlPerDistrict.SelectedValue = "-Select-"; ddlPerThana.SelectedValue = "-Select-"; ddlPerUpzila.SelectedValue = "-Select-"; MemnoMSG(); Session["CuType"] = lblCUType.Text; Session["CrNo"] = lblCUNumber.Text; Session["RCreditUNo"] = lblCrNo.Text; Session["NewMemNo"] = lbllastMemno.Text; Session["RMemNo"] = lbllastMemno.Text; Session["NewMemName"] = txtCULBMemName.Text; Session["CtrlFlag"] = "1"; if (ProgCtrl.Text == "0") { ScriptManager.RegisterStartupScript(Page, typeof(System.Web.UI.Page), "click", @"<script>window.opener.location.href='CSInstantAccountOpeningMaintenance.aspx'; self.close();</script>", false); } if (ProgCtrl.Text == "1") { ScriptManager.RegisterStartupScript(Page, typeof(System.Web.UI.Page), "click", @"<script>window.opener.location.href='CSLoanApplication.aspx'; self.close();</script>", false); } //SessionRemove(); clearInfo(); } } catch (Exception ex) { Page.ClientScript.RegisterStartupScript(this.GetType(), "scriptkey", "<script>alert('System Error.BtnSubmit_Click Problem');</script>"); //throw ex; } }
protected void txtCULBMemNo_TextChanged(object sender, EventArgs e) { try { if (txtCULBMemNo.Text != string.Empty) { string c = ""; int a = txtCreditUNo.Text.Length; string b = txtCreditUNo.Text; c = b.Substring(0, 1); int re = Converter.GetSmallInteger(c); int dd = a - 1; string d = b.Substring(1, dd); int re1 = Converter.GetSmallInteger(d); Int16 CuType = Converter.GetSmallInteger(lblCUType.Text); int CNo = Converter.GetSmallInteger(lblCUNumber.Text); int MemNumber = Converter.GetInteger(txtCULBMemNo.Text); A2ZMEMBERDTO getDTO = new A2ZMEMBERDTO(); getDTO = (A2ZMEMBERDTO.GetInformation(CuType, CNo, MemNumber)); if (getDTO.NoRecord > 0) { if (CtrlModule.Text == "1") { ddlCULBMemNo.SelectedValue = Converter.GetString(getDTO.MemberNo); } txtCULBMemName.Text = getDTO.MemberName; txtFatherName.Text = Converter.GetString(getDTO.FatherName); txtMotherName.Text = Converter.GetString(getDTO.MotherName); txtSpouseName.Text = Converter.GetString(getDTO.SpouseName); DateTime dt = Converter.GetDateTime(getDTO.OpenDate); string date = dt.ToString("dd/MM/yyyy"); txtOpenDate.Text = date; DateTime dt1 = Converter.GetDateTime(getDTO.DateOfBirth); string date1 = dt1.ToString("dd/MM/yyyy"); txtDateOfBirth.Text = date1; txtPlaceOfBirth.Text = Converter.GetString(getDTO.PlaceofBirth); ddlOccupation.SelectedValue = Converter.GetString(getDTO.Occupation); ddlNationality.SelectedValue = Converter.GetString(getDTO.Nationality); ddlGender.SelectedValue = Converter.GetString(getDTO.Gender); ddlMemType.SelectedValue = Converter.GetString(getDTO.MemType); ddlReligion.SelectedValue = Converter.GetString(getDTO.Religion); ddlNature.SelectedValue = Converter.GetString(getDTO.Nature); ddlMaritalStatus.SelectedValue = Converter.GetString(getDTO.MaritalStatus); txtAddressL1.Text = Converter.GetString(getDTO.PreAddressLine1); txtAddressL2.Text = Converter.GetString(getDTO.PreAddressLine2); txtAddressL3.Text = Converter.GetString(getDTO.PreAddressLine3); ddlDivision.SelectedValue = Converter.GetString(getDTO.PreDivision); ddlDistrict.SelectedValue = Converter.GetString(getDTO.PreDistrict); ddlThana.SelectedValue = Converter.GetString(getDTO.preThana); txtTelNo.Text = Converter.GetString(getDTO.PreTelephone); txtMobileNo.Text = Converter.GetString(getDTO.PreMobile); txtEmail.Text = Converter.GetString(getDTO.PreEmail); txtPerAddL1.Text = Converter.GetString(getDTO.PerAddressLine1); txtPerAddL2.Text = Converter.GetString(getDTO.PerAddressLine2); txtPerAddL3.Text = Converter.GetString(getDTO.PerAddressLine3); ddlPerDivision.SelectedValue = Converter.GetString(getDTO.PerDivision); ddlPerDistrict.SelectedValue = Converter.GetString(getDTO.PerDistrict); ddlPerThana.SelectedValue = Converter.GetString(getDTO.PerThana); txtPerTelNo.Text = Converter.GetString(getDTO.PerTelephone); txtPerMobNo.Text = Converter.GetString(getDTO.PerMobile); txtPerEmail.Text = Converter.GetString(getDTO.PerEmail); txtEmpName.Text = Converter.GetString(getDTO.EmployerName); txtEmpAddress.Text = Converter.GetString(getDTO.EmployerAddress); txtIntroducerMem1.Text = Converter.GetString(getDTO.IntroducerNo1); txtIntroducerName1.Text = Converter.GetString(getDTO.IntroducerName1); txtIntroduceMem2.Text = Converter.GetString(getDTO.IntroducerNo2); txtIntroducerName2.Text = Converter.GetString(getDTO.IntroducerName2); txtPassportNo.Text = Converter.GetString(getDTO.PassportNo); DateTime dt2 = Converter.GetDateTime(getDTO.PassportIssueDate); string date2 = dt2.ToString("dd/MM/yyyy"); txtPassportIssueDate.Text = date2; txtPassportIssuePlace.Text = Converter.GetString(getDTO.PassportIssuePlace); txtNationalID.Text = Converter.GetString(getDTO.NationalIdNo); DateTime dt4 = Converter.GetDateTime(getDTO.PassportExpiryDate); string date4 = dt4.ToString("dd/MM/yyyy"); txtPassportExpdate.Text = date4; txtTIN.Text = Converter.GetString(getDTO.TIN); DateTime dt3 = Converter.GetDateTime(getDTO.LastTaxPayDate); string date3 = dt3.ToString("dd/MM/yyyy"); txtLastTaxPdate.Text = date3; txtCULBMemName.Focus(); BtnSubmit.Visible = false; BtnUpdate.Visible = true; } else { clearInfo(); txtCULBMemName.Text = string.Empty; BtnSubmit.Visible = true; BtnUpdate.Visible = false; txtCULBMemName.Focus(); if (CtrlModule.Text == "1") { ddlCULBMemNo.SelectedIndex = 0; } } } } catch (Exception ex) { throw ex; } }
public void GetAccInfo2() { try { Int64 AccNumber = Converter.GetLong(txtTrnAccNo.Text); A2ZACCOUNTDTO accgetDTO = (A2ZACCOUNTDTO.GetInfoAccNo(AccNumber)); if (accgetDTO.a == 0) { InvalidAccount(); txtTrnAccNo.Text = string.Empty; txtTrnAccNo.Focus(); return; } else { CtrlAccStatus.Text = Converter.GetString(accgetDTO.AccStatus); if (CtrlAccStatus.Text == "98") { txtTrnAccNo.Text = string.Empty; txtTrnAccNo.Focus(); TransferedAccount(); return; } if (CtrlAccStatus.Text == "99") { txtTrnAccNo.Text = string.Empty; txtTrnAccNo.Focus(); ClosedAccount(); return; } txtTrnStaffCode.Text = Converter.GetString(accgetDTO.MemberNo); CtrlTrnAccType.Text = Converter.GetString(accgetDTO.AccType); lblcls.Text = Converter.GetString(accgetDTO.AccAtyClass); lblTrnAtyClass.Text = Converter.GetString(accgetDTO.AccAtyClass); if (lblTrnAtyClass.Text == "5" || lblTrnAtyClass.Text == "6") { lblIntAmt.Visible = true; txtIntAmt.Visible = true; lblPrincAmt.Visible = true; txtPrincAmt.Visible = true; txtTrnAmount.ReadOnly = true; } if (lblAtyClass.Text == "7") { string input = txtTrnAccNo.Text; lblTrnPayType.Text = input.Substring(13, 3); int paytype = Converter.GetInteger(lblTrnPayType.Text); A2ZTRNCODEDTO get3DTO = (A2ZTRNCODEDTO.GetInformation99(paytype)); if (get3DTO.TrnCode > 0) { lblTrnAccTitle.Text = Converter.GetString(get3DTO.TrnDescription); } } else { lblTrnPayType.Text = "0"; Int16 AccType = Converter.GetSmallInteger(CtrlTrnAccType.Text); A2ZACCTYPEDTO get3DTO = (A2ZACCTYPEDTO.GetInformation(AccType)); if (get3DTO.AccTypeCode > 0) { lblTrnAccTitle.Text = Converter.GetString(get3DTO.AccTypeDescription); } } int MNo = Converter.GetInteger(txtTrnStaffCode.Text); A2ZMEMBERDTO get6DTO = (A2ZMEMBERDTO.GetInformation(0, 0, MNo)); if (get6DTO.NoRecord > 0) { lblTrnStaffName.Text = Converter.GetString(get6DTO.MemberName); } } } catch (Exception ex) { Page.ClientScript.RegisterStartupScript(this.GetType(), "scriptkey", "<script>alert('System Error.GetAccInfo Problem');</script>"); //throw ex; } }
protected void BtnUpdate_Click(object sender, EventArgs e) { A2ZMEMBERDTO UpDTO = new A2ZMEMBERDTO(); UpDTO.CuType = Converter.GetSmallInteger(lblCUType.Text); UpDTO.CreditUnionNo = Converter.GetInteger(lblCUNumber.Text); UpDTO.MemberNo = Converter.GetInteger(txtCULBMemNo.Text); UpDTO.MemberName = Converter.GetString(ddlCULBMemNo.SelectedItem.Text); UpDTO.MemberName = Converter.GetString(txtCULBMemName.Text); UpDTO.FatherName = Converter.GetString(txtFatherName.Text); UpDTO.MotherName = Converter.GetString(txtMotherName.Text); UpDTO.SpouseName = Converter.GetString(txtSpouseName.Text); UpDTO.Occupation = Converter.GetSmallInteger(ddlOccupation.SelectedValue); UpDTO.Nationality = Converter.GetSmallInteger(ddlNationality.SelectedValue); UpDTO.Gender = Converter.GetSmallInteger(ddlGender.SelectedValue); UpDTO.MemType = Converter.GetSmallInteger(ddlMemType.SelectedValue); UpDTO.Religion = Converter.GetSmallInteger(ddlReligion.SelectedValue); UpDTO.Nature = Converter.GetSmallInteger(ddlNature.SelectedValue); UpDTO.MaritalStatus = Converter.GetSmallInteger(ddlMaritalStatus.SelectedValue); if (txtOpenDate.Text != string.Empty) { DateTime opdate = DateTime.ParseExact(txtOpenDate.Text, "dd/MM/yyyy", System.Globalization.CultureInfo.InvariantCulture); UpDTO.OpenDate = opdate; } else { UpDTO.OpenDate = Converter.GetDateTime(System.DateTime.Now.ToLongDateString()); } if (txtDateOfBirth.Text != string.Empty) { DateTime datebirth = DateTime.ParseExact(txtDateOfBirth.Text, "dd/MM/yyyy", System.Globalization.CultureInfo.InvariantCulture); UpDTO.DateOfBirth = datebirth; } else { UpDTO.DateOfBirth = Converter.GetDateTime(System.DateTime.Now.ToLongDateString()); } UpDTO.PlaceofBirth = Converter.GetString(txtPlaceOfBirth.Text); UpDTO.PreAddressLine1 = Converter.GetString(txtAddressL1.Text); UpDTO.PreAddressLine2 = Converter.GetString(txtAddressL2.Text); UpDTO.PreAddressLine3 = Converter.GetString(txtAddressL3.Text); UpDTO.PreDivision = Converter.GetInteger(ddlDivision.SelectedValue); UpDTO.PreDistrict = Converter.GetInteger(ddlDistrict.SelectedValue); UpDTO.preThana = Converter.GetInteger(ddlThana.SelectedValue); UpDTO.PreTelephone = Converter.GetString(txtTelNo.Text); UpDTO.PreMobile = Converter.GetString(txtMobileNo.Text); UpDTO.PreEmail = Converter.GetString(txtEmail.Text); UpDTO.PerAddressLine1 = Converter.GetString(txtPerAddL1.Text); UpDTO.PerAddressLine2 = Converter.GetString(txtPerAddL2.Text); UpDTO.PerAddressLine3 = Converter.GetString(txtPerAddL3.Text); UpDTO.PerDivision = Converter.GetInteger(ddlPerDivision.SelectedValue); UpDTO.PerDistrict = Converter.GetInteger(ddlPerDistrict.SelectedValue); UpDTO.PerThana = Converter.GetInteger(ddlPerThana.SelectedValue); UpDTO.PerTelephone = Converter.GetString(txtPerTelNo.Text); UpDTO.PerMobile = Converter.GetString(txtPerMobNo.Text); UpDTO.PerEmail = Converter.GetString(txtPerEmail.Text); UpDTO.EmployerName = Converter.GetString(txtEmpName.Text); UpDTO.EmployerAddress = Converter.GetString(txtEmpAddress.Text); UpDTO.IntroducerNo1 = Converter.GetString(txtIntroducerMem1.Text); UpDTO.IntroducerName1 = Converter.GetString(txtIntroducerName1.Text); UpDTO.IntroducerNo2 = Converter.GetString(txtIntroduceMem2.Text); UpDTO.IntroducerName2 = Converter.GetString(txtIntroducerName2.Text); UpDTO.NationalIdNo = Converter.GetString(txtNationalID.Text); UpDTO.PassportNo = Converter.GetString(txtPassportNo.Text); if (txtPassportIssueDate.Text != string.Empty) { DateTime Issuedate = DateTime.ParseExact(txtPassportIssueDate.Text, "dd/MM/yyyy", System.Globalization.CultureInfo.InvariantCulture); UpDTO.PassportIssueDate = Issuedate; } else { UpDTO.PassportIssueDate = Converter.GetDateTime(System.DateTime.Now.ToShortDateString()); } if (txtPassportExpdate.Text != string.Empty) { DateTime Expdate = DateTime.ParseExact(txtPassportExpdate.Text, "dd/MM/yyyy", System.Globalization.CultureInfo.InvariantCulture); UpDTO.PassportExpiryDate = Expdate; } else { UpDTO.PassportExpiryDate = Converter.GetDateTime(System.DateTime.Now.ToShortDateString()); } UpDTO.PassportIssuePlace = Converter.GetString(txtPassportIssuePlace.Text); UpDTO.TIN = Converter.GetString(txtTIN.Text); if (txtLastTaxPdate.Text != string.Empty) { DateTime LTPaydate = DateTime.ParseExact(txtLastTaxPdate.Text, "dd/MM/yyyy", System.Globalization.CultureInfo.InvariantCulture); UpDTO.LastTaxPayDate = LTPaydate; } else { UpDTO.LastTaxPayDate = Converter.GetDateTime(System.DateTime.Now.ToShortDateString()); } int roweffect = A2ZMEMBERDTO.UpdateInformation(UpDTO); if (roweffect > 0) { if (CtrlModule.Text == "1") { string sqquery = @"SELECT MemNo,MemName FROM A2ZMEMBER WHERE CuNo='" + lblCUNumber.Text + "'and CuType='" + lblCUType.Text + "' GROUP BY MemNo,MemName"; ddlCULBMemNo = DataAccessLayer.BLL.CommonManager.Instance.FillDropDownListWithSelect(sqquery, ddlCULBMemNo, "A2ZCSMCUS"); ddlCULBMemNo.SelectedValue = "-Select-"; } txtCULBMemNo.Focus(); clearInfo(); BtnUpdate.Visible = false; BtnSubmit.Visible = true; } else { clearInfo(); } }
protected void BtnSubmit_Click(object sender, EventArgs e) { A2ZMEMBERDTO objDTO = new A2ZMEMBERDTO(); objDTO.CuType = Converter.GetSmallInteger(lblCUType.Text); objDTO.CreditUnionNo = Converter.GetInteger(lblCUNumber.Text); objDTO.MemberNo = Converter.GetInteger(txtCULBMemNo.Text); objDTO.MemberName = Converter.GetString(txtCULBMemName.Text); objDTO.FatherName = Converter.GetString(txtFatherName.Text); objDTO.MotherName = Converter.GetString(txtMotherName.Text); objDTO.SpouseName = Converter.GetString(txtSpouseName.Text); objDTO.Occupation = Converter.GetSmallInteger(ddlOccupation.SelectedValue); objDTO.Nationality = Converter.GetSmallInteger(ddlNationality.SelectedValue); objDTO.Gender = Converter.GetSmallInteger(ddlGender.SelectedValue); objDTO.MemType = Converter.GetSmallInteger(ddlMemType.SelectedValue); objDTO.Religion = Converter.GetSmallInteger(ddlReligion.SelectedValue); objDTO.Nature = Converter.GetSmallInteger(ddlNature.SelectedValue); objDTO.MaritalStatus = Converter.GetSmallInteger(ddlMaritalStatus.SelectedValue); if (txtOpenDate.Text != string.Empty) { DateTime opdate = DateTime.ParseExact(txtOpenDate.Text, "dd/MM/yyyy", System.Globalization.CultureInfo.InvariantCulture); objDTO.OpenDate = opdate; } else { objDTO.OpenDate = Converter.GetDateTime(System.DateTime.Now.ToLongDateString()); //Nullable < DateTime > nullDateTime; //DateTime? nullDateTime; //objDTO.OpenDate = Converter.GetDateTime(nullDateTime); //System.DateTime? MyDateTime; //MyDateTime = null; //var defaultDateTimeValue = default(DateTime?); //objDTO.OpenDate = Converter.GetDateTime(defaultDateTimeValue); } if (txtDateOfBirth.Text != string.Empty) { DateTime datebirth = DateTime.ParseExact(txtDateOfBirth.Text, "dd/MM/yyyy", System.Globalization.CultureInfo.InvariantCulture); objDTO.DateOfBirth = datebirth; } else { objDTO.DateOfBirth = Converter.GetDateTime(System.DateTime.Now.ToLongDateString()); } objDTO.PlaceofBirth = Converter.GetString(txtPlaceOfBirth.Text); objDTO.PreAddressLine1 = Converter.GetString(txtAddressL1.Text); objDTO.PreAddressLine2 = Converter.GetString(txtAddressL2.Text); objDTO.PreAddressLine3 = Converter.GetString(txtAddressL3.Text); objDTO.PreDivision = Converter.GetInteger(ddlDivision.SelectedValue); objDTO.PreDistrict = Converter.GetInteger(ddlDistrict.SelectedValue); objDTO.preThana = Converter.GetInteger(ddlThana.SelectedValue); objDTO.PreTelephone = Converter.GetString(txtTelNo.Text); objDTO.PreMobile = Converter.GetString(txtMobileNo.Text); objDTO.PreEmail = Converter.GetString(txtEmail.Text); objDTO.PerAddressLine1 = Converter.GetString(txtPerAddL1.Text); objDTO.PerAddressLine2 = Converter.GetString(txtPerAddL2.Text); objDTO.PerAddressLine3 = Converter.GetString(txtPerAddL3.Text); objDTO.PerDivision = Converter.GetInteger(ddlPerDivision.SelectedValue); objDTO.PerDistrict = Converter.GetInteger(ddlPerDistrict.SelectedValue); objDTO.PerThana = Converter.GetInteger(ddlPerThana.SelectedValue); objDTO.PerTelephone = Converter.GetString(txtPerTelNo.Text); objDTO.PerMobile = Converter.GetString(txtPerMobNo.Text); objDTO.PerEmail = Converter.GetString(txtPerEmail.Text); objDTO.EmployerName = Converter.GetString(txtEmpName.Text); objDTO.EmployerAddress = Converter.GetString(txtEmpAddress.Text); objDTO.IntroducerNo1 = Converter.GetString(txtIntroducerMem1.Text); objDTO.IntroducerName1 = Converter.GetString(txtIntroducerName1.Text); objDTO.IntroducerNo2 = Converter.GetString(txtIntroduceMem2.Text); objDTO.IntroducerName2 = Converter.GetString(txtIntroducerName2.Text); objDTO.NationalIdNo = Converter.GetString(txtNationalID.Text); objDTO.PassportNo = Converter.GetString(txtPassportNo.Text); if (txtPassportIssueDate.Text != string.Empty) { DateTime Issuedate = DateTime.ParseExact(txtPassportIssueDate.Text, "dd/MM/yyyy", System.Globalization.CultureInfo.InvariantCulture); objDTO.PassportIssueDate = Issuedate; } else { objDTO.PassportIssueDate = Converter.GetDateTime(System.DateTime.Now.ToShortDateString()); } if (txtPassportExpdate.Text != string.Empty) { DateTime Expdate = DateTime.ParseExact(txtPassportExpdate.Text, "dd/MM/yyyy", System.Globalization.CultureInfo.InvariantCulture); objDTO.PassportExpiryDate = Expdate; } else { objDTO.PassportExpiryDate = Converter.GetDateTime(System.DateTime.Now.ToShortDateString()); } objDTO.PassportIssuePlace = Converter.GetString(txtPassportIssuePlace.Text); objDTO.TIN = Converter.GetString(txtTIN.Text); if (txtLastTaxPdate.Text != string.Empty) { DateTime LTPaydate = DateTime.ParseExact(txtLastTaxPdate.Text, "dd/MM/yyyy", System.Globalization.CultureInfo.InvariantCulture); objDTO.LastTaxPayDate = LTPaydate; } else { objDTO.LastTaxPayDate = Converter.GetDateTime(System.DateTime.Now.ToShortDateString()); } int roweffect = A2ZMEMBERDTO.InsertInformation(objDTO); if (roweffect > 0) { txtCULBMemNo.Text = string.Empty; clearInfo(); txtCULBMemNo.Focus(); if (CtrlModule.Text == "1") { string sqquery = @"SELECT MemNo,MemName FROM A2ZMEMBER WHERE CuNo='" + lblCUNumber.Text + "'and CuType='" + lblCUType.Text + "' GROUP BY MemNo,MemName"; ddlCULBMemNo = DataAccessLayer.BLL.CommonManager.Instance.FillDropDownListWithSelect(sqquery, ddlCULBMemNo, "A2ZCSMCUS"); } ddlDivision.SelectedValue = "-Select-"; ddlDistrict.SelectedValue = "-Select-"; ddlThana.SelectedValue = "-Select-"; ddlPerDivision.SelectedValue = "-Select-"; ddlPerDistrict.SelectedValue = "-Select-"; ddlPerThana.SelectedValue = "-Select-"; } //SqlDateTime sqldatenull; //string sqlStmt = "insert into A2ZMEMBER (MemOpenDate) Values () "; //int rowEffect = Converter.GetInteger(DataAccessLayer.BLL.CommonManager.Instance.ExecuteNonQuery(sqlStmt, "A2ZCSMCUS")); //SqlCommand cmd = new SqlCommand(); //cmd.Parameters.Add(new SqlParameter("@Date", SqlDbType.DateTime)); //sqldatenull = SqlDateTime.Null; //if(txtOpenDate.Text=="") //{ // cmd.Parameters["@Date"].Value = sqldatenull; //} }
protected void txtTrnMemNo_TextChanged(object sender, EventArgs e) { try { if (txtTrnMemNo.Text != string.Empty && txtTrnCuNo.Text != string.Empty) { Int16 CuType = Converter.GetSmallInteger(lblTrnferCuType.Text); int CNo = Converter.GetSmallInteger(lblTrnferCuNo.Text); int MemNumber = Converter.GetInteger(txtTrnMemNo.Text); int CuNumber = Converter.GetInteger(hdnCuNumber.Text); A2ZMEMBERDTO getDTO = new A2ZMEMBERDTO(); getDTO = (A2ZMEMBERDTO.GetInformation(CuType, CNo, MemNumber)); //A2ZMEMBERDTO getDTO = new A2ZMEMBERDTO(); //getDTO = (A2ZMEMBERDTO.GetInfoMember(CuType, CNo, CuNumber, MemNumber)); if (getDTO.NoRecord > 0) { txtTrnMemNo.Text = Converter.GetString(getDTO.MemberNo); lblTrfMemName.Text = Converter.GetString(getDTO.MemberName); //ddlTrnMemNo.SelectedValue = Converter.GetString(getDTO.MemberNo); string a = txtAccNo.Text; string b = a.Substring(15, 1); if (txtAccType.Text == "53") { string qry1 = "SELECT Id,AccNo FROM A2ZACCOUNT where CuType='" + lblTrnferCuType.Text + "' and CuNo='" + lblTrnferCuNo.Text + "' and MemNo='" + txtTrnMemNo.Text + "' and AccType='" + txtAccType.Text + "' and Right(AccNo,1) = '" + b + "'"; DataTable dt1 = DataAccessLayer.BLL.CommonManager.Instance.GetDataTableByQuery(qry1, "A2ZCSMCUS"); if (dt1.Rows.Count > 0) { NotAllowAccount(); txtTrnMemNo.Text = string.Empty; txtTrnMemNo.Focus(); return; } else { return; } } string qry = "SELECT Id,AccNo FROM A2ZACCOUNT where CuType='" + lblTrnferCuType.Text + "' and CuNo='" + lblTrnferCuNo.Text + "' and MemNo='" + txtTrnMemNo.Text + "' and AccType='" + txtAccType.Text + "'"; DataTable dt = DataAccessLayer.BLL.CommonManager.Instance.GetDataTableByQuery(qry, "A2ZCSMCUS"); if (dt.Rows.Count > 0) { if (lblAccFlag.Text == "1" || lblAccFlag.Text == "2") { MultiAccount(); txtTrnMemNo.Text = string.Empty; txtTrnMemNo.Focus(); return; } } else { if (lblAccessType1.Text == "0" && lblTrnferCuType.Text == "1") { NotAllowAccount(); txtTrnMemNo.Text = string.Empty; txtTrnMemNo.Focus(); return; } if (lblAccessType2.Text == "0" && lblTrnferCuType.Text == "2") { NotAllowAccount(); txtTrnMemNo.Text = string.Empty; txtTrnMemNo.Focus(); return; } if (lblAccessType3.Text == "0" && lblTrnferCuType.Text == "3") { NotAllowAccount(); txtTrnMemNo.Text = string.Empty; txtTrnMemNo.Focus(); return; } } } else { InvalidMemNo(); txtTrnMemNo.Text = string.Empty; txtTrnMemNo.Focus(); } } } catch (Exception ex) { Page.ClientScript.RegisterStartupScript(this.GetType(), "scriptkey", "<script>alert('System Error.txtTrnMemNo_TextChanged Problem');</script>"); //throw ex; } }
public void GetAccInfo1() { try { Int64 AccNumber = Converter.GetLong(txtAccNo.Text); A2ZACCOUNTDTO accgetDTO = (A2ZACCOUNTDTO.GetInfoAccNo(AccNumber)); if (accgetDTO.a == 0) { InvalidAccount(); txtAccNo.Text = string.Empty; txtAccNo.Focus(); return; } else { CtrlAccStatus.Text = Converter.GetString(accgetDTO.AccStatus); if (CtrlAccStatus.Text == "98") { txtAccNo.Text = string.Empty; txtAccNo.Focus(); TransferedAccount(); return; } if (CtrlAccStatus.Text == "99") { txtAccNo.Text = string.Empty; txtAccNo.Focus(); ClosedAccount(); return; } CtrlLadgerBalance.Text = Converter.GetString(String.Format("{0:0,0.00}", accgetDTO.AccBalance)); CtrlLienAmt.Text = Converter.GetString(String.Format("{0:0,0.00}", accgetDTO.AccLienAmt)); CtrlLoanSancAmt.Text = Converter.GetString(String.Format("{0:0,0.00}", accgetDTO.LoanAmount)); CtrlAccType.Text = Converter.GetString(accgetDTO.AccType); lblcls.Text = Converter.GetString(accgetDTO.AccAtyClass); UnPostValue(); lblCuType.Text = Converter.GetString(accgetDTO.CuType); lblCuNo.Text = Converter.GetString(accgetDTO.CuNo); txtCreditUNo.Text = (lblCuType.Text + "-" + lblCuNo.Text); txtMemNo.Text = Converter.GetString(accgetDTO.MemberNo); lblAtyClass.Text = Converter.GetString(accgetDTO.AccAtyClass); if (lblAtyClass.Text == "7") { string input = txtAccNo.Text; lblPayType.Text = input.Substring(13, 3); int paytype = Converter.GetInteger(lblPayType.Text); A2ZTRNCODEDTO get3DTO = (A2ZTRNCODEDTO.GetInformation99(paytype)); if (get3DTO.TrnCode > 0) { lblTrnCode.Text = Converter.GetString(get3DTO.TrnCode); lblAccTitle.Text = Converter.GetString(get3DTO.TrnDescription); } } else { lblPayType.Text = "0"; Int16 AccType = Converter.GetSmallInteger(CtrlAccType.Text); A2ZACCTYPEDTO get3DTO = (A2ZACCTYPEDTO.GetInformation(AccType)); if (get3DTO.AccTypeCode > 0) { lblAccTitle.Text = Converter.GetString(get3DTO.AccTypeDescription); } int AType = Converter.GetInteger(CtrlAccType.Text); A2ZTRNCODEDTO get4DTO = (A2ZTRNCODEDTO.GetInformation01(AType)); if (get4DTO.TrnCode > 0) { lblTrnCode.Text = Converter.GetString(get4DTO.TrnCode); } } Int16 CType = Converter.GetSmallInteger(lblCuType.Text); int CNo = Converter.GetInteger(lblCuNo.Text); A2ZCUNIONDTO get5DTO = (A2ZCUNIONDTO.GetInformation(CType, CNo)); if (get5DTO.NoRecord > 0) { lblCuName.Text = Converter.GetString(get5DTO.CreditUnionName); } Int16 CUType = Converter.GetSmallInteger(lblCuType.Text); int CUNo = Converter.GetInteger(lblCuNo.Text); int MNo = Converter.GetInteger(txtMemNo.Text); A2ZMEMBERDTO get6DTO = (A2ZMEMBERDTO.GetInformation(CUType, CUNo, MNo)); if (get6DTO.NoRecord > 0) { lblMemName.Text = Converter.GetString(get6DTO.MemberName); } } } catch (Exception ex) { Page.ClientScript.RegisterStartupScript(this.GetType(), "scriptkey", "<script>alert('System Error.GetAccInfo Problem');</script>"); //throw ex; } }