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;
}
}
private void OldMemberInfoHelp()
{
int CN = Converter.GetInteger(txtOldCuNo.Text);
hdnCuNumber.Text = Converter.GetString(CN);
A2ZCUNIONDTO getDTO = (A2ZCUNIONDTO.GetOldInfo(CN));
if (getDTO.NoRecord > 0)
{
lblCuType.Text = Converter.GetString(getDTO.CuType);
lblCuNo.Text = Converter.GetString(getDTO.CreditUnionNo);
lblCuNumber.Text = lblCuType.Text + lblCuNo.Text;
if (CFlag.Text != "1")
{
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;
}
gvSearchMEMDetail();
gvSearchMEMInfo.Visible = true;
txtSearchMemName.ReadOnly = false;
}
}
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 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);
lblCuNo.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 + "'";
ddlCreditUNo = DataAccessLayer.BLL.CommonManager.Instance.FillDropDownListWithSelect(sqlquery, ddlCreditUNo, "A2ZCSMCUS");
ddlCreditUNo.SelectedValue = Converter.GetString(lblCuType.Text + lblCuNo.Text);
txtMemNo.Focus();
txtCreditUNo.Text = lblCuType.Text + "-" + lblCuNo.Text;
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");
}
else
{
ddlCreditUNo.SelectedValue = "-Select-";
ddlMemNo.SelectedIndex = 0;
txtMemNo.Text = string.Empty;
}
}
}
catch (Exception ex)
{
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;
}
}
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 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 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 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 (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();
}
}
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 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 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;
}
}
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;
}
}
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 ddlCreditUNo_SelectedIndexChanged(object sender, EventArgs e)
{
if (ddlCreditUNo.SelectedValue == "-Select-")
{
clearInfo();
txtCreditUNo.Text = string.Empty;
txtCULBMemNo.Focus();
ddlCULBMemNo.SelectedIndex = 0;
return;
}
// CULBMemberDropdown();
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);
lblCUNumber.Text = Converter.GetString(CNo);
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");
A2ZCUNIONDTO getDTO = (A2ZCUNIONDTO.GetInformation(CuType, CNo));
if (getDTO.CreditUnionNo > 0)
{
txtCreditUNo.Text = Converter.GetString(txtHidden.Text);
txtCreditUNo.Text = (c + "-" + d);
txtCULBMemNo.Focus();
clearInfo();
}
else
{
ddlCreditUNo.SelectedValue = "-Select-";
}
}
}
catch (Exception ex)
{
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;
}
}
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 BtnProceed_Click(object sender, EventArgs e)
{
string sqlquery3 = "Truncate table dbo.A2ZCUNION ";
// string sqlquery4 = "Truncate table dbo.A2ZMEMBER ";
int result = Converter.GetInteger(DataAccessLayer.BLL.CommonManager.Instance.ExecuteNonQuery(sqlquery3, "A2ZCSMCUS"));
// int resultM = Converter.GetInteger(DataAccessLayer.BLL.CommonManager.Instance.ExecuteNonQuery(sqlquery4, "A2ZCSMCUS"));
SqlCommand cmd = new SqlCommand("INSERT INTO A2ZCSMCUS.dbo.A2ZCUNION(CuOldCuNo,CuName,CuOpDt,CuFlag,CuType,CuCertNo,CuAddL1,CuAddL2,CuAddL3,CuEmail,CuTel,CuMobile,CuFax,CuDivi,CuDist,CuThana,GLCashCode) SELECT CUNO,CUNAME,CUOPDT,CUMEMFLAG,CUTYPE,CUCERTNO,CUADDL1,CUADDL2,CUADDL3,CUEMAIL,CUTEL,CUMOBILE,CUFAX,CUDIVI,CUDIST,CUTHAN,GLCASHCODE FROM A2ZCCULB.dbo.A2ZCRUNION", con);
// SqlCommand cmd1 = new SqlCommand("INSERT INTO A2ZCSMCUS.dbo.A2ZMEMBER(CuType,CuNo,MemName,MemOpenDate) SELECT CUTYPE,CUNO,CUNAME,CUOPDT FROM A2ZCCULB.dbo.A2ZCRUNION", con);
con.Open();
int result1 = cmd.ExecuteNonQuery();
// int result2 = cmd1.ExecuteNonQuery();
if (result1 > 0)
{
Successful();
}
string qry = "SELECT Id,CuType,CuNo,CuName,CuOpDt FROM A2ZCUNION ";
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 ParentId = dr["Id"].ToString();
//if (ParentId <= totrec.text)
//{
var CType = dr["CuType"].ToString();
var CNo = dr["CuNo"].ToString();
var CName = dr["CuName"].ToString();
var COpDt = dr["CuOpDt"].ToString();
int a = Converter.GetSmallInteger(CType);
int b = Converter.GetSmallInteger(CNo);
A2ZCUNIONDTO objDTO = new A2ZCUNIONDTO();
objDTO.ID = Converter.GetSmallInteger(ParentId);
if (CType == "0")
{
objDTO.CuType = 1;
objDTO.CuTypeName = "Affiliate";
}
else if (CType == "1")
{
objDTO.CuType = 2;
objDTO.CuTypeName = "Associate";
}
else if (CType == "2")
{
objDTO.CuType = 3;
objDTO.CuTypeName = "Regular";
}
objDTO.CuProcFlag = 13;
if (COpDt == "")
{
A2ZCSPARAMETERDTO dto = A2ZCSPARAMETERDTO.GetParameterValue();
string strQuery = "UPDATE A2ZCUNION set CuOpDt='" + dto.ProcessDate + "' where Id='" + objDTO.ID + "' ";
int rowEffect = Converter.GetInteger(DataAccessLayer.BLL.CommonManager.Instance.ExecuteNonQuery(strQuery, "A2ZCSMCUS"));
if (rowEffect > 0)
{
DataTable dt1 = DataAccessLayer.BLL.CommonManager.Instance.GetDataTableByQuery("SELECT CuOpDt FROM A2ZCUNION WHERE Id='" + objDTO.ID + "'", "A2ZCSMCUS");
if (dt1.Rows.Count > 0)
{
var OpDt1 = Converter.GetString(dt1.Rows[0]["CuOpDt"]);
objDTO.CuStatusDate = Converter.GetDateTime(OpDt1);
objDTO.InputByDate = Converter.GetDateTime(OpDt1);
objDTO.VerifyByDate = Converter.GetDateTime(OpDt1);
objDTO.ApprovByDate = Converter.GetDateTime(OpDt1);
}
}
}
else
{
objDTO.CuStatusDate = Converter.GetDateTime(COpDt);
objDTO.InputByDate = Converter.GetDateTime(COpDt);
objDTO.VerifyByDate = Converter.GetDateTime(COpDt);
objDTO.ApprovByDate = Converter.GetDateTime(COpDt);
}
int row = A2ZCUNIONDTO.UpdateInformation1(objDTO);
if (row > 0)
{
}
Int16 rcytype = Converter.GetSmallInteger(objDTO.CuType);
A2ZRECCTRLDTO RDTO = (A2ZRECCTRLDTO.GetLastRecords(rcytype));
objDTO.CreditUnionNo = Converter.GetSmallInteger(RDTO.CtrlRecLastNo);
int row1 = A2ZCUNIONDTO.UpdateInformation1(objDTO);
if (row1 > 0)
{
// A2ZMEMBERDTO MemDTO = new A2ZMEMBERDTO();
// MemDTO.MemberNo = 0;
// MemDTO.ID = Converter.GetSmallInteger(objDTO.ID);
// MemDTO.CuType = Converter.GetSmallInteger(objDTO.CuType);
// MemDTO.CreditUnionNo = Converter.GetInteger(objDTO.CreditUnionNo);
// MemDTO.MemberName = Converter.GetString(CName);
// int row2 = A2ZMEMBERDTO.Update(MemDTO);
}
}
}
GLCashCode();
}
private void OldMemberInfoHelp()
{
int CN = Converter.GetInteger(txtOldCuNo.Text);
hdnCuNumber.Text = Converter.GetString(CN);
A2ZCUNIONDTO getDTO = (A2ZCUNIONDTO.GetOldInfo(CN));
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;
}
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 ddlCreditUNo_SelectedIndexChanged(object sender, EventArgs e)
{
if (ddlCreditUNo.SelectedValue == "-Select-")
{
clearInfo();
txtCreditUNo.Text = string.Empty;
ddlCuMemberFlag.SelectedValue = "0";
ddlCuMemberType.SelectedValue = "0";
BtnCreUnionSubmit.Visible = true;
BtnCreUnionUpdate.Visible = false;
txtCreditUNo.Focus();
}
try
{
if (ddlCreditUNo.SelectedValue != "-Select-")
{
int CNo = Converter.GetInteger(ddlCreditUNo.SelectedValue);
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 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;
}
}