protected void txtCreditUNo_TextChanged(object sender, EventArgs e)
{
if (txtCreditUNo.Text != string.Empty)
{
txtMemNo.Text = string.Empty;
lblMemName.Text = string.Empty;
A2ZCUNIONDTO getDTO = new A2ZCUNIONDTO();
if (chkOldSearch.Checked == true)
{
int CN = Converter.GetInteger(txtCreditUNo.Text);
hdnCuNumber.Text = Converter.GetString(CN);
getDTO = (A2ZCUNIONDTO.GetOldInfo(CN));
}
else
{
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);
getDTO = (A2ZCUNIONDTO.GetInformation(CType, 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);
txtAccNo.Text = string.Empty;
txtMemNo.Focus();
}
else
{
txtAccNo.Text = string.Empty;
txtCreditUNo.Text = string.Empty;
txtCreditUNo.Focus();
return;
}
}
}
protected void PrevUpdateInfo()
{
A2ZCUNIONDTO objDTO = new A2ZCUNIONDTO();
objDTO.CuType = Converter.GetSmallInteger(lblNewCuType.Text);
if (objDTO.CuType == 3)
{
Int16 CuType = Converter.GetSmallInteger(lblAffiCuType.Text);
int CuNo = Converter.GetInteger(lblAffiCuNo.Text);
objDTO = (A2ZCUNIONDTO.GetInformation(CuType, CuNo));
if (objDTO.CreditUnionNo > 0)
{
objDTO.CuReguCuType = Converter.GetSmallInteger(lblReguCuType.Text);
objDTO.CuReguCuNo = Converter.GetInteger(lblReguCuNo.Text);
objDTO.CuReguCuTypeName = Converter.GetString(lblReguCuTypeName.Text);
var prm = new object[5];
prm[0] = objDTO.CuType;
prm[1] = objDTO.CreditUnionNo;
prm[2] = objDTO.CuReguCuType;
prm[3] = objDTO.CuReguCuTypeName;
prm[4] = objDTO.CuReguCuNo;
int result = Converter.GetInteger(CommonManager.Instance.GetScalarValueBySp("Sp_CSCUPreviousDataUpdate", prm, "A2ZCSMCUS"));
if (result == 0)
{
}
//int roweffect = A2ZCUNIONDTO.UpdateInformation(objDTO);
}
Int16 CType = Converter.GetSmallInteger(lblAssoCuType.Text);
int CNo = Converter.GetInteger(lblAssoCuNo.Text);
objDTO = (A2ZCUNIONDTO.GetInformation(CType, CNo));
if (objDTO.CreditUnionNo > 0)
{
objDTO.CuReguCuType = Converter.GetSmallInteger(lblReguCuType.Text);
objDTO.CuReguCuNo = Converter.GetInteger(lblReguCuNo.Text);
objDTO.CuReguCuTypeName = Converter.GetString(lblReguCuTypeName.Text);
var prm = new object[5];
prm[0] = objDTO.CuType;
prm[1] = objDTO.CreditUnionNo;
prm[2] = objDTO.CuReguCuType;
prm[3] = objDTO.CuReguCuTypeName;
prm[4] = objDTO.CuReguCuNo;
int result = Converter.GetInteger(CommonManager.Instance.GetScalarValueBySp("Sp_CSCUPreviousDataUpdate", prm, "A2ZCSMCUS"));
if (result == 0)
{
}
//int roweffect = A2ZCUNIONDTO.UpdateInformation(objDTO);
}
}
}
private void NewMemberInfoHelp()
{
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;
}
gvSearchMEMDetail();
gvSearchMEMInfo.Visible = true;
txtSearchMemName.ReadOnly = false;
}
}
protected void ddlCreditUNo_SelectedIndexChanged(object sender, EventArgs e)
{
if (ddlCreditUNo.SelectedValue == "-Select-")
{
txtCreditUNo.Text = string.Empty;
txtMemNo.Focus();
ddlMemNo.SelectedIndex = 0;
return;
}
try
{
if (ddlCreditUNo.SelectedValue != "-Select-")
{
txtHidden.Text = Converter.GetString(ddlCreditUNo.SelectedValue);
string c = "";
int a = txtHidden.Text.Length;
string b = txtHidden.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(re);
lblCuType.Text = Converter.GetString(CuType);
int CNo = Converter.GetSmallInteger(re1);
lblCuNo.Text = Converter.GetString(CNo);
string sqquery = @"SELECT MemNo,MemName FROM A2ZMEMBER WHERE CuNo='" + CNo + "'and CuType='" + CuType + "' GROUP BY MemNo,MemName";
ddlMemNo = DataAccessLayer.BLL.CommonManager.Instance.FillDropDownListWithSelect(sqquery, ddlMemNo, "A2ZCSMCUS");
A2ZCUNIONDTO getDTO = (A2ZCUNIONDTO.GetInformation(CuType, CNo));
if (getDTO.CreditUnionNo > 0)
{
txtCreditUNo.Text = Converter.GetString(txtHidden.Text);
txtCreditUNo.Text = lblCuType.Text + "-" + lblCuNo.Text;
txtMemNo.Focus();
}
else
{
ddlCreditUNo.SelectedValue = "-Select-";
}
}
}
catch (Exception ex)
{
throw ex;
}
}
protected void AccGetInfo()
{
try
{
Int64 AccNumber = Converter.GetLong(txtAccNo.Text);
A2ZACCOUNTDTO accgetDTO = (A2ZACCOUNTDTO.GetInfoAccNo(AccNumber));
if (accgetDTO.a == 0 || accgetDTO.AccStatus > 97)
{
txtAccType.Text = string.Empty;
ddlAcType.SelectedIndex = 0;
lblAccTitle.Text = string.Empty;
lblCuName.Text = string.Empty;
lblMemName.Text = string.Empty;
txtCreditUNo.Text = string.Empty;
txtMemNo.Text = string.Empty;
txtAccNo.Text = string.Empty;
txtAccNo.Focus();
return;
}
else
{
txtAccType.Text = Converter.GetString(accgetDTO.AccType);
if (txtAccType.Text != "0")
{
ddlAcType.SelectedValue = txtAccType.Text;
}
lblCuType.Text = Converter.GetString(accgetDTO.CuType);
lblCuNo.Text = Converter.GetString(accgetDTO.CuNo);
txtCreditUNo.Text = (lblCuType.Text + "-" + lblCuNo.Text);
txtMemNo.Text = Converter.GetString(accgetDTO.MemberNo);
lblMemName.Text = Converter.GetString(accgetDTO.MemberName);
lblcls.Text = Converter.GetString(accgetDTO.AccAtyClass);
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);
}
}
}
catch (Exception ex)
{
ClearText();
Page.ClientScript.RegisterStartupScript(this.GetType(), "scriptkey", "<script>alert('System Error.AccGetInfo Problem');</script>");
//throw ex;
}
}
protected void txtCreditUNo_TextChanged(object sender, EventArgs e)
{
try
{
if (txtCreditUNo.Text != string.Empty)
{
int CNo = Converter.GetInteger(txtCreditUNo.Text);
A2ZCUNIONDTO getDTO = (A2ZCUNIONDTO.GetInformation(CNo));
if (getDTO.CreditUnionNo > 0)
{
txtCreditUNo.Text = Converter.GetString(getDTO.CreditUnionNo);
txtCreUName.Text = Converter.GetString(getDTO.CreditUnionName);
ddlCreditUNo.SelectedValue = Converter.GetString(getDTO.CreditUnionNo);
DateTime dt = Converter.GetDateTime(getDTO.opendate);
string date = dt.ToString("dd/MM/yyyy");
txtCuOpenDate.Text = date;
//txtCuOpenDate.Text = Converter.GetString(getDTO.opendate);
ddlCuMemberFlag.SelectedValue = Converter.GetString(getDTO.MemberFlag);
ddlCuMemberType.SelectedValue = Converter.GetString(getDTO.MemberType);
txtCuCertificateNo.Text = Converter.GetString(getDTO.CertificateNo);
txtCuAddressL1.Text = Converter.GetString(getDTO.AddressL1);
txtCuAddressL2.Text = Converter.GetString(getDTO.AddressL2);
txtCuAddressL3.Text = Converter.GetString(getDTO.AddressL3);
txtCuTelNo.Text = Converter.GetString(getDTO.TelephoneNo);
txtCuMobileNo.Text = Converter.GetString(getDTO.MobileNo);
txtCuFax.Text = Converter.GetString(getDTO.Fax);
txtCuEmail.Text = Converter.GetString(getDTO.email);
ddlDivision.SelectedValue = Converter.GetString(getDTO.Division);
ddlDistrict.SelectedValue = Converter.GetString(getDTO.District);
ddlThana.SelectedValue = Converter.GetString(getDTO.Thana);
BtnCreUnionSubmit.Visible = false;
BtnCreUnionUpdate.Visible = true;
txtCreUName.Focus();
}
else
{
clearInfo();
//txtCreUName.Text = string.Empty;
ddlCreditUNo.SelectedValue = "-Select-";
ddlCuMemberFlag.SelectedValue = "0";
ddlCuMemberType.SelectedValue = "0";
BtnCreUnionSubmit.Visible = true;
BtnCreUnionUpdate.Visible = false;
txtCreUName.Focus();
}
}
}
catch (Exception ex)
{
throw ex;
}
}
protected void txtCrUnion_TextChanged(object sender, EventArgs e)
{
try
{
if (txtCrUnion.Text != string.Empty)
{
string c = "";
int a = txtCrUnion.Text.Length;
string b = txtCrUnion.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(re);
int CNo = Converter.GetSmallInteger(re1);
A2ZCUNIONDTO getDTO = (A2ZCUNIONDTO.GetInformation(CuType, CNo));
if (getDTO.CreditUnionNo > 0)
{
hdnCashCode.Text = Converter.GetString(getDTO.GLCashCode);
if (lblModule.Text == "6" && hdnCashCode.Text != lblCashCode.Text)
{
txtCrUnion.Text = string.Empty;
txtCrUnion.Focus();
InvalidCuNoMSG();
return;
}
lblCuNo.Text = Converter.GetString(getDTO.CreditUnionNo);
lblCuType.Text = Converter.GetString(getDTO.CuType);
string sqlquery = "SELECT lTrim(str(CuType) +lTrim(str(CuNo))) As CuNo,CuName from A2ZCUNION where CuType='" + CuType + "' ORDER BY CuName ASC";
ddlCrUnion = DataAccessLayer.BLL.CommonManager.Instance.FillDropDownListWithSelect(sqlquery, ddlCrUnion, "A2ZCSMCUS");
ddlCrUnion.SelectedValue = Converter.GetString(txtCrUnion.Text);
}
}
}
catch (Exception ex)
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "scriptkey", "<script>alert('System Error.txtCrUnion_TextChanged Problem');</script>");
//throw ex;
}
}
protected void txtCrUnion_TextChanged(object sender, EventArgs e)
{
try
{
if (txtCrUnion.Text != string.Empty)
{
string c = "";
int a = txtCrUnion.Text.Length;
string b = txtCrUnion.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(re);
int CNo = Converter.GetSmallInteger(re1);
A2ZCUNIONDTO getDTO = (A2ZCUNIONDTO.GetInformation(CuType, CNo));
if (getDTO.CreditUnionNo > 0)
{
hdnCashCode.Text = Converter.GetString(getDTO.GLCashCode);
lblCuName.Text = Converter.GetString(getDTO.CreditUnionName);
if (lblModule.Text == "6" && hdnCashCode.Text != lblCashCode.Text)
{
txtCrUnion.Text = string.Empty;
txtCrUnion.Focus();
InvalidCuNoMSG();
return;
}
lblCuNo.Text = Converter.GetString(getDTO.CreditUnionNo);
lblCuType.Text = Converter.GetString(getDTO.CuType);
}
}
}
catch (Exception ex)
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "scriptkey", "<script>alert('System Error.txtCrUnion_TextChanged Problem');</script>");
//throw ex;
}
}
public void ShowRecords()
{
Int16 CuType = Converter.GetSmallInteger(0);
int CNo = Converter.GetInteger(txtCreditUNo.Text);
A2ZCUNIONDTO getDTO = (A2ZCUNIONDTO.GetInformation(CuType, CNo));
if (getDTO.CreditUnionNo > 0)
{
txtCreditUNo.Text = Converter.GetString(getDTO.CreditUnionNo);
txtCreUName.Text = Converter.GetString(getDTO.CreditUnionName);
ddlCreditUNo.SelectedValue = Converter.GetString(getDTO.CreditUnionNo);
DateTime dt = Converter.GetDateTime(getDTO.opendate);
string date = dt.ToString("dd/MM/yyyy");
txtCuOpenDate.Text = date;
GetOpenDate.Text = date;
//txtCuOpenDate.Text = Converter.GetString(getDTO.opendate);
//ddlCuMemberFlag.SelectedValue = Converter.GetString(getDTO.MemberFlag);
txtCuCertificateNo.Text = Converter.GetString(getDTO.CertificateNo);
txtGLCashCode.Text = Converter.GetString(getDTO.GLCashCode);
txtCuAddressL1.Text = Converter.GetString(getDTO.AddressL1);
txtCuAddressL2.Text = Converter.GetString(getDTO.AddressL2);
txtCuAddressL3.Text = Converter.GetString(getDTO.AddressL3);
txtCuTelNo.Text = Converter.GetString(getDTO.TelephoneNo);
txtCuMobileNo.Text = Converter.GetString(getDTO.MobileNo);
txtCuFax.Text = Converter.GetString(getDTO.Fax);
txtCuEmail.Text = Converter.GetString(getDTO.email);
ddlDivision.SelectedValue = Converter.GetString(getDTO.Division);
ddlDistrict.SelectedValue = Converter.GetString(getDTO.District);
ddlThana.SelectedValue = Converter.GetString(getDTO.Thana);
ddlUpzila.SelectedValue = Converter.GetString(getDTO.Upzila);
BtnCreUnionUpdate.Visible = true;
txtCreUName.Focus();
}
else
{
clearInfo();
//txtCreUName.Text = string.Empty;
ddlCreditUNo.SelectedValue = "-Select-";
//ddlCuMemberFlag.SelectedValue = "0";
BtnCreUnionUpdate.Visible = false;
txtCreUName.Focus();
}
}
protected void txtCuNo_TextChanged(object sender, EventArgs e)
{
try
{
if (txtCuNo.Text != string.Empty)
{
ibtnUpload.Visible = true;
BtnUpdate.Visible = false;
ImgPicture.ImageUrl = "~/Images/index.jpg";
string c = "";
int a = txtCuNo.Text.Length;
string b = txtCuNo.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(re);
int CNo = Converter.GetSmallInteger(re1);
lblhideCuNo.Text = Converter.GetString(CNo);
lblhideCutype.Text = Converter.GetString(CuType);
A2ZCUNIONDTO getDTO = (A2ZCUNIONDTO.GetInformation(CuType, CNo));
if (getDTO.CreditUnionNo > 0)
{
lblCuName.Text = Converter.GetString(getDTO.CreditUnionName);
txtCuNo.Text = (c + "-" + d);
txtMemNo.Focus();
}
}
}
catch (Exception ex)
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "scriptkey", "<script>alert('System Error.txtCuNo_TextChanged Problem');</script>");
//throw ex;
}
}
protected void ddlCreditUNo_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
if (ddlCreditUNo.SelectedValue != "-Select-")
{
txtHidden.Text = Converter.GetString(ddlCreditUNo.SelectedValue);
string c = "";
int a = txtHidden.Text.Length;
string b = txtHidden.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(re);
int CNo = Converter.GetSmallInteger(re1);
lblhideCuNo.Text = Converter.GetString(CNo);
lblhideCutype.Text = Converter.GetString(CuType);
A2ZCUNIONDTO getDTO = (A2ZCUNIONDTO.GetInformation(CuType, CNo));
if (getDTO.CreditUnionNo > 0)
{
txtCuNo.Text = Converter.GetString(txtHidden.Text);
txtCuNo.Text = (c + "-" + d);
Memdropdown();
txtMemNo.Focus();
}
}
}
catch (Exception ex)
{
throw ex;
}
}
protected void txtCuNo_TextChanged(object sender, EventArgs e)
{
try
{
if (txtCuNo.Text != string.Empty)
{
string c = "";
int a = txtCuNo.Text.Length;
string b = txtCuNo.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(re);
int CNo = Converter.GetSmallInteger(re1);
lblhideCuNo.Text = Converter.GetString(CNo);
lblhideCutype.Text = Converter.GetString(CuType);
A2ZCUNIONDTO getDTO = (A2ZCUNIONDTO.GetInformation(CuType, CNo));
if (getDTO.CreditUnionNo > 0)
{
//string sqlquery = "SELECT lTrim(str(CuType) +lTrim(str(CuNo))) As CuNo,CuName from A2ZCUNION where CuType='" + CuType + "'";
//ddlCreditUNo = DataAccessLayer.BLL.CommonManager.Instance.FillDropDownListWithSelect(sqlquery, ddlCreditUNo, "A2ZCSMCUS");
ddlCreditUNo.SelectedValue = Converter.GetString(lblhideCutype.Text + lblhideCuNo.Text);
txtCuNo.Text = (c + "-" + d);
Memdropdown();
}
}
}
catch (Exception ex)
{
throw ex;
}
}
protected void ddlCrUnion_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
if (ddlCrUnion.SelectedValue != "-Select-")
{
txtHidden.Text = Converter.GetString(ddlCrUnion.SelectedValue);
string c = "";
int a = txtHidden.Text.Length;
string b = txtHidden.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(re);
int CNo = Converter.GetSmallInteger(re1);
A2ZCUNIONDTO getDTO = (A2ZCUNIONDTO.GetInformation(CuType, CNo));
if (getDTO.CreditUnionNo > 0)
{
lblCuNo.Text = Converter.GetString(getDTO.CreditUnionNo);
lblCuType.Text = Converter.GetString(getDTO.CuType);
txtCrUnion.Text = Converter.GetString(txtHidden.Text);
}
}
}
catch (Exception ex)
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "scriptkey", "<script>alert('System Error.ddlCrUnion_SelectedIndexChanged Problem');</script>");
//throw ex;
}
}
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;
}
}
public void GetAccInfo()
{
try
{
Int64 AccNumber = Converter.GetLong(txtAccNo.Text);
A2ZACCOUNTDTO accgetDTO = (A2ZACCOUNTDTO.GetInfoAccNo(AccNumber));
if (accgetDTO.a == 0)
{
InvalidAccountNoMSG();
txtAccNo.Text = string.Empty;
txtAccNo.Focus();
return;
}
else
{
CtrlAccStatus.Text = Converter.GetString(accgetDTO.AccStatus);
if (CtrlAccStatus.Text == "98")
{
txtAccNo.Text = string.Empty;
txtAccNo.Focus();
AccTransferedMSG();
return;
}
Int16 AccStat = Converter.GetSmallInteger(CtrlAccStatus.Text);
A2ZACCSTATUSDTO get0DTO = (A2ZACCSTATUSDTO.GetInformation(AccStat));
if (get0DTO.AccStatusCode > 0)
{
txtstat.Text = Converter.GetString(get0DTO.AccStatusDescription);
}
lblCuType.Text = Converter.GetString(accgetDTO.CuType);
lblCuNo.Text = Converter.GetString(accgetDTO.CuNo);
txtCreditUNo.Text = (lblCuType.Text + "-" + lblCuNo.Text);
txtCULBMemNo.Text = Converter.GetString(accgetDTO.MemberNo);
CtrlAccType.Text = Converter.GetString(accgetDTO.AccType);
lblcls.Text = Converter.GetString(accgetDTO.AccAtyClass);
if (lblcls.Text == "7")
{
string input2 = txtAccNo.Text;
string paytype = input2.Substring(12, 4);
int atyclass = Converter.GetInteger(lblcls.Text);
int paycode = Converter.GetInteger(paytype);
A2ZPAYTYPEDTO get1DTO = (A2ZPAYTYPEDTO.GetInformation(atyclass, paycode));
if (get1DTO.PayTypeCode > 0)
{
lblAccTitle.Text = Converter.GetString(get1DTO.PayTypeDescription);
int pcode = Converter.GetInteger(paytype);
A2ZTRNCODEDTO get2DTO = (A2ZTRNCODEDTO.GetInformation99(pcode));
if (get2DTO.TrnCode > 0)
{
lblTrnCode.Text = Converter.GetString(get2DTO.TrnCode);
}
}
}
else
{
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)
{
hdnCashCode.Text = Converter.GetString(get5DTO.GLCashCode);
if (lblModule.Text == "06" && hdnCashCode.Text != lblCashCode.Text)
{
txtAccNo.Text = string.Empty;
txtCreditUNo.Text = string.Empty;
txtCULBMemNo.Text = string.Empty;
txtAccNo.Focus();
AccessDeniedMSG();
return;
}
lblCuName.Text = Converter.GetString(get5DTO.CreditUnionName);
}
Int16 CUType = Converter.GetSmallInteger(lblCuType.Text);
int CUNo = Converter.GetInteger(lblCuNo.Text);
int MNo = Converter.GetInteger(txtCULBMemNo.Text);
A2ZMEMBERDTO get6DTO = (A2ZMEMBERDTO.GetInformation(CUType, CUNo, MNo));
if (get6DTO.NoRecord > 0)
{
lblMemName.Text = Converter.GetString(get6DTO.MemberName);
}
if (lblcls.Text == "4")
{
DateTime dt0 = Converter.GetDateTime(accgetDTO.LastTrnDate);
string date0 = dt0.ToString("dd/MM/yyyy");
tLastTrnDate.Text = date0;
if (tLastTrnDate.Text == "01/01/0001")
{
tLastTrnDate.Text = string.Empty;
}
DateTime dt12 = Converter.GetDateTime(accgetDTO.MatruityDate);
string date12 = dt12.ToString("dd/MM/yyyy");
tMaturityDt.Text = date12;
if (tMaturityDt.Text == "01/01/0001")
{
tMaturityDt.Text = string.Empty;
}
tAccPeriod.Text = Converter.GetString(accgetDTO.Period);
tTotalDeposit.Text = Converter.GetString(String.Format("{0:0,0.00}", accgetDTO.TotDepositAmount));
tMthDeposit.Text = Converter.GetString(String.Format("{0:0,0.00}", accgetDTO.DepositAmount));
DateTime TrnDate = DateTime.ParseExact(lblProcDate.Text, "dd/MM/yyyy", System.Globalization.CultureInfo.InvariantCulture);
Int16 CuType = Converter.GetSmallInteger(lblCuType.Text);
int CuNo = Converter.GetInteger(lblCuNo.Text);
Int16 Acctype = Converter.GetSmallInteger(CtrlAccType.Text);
Int64 AccNo = Converter.GetLong(txtAccNo.Text);
int MemNumber = Converter.GetInteger(txtCULBMemNo.Text);
A2ZPENSIONDEFAULTERDTO getDTO = (A2ZPENSIONDEFAULTERDTO.GetPensionDepInformation(TrnDate, CuType, CuNo, MemNumber, Acctype, AccNumber));
if (getDTO.CuType > 0)
{
tDueDepositAmt.Text = Converter.GetString(String.Format("{0:0,0.00}", (getDTO.DueDepositAmt)));
tUptoDate.Text = Converter.GetString(getDTO.UptoDate);
}
}
}
string qry = "SELECT Id,AccNo,AccOpenDate,AccMatureDate,AccRenwlDate,AccPeriod,AccBalance,AccOrgAmt,AccPrincipal,AccIntRate,AccLoanSancAmt,AccLoanSancDate,AccDisbAmt,AccDisbDate,AccNoInstl,AccLoanInstlAmt,AccLoanLastInstlAmt,AccAtyClass,AccOldNumber,AccCertNo,AccFixedMthInt FROM A2ZACCOUNT where AccType ='" + CtrlAccType.Text + "' and CuType='" + lblCuType.Text + "' and CuNo='" + lblCuNo.Text + "' and MemNo='" + txtCULBMemNo.Text + "' and AccNo ='" + txtAccNo.Text + "'";
DataTable dt = DataAccessLayer.BLL.CommonManager.Instance.GetDataTableByQuery(qry, "A2ZCSMCUS");
if (dt.Rows.Count > 0)
{
//For Report Header Parameter class wise
// Loan Information
tAccBalance.Text = Converter.GetString(dt.Rows[0]["AccBalance"]);
tAccLoanSancAmt.Text = Converter.GetString(dt.Rows[0]["AccLoanSancAmt"]);
tAccLoanSancDate.Text = Converter.GetString(dt.Rows[0]["AccLoanSancDate"]);
tAccDisbAmt.Text = Converter.GetString(dt.Rows[0]["AccDisbAmt"]);
tAccDisbDate.Text = Converter.GetString(dt.Rows[0]["AccDisbDate"]);
tAccNoInstl.Text = Converter.GetString(dt.Rows[0]["AccNoInstl"]);
tAccLoanInstlAmt.Text = Converter.GetString(dt.Rows[0]["AccLoanInstlAmt"]);
tAccLoanLastInstlAmt.Text = Converter.GetString(dt.Rows[0]["AccLoanLastInstlAmt"]);
tOpenDt.Text = Converter.GetString(dt.Rows[0]["AccOpenDate"]);
tClass.Text = Converter.GetString(dt.Rows[0]["AccAtyClass"]);
// FOR A/C TYPE Class
int AccTypeClass = Converter.GetSmallInteger(tClass.Text);
if (AccTypeClass == 2 || AccTypeClass == 3)
{
// tOpenDt.Text = Converter.GetString(dt.Rows[0]["AccOpenDate"]);
tMaturityDt.Text = Converter.GetString(dt.Rows[0]["AccMatureDate"]);
tRenewalDt.Text = Converter.GetString(dt.Rows[0]["AccRenwlDate"]);
tAccPeriod.Text = Converter.GetString(dt.Rows[0]["AccPeriod"]);
tOrgAmt.Text = Converter.GetString(dt.Rows[0]["AccOrgAmt"]);
tPrincipleAmt.Text = Converter.GetString(dt.Rows[0]["AccPrincipal"]);
tOldAccount.Text = Converter.GetString(dt.Rows[0]["AccOldNumber"]);
tAccCertNo.Text = Converter.GetString(dt.Rows[0]["AccCertNo"]);
}
if (AccTypeClass == 2)
{
// Int Rate
tIntRate.Text = Converter.GetString(dt.Rows[0]["AccIntRate"]);
}
if (AccTypeClass == 3)
{
// Monthly Benefit
tAccFixedMthInt.Text = Converter.GetString(dt.Rows[0]["AccFixedMthInt"]);
}
// decimal b = Converter.GetDecimal(dt.Rows[0]["AccBalance"]);
}
}
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 txtTrnCuNo_TextChanged(object sender, EventArgs e)
{
try
{
if (txtTrnCuNo.Text != string.Empty)
{
int CN = Converter.GetInteger(txtTrnCuNo.Text);
hdnCuNumber.Text = Converter.GetString(CN);
string c = "";
int a = txtTrnCuNo.Text.Length;
string b = txtTrnCuNo.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(re);
lblTrnferCuType.Text = Converter.GetString(CuType);
int CNo = Converter.GetSmallInteger(re1);
lblTrnferCuNo.Text = Converter.GetString(CNo);
A2ZCUNIONDTO getDTO = (A2ZCUNIONDTO.GetInformation(CuType, CNo));
//if (getDTO.CreditUnionNo > 0)
//A2ZCUNIONDTO getDTO = (A2ZCUNIONDTO.GetInfo(CN));
if (getDTO.NoRecord > 0)
{
lblTrnferCuType.Text = Converter.GetString(getDTO.CuType);
lblCuTypeName.Text = Converter.GetString(getDTO.CreditUnionName);
lblTrnferCuNo.Text = Converter.GetString(getDTO.CreditUnionNo);
lblTrfCuName.Text = Converter.GetString(getDTO.CreditUnionName);
if (getDTO.CuStatus == 9)
{
if (getDTO.CuReguCuType == 0)
{
lblCuTypeName.Text = Converter.GetString(getDTO.CuAssoCuTypeName);
lblCuNo.Text = Converter.GetString(getDTO.CuAssoCuNo);
lblCuType.Text = Converter.GetString(getDTO.CuAssoCuType);
}
else
{
lblCuTypeName.Text = Converter.GetString(getDTO.CuReguCuTypeName);
lblCuNo.Text = Converter.GetString(getDTO.CuReguCuNo);
lblCuType.Text = Converter.GetString(getDTO.CuReguCuType);
}
DisplayMessage();
txtCreditUNo.Text = string.Empty;
txtCreditUNo.Focus();
return;
}
txtTrnMemNo.Focus();
txtTrnCuNo.Text = lblTrnferCuType.Text + "-" + lblTrnferCuNo.Text;
}
else
{
InvalidCuNo();
txtCreditUNo.Text = string.Empty;
txtCreditUNo.Focus();
}
}
}
catch (Exception ex)
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "scriptkey", "<script>alert('System Error.txtTrnCuNo_TextChanged Problem');</script>");
//throw ex;
}
}
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 ddlCreditUNo_SelectedIndexChanged(object sender, EventArgs e)
{
if (ddlCreditUNo.SelectedValue == "-Select-")
{
clearInfo();
txtCreditUNo.Text = string.Empty;
//ddlCuMemberFlag.SelectedValue = "0";
BtnCreUnionUpdate.Visible = false;
txtCreditUNo.Focus();
}
try
{
if (ddlCreditUNo.SelectedValue != "-Select-")
{
txtHidden.Text = Converter.GetString(ddlCreditUNo.SelectedValue);
int CN = Converter.GetInteger(ddlCreditUNo.SelectedValue);
hdnCuNumber.Text = Converter.GetString(CN);
string c = "";
int a = txtHidden.Text.Length;
string b = txtHidden.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(re);
int CNo = Converter.GetSmallInteger(re1);
//A2ZCUNIONDTO getDTO = (A2ZCUNIONDTO.GetInfo(CN));
A2ZCUNIONDTO getDTO = (A2ZCUNIONDTO.GetInformation(CuType, CNo));
if (getDTO.NoRecord > 0)
{
txtCreditUNo.Text = Converter.GetString(txtHidden.Text);
txtCreUName.Text = Converter.GetString(getDTO.CreditUnionName);
lblNewCuNo.Text = Converter.GetString(getDTO.CreditUnionNo);
lblNewCuType.Text = Converter.GetString(getDTO.CuType);
txtCreditUNo.Text = (lblNewCuType.Text + "-" + lblNewCuNo.Text);
//ddlCreditUNo.SelectedValue = Converter.GetString(getDTO.CreditUnionNo);
DateTime dt = Converter.GetDateTime(getDTO.opendate);
string date = dt.ToString("dd/MM/yyyy");
txtCuOpenDate.Text = date;
//txtCuOpenDate.Text = Converter.GetString(getDTO.opendate);
//ddlCuMemberFlag.SelectedValue = Converter.GetString(getDTO.MemberFlag);
if (getDTO.CuStatus == 9)
{
DisplayMessage();
txtCreditUNo.Focus();
return;
}
txtCuCertificateNo.Text = Converter.GetString(getDTO.CertificateNo);
txtGLCashCode.Text = Converter.GetString(getDTO.GLCashCode);
if (txtGLCashCode.Text != string.Empty && txtGLCashCode.Text != "0")
{
ddlGLCashCode.SelectedValue = Converter.GetString(getDTO.GLCashCode);
}
txtCuAddressL1.Text = Converter.GetString(getDTO.AddressL1);
txtCuAddressL2.Text = Converter.GetString(getDTO.AddressL2);
txtCuAddressL3.Text = Converter.GetString(getDTO.AddressL3);
txtCuTelNo.Text = Converter.GetString(getDTO.TelephoneNo);
txtCuMobileNo.Text = Converter.GetString(getDTO.MobileNo);
txtCuFax.Text = Converter.GetString(getDTO.Fax);
txtCuEmail.Text = Converter.GetString(getDTO.email);
ddlDivision.Enabled = true;
ddlDistrict.Enabled = true;
ddlUpzila.Enabled = true;
ddlThana.Enabled = true;
//ddlCuMemberFlag.Enabled = true;
ddlGLCashCode.Enabled = true;
ddlDivision.SelectedValue = Converter.GetString(getDTO.Division);
ddlDistrict.SelectedValue = Converter.GetString(getDTO.District);
ddlUpzila.SelectedValue = Converter.GetString(getDTO.Upzila);
ddlThana.SelectedValue = Converter.GetString(getDTO.Thana);
BtnCreUnionUpdate.Visible = true;
txtCreUName.Focus();
}
else
{
InvalidRecords();
txtCreditUNo.Focus();
}
}
}
catch (Exception ex)
{
throw ex;
}
}
protected void txtCreditUNo_TextChanged(object sender, EventArgs e)
{
try
{
if (txtCreditUNo.Text != string.Empty)
{
int CN = Converter.GetInteger(txtCreditUNo.Text);
hdnCuNumber.Text = Converter.GetString(CN);
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(re);
int CNo = Converter.GetSmallInteger(re1);
A2ZCUNIONDTO getDTO = (A2ZCUNIONDTO.GetInformation(CuType, CNo));
//A2ZCUNIONDTO getDTO = (A2ZCUNIONDTO.GetInfo(CN));
if (getDTO.NoRecord > 0)
{
//CreditUnionDropdown();
lblNewCuTypeName.Text = Converter.GetString(getDTO.CreditUnionName);
lblNewCuNo.Text = Converter.GetString(getDTO.CreditUnionNo);
lblNewCuType.Text = Converter.GetString(getDTO.CuType);
if (getDTO.CuStatus == 9)
{
if (getDTO.CuReguCuType == 0)
{
lblNewCuTypeName.Text = Converter.GetString(getDTO.CuAssoCuTypeName);
lblNewCuNo.Text = Converter.GetString(getDTO.CuAssoCuNo);
lblNewCuType.Text = Converter.GetString(getDTO.CuAssoCuType);
}
else
{
lblNewCuTypeName.Text = Converter.GetString(getDTO.CuReguCuTypeName);
lblNewCuNo.Text = Converter.GetString(getDTO.CuReguCuNo);
lblNewCuType.Text = Converter.GetString(getDTO.CuReguCuType);
}
DisplayMessage();
txtCreditUNo.Text = string.Empty;
txtCreditUNo.Focus();
return;
}
//txtCreditUNo.Text = Converter.GetString(getDTO.CreditUnionNo);
txtCreUName.Text = Converter.GetString(getDTO.CreditUnionName);
string sqlquery = "SELECT lTrim(str(CuType) +lTrim(str(CuNo))) As CuNo,CuName from A2ZCUNION where CuType='" + lblNewCuType.Text + "' ORDER BY CuName ASC";
ddlCreditUNo = DataAccessLayer.BLL.CommonManager.Instance.FillDropDownListWithSelect(sqlquery, ddlCreditUNo, "A2ZCSMCUS");
ddlCreditUNo.SelectedValue = Converter.GetString(lblNewCuType.Text + lblNewCuNo.Text);
txtCreditUNo.Text = (lblNewCuType.Text + "-" + lblNewCuNo.Text);
DateTime dt = Converter.GetDateTime(getDTO.opendate);
string date = dt.ToString("dd/MM/yyyy");
txtCuOpenDate.Text = date;
//txtCuOpenDate.Text = Converter.GetString(getDTO.opendate);
//ddlCuMemberFlag.SelectedValue = Converter.GetString(getDTO.MemberFlag);
txtCuCertificateNo.Text = Converter.GetString(getDTO.CertificateNo);
txtGLCashCode.Text = Converter.GetString(getDTO.GLCashCode);
if (txtGLCashCode.Text != string.Empty && txtGLCashCode.Text != "0")
{
ddlGLCashCode.SelectedValue = Converter.GetString(getDTO.GLCashCode);
}
txtCuAddressL1.Text = Converter.GetString(getDTO.AddressL1);
txtCuAddressL2.Text = Converter.GetString(getDTO.AddressL2);
txtCuAddressL3.Text = Converter.GetString(getDTO.AddressL3);
txtCuTelNo.Text = Converter.GetString(getDTO.TelephoneNo);
txtCuMobileNo.Text = Converter.GetString(getDTO.MobileNo);
txtCuFax.Text = Converter.GetString(getDTO.Fax);
txtCuEmail.Text = Converter.GetString(getDTO.email);
ddlDivision.Enabled = true;
ddlDistrict.Enabled = true;
ddlUpzila.Enabled = true;
ddlThana.Enabled = true;
//ddlCuMemberFlag.Enabled = true;
ddlGLCashCode.Enabled = true;
ddlDivision.SelectedValue = Converter.GetString(getDTO.Division);
ddlDistrict.SelectedValue = Converter.GetString(getDTO.District);
ddlThana.SelectedValue = Converter.GetString(getDTO.Thana);
ddlUpzila.SelectedValue = Converter.GetString(getDTO.Upzila);
BtnCreUnionUpdate.Visible = true;
txtCreUName.Focus();
}
else
{
InvalidRecords();
txtCreditUNo.Focus();
}
}
}
catch (Exception ex)
{
throw ex;
}
}
protected void gvSearchMEMBERInfo_SelectedIndexChanged(object sender, EventArgs e)
{
GridViewRow row = gvSearchMEMBERInfo.SelectedRow;
lblMemName.Text = row.Cells[0].Text;
txtMemNo.Text = row.Cells[1].Text;
txtCreditUNo.Text = row.Cells[2].Text;
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;
}
}
gvSearchMEMBERInfo.Visible = false;
//txtCreditUNo.Text = (lblCuType.Text + "-" + lblCuNo.Text);
gvDetailInfo.Visible = true;
gvDetail();
//BtnSearch_Click(this, EventArgs.Empty);
}
protected void btnSearch_Click(object sender, EventArgs e)
{
if (txtCuNo.Text == string.Empty)
{
txtCuNo.Focus();
ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Please Input Credit Union No.');", true);
return;
}
string c = "";
int a = txtCuNo.Text.Length;
string b = txtCuNo.Text;
c = b.Substring(0, 1);
Int16 re = Converter.GetSmallInteger(c);
int dd = a - 1;
string d = b.Substring(1, dd);
int re1 = Converter.GetInteger(d);
Int16 CuType = Converter.GetSmallInteger(re);
lblCuType.Text = Converter.GetString(re);
int CNo = Converter.GetInteger(re1);
lblCuNumber.Text = Converter.GetString(re1);
A2ZCUNIONDTO objDTO = (A2ZCUNIONDTO.GetInformation(CuType, CNo));
if (objDTO.CreditUnionNo > 0)
{
lblCuName.Text = Converter.GetString(objDTO.CreditUnionName);
txtCuNo.Text = (c + "-" + d);
if (objDTO.CuProcFlag != 13)
{
ProcMSG();
txtCuNo.Text = string.Empty;
lblCuName.Text = string.Empty;
lblCuType.Text = string.Empty;
lblCuNumber.Text = string.Empty;
txtCuNo.Focus();
return;
}
if (objDTO.CuStatus != 0)
{
StatusMSG();
txtCuNo.Text = string.Empty;
lblCuName.Text = string.Empty;
lblCuType.Text = string.Empty;
lblCuNumber.Text = string.Empty;
txtCuNo.Focus();
return;
}
if (CuType == 3)
{
InvalidMSG();
txtCuNo.Text = string.Empty;
lblCuName.Text = string.Empty;
lblCuType.Text = string.Empty;
lblCuNumber.Text = string.Empty;
txtCuNo.Focus();
return;
}
if (CuType == 1)
{
lblTransferMode.Text = "Transfering ... Affiliate to Associate";
}
else
{
lblTransferMode.Text = "Transfering ... Associate to Regular";
}
btnSearch.Visible = false;
txtCuNo.Enabled = false;
BtnProcess.Focus();
return;
}
else
{
InvalidMSG();
txtCuNo.Text = string.Empty;
lblCuType.Text = string.Empty;
lblCuNumber.Text = string.Empty;
lblCuName.Text = string.Empty;
txtCuNo.Focus();
}
}
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;
}
}
protected void BtnProcess_Click(object sender, EventArgs e)
{
if (txtCuNo.Text != string.Empty && lblCuType.Text != string.Empty && lblCuNumber.Text != string.Empty)
{
Int16 CuType = Converter.GetSmallInteger(lblCuType.Text);
int CNo = Converter.GetInteger(lblCuNumber.Text);
A2ZCUNIONDTO objDTO = (A2ZCUNIONDTO.GetInformation(CuType, CNo));
if (objDTO.CreditUnionNo > 0)
{
if (objDTO.CuProcFlag != 13)
{
txtCuNo.Text = string.Empty;
lblCuName.Text = string.Empty;
lblCuType.Text = string.Empty;
lblCuNumber.Text = string.Empty;
ProcMSG();
txtCuNo.Focus();
return;
}
if (objDTO.CuStatus != 0)
{
txtCuNo.Text = string.Empty;
lblCuName.Text = string.Empty;
lblCuType.Text = string.Empty;
lblCuNumber.Text = string.Empty;
StatusMSG();
txtCuNo.Focus();
return;
}
var prm = new object[4];
prm[0] = lblCuType.Text;
prm[1] = lblCuNumber.Text;
prm[2] = lblID.Text;
prm[3] = 0;
int result1 = Converter.GetInteger(CommonManager.Instance.GetScalarValueBySp("Sp_CSCUTransfer", prm, "A2ZCSMCUS"));
if (result1 == 0)
{
DisplayMessage();
txtCuNo.Text = string.Empty;
lblCuName.Text = string.Empty;
lblTransferMode.Text = string.Empty;
btnSearch.Visible = true;
txtCuNo.Enabled = true;
txtCuNo.Focus();
return;
}
}
else
{
txtCuNo.Text = string.Empty;
lblCuName.Text = string.Empty;
lblCuType.Text = string.Empty;
lblCuNumber.Text = string.Empty;
InvalidMSG();
txtCuNo.Focus();
return;
}
}
else
{
txtCuNo.Text = string.Empty;
lblCuName.Text = string.Empty;
lblCuType.Text = string.Empty;
lblCuNumber.Text = string.Empty;
txtCuNo.Focus();
ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Please Input Credit Union No.');", true);
return;
}
}
protected void txtCreditUNo_TextChanged(object sender, EventArgs e)
{
try
{
if (txtCreditUNo.Text != string.Empty)
{
int CN = Converter.GetInteger(txtCreditUNo.Text);
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(re);
lblCUType.Text = Converter.GetString(CuType);
int CNo = Converter.GetSmallInteger(re1);
lblCUNumber.Text = Converter.GetString(CNo);
A2ZCUNIONDTO getDTO = (A2ZCUNIONDTO.GetInformation(CuType, CNo));
//A2ZCUNIONDTO getDTO = (A2ZCUNIONDTO.GetInfo(CN));
if (getDTO.NoRecord > 0)
{
lblCUType.Text = Converter.GetString(getDTO.CuType);
lblCUNumber.Text = Converter.GetString(getDTO.CreditUnionNo);
lblCrNo.Text = (lblCUType.Text + lblCUNumber.Text);
txtCreditUNo.Text = (lblCUType.Text + "-" + lblCUNumber.Text);
DateTime dt = Converter.GetDateTime(getDTO.opendate);
string date = dt.ToString("dd/MM/yyyy");
lblCuOpenDate.Text = date;
string sqlquery = "SELECT lTrim(str(CuType) +lTrim(str(CuNo))) As CuNo,CuName from A2ZCUNION where CuType='" + lblCUType.Text + "'";
lblCuName.Text = Converter.GetString(getDTO.CreditUnionName);
//txtCULBMemNo.Focus();
clearInfo();
//if (CtrlModule.Text == "1")
//{
// string sqquery = @"SELECT MemNo,MemName FROM A2ZMEMBER WHERE CuNo='" + CNo + "'and CuType='" + CuType + "' GROUP BY MemNo,MemName";
// ddlCULBMemNo = DataAccessLayer.BLL.CommonManager.Instance.FillDropDownListWithSelect(sqquery, ddlCULBMemNo, "A2ZCSMCUS");
//}
}
else
{
InvalidCUMSG();
clearInfo();
txtCreditUNo.Focus();
txtCreditUNo.Text = string.Empty;
//txtCULBMemNo.Text = string.Empty;
txtCULBMemName.Text = string.Empty;
BtnSubmit.Visible = true;
}
}
}
catch (Exception ex)
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "scriptkey", "<script>alert('System Error.txtCreditUNo_TextChanged Problem');</script>");
//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;
}
lblTrnferCuType.Text = Converter.GetString(accgetDTO.CuType);
lblTrnferCuNo.Text = Converter.GetString(accgetDTO.CuNo);
txtTrnCuNo.Text = (lblTrnferCuType.Text + "-" + lblTrnferCuNo.Text);
txtTrnMemNo.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 (lblTrnAtyClass.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);
}
}
Int16 CType = Converter.GetSmallInteger(lblTrnferCuType.Text);
int CNo = Converter.GetInteger(lblTrnferCuNo.Text);
A2ZCUNIONDTO get5DTO = (A2ZCUNIONDTO.GetInformation(CType, CNo));
if (get5DTO.NoRecord > 0)
{
lblTrnCuName.Text = Converter.GetString(get5DTO.CreditUnionName);
}
Int16 CUType = Converter.GetSmallInteger(lblTrnferCuType.Text);
int CUNo = Converter.GetInteger(lblTrnferCuNo.Text);
int MNo = Converter.GetInteger(txtTrnMemNo.Text);
A2ZMEMBERDTO get6DTO = (A2ZMEMBERDTO.GetInformation(CUType, CUNo, MNo));
if (get6DTO.NoRecord > 0)
{
lblTrnMemName.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 txtTrnCuNo_TextChanged(object sender, EventArgs e)
{
try
{
if (txtTrnCuNo.Text != string.Empty)
{
BtnTransfer.Visible = false;
A2ZCUNIONDTO getDTO = new A2ZCUNIONDTO();
if (chkOldSearch.Checked == true)
{
int CN = Converter.GetInteger(txtTrnCuNo.Text);
hdnCuNumber.Text = Converter.GetString(CN);
getDTO = (A2ZCUNIONDTO.GetOldInfo(CN));
}
else
{
string c = "";
int a = txtTrnCuNo.Text.Length;
string b = txtTrnCuNo.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);
getDTO = (A2ZCUNIONDTO.GetInformation(CType, CNo));
}
if (getDTO.NoRecord > 0)
{
lblTrnferCuType.Text = Converter.GetString(getDTO.CuType);
lblTrnferCuNo.Text = Converter.GetString(getDTO.CreditUnionNo);
lblCuName.Text = Converter.GetString(getDTO.CreditUnionName);
txtTrnMemNo.Focus();
txtTrnCuNo.Text = lblTrnferCuType.Text + "-" + lblTrnferCuNo.Text;
}
else
{
InvalidCuNo();
txtTrnCuNo.Text = string.Empty;
txtTrnCuNo.Focus();
}
}
}
catch (Exception ex)
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "scriptkey", "<script>alert('System Error.txtTrnCuNo_TextChanged Problem');</script>");
//throw ex;
}
}
protected void txtCreditUNo_TextChanged(object sender, EventArgs e)
{
try
{
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 CuType = Converter.GetSmallInteger(re);
lblCUType.Text = Converter.GetString(CuType);
int CNo = Converter.GetSmallInteger(re1);
lblCUNumber.Text = Converter.GetString(CNo);
A2ZCUNIONDTO getDTO = (A2ZCUNIONDTO.GetInformation(CuType, CNo));
if (getDTO.CreditUnionNo > 0)
{
string sqlquery = "SELECT lTrim(str(CuType) +lTrim(str(CuNo))) As CuNo,CuName from A2ZCUNION where CuType='" + CuType + "'";
if (CtrlModule.Text == "1")
{
ddlCreditUNo = DataAccessLayer.BLL.CommonManager.Instance.FillDropDownListWithSelect(sqlquery, ddlCreditUNo, "A2ZCSMCUS");
ddlCreditUNo.SelectedValue = Converter.GetString(txtCreditUNo.Text);
}
lblCuName.Text = Converter.GetString(getDTO.CreditUnionName);
txtCreditUNo.Text = (c + "-" + d);
txtCULBMemNo.Focus();
clearInfo();
if (CtrlModule.Text == "1")
{
string sqquery = @"SELECT MemNo,MemName FROM A2ZMEMBER WHERE CuNo='" + CNo + "'and CuType='" + CuType + "' GROUP BY MemNo,MemName";
ddlCULBMemNo = DataAccessLayer.BLL.CommonManager.Instance.FillDropDownListWithSelect(sqquery, ddlCULBMemNo, "A2ZCSMCUS");
}
}
else
{
clearInfo();
txtCULBMemNo.Text = string.Empty;
txtCULBMemName.Text = string.Empty;
BtnSubmit.Visible = true;
BtnUpdate.Visible = false;
if (CtrlModule.Text == "1")
{
ddlCreditUNo.SelectedValue = "-Select-";
ddlCULBMemNo.SelectedIndex = 0;
}
}
}
}
catch (Exception ex)
{
throw ex;
}
}
private void NewMemberInfoHelp()
{
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;
}
//GridViewRow row = gvSearchCUInfo.SelectedRow;
//txtCreditUNo.Text = row.Cells[1].Text;
//lblCuNumber.Text = row.Cells[1].Text;
//lblCuName.Text = row.Cells[0].Text;
gvSearchCUInfo.Visible = false;
Session["RCreditUNo"] = lblCuNumber.Text;
Session["RtxtOldCuNo"] = txtOldCuNo.Text;
//Session["RMemNo"] = txtMemNo.Text;
//Session["MemName"] = lblMemName.Text;
Session["flag"] = "1";
Session["ExFlag"] = string.Empty;
Session["SFlag"] = string.Empty;
//txtCreditUNo.Text = (lblCuType.Text + "-" + lblCuNo.Text);
if (lblNflag.Text == "0")
{
ScriptManager.RegisterStartupScript(Page, typeof(System.Web.UI.Page),
"click", @"<script>window.opener.location.href='CSInstantAccountOpeningMaintenance.aspx'; self.close();</script>", false);
}
//gvSearchMEMDetail();
//gvSearchMEMInfo.Visible = true;
//txtSearchMemName.ReadOnly = false;
}
}
protected void txtCreditUNo_TextChanged(object sender, EventArgs e)
{
try
{
if (txtCreditUNo.Text != string.Empty)
{
A2ZCUNIONDTO getDTO = new A2ZCUNIONDTO();
if (chkOldSearch.Checked == true)
{
int CN = Converter.GetInteger(txtCreditUNo.Text);
getDTO = (A2ZCUNIONDTO.GetOldInfo(CN));
hdnCuNumber.Text = txtCreditUNo.Text;
}
else
{
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(re);
lblCuType.Text = Converter.GetString(CuType);
int CNo = Converter.GetSmallInteger(re1);
lblCuNo.Text = Converter.GetString(CNo);
getDTO = (A2ZCUNIONDTO.GetInformation(CuType, CNo));
}
if (getDTO.CreditUnionNo > 0)
{
lblCuStatus.Text = Converter.GetString(getDTO.CuStatus);
if (lblCuStatus.Text == "9")
{
TransferCuNoMSG();
txtCreditUNo.Text = string.Empty;
txtCreditUNo.Focus();
return;
}
lblCuType.Text = Converter.GetString(getDTO.CuType);
lblCuNo.Text = Converter.GetString(getDTO.CreditUnionNo);
//string sqlquery = "SELECT lTrim(str(CuType) +lTrim(str(CuNo))) As CuNo,CuName from A2ZCUNION where CuType='" + CuType + "'";
//ddlCreditUNo = DataAccessLayer.BLL.CommonManager.Instance.FillDropDownListWithSelect(sqlquery, ddlCreditUNo, "A2ZCSMCUS");
//ddlCreditUNo.SelectedValue = Converter.GetString(lblCuType.Text + lblCuNo.Text);
txtCreditUNo.Text = lblCuType.Text + "-" + lblCuNo.Text;
lblCuName.Text = Converter.GetString(getDTO.CreditUnionName);
txtMemNo.Focus();
}
else
{
InvalidCuNoMSG();
txtCreditUNo.Text = string.Empty;
txtCreditUNo.Focus();
}
}
}
catch (Exception ex)
{
throw ex;
}
}