protected void txtMemNo_TextChanged(object sender, EventArgs e)
{
try
{
if (txtMemNo.Text != string.Empty)
{
Int16 CuType = Converter.GetSmallInteger(lblCuType.Text);
int CNo = Converter.GetInteger(lblCuNo.Text);
int MemNumber = Converter.GetInteger(txtMemNo.Text);
A2ZMEMBERDTO getDTO = new A2ZMEMBERDTO();
getDTO = (A2ZMEMBERDTO.GetInformation(CuType, CNo, MemNumber));
if (getDTO.NoRecord > 0)
{
lblMemName.Text = getDTO.MemberName;
}
}
}
catch (Exception ex)
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "scriptkey", "<script>alert('System Error.txtCrUnion_TextChanged Problem');</script>");
//throw ex;
}
}
protected void BtnSearch_Click(object sender, EventArgs e)
{
if (txtMemNo.Text != string.Empty)
{
lblCuType.Text = "0";
lblCuNo.Text = "0";
Int16 CUType = Converter.GetSmallInteger(lblCuType.Text);
int CUNo = Converter.GetInteger(lblCuNo.Text);
int MNo = Converter.GetInteger(txtMemNo.Text);
A2ZMEMBERDTO get6DTO = (A2ZMEMBERDTO.GetInformation(CUType, CUNo, MNo));
if (get6DTO.NoRecord > 0)
{
lblMemName.Text = Converter.GetString(get6DTO.MemberName);
gvDetailInfo.Visible = true;
gvDetail();
//MoveAccDescription();
}
else
{
InvalidStaffNo();
txtMemNo.Text = string.Empty;
txtMemNo.Focus();
return;
}
}
}
protected void txtLoanMemNo_TextChanged(object sender, EventArgs e)
{
if (ddlLoanMemNo.SelectedValue == "-Select-")
{
txtLoanMemNo.Focus();
}
if (txtLoanMemNo.Text != string.Empty)
{
int MemNumber = Converter.GetInteger(txtLoanMemNo.Text);
A2ZMEMBERDTO getDTO = new A2ZMEMBERDTO();
getDTO = (A2ZMEMBERDTO.GetInformation(0, 0, MemNumber));
if (getDTO.NoRecord > 0)
{
ddlLoanMemNo.SelectedValue = Converter.GetString(getDTO.MemberNo);
}
else
{
//String csname1 = "PopupScript";
//Type cstype = GetType();
//ClientScriptManager cs = Page.ClientScript;
//if (!cs.IsStartupScriptRegistered(cstype, csname1))
//{
// String cstext1 = "alert('Depositor No does not exist in file');";
// cs.RegisterStartupScript(cstype, csname1, cstext1, true);
// txtLoanMemNo.Focus();
//}
ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Depositor No does not exist in file');", true);
return;
}
}
}
protected void txtMemNo_TextChanged(object sender, EventArgs e)
{
try
{
if (ddlMemNo.SelectedValue == "-Select-")
{
}
if (txtMemNo.Text != string.Empty && ddlCreditUNo.SelectedValue != "-Select-")
{
Int16 CuType = Converter.GetSmallInteger(lblCuType.Text);
int CNo = Converter.GetSmallInteger(lblCuNo.Text);
int MemNumber = Converter.GetInteger(txtMemNo.Text);
A2ZMEMBERDTO getDTO = new A2ZMEMBERDTO();
getDTO = (A2ZMEMBERDTO.GetInformation(CuType, CNo, MemNumber));
if (getDTO.NoRecord > 0)
{
ddlMemNo.SelectedValue = Converter.GetString(getDTO.MemberNo);
}
else
{
ddlMemNo.SelectedValue = "-Select-";
}
}
}
catch (Exception ex)
{
throw ex;
}
}
protected void ddlMemNo_SelectedIndexChanged(object sender, EventArgs e)
{
if (ddlMemNo.SelectedValue == "-Select-")
{
txtMemNo.Text = string.Empty;
txtMemNo.Focus();
}
if (ddlMemNo.SelectedValue != "-Select-")
{
A2ZMEMBERDTO getDTO = new A2ZMEMBERDTO();
Int16 CuType = 0;
int CreditNumber = 0;
int MemNumber = Converter.GetInteger(ddlMemNo.SelectedValue);
getDTO = (A2ZMEMBERDTO.GetInformation(CuType, CreditNumber, MemNumber));
if (getDTO.NoRecord > 0)
{
txtMemNo.Text = Converter.GetString(getDTO.MemberNo);
txtAccType.Focus();
}
else
{
txtMemNo.Text = string.Empty;
}
}
}
protected void txtMemNo_TextChanged(object sender, EventArgs e)
{
try
{
if (txtMemNo.Text != string.Empty)
{
A2ZMEMBERDTO getDTO = new A2ZMEMBERDTO();
if (chkOldSearch.Checked == true)
{
int MemNumber = Converter.GetInteger(txtMemNo.Text);
int CuNumber = Converter.GetInteger(hdnCuNumber.Text);
getDTO = (A2ZMEMBERDTO.GetInfoOldMember(CuNumber, MemNumber));
}
else
{
Int16 CUType = Converter.GetSmallInteger(lblCuType.Text);
int CUNo = Converter.GetInteger(lblCuNo.Text);
int MNo = Converter.GetInteger(txtMemNo.Text);
getDTO = (A2ZMEMBERDTO.GetInformation(CUType, CUNo, MNo));
}
//Int16 CuType = Converter.GetSmallInteger(lblCuType.Text);
//int CNo = Converter.GetSmallInteger(lblCuNo.Text);
//int MemNumber = Converter.GetInteger(txtMemNo.Text);
//A2ZMEMBERDTO getDTO = new A2ZMEMBERDTO();
//getDTO = (A2ZMEMBERDTO.GetInformation(CuType, CNo, MemNumber));
if (getDTO.NoRecord > 0)
{
txtMemNo.Text = Converter.GetString(getDTO.MemberNo);
lblMemName.Text = Converter.GetString(getDTO.MemberName);
}
else
{
txtMemNo.Text = string.Empty;
lblMemName.Text = string.Empty;
txtMemNo.Focus();
InvalidMemNoMSG();
}
}
}
catch (Exception ex)
{
throw ex;
}
}
protected void txtMemNo_TextChanged(object sender, EventArgs e)
{
A2ZACCOUNTDTO GetAccount = new A2ZACCOUNTDTO();
Int16 CuType = Converter.GetSmallInteger(lblCuType.Text);
int AccType = Converter.GetInteger(ddlAcType.SelectedValue);
int CreditNo = Converter.GetInteger(lblCuNo.Text);
int MemberNo = Converter.GetInteger(txtMemNo.Text);
GetAccount = (A2ZACCOUNTDTO.GetInfo(AccType, CuType, CreditNo, MemberNo));
if (GetAccount.AccNo > 0 && GetAccount.AccStatus < 98)
{
txtAccNo.Text = Converter.GetString(GetAccount.AccNo);
}
else
{
txtAccNo.Text = string.Empty;
txtMemNo.Text = string.Empty;
txtMemNo.Focus();
return;
}
A2ZMEMBERDTO getDTO = new A2ZMEMBERDTO();
if (chkOldSearch.Checked == true)
{
int MemNumber = Converter.GetInteger(txtMemNo.Text);
int CuNumber = Converter.GetInteger(hdnCuNumber.Text);
getDTO = (A2ZMEMBERDTO.GetInfoOldMember(CuNumber, MemNumber));
}
else
{
Int16 CUType = Converter.GetSmallInteger(lblCuType.Text);
int CUNo = Converter.GetInteger(lblCuNo.Text);
int MNo = Converter.GetInteger(txtMemNo.Text);
getDTO = (A2ZMEMBERDTO.GetInformation(CUType, CUNo, MNo));
}
if (getDTO.NoRecord > 0)
{
lblMemName.Text = Converter.GetString(getDTO.MemberName);
txtAmount.Focus();
}
else
{
lblMemName.Text = string.Empty;
txtMemNo.Focus();
}
}
protected void txtTrnMemNo_TextChanged(object sender, EventArgs e)
{
try
{
if (txtTrnMemNo.Text != string.Empty)
{
BtnTransfer.Visible = false;
A2ZMEMBERDTO getDTO = new A2ZMEMBERDTO();
if (chkOldSearch.Checked == true)
{
int MemNumber = Converter.GetInteger(txtTrnMemNo.Text);
int CuNumber = Converter.GetInteger(hdnCuNumber.Text);
getDTO = (A2ZMEMBERDTO.GetInfoOldMember(CuNumber, MemNumber));
}
else
{
Int16 CUType = Converter.GetSmallInteger(lblCuType.Text);
int CUNo = Converter.GetInteger(lblCuNo.Text);
int MNo = Converter.GetInteger(txtTrnMemNo.Text);
getDTO = (A2ZMEMBERDTO.GetInformation(CUType, CUNo, MNo));
}
if (getDTO.NoRecord > 0)
{
txtTrnMemNo.Text = Converter.GetString(getDTO.MemberNo);
lblMemName.Text = Converter.GetString(getDTO.MemberName);
BtnTrfSearch.Visible = true;
}
else
{
InvalidMemNo();
BtnTrfSearch.Visible = false;
txtTrnMemNo.Text = string.Empty;
txtTrnMemNo.Focus();
}
}
}
catch (Exception ex)
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "scriptkey", "<script>alert('System Error.txtTrnMemNo_TextChanged Problem');</script>");
//throw ex;
}
}
protected void ddlLoanMemNo_SelectedIndexChanged(object sender, EventArgs e)
{
if (ddlLoanMemNo.SelectedValue != "-Select-")
{
int MemNumber = Converter.GetInteger(ddlLoanMemNo.SelectedValue);
A2ZMEMBERDTO getDTO = new A2ZMEMBERDTO();
getDTO = (A2ZMEMBERDTO.GetInformation(0, 0, MemNumber));
if (getDTO.NoRecord > 0)
{
ItxtMemNo.Text = Converter.GetString(getDTO.MemberNo);
txtAccType.Focus();
}
}
}
protected void ddlMemNo_SelectedIndexChanged(object sender, EventArgs e)
{
if (ddlMemNo.SelectedValue != "-Select-" && ddlCreditUNo.SelectedValue != "-Select-")
{
Int16 CuType = Converter.GetSmallInteger(lblCuType.Text);
int CNo = Converter.GetSmallInteger(lblCuNo.Text);
int MemNumber = Converter.GetInteger(ddlMemNo.SelectedValue);
A2ZMEMBERDTO getDTO = new A2ZMEMBERDTO();
getDTO = (A2ZMEMBERDTO.GetInformation(CuType, CNo, MemNumber));
if (getDTO.NoRecord > 0)
{
txtMemNo.Text = Converter.GetString(getDTO.MemberNo);
}
}
}
protected void txtLoanMemNo_TextChanged(object sender, EventArgs e)
{
if (ddlLoanMemNo.SelectedValue == "-Select-")
{
txtLoanMemNo.Focus();
}
if (txtLoanMemNo.Text != string.Empty)
{
int MemNumber = Converter.GetInteger(txtLoanMemNo.Text);
A2ZMEMBERDTO getDTO = new A2ZMEMBERDTO();
getDTO = (A2ZMEMBERDTO.GetInformation(0, 0, MemNumber));
if (getDTO.NoRecord > 0)
{
ddlLoanMemNo.SelectedValue = Converter.GetString(getDTO.MemberNo);
AccountOpenCheck();
if (MsgFlag.Text == "1")
{
txtLoanMemNo.Text = string.Empty;
ddlLoanMemNo.SelectedIndex = 0;
txtLoanMemNo.Focus();
return;
}
else
{
txtLoanAppAmount.Focus();
}
}
else
{
txtLoanMemNo.Focus();
ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Staff No. does not exist in file');", true);
return;
}
}
}
protected void ItxtMemNo_TextChanged(object sender, EventArgs e)
{
try
{
if (ItxtMemNo.Text != string.Empty)
{
Int16 CuType = Converter.GetSmallInteger(lblCuType.Text);
int CNo = Converter.GetSmallInteger(lblCuNo.Text);
int MemNumber = Converter.GetInteger(ItxtMemNo.Text);
int CuNumber = Converter.GetInteger(hdnCuNumber.Text);
A2ZMEMBERDTO getDTO = new A2ZMEMBERDTO();
getDTO = (A2ZMEMBERDTO.GetInformation(CuType, CNo, MemNumber));
//A2ZMEMBERDTO getDTO = new A2ZMEMBERDTO();
//getDTO = (A2ZMEMBERDTO.GetInfoMember(CuType, CNo, CuNumber, MemNumber));
if (getDTO.NoRecord > 0)
{
ItxtMemNo.Text = Converter.GetString(getDTO.MemberNo);
ddlLoanMemNo.SelectedValue = Converter.GetString(getDTO.MemberNo);
txtAccType.Focus();
}
else
{
ItxtMemNo.Text = string.Empty;
ddlLoanMemNo.SelectedIndex = 0;
ItxtMemNo.Focus();
InvalidMemMSG();
}
}
}
catch (Exception ex)
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "scriptkey", "<script>alert('System Error.txtMemNo_TextChanged Problem');</script>");
//throw ex;
}
}
protected void txtMemNo_TextChanged(object sender, EventArgs e)
{
if (txtMemNo.Text != string.Empty)
{
A2ZMEMBERDTO getDTO = new A2ZMEMBERDTO();
Int16 CuType = Converter.GetSmallInteger(lblhideCutype.Text);
int CreditNumber = Converter.GetInteger(lblhideCuNo.Text);
int MemNumber = Converter.GetInteger(txtMemNo.Text);
getDTO = (A2ZMEMBERDTO.GetInformation(CuType, CreditNumber, MemNumber));
if (getDTO.NoRecord > 0)
{
ddlMemNo.SelectedValue = Converter.GetString(getDTO.MemberNo);
txtMemNo.Focus();
}
else
{
ddlMemNo.SelectedValue = "-Select-";
}
}
}
protected void ddlMemNo_SelectedIndexChanged(object sender, EventArgs e)
{
if (ddlMemNo.SelectedValue == "-Select-")
{
txtMemNo.Text = string.Empty;
txtMemNo.Focus();
}
if (ddlMemNo.SelectedValue != "-Select-")
{
A2ZMEMBERDTO getDTO = new A2ZMEMBERDTO();
Int16 CuType = Converter.GetSmallInteger(0);
int CreditNumber = Converter.GetInteger(0);
int MemNumber = Converter.GetInteger(ddlMemNo.SelectedValue);
getDTO = (A2ZMEMBERDTO.GetInformation(CuType, CreditNumber, MemNumber));
if (getDTO.NoRecord > 0)
{
txtMemNo.Text = Converter.GetString(ddlMemNo.SelectedValue);
string qry = "SELECT Image,MemNo FROM uploadImg WHERE CuType='0' and CuNo='0' and MemNo = '" + txtMemNo.Text + "'";
DataTable dt = DataAccessLayer.BLL.CommonManager.Instance.GetDataTableByQuery(qry, "A2ZIMAGEMCUS");
if (dt.Rows.Count > 0)
{
CheckCU();
con.Open();
using (SqlCommand cmd = new SqlCommand("SELECT CuType,CuNo,MemNo,Image FROM uploadImg WHERE CuType='0' and CuNo='0' and MemNo = '" + txtMemNo.Text + "'", con))
using (SqlDataReader reader = cmd.ExecuteReader())
{
if (reader.Read())
{
byte[] picData = reader["Image"] as byte[] ?? null;
if (picData != null)
{
using (MemoryStream ms = new MemoryStream(picData))
{
string base64String = Convert.ToBase64String(picData, 0, picData.Length);
ImgPicture.ImageUrl = "data:image/png;base64," + base64String;
}
}
}
}
ibtnUpload.Visible = false;
BtnUpdate.Visible = true;
return;
}
else
{
ibtnUpload.Visible = true;
BtnUpdate.Visible = false;
ImgPicture.ImageUrl = "~/Images/index.jpg";
return;
}
}
else
{
ddlMemNo.SelectedValue = "-Select-";
txtMemNo.Text = string.Empty;
ImgPicture.ImageUrl = "~/Images/index.jpg";
ibtnUpload.Visible = true;
BtnUpdate.Visible = false;
}
}
else
{
txtMemNo.Text = string.Empty;
}
}
protected void BtnProcess_Click(object sender, EventArgs e)
{
if (txtProcessDate.Text == string.Empty)
{
//String csname1 = "PopupScript";
//Type cstype = GetType();
//ClientScriptManager cs = Page.ClientScript;
//if (!cs.IsStartupScriptRegistered(cstype, csname1))
//{
// String cstext1 = "alert('Please fill up the process date!' );";
// cs.RegisterStartupScript(cstype, csname1, cstext1, true);
//}
ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Please fill up the Process Date');", true);
return;
}
if (txtVchNo.Text == string.Empty && ddlFuncType.SelectedValue == "99")
{
//String csname1 = "PopupScript";
//Type cstype = GetType();
//ClientScriptManager cs = Page.ClientScript;
//if (!cs.IsStartupScriptRegistered(cstype, csname1))
//{
// String cstext1 = "alert('Please Input Voucher No.' );";
// cs.RegisterStartupScript(cstype, csname1, cstext1, true);
//}
ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Please Input Voucher No.');", true);
return;
}
DateTime fdate = DateTime.ParseExact(txtProcessDate.Text, "dd/MM/yyyy", System.Globalization.CultureInfo.InvariantCulture);
////if(lblProcDate.Text != txtProcessDate.Text)
////{
//// lblVchFlag.Text = "1";
//// lblVchYear.Text = Converter.GetString(fdate.Year);
////}
////else
////{
lblVchFlag.Text = "0";
////}
string qry;
if (ddlFuncType.SelectedValue == "99")
{
if (lblVchFlag.Text == "0")
{
if (CtrlModule.Text == "1")
{
qry = "SELECT Id,CuType,CuNo,MemNo,FuncOpt,TrnType,ValueDate,UserID,FromCashCode FROM A2ZTRANSACTION WHERE VchNo = '" + txtVchNo.Text + "' AND TrnDate='" + fdate + "' AND TrnFlag= 0 AND TrnCSGL= 0";
}
else
{
qry = "SELECT Id,CuType,CuNo,MemNo,FuncOpt,TrnType,ValueDate,UserID,FromCashCode FROM A2ZTRANSACTION WHERE VchNo = '" + txtVchNo.Text + "' AND TrnDate='" + fdate + "' AND FromCashCode='" + lblCashCode.Text + "' AND TrnFlag= 0 AND TrnCSGL= 0";
}
}
else
{
if (CtrlModule.Text == "1")
{
qry = "SELECT Id,CuType,CuNo,MemNo,FuncOpt,TrnType,ValueDate,UserID,FromCashCode FROM A2ZCSMCUST" + lblVchYear.Text + "..A2ZTRANSACTION WHERE VchNo = '" + txtVchNo.Text + "' AND TrnDate='" + fdate + "' AND TrnFlag= 0 AND TrnCSGL= 0";
}
else
{
qry = "SELECT Id,CuType,CuNo,MemNo,FuncOpt,TrnType,ValueDate,UserID,FromCashCode FROM A2ZCSMCUST" + lblVchYear.Text + "..A2ZTRANSACTION WHERE VchNo = '" + txtVchNo.Text + "' AND TrnDate='" + fdate + "' AND FromCashCode='" + lblCashCode.Text + "' AND TrnFlag= 0 AND TrnCSGL= 0";
}
}
}
else
{
if (lblVchFlag.Text == "0")
{
if (CtrlModule.Text == "1")
{
qry = "SELECT Id,CuType,CuNo,MemNo,FuncOpt,TrnType,ValueDate,UserID,FromCashCode FROM A2ZTRANSACTION WHERE VchNo = '" + lblAutoVchNo.Text + "' AND TrnDate='" + fdate + "' AND TrnFlag= 0 AND TrnCSGL= 0";
}
else
{
qry = "SELECT Id,CuType,CuNo,MemNo,FuncOpt,TrnType,ValueDate,UserID,FromCashCode FROM A2ZTRANSACTION WHERE VchNo = '" + lblAutoVchNo.Text + "' AND TrnDate='" + fdate + "' AND FromCashCode='" + lblCashCode.Text + "' AND TrnFlag= 0 AND TrnCSGL= 0";
}
}
else
{
if (CtrlModule.Text == "1")
{
qry = "SELECT Id,CuType,CuNo,MemNo,FuncOpt,TrnType,ValueDate,UserID,FromCashCode FROM A2ZCSMCUST" + lblVchYear.Text + "..A2ZTRANSACTION WHERE VchNo = '" + lblAutoVchNo.Text + "' AND TrnDate='" + fdate + "' AND TrnFlag= 0 AND TrnCSGL= 0";
}
else
{
qry = "SELECT Id,CuType,CuNo,MemNo,FuncOpt,TrnType,ValueDate,UserID,FromCashCode FROM A2ZCSMCUST" + lblVchYear.Text + "..A2ZTRANSACTION WHERE VchNo = '" + lblAutoVchNo.Text + "' AND TrnDate='" + fdate + "' AND FromCashCode='" + lblCashCode.Text + "' AND TrnFlag= 0 AND TrnCSGL= 0";
}
}
}
DataTable dt = DataAccessLayer.BLL.CommonManager.Instance.GetDataTableByQuery(qry, "A2ZCSMCUS");
if (dt.Rows.Count > 0)
{
lblCuType.Text = Converter.GetString(dt.Rows[0]["CuType"]);
lblCuNo.Text = Converter.GetString(dt.Rows[0]["CuNo"]);
lblMemNo.Text = Converter.GetString(dt.Rows[0]["MemNo"]);
lblFuncOpt.Text = Converter.GetString(dt.Rows[0]["FuncOpt"]);
lblTrnType.Text = Converter.GetString(dt.Rows[0]["TrnType"]);
lblValueDate.Text = Converter.GetString(dt.Rows[0]["ValueDate"]);
lblUserID.Text = Converter.GetString(dt.Rows[0]["UserID"]);
lblFromCashCode.Text = Converter.GetString(dt.Rows[0]["FromCashCode"]);
string qry1 = "SELECT IdsNo,IdsName from A2ZSYSIDS WHERE IdsNo = '" + lblUserID.Text + "'";
DataTable dt1 = DataAccessLayer.BLL.CommonManager.Instance.GetDataTableByQuery(qry1, "A2ZCSMCUS");
if (dt1.Rows.Count > 0)
{
lblUserIDName.Text = Converter.GetString(dt1.Rows[0]["IdsName"]);
}
string qry3 = "SELECT GLAccDesc FROM A2ZCGLMST where GLAccNo='" + lblFromCashCode.Text + "'";
DataTable dt3 = DataAccessLayer.BLL.CommonManager.Instance.GetDataTableByQuery(qry3, "A2ZGLMCUS");
if (dt3.Rows.Count > 0)
{
lblBoothNo.Text = lblFromCashCode.Text;
lblBoothName.Text = Converter.GetString(dt3.Rows[0]["GLAccDesc"]);
}
}
else
{
txtVchNo.Text = string.Empty;
txtVchNo.Focus();
InvalidVoucherMSG();
return;
}
Int16 CUType = Converter.GetSmallInteger(lblCuType.Text);
int CUNo = Converter.GetInteger(lblCuNo.Text);
int MNo = Converter.GetInteger(lblMemNo.Text);
A2ZMEMBERDTO get6DTO = (A2ZMEMBERDTO.GetInformation(CUType, CUNo, MNo));
if (get6DTO.NoRecord > 0)
{
lblMemName.Text = Converter.GetString(get6DTO.MemberName);
}
if (lblTrnType.Text == "1")
{
lblTrnTypeTitle.Text = "CASH";
}
else
{
lblTrnTypeTitle.Text = "TRANSFER";
}
if (lblFuncOpt.Text == "1" || lblFuncOpt.Text == "2" || lblFuncOpt.Text == "11")
{
lblFuncTitle.Text = "DEPOSIT";
}
else
{
lblFuncTitle.Text = "WITHDRAWAL";
}
if (ddlFuncType.SelectedValue == "99")
{
PrintTrnVoucher1();
}
else
{
PrintTrnVoucher2();
}
}
public void GetAccInfo()
{
try
{
Int64 AccNumber = Converter.GetLong(txtAccNo.Text);
A2ZACCOUNTDTO accgetDTO = (A2ZACCOUNTDTO.GetInfoAccNo(AccNumber));
if (accgetDTO.a == 0)
{
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;
}
}
}
}
}
public void GetAccInfo()
{
try
{
Int64 AccNumber = Converter.GetLong(txtAccNo.Text);
A2ZACCOUNTDTO accgetDTO = (A2ZACCOUNTDTO.GetInfoAccNo(AccNumber));
if (accgetDTO.a == 0)
{
InvalidAccMSG();
txtAccNo.Text = string.Empty;
txtAccNo.Focus();
return;
}
else
{
lblAccBalance.Text = Converter.GetString(String.Format("{0:0,0.00}", accgetDTO.AccBalance));
lblBalance.Text = Converter.GetString(String.Format("{0:0,0.00}", accgetDTO.AccBalance));
lblBalLienAmount.Text = Converter.GetString(String.Format("{0:0,0.00}", accgetDTO.AccLienAmt));
lblStatP.Text = Converter.GetString(accgetDTO.AccStatus);
DateTime dt = Converter.GetDateTime(accgetDTO.AccStatusDate);
string date = dt.ToString("dd/MM/yyyy");
lblCurrRef.Text = Converter.GetString(accgetDTO.AccStatusNote);
if (lblStatP.Text == "98")
{
txtAccNo.Text = string.Empty;
txtAccNo.Focus();
InvalidAccStatusChg();
return;
}
if (lblStatP.Text == "50")
{
lblBalLien.Visible = true;
lblBalLienAmount.Visible = true;
}
if (date == "01/01/0001")
{
lblCurrStatDt.Text = string.Empty;
}
else
{
lblCurrStatDt.Text = date;
}
string qry1 = "SELECT AccStatusDescription FROM A2ZACCSTATUS where AccStatusCode='" + lblStatP.Text + "'";
DataTable dt1 = DataAccessLayer.BLL.CommonManager.Instance.GetDataTableByQuery(qry1, "A2ZCSMCUS");
if (dt1.Rows.Count > 0)
{
lblCurrStatus.Text = Converter.GetString(dt1.Rows[0]["AccStatusDescription"]);
}
lblCuType.Text = Converter.GetString(accgetDTO.CuType);
lblCuNo.Text = Converter.GetString(accgetDTO.CuNo);
txtCreditUNo.Text = (lblCuType.Text + "-" + lblCuNo.Text);
txtMemNo.Text = Converter.GetString(accgetDTO.MemberNo);
CtrlAccType.Text = Converter.GetString(accgetDTO.AccType);
lblcls.Text = Converter.GetString(accgetDTO.AccAtyClass);
Int16 AccType = Converter.GetSmallInteger(CtrlAccType.Text);
A2ZACCTYPEDTO get3DTO = (A2ZACCTYPEDTO.GetInformation(AccType));
if (get3DTO.AccTypeCode > 0)
{
lblAccTitle.Text = Converter.GetString(get3DTO.AccTypeDescription);
}
Int16 CType = Converter.GetSmallInteger(lblCuType.Text);
int CNo = Converter.GetInteger(lblCuNo.Text);
A2ZCUNIONDTO get5DTO = (A2ZCUNIONDTO.GetInformation(CType, CNo));
if (get5DTO.NoRecord > 0)
{
lblCuName.Text = Converter.GetString(get5DTO.CreditUnionName);
}
Int16 CUType = Converter.GetSmallInteger(lblCuType.Text);
int CUNo = Converter.GetInteger(lblCuNo.Text);
int MNo = Converter.GetInteger(txtMemNo.Text);
A2ZMEMBERDTO get6DTO = (A2ZMEMBERDTO.GetInformation(CUType, CUNo, MNo));
if (get6DTO.NoRecord > 0)
{
lblMemName.Text = Converter.GetString(get6DTO.MemberName);
}
}
}
catch (Exception ex)
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "scriptkey", "<script>alert('System Error.GetAccInfo Problem');</script>");
//throw ex;
}
}
protected void txtTrnMemNo_TextChanged(object sender, EventArgs e)
{
try
{
if (txtTrnMemNo.Text != string.Empty && txtTrnCuNo.Text != string.Empty)
{
Int16 CuType = Converter.GetSmallInteger(lblTrnferCuType.Text);
int CNo = Converter.GetSmallInteger(lblTrnferCuNo.Text);
int MemNumber = Converter.GetInteger(txtTrnMemNo.Text);
int CuNumber = Converter.GetInteger(hdnCuNumber.Text);
A2ZMEMBERDTO getDTO = new A2ZMEMBERDTO();
getDTO = (A2ZMEMBERDTO.GetInformation(CuType, CNo, MemNumber));
//A2ZMEMBERDTO getDTO = new A2ZMEMBERDTO();
//getDTO = (A2ZMEMBERDTO.GetInfoMember(CuType, CNo, CuNumber, MemNumber));
if (getDTO.NoRecord > 0)
{
txtTrnMemNo.Text = Converter.GetString(getDTO.MemberNo);
lblTrfMemName.Text = Converter.GetString(getDTO.MemberName);
//ddlTrnMemNo.SelectedValue = Converter.GetString(getDTO.MemberNo);
string a = txtAccNo.Text;
string b = a.Substring(15, 1);
if (txtAccType.Text == "53")
{
string qry1 = "SELECT Id,AccNo FROM A2ZACCOUNT where CuType='" + lblTrnferCuType.Text + "' and CuNo='" + lblTrnferCuNo.Text + "' and MemNo='" + txtTrnMemNo.Text + "' and AccType='" + txtAccType.Text + "' and Right(AccNo,1) = '" + b + "'";
DataTable dt1 = DataAccessLayer.BLL.CommonManager.Instance.GetDataTableByQuery(qry1, "A2ZCSMCUS");
if (dt1.Rows.Count > 0)
{
NotAllowAccount();
txtTrnMemNo.Text = string.Empty;
txtTrnMemNo.Focus();
return;
}
else
{
return;
}
}
string qry = "SELECT Id,AccNo FROM A2ZACCOUNT where CuType='" + lblTrnferCuType.Text + "' and CuNo='" + lblTrnferCuNo.Text + "' and MemNo='" + txtTrnMemNo.Text + "' and AccType='" + txtAccType.Text + "'";
DataTable dt = DataAccessLayer.BLL.CommonManager.Instance.GetDataTableByQuery(qry, "A2ZCSMCUS");
if (dt.Rows.Count > 0)
{
if (lblAccFlag.Text == "1" || lblAccFlag.Text == "2")
{
MultiAccount();
txtTrnMemNo.Text = string.Empty;
txtTrnMemNo.Focus();
return;
}
}
else
{
if (lblAccessType1.Text == "0" && lblTrnferCuType.Text == "1")
{
NotAllowAccount();
txtTrnMemNo.Text = string.Empty;
txtTrnMemNo.Focus();
return;
}
if (lblAccessType2.Text == "0" && lblTrnferCuType.Text == "2")
{
NotAllowAccount();
txtTrnMemNo.Text = string.Empty;
txtTrnMemNo.Focus();
return;
}
if (lblAccessType3.Text == "0" && lblTrnferCuType.Text == "3")
{
NotAllowAccount();
txtTrnMemNo.Text = string.Empty;
txtTrnMemNo.Focus();
return;
}
}
}
else
{
InvalidMemNo();
txtTrnMemNo.Text = string.Empty;
txtTrnMemNo.Focus();
}
}
}
catch (Exception ex)
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "scriptkey", "<script>alert('System Error.txtTrnMemNo_TextChanged Problem');</script>");
//throw ex;
}
}
protected void ddlPMemNo_SelectedIndexChanged(object sender, EventArgs e)
{
if (ddlPMemNo.SelectedItem.Text == "-Select-")
{
txtPMemNo.Text = string.Empty;
clearInfo();
txtPMemNo.Focus();
BtnSubmit.Visible = true;
BtnUpdate.Visible = false;
}
try
{
if (ddlPMemNo.SelectedValue != "-Select-")
{
A2ZMEMBERDTO getDTO = new A2ZMEMBERDTO();
Int16 CuType = Converter.GetSmallInteger(0);
int CreditNumber = Converter.GetInteger(0);
int MemNumber = Converter.GetInteger(ddlPMemNo.SelectedValue);
getDTO = (A2ZMEMBERDTO.GetInformation(CuType, CreditNumber, MemNumber));
if (getDTO.CreditUnionNo > 0 || getDTO.MemberNo > 0)
{
txtPMemNo.Text = Converter.GetString(getDTO.MemberNo);
txtPMemName.Text = getDTO.MemberName;
ddlPMemNo.SelectedValue = Converter.GetString(getDTO.MemberNo);
txtFatherName.Text = Converter.GetString(getDTO.FatherName);
txtMotherName.Text = Converter.GetString(getDTO.MotherName);
txtSpouseName.Text = Converter.GetString(getDTO.SpouseName);
DateTime dt = Converter.GetDateTime(getDTO.OpenDate);
string date = dt.ToString("dd/MM/yyyy");
txtOpenDate.Text = date;
DateTime dt1 = Converter.GetDateTime(getDTO.DateOfBirth);
string date1 = dt1.ToString("dd/MM/yyyy");
txtDateOfBirth.Text = date1;
txtPlaceOfBirth.Text = Converter.GetString(getDTO.PlaceofBirth);
ddlOccupation.SelectedValue = Converter.GetString(getDTO.Occupation);
ddlNationality.SelectedValue = Converter.GetString(getDTO.Nationality);
ddlGender.SelectedValue = Converter.GetString(getDTO.Gender);
ddlMemType.SelectedValue = Converter.GetString(getDTO.MemType);
ddlReligion.SelectedValue = Converter.GetString(getDTO.Religion);
ddlNature.SelectedValue = Converter.GetString(getDTO.Nature);
ddlMaritalStatus.SelectedValue = Converter.GetString(getDTO.MaritalStatus);
txtAddressL1.Text = Converter.GetString(getDTO.PreAddressLine1);
txtAddressL2.Text = Converter.GetString(getDTO.PreAddressLine2);
txtAddressL3.Text = Converter.GetString(getDTO.PreAddressLine3);
ddlDivision.SelectedValue = Converter.GetString(getDTO.PreDivision);
ddlDistrict.SelectedValue = Converter.GetString(getDTO.PreDistrict);
ddlThana.SelectedValue = Converter.GetString(getDTO.preThana);
txtTelNo.Text = Converter.GetString(getDTO.PreTelephone);
txtMobileNo.Text = Converter.GetString(getDTO.PreMobile);
txtEmail.Text = Converter.GetString(getDTO.PreEmail);
txtPerAddL1.Text = Converter.GetString(getDTO.PerAddressLine1);
txtPerAddL2.Text = Converter.GetString(getDTO.PerAddressLine2);
txtPerAddL3.Text = Converter.GetString(getDTO.PerAddressLine3);
ddlDivision.SelectedValue = Converter.GetString(getDTO.PerDivision);
ddlDistrict.SelectedValue = Converter.GetString(getDTO.PerDistrict);
ddlThana.SelectedValue = Converter.GetString(getDTO.PerThana);
txtPerTelNo.Text = Converter.GetString(getDTO.PerTelephone);
txtPerMobNo.Text = Converter.GetString(getDTO.PerMobile);
txtPerEmail.Text = Converter.GetString(getDTO.PerEmail);
txtEmpName.Text = Converter.GetString(getDTO.EmployerName);
txtEmpAddress.Text = Converter.GetString(getDTO.EmployerAddress);
txtIntroducerMem1.Text = Converter.GetString(getDTO.IntroducerNo1);
txtIntroducerName1.Text = Converter.GetString(getDTO.IntroducerName1);
txtIntroduceMem2.Text = Converter.GetString(getDTO.IntroducerNo2);
txtIntroducerName2.Text = Converter.GetString(getDTO.IntroducerName2);
txtPassportNo.Text = Converter.GetString(getDTO.PassportNo);
DateTime dt2 = Converter.GetDateTime(getDTO.PassportIssueDate);
string date2 = dt2.ToString("dd/MM/yyyy");
txtPassportIssueDate.Text = date2;
txtPassportIssuePlace.Text = Converter.GetString(getDTO.PassportIssuePlace);
txtNationalID.Text = Converter.GetString(getDTO.NationalIdNo);
DateTime dt4 = Converter.GetDateTime(getDTO.PassportExpiryDate);
string date4 = dt4.ToString("dd/MM/yyyy");
txtPassportExpdate.Text = date4;
txtTIN.Text = Converter.GetString(getDTO.TIN);
DateTime dt3 = Converter.GetDateTime(getDTO.LastTaxPayDate);
string date3 = dt3.ToString("dd/MM/yyyy");
txtLastTaxPdate.Text = date3;
txtPMemName.Focus();
}
BtnSubmit.Visible = false;
BtnUpdate.Visible = true;
}
}
catch (Exception ex)
{
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;
}
txtTrnStaffCode.Text = Converter.GetString(accgetDTO.MemberNo);
CtrlTrnAccType.Text = Converter.GetString(accgetDTO.AccType);
lblcls.Text = Converter.GetString(accgetDTO.AccAtyClass);
lblTrnAtyClass.Text = Converter.GetString(accgetDTO.AccAtyClass);
if (lblTrnAtyClass.Text == "5" || lblTrnAtyClass.Text == "6")
{
lblIntAmt.Visible = true;
txtIntAmt.Visible = true;
lblPrincAmt.Visible = true;
txtPrincAmt.Visible = true;
txtTrnAmount.ReadOnly = true;
}
if (lblAtyClass.Text == "7")
{
string input = txtTrnAccNo.Text;
lblTrnPayType.Text = input.Substring(13, 3);
int paytype = Converter.GetInteger(lblTrnPayType.Text);
A2ZTRNCODEDTO get3DTO = (A2ZTRNCODEDTO.GetInformation99(paytype));
if (get3DTO.TrnCode > 0)
{
lblTrnAccTitle.Text = Converter.GetString(get3DTO.TrnDescription);
}
}
else
{
lblTrnPayType.Text = "0";
Int16 AccType = Converter.GetSmallInteger(CtrlTrnAccType.Text);
A2ZACCTYPEDTO get3DTO = (A2ZACCTYPEDTO.GetInformation(AccType));
if (get3DTO.AccTypeCode > 0)
{
lblTrnAccTitle.Text = Converter.GetString(get3DTO.AccTypeDescription);
}
}
int MNo = Converter.GetInteger(txtTrnStaffCode.Text);
A2ZMEMBERDTO get6DTO = (A2ZMEMBERDTO.GetInformation(0, 0, MNo));
if (get6DTO.NoRecord > 0)
{
lblTrnStaffName.Text = Converter.GetString(get6DTO.MemberName);
}
}
}
catch (Exception ex)
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "scriptkey", "<script>alert('System Error.GetAccInfo Problem');</script>");
//throw ex;
}
}
protected void txtMemNo_TextChanged(object sender, EventArgs e)
{
try
{
if (txtMemNo.Text != string.Empty)
{
A2ZMEMBERDTO getDTO = new A2ZMEMBERDTO();
Int16 CuType = Converter.GetSmallInteger(lblhideCutype.Text);
int CreditNumber = Converter.GetInteger(lblhideCuNo.Text);
int MemNumber = Converter.GetInteger(txtMemNo.Text);
getDTO = (A2ZMEMBERDTO.GetInformation(CuType, CreditNumber, MemNumber));
if (getDTO.NoRecord > 0)
{
lblMemName.Text = Converter.GetString(getDTO.MemberName);
string qry = "SELECT Image,MemNo FROM uploadImg WHERE CuType='" + lblhideCutype.Text + "' and CuNo='" + lblhideCuNo.Text + "' and MemNo='" + txtMemNo.Text + "'";
DataTable dt = DataAccessLayer.BLL.CommonManager.Instance.GetDataTableByQuery(qry, "A2ZIMAGEMCUS");
if (dt.Rows.Count > 0)
{
CheckCU();
con.Open();
using (SqlCommand cmd = new SqlCommand("SELECT CuType,CuNo,MemNo,Image FROM uploadImg WHERE CuType='" + lblhideCutype.Text + "' and CuNo='" + lblhideCuNo.Text + "' and MemNo='" + txtMemNo.Text + "'", con))
using (SqlDataReader reader = cmd.ExecuteReader())
{
if (reader.Read())
{
byte[] picData = reader["Image"] as byte[] ?? null;
if (picData != null)
{
using (MemoryStream ms = new MemoryStream(picData))
{
string base64String = Convert.ToBase64String(picData, 0, picData.Length);
ImgPicture.ImageUrl = "data:image/png;base64," + base64String;
}
}
}
}
ibtnUpload.Visible = false;
BtnUpdate.Visible = true;
return;
}
else
{
ibtnUpload.Visible = true;
BtnUpdate.Visible = false;
ImgPicture.ImageUrl = "~/Images/index.jpg";
return;
}
}
else
{
txtCuNo.Text = string.Empty;
txtCuNo.Focus();
txtMemNo.Text = string.Empty;
ImgPicture.ImageUrl = "~/Images/index.jpg";
ibtnUpload.Visible = true;
BtnUpdate.Visible = false;
}
}
else
{
}
}
catch (Exception ex)
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "scriptkey", "<script>alert('System Error.txtMemNo_TextChanged Problem');</script>");
//throw ex;
}
}
protected void txtCULBMemNo_TextChanged(object sender, EventArgs e)
{
try
{
if (txtCULBMemNo.Text != string.Empty)
{
string c = "";
int a = txtCreditUNo.Text.Length;
string b = txtCreditUNo.Text;
c = b.Substring(0, 1);
int re = Converter.GetSmallInteger(c);
int dd = a - 1;
string d = b.Substring(1, dd);
int re1 = Converter.GetSmallInteger(d);
Int16 CuType = Converter.GetSmallInteger(lblCUType.Text);
int CNo = Converter.GetSmallInteger(lblCUNumber.Text);
int MemNumber = Converter.GetInteger(txtCULBMemNo.Text);
A2ZMEMBERDTO getDTO = new A2ZMEMBERDTO();
getDTO = (A2ZMEMBERDTO.GetInformation(CuType, CNo, MemNumber));
if (getDTO.NoRecord > 0)
{
if (CtrlModule.Text == "1")
{
ddlCULBMemNo.SelectedValue = Converter.GetString(getDTO.MemberNo);
}
txtCULBMemName.Text = getDTO.MemberName;
txtFatherName.Text = Converter.GetString(getDTO.FatherName);
txtMotherName.Text = Converter.GetString(getDTO.MotherName);
txtSpouseName.Text = Converter.GetString(getDTO.SpouseName);
DateTime dt = Converter.GetDateTime(getDTO.OpenDate);
string date = dt.ToString("dd/MM/yyyy");
txtOpenDate.Text = date;
DateTime dt1 = Converter.GetDateTime(getDTO.DateOfBirth);
string date1 = dt1.ToString("dd/MM/yyyy");
txtDateOfBirth.Text = date1;
txtPlaceOfBirth.Text = Converter.GetString(getDTO.PlaceofBirth);
ddlOccupation.SelectedValue = Converter.GetString(getDTO.Occupation);
ddlNationality.SelectedValue = Converter.GetString(getDTO.Nationality);
ddlGender.SelectedValue = Converter.GetString(getDTO.Gender);
ddlMemType.SelectedValue = Converter.GetString(getDTO.MemType);
ddlReligion.SelectedValue = Converter.GetString(getDTO.Religion);
ddlNature.SelectedValue = Converter.GetString(getDTO.Nature);
ddlMaritalStatus.SelectedValue = Converter.GetString(getDTO.MaritalStatus);
txtAddressL1.Text = Converter.GetString(getDTO.PreAddressLine1);
txtAddressL2.Text = Converter.GetString(getDTO.PreAddressLine2);
txtAddressL3.Text = Converter.GetString(getDTO.PreAddressLine3);
ddlDivision.SelectedValue = Converter.GetString(getDTO.PreDivision);
ddlDistrict.SelectedValue = Converter.GetString(getDTO.PreDistrict);
ddlThana.SelectedValue = Converter.GetString(getDTO.preThana);
txtTelNo.Text = Converter.GetString(getDTO.PreTelephone);
txtMobileNo.Text = Converter.GetString(getDTO.PreMobile);
txtEmail.Text = Converter.GetString(getDTO.PreEmail);
txtPerAddL1.Text = Converter.GetString(getDTO.PerAddressLine1);
txtPerAddL2.Text = Converter.GetString(getDTO.PerAddressLine2);
txtPerAddL3.Text = Converter.GetString(getDTO.PerAddressLine3);
ddlPerDivision.SelectedValue = Converter.GetString(getDTO.PerDivision);
ddlPerDistrict.SelectedValue = Converter.GetString(getDTO.PerDistrict);
ddlPerThana.SelectedValue = Converter.GetString(getDTO.PerThana);
txtPerTelNo.Text = Converter.GetString(getDTO.PerTelephone);
txtPerMobNo.Text = Converter.GetString(getDTO.PerMobile);
txtPerEmail.Text = Converter.GetString(getDTO.PerEmail);
txtEmpName.Text = Converter.GetString(getDTO.EmployerName);
txtEmpAddress.Text = Converter.GetString(getDTO.EmployerAddress);
txtIntroducerMem1.Text = Converter.GetString(getDTO.IntroducerNo1);
txtIntroducerName1.Text = Converter.GetString(getDTO.IntroducerName1);
txtIntroduceMem2.Text = Converter.GetString(getDTO.IntroducerNo2);
txtIntroducerName2.Text = Converter.GetString(getDTO.IntroducerName2);
txtPassportNo.Text = Converter.GetString(getDTO.PassportNo);
DateTime dt2 = Converter.GetDateTime(getDTO.PassportIssueDate);
string date2 = dt2.ToString("dd/MM/yyyy");
txtPassportIssueDate.Text = date2;
txtPassportIssuePlace.Text = Converter.GetString(getDTO.PassportIssuePlace);
txtNationalID.Text = Converter.GetString(getDTO.NationalIdNo);
DateTime dt4 = Converter.GetDateTime(getDTO.PassportExpiryDate);
string date4 = dt4.ToString("dd/MM/yyyy");
txtPassportExpdate.Text = date4;
txtTIN.Text = Converter.GetString(getDTO.TIN);
DateTime dt3 = Converter.GetDateTime(getDTO.LastTaxPayDate);
string date3 = dt3.ToString("dd/MM/yyyy");
txtLastTaxPdate.Text = date3;
txtCULBMemName.Focus();
BtnSubmit.Visible = false;
BtnUpdate.Visible = true;
}
else
{
clearInfo();
txtCULBMemName.Text = string.Empty;
BtnSubmit.Visible = true;
BtnUpdate.Visible = false;
txtCULBMemName.Focus();
if (CtrlModule.Text == "1")
{
ddlCULBMemNo.SelectedIndex = 0;
}
}
}
}
catch (Exception ex)
{
throw ex;
}
}
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;
}
}
}
}
