public List <clsMemberRegistration> GetAllUnSentToGP() { List <clsMemberRegistration> lst = new List <clsMemberRegistration>(); using (SqlConnection conn = new SqlConnection(strConn)) { using (SqlCommand cmd = new SqlCommand("TMR_USP_GetUnSentToGP")) { cmd.CommandType = CommandType.StoredProcedure; cmd.Connection = conn; conn.Open(); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { clsMemberRegistration info = new clsMemberRegistration(); info.id = int.Parse(reader["id"].ToString()); info.RegistrationNo = reader["RegistrationNo"].ToString(); info.ClientID = reader["ClientID"].ToString(); info.Name = reader["Name"].ToString(); info.Booking = Convert.ToDateTime(reader["Booking"]); info.strProjectid = reader["ProjectID"].ToString(); info.Plan = reader["Plan"].ToString(); lst.Add(info); } conn.Close(); } } return(lst); }
private void Clear() { id = 0; cmbApprovalStatus.Text = "Not Saved"; txtRegistration.Text = ""; txtProject.Text = ""; txtBlock.Text = ""; txtPlot.Text = ""; txtClientID.Text = ""; txtName.Text = ""; cBFatherHusband.Text = ""; txtFatherHusband.Text = ""; txtNIDCNIC.Text = ""; cmbNationality.Text = ""; txtCurrentAddress1.Text = ""; txtCurrentAddress2.Text = ""; txtCurrentAddress3.Text = ""; cmbCountry.Text = ""; txtCity.Text = ""; txtEmailAddress.Text = ""; txtMob.Text = ""; txtPh.Text = ""; txtRes.Text = ""; txtFax.Text = ""; txtTransferID.Text = ""; txtTransferName.Text = ""; cmbTransferFatherHusband.Text = null; txtTransferFatherHusband.Text = ""; cmbTransferNationality.Text = null; dTPTransferDOB.Text = ""; txtTransferCurrentAddress1.Text = ""; txtTransferCurrentAddress2.Text = ""; txtTransferCurrentAddress3.Text = ""; cmbTransferCountry.Text = null; txtTransferCity.Text = ""; txtTransferPh.Text = ""; txtTransferRes.Text = ""; txtTransferMob.Text = ""; txtTransferEmailAddress.Text = ""; txtPictureName.Text = ""; txtTransferEmailAddress.Text = ""; pbTransferToImage.Image = null; txtPictureName.Text = ""; pbTransferToCNIC.Image = null; txtCNICName.Text = ""; pBMemberRegistration.Image = null; pBMemberCNIC.Image = null; infoMember = null; EntryApproved = ApprovalStatus.Pending; /////Enabling btnSelect.Enabled = true; }
private void txtRegistrationNo_TextChanged(object sender, EventArgs e) { #region Loading Member Registration Table Info if (!string.IsNullOrEmpty(txtRegistrationNo.Text)) { info1.RegistrationNo = txtRegistrationNo.Text; info1 = da.GetMemberRegistrationInfo(txtRegistrationNo.Text); txtRegistrationNo.Text = info1.RegistrationNo; txtSizeCode.Text = info1.Plan; txtBookingDate.Text = info1.Booking.ToShortDateString(); txtClientID.Text = info1.ClientID; txtRebatAmt.Text = Convert.ToString(info1.RebatAmt); txtNetRetailPrice.Text = Convert.ToString(info1.NetOrRetailPrice); txtBookingPrice.Text = Convert.ToString(info1.BookingPrice); txtClientName.Text = info1.Name; var res = da.GetMemberImage(txtRegistrationNo.Text, txtClientID.Text); if (!(res == null || res.Image == null)) { pBMemberRegistration.Image = byteArrayToImage(res.Image); } } #endregion }
/// <summary> /// Update Member Reg After Cancellation /// </summary> /// <param name="regNo"></param> /// <param name="status"></param> /// <returns></returns> public bool UpdateMemberRegistrationAfterCancellation(clsMemberRegistration info) { int st = 0; try { using (SqlConnection conn = new SqlConnection(strConn)) { conn.Open(); { using (SqlCommand cmd = new SqlCommand("TMR_USP_UpdateMemRegAfterCancellation")) { cmd.CommandType = CommandType.StoredProcedure; cmd.Connection = conn; cmd.Parameters.AddWithValue("@RegistrationNo", info.RegistrationNo); cmd.Parameters.AddWithValue("@ClientID", info.ClientID); cmd.Parameters.AddWithValue("@StatusCode", info.intStatusCode); st = cmd.ExecuteNonQuery(); } } conn.Close(); } } catch (Exception ex) { } if (st > 0) { return(true); } else { return(false); } }
public bool CreateGPCustomer(clsMemberRegistration info) { int st = 0; try { using (SqlConnection conn = this.GetDBConection(ConnectionType.Company, info.strProjectid)) { conn.Open(); { using (SqlCommand cmd = new SqlCommand("TMR_USP_CreateCustomer")) { cmd.CommandType = CommandType.StoredProcedure; cmd.Connection = conn; cmd.Parameters.AddWithValue("@custnmbr", info.RegistrationNo); cmd.Parameters.AddWithValue("@Name", info.Name); cmd.Parameters.AddWithValue("@CNTCT", info.Name); cmd.Parameters.AddWithValue("@STMNT", info.Name); cmd.Parameters.AddWithValue("@SHRT", info.Name); cmd.Parameters.AddWithValue("@ADRSCODE", "PRIMARY");//info.FatherOrHusbandType); cmd.Parameters.AddWithValue("@ADRS1", info.CurrentAddress1); cmd.Parameters.AddWithValue("@ADRS2", info.CurrentAddress2); cmd.Parameters.AddWithValue("@ADRS3", info.CurrentAddress2); cmd.Parameters.AddWithValue("@CNtry", info.Country); cmd.Parameters.AddWithValue("@city", info.City); cmd.Parameters.AddWithValue("@custclas", "USA-ILMO-T1"); cmd.Parameters.AddWithValue("@PHONEOFF", info.PhOff); cmd.Parameters.AddWithValue("@PHONERES", info.Res); cmd.Parameters.AddWithValue("@MOBILE", info.Mob); cmd.Parameters.AddWithValue("@CNIC", info.ClientID); cmd.Parameters.AddWithValue("@Project", info.strProjectid); cmd.Parameters.AddWithValue("@Block", info.Block); cmd.Parameters.AddWithValue("@UnitID", info.Plot); //@CNIC varchar(50), @Project varchar(50), @PHONEOFF varchar(50), @PHONERES varchar(50), @MOBILE varchar(50) st = cmd.ExecuteNonQuery(); } } conn.Close(); } } catch (Exception ex) { } if (st > 0) { return(true); } else { return(false); } }
private void cmbRegistration_SelectedIndexChanged(object sender, EventArgs e) { infoMember.RegistrationNo = txtRegistrationNo.Text; infoMember = da.GetMemberRegistrationInfo(txtRegistrationNo.Text); txtRegistrationNo.Text = infoMember.RegistrationNo; dTPBooking.Value = infoMember.Booking; txtTotalPrice.Text = Convert.ToString(infoMember.TotalPrice); txtRebatAmt.Text = Convert.ToString(infoMember.RebatAmt); txtNetRetailPrice.Text = Convert.ToString(infoMember.NetOrRetailPrice); txtBookingPrice.Text = Convert.ToString(infoMember.BookingPrice); string strMemCurrentStatus = infoMember.strStatus; }
public bool UpdateGPCustomer(clsMemberRegistration info) { int st = 0; try { using (SqlConnection conn = this.GetDBConection(ConnectionType.Company, info.strProjectid)) { conn.Open(); { using (SqlCommand cmd = new SqlCommand("TMR_USP_UpdateCustomer")) { cmd.CommandType = CommandType.StoredProcedure; cmd.Connection = conn; cmd.Parameters.AddWithValue("@custnmbr", info.RegistrationNo); cmd.Parameters.AddWithValue("@Name", info.Name); cmd.Parameters.AddWithValue("@CNTCT", info.Name); cmd.Parameters.AddWithValue("@STMNT", info.Name); cmd.Parameters.AddWithValue("@SHRT", info.Name); cmd.Parameters.AddWithValue("@ADRSCODE", "PRIMARY");//info.FatherOrHusbandType); cmd.Parameters.AddWithValue("@ADRS1", info.CurrentAddress1); cmd.Parameters.AddWithValue("@ADRS2", info.CurrentAddress2); cmd.Parameters.AddWithValue("@ADRS3", info.CurrentAddress2); cmd.Parameters.AddWithValue("@CNtry", info.Country); cmd.Parameters.AddWithValue("@city", info.City); st = cmd.ExecuteNonQuery(); } } conn.Close(); } } catch (Exception ex) { } if (st > 0) { return(true); } else { return(false); } }
private void LoadMemberImages() { if (!String.IsNullOrEmpty(txtRegistration.Text)) { infoMember.RegistrationNo = txtRegistration.Text; infoMember = da.GetMemberRegistrationInfo(txtRegistration.Text); txtRegistration.Text = infoMember.RegistrationNo; txtClientID.Text = infoMember.ClientID; var res = da.GetMemberImage(txtRegistration.Text, txtClientID.Text); if (!(res == null || res.Image == null)) { pBMemberRegistration.Image = byteArrayToImage(res.Image); } res = da.GetMemberCnic(txtRegistration.Text, txtClientID.Text); if (!(res == null || res.Image == null)) { pBMemberCNIC.Image = byteArrayToImage(res.Image); } } }
public bool UpdateMemberRegistrationAfterAllocation(clsMemberRegistration info) { int st = 0; try { using (SqlConnection conn = new SqlConnection(strConn)) { conn.Open(); { using (SqlCommand cmd = new SqlCommand("TMR_USP_UpdateMemRegAtAllocation")) { cmd.CommandType = CommandType.StoredProcedure; cmd.Connection = conn; cmd.Parameters.AddWithValue("@RegistrationNo", info.RegistrationNo); cmd.Parameters.AddWithValue("@ClientID", info.ClientID); cmd.Parameters.AddWithValue("@Block", info.Block); cmd.Parameters.AddWithValue("@Plot", info.Plot); cmd.Parameters.AddWithValue("@Allocated", info.bitAllocated); cmd.Parameters.AddWithValue("@StatusCode", info.intStatusCode); cmd.Parameters.AddWithValue("@DirectorName", string.IsNullOrEmpty(info.strDirectorName) ? string.Empty : info.strDirectorName); st = cmd.ExecuteNonQuery(); } } conn.Close(); } } catch (Exception ex) { } if (st > 0) { return(true); } else { return(false); } }
/// <summary> /// This function Loads information /// against RegNo From Member Registration /// </summary> private void LoadInformation() { if (txtRegistrationNo.Text.Trim() == "") { return; } infoMember.RegistrationNo = txtRegistrationNo.Text; infoMember = da.GetMemberRegistrationInfo(txtRegistrationNo.Text); if (infoMember == null) { MessageBox.Show("Please select a valid Registration Number."); txtRegistrationNo.Text = ""; return; } txtRegistrationNo.Text = infoMember.RegistrationNo; dTPBooking.Value = infoMember.Booking; txtRebatAmt.Text = Convert.ToString(infoMember.RebatAmt); txtNetRetailPrice.Text = Convert.ToString(infoMember.NetOrRetailPrice); txtBookingPrice.Text = Convert.ToString(infoMember.BookingPrice); }
public clsMemberRegistration GetMemberRegistrationInfoById(int id) { clsMemberRegistration info = new clsMemberRegistration(); try { using (SqlConnection conn = new SqlConnection(strConn)) { conn.Open(); using (SqlCommand cmd = new SqlCommand("TMR_USP_GetMemberRegistrationByID")) { cmd.CommandType = CommandType.StoredProcedure; cmd.Connection = conn; //conn.Open(); cmd.Parameters.AddWithValue("@id", id); SqlDataReader reader = cmd.ExecuteReader(); if (reader.HasRows == false) { info = null; } while (reader.Read()) { info = new clsMemberRegistration(); info.RegistrationNo = reader["RegistrationNo"].ToString(); info.ClientID = reader["ClientID"].ToString(); info.strProjectid = reader["ProjectID"].ToString(); info.Name = reader["Name"].ToString(); info.FatherOrHusbandType = reader["FatherOrHusbandType"].ToString(); info.FatherOrHusband = reader["FatherOrHusbandName"].ToString(); info.NIDOrCNIC = reader["CNIC"].ToString(); info.Nationality = reader["Nationality"].ToString(); info.DOB = Convert.ToDateTime(reader["DOB"].ToString()); info.CurrentAddress1 = reader["CurrentAddress1"].ToString(); info.CurrentAddress2 = reader["CurrentAddress2"].ToString(); info.CurrentAddress3 = reader["CurrentAddress3"].ToString(); info.Country = reader["Country"].ToString(); info.City = reader["City"].ToString(); info.PhOff = reader["PhOff"].ToString(); info.Res = reader["Res"].ToString(); info.Mob = reader["Mob"].ToString(); info.Fax = reader["Fax"].ToString(); info.EmailAddress = reader["EmailAddress"].ToString(); info.Plan = reader["Plan"].ToString(); info.Booking = Convert.ToDateTime(reader["Booking"].ToString()); info.Block = reader["Block"].ToString(); info.Plot = reader["Plot"].ToString(); info.UnitRate = Convert.ToDecimal(reader["UnitRate"].ToString()); info.TotalPrice = Convert.ToDecimal(reader["TotalPrice"].ToString()); info.FinanceAmt = Convert.ToDecimal(reader["FinanceAmt"].ToString()); info.RebatAmt = Convert.ToDecimal(reader["RebatAmt"].ToString()); info.NetOrRetailPrice = Convert.ToDecimal(reader["NetPrice"].ToString()); info.BookingPrice = Convert.ToDecimal(reader["BookingPrice"].ToString()); info.strProjectid = reader["ProjectID"].ToString(); info.intPercentage = int.Parse(reader["Percentage"].ToString()); info.strStatus = (reader["Status"].ToString()); info.intStatusCode = int.Parse(reader["statuscode"].ToString()); info.AccountNumber = reader["AccountNumber"].ToString(); info.AccountTitle = reader["AccountTitle"].ToString(); info.BankName = reader["BankName"].ToString(); info.CustomerNumber = (reader["CustomerNumber"].ToString()); info.strSalesRep = (reader["SalesRep"].ToString()); info.bSoleOwner = Convert.ToBoolean(reader["SoleOwner"]); info.bTransferPending = Convert.ToBoolean(reader["TransferPending"]); info.bSendToGP = Convert.ToBoolean(reader["SendToGP"]); info.id = int.Parse(reader["id"].ToString()); } conn.Close(); } } } catch (Exception exc) { info = null; } finally { } return(info); }
public List <clsMemberRegistration> GetMemberRegistration(clsMemberShipFilter filter) { List <clsMemberRegistration> lst = new List <clsMemberRegistration>(); using (SqlConnection conn = new SqlConnection(strConn)) { try { conn.Open(); using (SqlCommand cmd = new SqlCommand("TMR_USP_GetMembership")) { cmd.CommandType = CommandType.StoredProcedure; cmd.Connection = conn; //conn.Open(); cmd.Parameters.AddWithValue("@ProjectID", filter.strProjectID); cmd.Parameters.AddWithValue("@Block", filter.strBlockNo); cmd.Parameters.AddWithValue("@RegistrationNo", filter.strMemberShipID); cmd.Parameters.AddWithValue("@MobileNumber", filter.strMobileNumber); cmd.Parameters.AddWithValue("@Name", filter.strName); cmd.Parameters.AddWithValue("@ClientID", filter.strClientID); cmd.Parameters.AddWithValue("@StatusCode", (int)filter.membershipStatus); cmd.Parameters.AddWithValue("@FilterAllocated", filter.bFilterAllocated); cmd.Parameters.AddWithValue("@Allocated", filter.bAllocated); cmd.Parameters.AddWithValue("@ForProcess", filter.bForProcess); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { clsMemberRegistration info = new clsMemberRegistration(); info.RegistrationNo = reader["RegistrationNo"].ToString(); info.ClientID = reader["ClientID"].ToString(); info.Name = reader["Name"].ToString(); info.FatherOrHusbandType = reader["FatherOrHusbandType"].ToString(); info.FatherOrHusband = reader["FatherOrHusbandName"].ToString(); info.NIDOrCNIC = reader["CNIC"].ToString(); info.Nationality = reader["Nationality"].ToString(); info.DOB = Convert.ToDateTime(reader["DOB"].ToString()); info.CurrentAddress1 = reader["CurrentAddress1"].ToString(); info.CurrentAddress2 = reader["CurrentAddress2"].ToString(); info.CurrentAddress3 = reader["CurrentAddress3"].ToString(); info.Country = reader["Country"].ToString(); info.City = reader["City"].ToString(); info.PhOff = reader["PhOff"].ToString(); info.Res = reader["Res"].ToString(); info.Mob = reader["Mob"].ToString(); info.Fax = reader["Fax"].ToString(); info.EmailAddress = reader["EmailAddress"].ToString(); info.Plan = reader["Plan"].ToString(); info.Booking = Convert.ToDateTime(reader["Booking"].ToString()); info.strProjectid = reader["ProjectID"].ToString(); info.Block = reader["Block"].ToString(); info.Plot = reader["Plot"].ToString(); info.UnitRate = Convert.ToDecimal(reader["UnitRate"].ToString()); info.TotalPrice = Convert.ToDecimal(reader["TotalPrice"].ToString()); info.FinanceAmt = Convert.ToDecimal(reader["FinanceAmt"].ToString()); info.RebatAmt = Convert.ToDecimal(reader["RebatAmt"].ToString()); info.NetOrRetailPrice = Convert.ToDecimal(reader["NetPrice"].ToString()); info.BookingPrice = Convert.ToDecimal(reader["BookingPrice"].ToString()); info.strStatus = reader["Status"].ToString(); info.bitAllocated = Convert.ToBoolean(reader["Allocated"]); info.bTransferPending = Convert.ToBoolean(reader["TransferPending"]); info.bSendToGP = Convert.ToBoolean(reader["SendToGP"]); lst.Add(info); } conn.Close(); } } catch (Exception exc) { } finally { } } return(lst); }
private void txtRegistrationNo_Leave(object sender, EventArgs e) { #region Member Registration Table Info if (!String.IsNullOrEmpty(txtRegistrationNo.Text)) { infoMember = da.GetMemberRegistrationInfo(txtRegistrationNo.Text); if (infoMember == null) { MessageBox.Show("Please select a valid registration no."); Clear(); txtRegistrationNo.Focus(); return; } if (infoMember.bitAllocated == true) { MessageBox.Show("Selected registration number is already allocated."); Clear(); txtRegistrationNo.Focus(); return; } if (infoMember.intStatusCode == (int)memberLookupCodes.Cancelled) { MessageBox.Show("Selected registration number is cancelled."); Clear(); txtRegistrationNo.Focus(); return; } if (infoMember.intStatusCode == (int)memberLookupCodes.MarkedForAllocation || infoMember.intStatusCode == (int)memberLookupCodes.MarkedForCancellation || infoMember.intStatusCode == (int)memberLookupCodes.MarkedForReactivation || infoMember.intStatusCode == (int)memberLookupCodes.MarkedForRefund || infoMember.intStatusCode == (int)memberLookupCodes.MarkedForTransfer) { MessageBox.Show("Selected registration number is locked."); Clear(); txtRegistrationNo.Focus(); return; } Clear(); txtRegistrationNo.Text = infoMember.RegistrationNo; txtClientName.Text = infoMember.Name; txtSizeCode.Text = infoMember.Plan; dTPBooking.Value = infoMember.Booking; txtClientID.Text = infoMember.ClientID; txtRebatAmt.Text = infoMember.RebatAmt.ToString("N2"); txtNetRetailPrice.Text = infoMember.NetOrRetailPrice.ToString("N2");; txtBookingPrice.Text = infoMember.BookingPrice.ToString("N2");; txtTotalPrice.Text = infoMember.TotalPrice.ToString("N2"); LoadMemberImage(); cmbProject.Text = infoMember.strProjectid; } else { } #endregion }
/// <summary> /// Get Cancellation Status Info /// </summary> /// <param name="status"></param> /// <returns></returns> public List <clsMemberRegistration> GetMemberByStatusFromMemberRegistration(string status) { List <clsMemberRegistration> lst = new List <clsMemberRegistration>(); using (SqlConnection conn = new SqlConnection(strConn)) { conn.Open(); try { using (SqlCommand cmd = new SqlCommand("TMR_USP_GetCancellationByStatus")) { cmd.CommandType = CommandType.StoredProcedure; cmd.Connection = conn; cmd.Parameters.AddWithValue("@Status", status); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { clsMemberRegistration info = new clsMemberRegistration(); info.RegistrationNo = reader["RegistrationNo"].ToString(); info.ClientID = reader["ClientID"].ToString(); info.Name = reader["Name"].ToString(); info.FatherOrHusbandType = reader["FatherOrHusbandType"].ToString(); info.FatherOrHusband = reader["FatherOrHusbandName"].ToString(); info.NIDOrCNIC = reader["CNIC"].ToString(); info.Nationality = reader["Nationality"].ToString(); info.DOB = Convert.ToDateTime(reader["DOB"].ToString()); info.CurrentAddress1 = reader["CurrentAddress1"].ToString(); info.CurrentAddress2 = reader["CurrentAddress2"].ToString(); info.CurrentAddress3 = reader["CurrentAddress3"].ToString(); info.Country = reader["Country"].ToString(); info.City = reader["City"].ToString(); info.PhOff = reader["PhOff"].ToString(); info.Res = reader["Res"].ToString(); info.Mob = reader["Mob"].ToString(); info.Fax = reader["Fax"].ToString(); info.EmailAddress = reader["EmailAddress"].ToString(); info.Plan = reader["Plan"].ToString(); info.Booking = Convert.ToDateTime(reader["Booking"].ToString()); info.strProjectid = reader["ProjectID"].ToString(); info.Block = reader["Block"].ToString(); info.Plot = reader["Plot"].ToString(); info.UnitRate = Convert.ToDecimal(reader["UnitRate"].ToString()); info.TotalPrice = Convert.ToDecimal(reader["TotalPrice"].ToString()); info.FinanceAmt = Convert.ToDecimal(reader["FinanceAmt"].ToString()); info.RebatAmt = Convert.ToDecimal(reader["RebatAmt"].ToString()); info.NetOrRetailPrice = Convert.ToDecimal(reader["NetPrice"].ToString()); info.BookingPrice = Convert.ToDecimal(reader["BookingPrice"].ToString()); lst.Add(info); } conn.Close(); } } catch (Exception ex) { } } return(lst); }
private void txtRegistrationNo_Leave(object sender, EventArgs e) { #region Member Registration Table Info if (!String.IsNullOrEmpty(txtRegistrationNo.Text)) { infoMember = da.GetMemberRegistrationInfo(txtRegistrationNo.Text); if (infoMember == null) { MessageBox.Show("Please select a valid registration no."); Clear(); txtRegistrationNo.Focus(); return; } if (infoMember.intStatusCode != (int)memberLookupCodes.Cancelled) { MessageBox.Show("Selected registration number is not cancelled. Only cancelled registration numbers can be refunded."); Clear(); txtRegistrationNo.Focus(); return; } if (infoMember.intStatusCode == (int)memberLookupCodes.MarkedForAllocation || infoMember.intStatusCode == (int)memberLookupCodes.MarkedForCancellation || infoMember.intStatusCode == (int)memberLookupCodes.MarkedForReactivation || infoMember.intStatusCode == (int)memberLookupCodes.MarkedForRefund || infoMember.intStatusCode == (int)memberLookupCodes.MarkedForTransfer) { MessageBox.Show("Selected registration number is locked."); Clear(); txtRegistrationNo.Focus(); return; } Clear(); txtProject.Text = infoMember.strProjectid; txtClientName.Text = infoMember.Name; txtRegistrationNo.Text = infoMember.RegistrationNo; txtSizeCode.Text = infoMember.Plan; txtBookingDate.Text = infoMember.Booking.ToString("dd/MM/yyyy"); txtClientID.Text = infoMember.ClientID; txtTotalPrice.Text = Convert.ToString(infoMember.TotalPrice); txtRebatAmt.Text = Convert.ToString(infoMember.RebatAmt); txtNetRetailPrice.Text = Convert.ToString(infoMember.NetOrRetailPrice); txtBookingPrice.Text = Convert.ToString(infoMember.BookingPrice); LoadMemberImage(); txtProject.Text = infoMember.strProjectid; } else { } #endregion #region Allocation Table Info if (!string.IsNullOrEmpty(txtRegistrationNo.Text) && !string.IsNullOrEmpty(txtRegistrationNo.Text)) { } #endregion }
private void LoadInformation() { if (id != 0) { return; } if (txtRegistration.Text.Trim() == "") { return; } infoMember = da.GetMemberRegistrationInfo(txtRegistration.Text); if (infoMember == null) { MessageBox.Show("Please select a valid registration no."); Clear(); txtRegistration.Focus(); return; } if (infoMember.intStatusCode == (int)memberLookupCodes.Cancelled) { MessageBox.Show("Selected registration number is cancelled."); Clear(); txtRegistration.Focus(); return; } if (infoMember.intStatusCode == (int)memberLookupCodes.Refunded) { MessageBox.Show("Selected registration number is refunded."); Clear(); txtRegistration.Focus(); return; } if (infoMember.intStatusCode == (int)memberLookupCodes.MarkedForAllocation || infoMember.intStatusCode == (int)memberLookupCodes.MarkedForCancellation || infoMember.intStatusCode == (int)memberLookupCodes.MarkedForReactivation || infoMember.intStatusCode == (int)memberLookupCodes.MarkedForRefund || infoMember.intStatusCode == (int)memberLookupCodes.MarkedForTransfer) { MessageBox.Show("Selected registration number is locked."); Clear(); txtRegistration.Focus(); return; } infoMember.RegistrationNo = txtRegistration.Text; infoMember = da.GetMemberRegistrationInfo(txtRegistration.Text); txtRegistration.Text = infoMember.RegistrationNo; txtClientID.Text = infoMember.ClientID; txtUnitID.Text = infoMember.Plot; txtName.Text = infoMember.Name; cBFatherHusband.Text = infoMember.FatherOrHusbandType; txtFatherHusband.Text = infoMember.FatherOrHusband; txtNIDCNIC.Text = infoMember.NIDOrCNIC; cmbNationality.Text = infoMember.Nationality; dTPDOB.Value = infoMember.DOB; txtCurrentAddress1.Text = infoMember.CurrentAddress1; txtCurrentAddress2.Text = infoMember.CurrentAddress2; txtCurrentAddress3.Text = infoMember.CurrentAddress3; cmbCountry.Text = infoMember.Country.ToString().ToUpper(); txtCity.Text = infoMember.City.ToString().ToUpper(); txtPh.Text = infoMember.PhOff; txtRes.Text = infoMember.Res; txtMob.Text = infoMember.Mob; txtFax.Text = infoMember.Fax; txtEmailAddress.Text = infoMember.EmailAddress; txtProject.Text = infoMember.strProjectid; txtBlock.Text = infoMember.Block; txtPlot.Text = infoMember.Plot; LoadMemberImages(); }