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