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 BtnUpdate_Click(object sender, EventArgs e)
{
A2ZMEMBERDTO UpDTO = new A2ZMEMBERDTO();
UpDTO.CreditUnionNo = Converter.GetInteger(0);
UpDTO.MemberNo = Converter.GetInteger(txtPMemNo.Text);
UpDTO.MemberName = Converter.GetString(txtPMemName.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.Religion = Converter.GetSmallInteger(ddlReligion.SelectedValue);
UpDTO.Nature = Converter.GetSmallInteger(ddlNature.SelectedValue);
UpDTO.MaritalStatus = Converter.GetSmallInteger(ddlMaritalStatus.SelectedValue);
DateTime opdate = Converter.GetDateTime(txtOpenDate.Text);
UpDTO.OpenDate = opdate;
DateTime Birthdate = Converter.GetDateTime(txtDateOfBirth.Text);
UpDTO.DateOfBirth = Birthdate;
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(ddlDivision.SelectedValue);
UpDTO.PerDistrict = Converter.GetInteger(ddlDistrict.SelectedValue);
UpDTO.PerThana = Converter.GetInteger(ddlThana.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);
DateTime Issuedate = Converter.GetDateTime(txtPassportIssueDate.Text);
UpDTO.PassportIssueDate = Issuedate;
DateTime Expdate = Converter.GetDateTime(txtPassportExpdate.Text);
UpDTO.PassportExpiryDate = Expdate;
UpDTO.PassportIssuePlace = Converter.GetString(txtPassportIssuePlace.Text);
UpDTO.TIN = Converter.GetString(txtTIN.Text);
DateTime LTpaydate = Converter.GetDateTime(txtLastTaxPdate.Text);
UpDTO.LastTaxPayDate = LTpaydate;
int roweffect = A2ZMEMBERDTO.UpdateInformation(UpDTO);
if (roweffect > 0)
{
PrimaryMemDropdown();
txtPMemNo.Focus();
clearInfo();
ddlPMemNo.SelectedValue = "-Select-";
BtnUpdate.Visible = false;
BtnSubmit.Visible = true;
txtPMemNo.Text = string.Empty;
}
else
{
clearInfo();
}
}
