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();
}
