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 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 BtnSubmit_Click(object sender, EventArgs e)
{
A2ZMEMBERDTO objDTO = new A2ZMEMBERDTO();
objDTO.MemberNo = Converter.GetInteger(txtPMemNo.Text);
objDTO.MemberName = Converter.GetString(txtPMemName.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.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());
}
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(ddlDivision.SelectedValue);
objDTO.PerDistrict = Converter.GetInteger(ddlDistrict.SelectedValue);
objDTO.PerThana = Converter.GetInteger(ddlThana.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.ToLongDateString());
}
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.ToLongDateString());
}
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.ToLongDateString());
}
int roweffect = A2ZMEMBERDTO.InsertInformation(objDTO);
if (roweffect > 0)
{
txtPMemNo.Text = string.Empty;
clearInfo();
txtPMemNo.Focus();
PrimaryMemDropdown();
}
}
