private void btnFilter_Click(object sender, EventArgs e) { clsMemberShipFilter filter = MakeFilter(); lstMemberRegistration = da.GetMemberRegistration(filter); PopulateGrid(lstMemberRegistration); }
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 frmMemberLookup_Load(object sender, EventArgs e) { Loadprojects(); //cmbProject.Text = "All"; if (strProject == "" || strProject == null) { cmbProject.Text = "All"; } else { cmbProject.Text = strProject; } cmbBlock.Text = "All"; cmbSearchBy.Text = "Membership ID"; #region All if (this.memberlookupCode == memberLookupCodes.All) { cmbAllocated.Text = "All"; cmbStatus.Text = "All"; } else if (this.memberlookupCode == memberLookupCodes.Unallocated) { cmbAllocated.Text = "Unallocated"; cmbStatus.Text = "All"; cmbAllocated.Enabled = false; } else if (this.memberlookupCode == memberLookupCodes.Cancelled) { cmbAllocated.Text = "All"; cmbStatus.Text = "Cancelled"; cmbStatus.Enabled = false; } else if (this.memberlookupCode == memberLookupCodes.Reactivate) { cmbAllocated.Text = "All"; cmbStatus.Text = "Reactivated"; cmbStatus.Enabled = false; } else if (this.memberlookupCode == memberLookupCodes.Refunded) { cmbAllocated.Text = "All"; cmbStatus.Text = "Refunded"; cmbStatus.Enabled = false; } else if (this.memberlookupCode == memberLookupCodes.Transferred) { cmbAllocated.Text = "All"; cmbStatus.Text = "Transferred"; cmbStatus.Enabled = false; } clsMemberShipFilter filter = MakeFilter(); lstMemberRegistration = da.GetMemberRegistration(filter); PopulateGrid(lstMemberRegistration); //} #endregion #region Unlocated //if (this.memberlookupCode == memberLookupCodes.Unallocated) //{ // cmbBlock.Visible = false; // cmbProject.Visible = false; // lblProject.Visible = false; // lblBlock.Visible = false; // lstMemberRegistration = da.GetUnallocatedMemberRegistration(new clsMemberShipFilter()); // PopulateGrid(lstMemberRegistration); //} #endregion #region Cancellation //cmbSearchBy.Text = "Membership ID"; //if (this.memberlookupCode == memberLookupCodes.Cancelled) //{ // cmbBlock.Visible = false; // cmbProject.Visible = false; // lblProject.Visible = false; // lblBlock.Visible = false; // lstMemberRegistration = da.GetMemberForCancellation(); // PopulateGrid(lstMemberRegistration); //} #endregion #region Deallocation //else if (this.memberlookupCode == memberLookupCodes.Deallocte) //{ // cmbBlock.Visible = false; // cmbProject.Visible = false; // lblProject.Visible = false; // lblBlock.Visible = false; // lstMemberRegistration = da.GetMemberRegistrationForDeallocation(new clsMemberShipFilter()); // PopulateGrid(lstMemberRegistration); //} #endregion #region Reactivation //else if (this.memberlookupCode == memberLookupCodes.Reactivate) //{ // cmbBlock.Visible = false; // cmbProject.Visible = false; // lblProject.Visible = false; // lblBlock.Visible = false; // lstMemberRegistration = da.GetMemberForReactivation(); // PopulateGrid(lstMemberRegistration); //} #endregion #region Refund //else if (this.memberlookupCode == memberLookupCodes.Refunded) //{ // cmbBlock.Visible = false; // cmbProject.Visible = false; // lblProject.Visible = false; // lblBlock.Visible = false; // //txtSearchValue.Visible = false; // //lblValue.Visible = false; // //btnFilter.Visible = false; // lstMemberRegistration = da.GetMemberForRefund(); // PopulateGrid(lstMemberRegistration); //} //else //{ //} #endregion }
private clsMemberShipFilter MakeFilter() { clsMemberShipFilter filter = new clsMemberShipFilter(); filter.strProjectID = cmbProject.Text; filter.strBlockNo = cmbBlock.Text; if (cmbAllocated.Text == "Allocated") { filter.bAllocated = true;; filter.bFilterAllocated = true; } else if (cmbAllocated.Text == "Unallocated") { filter.bAllocated = false;; filter.bFilterAllocated = true; } else if (cmbAllocated.Text == "All") { filter.bAllocated = false; filter.bFilterAllocated = false; } if (cmbStatus.Text == "All") { filter.membershipStatus = memberLookupCodes.All; } else if (cmbStatus.Text == "New") { filter.membershipStatus = memberLookupCodes.New; } else if (cmbStatus.Text == "Cancelled") { filter.membershipStatus = memberLookupCodes.Cancelled; } else if (cmbStatus.Text == "Refunded") { filter.membershipStatus = memberLookupCodes.Refunded; } else if (cmbStatus.Text == "Reactivated") { filter.membershipStatus = memberLookupCodes.Reactivate; } else if (cmbStatus.Text == "Transferred") { filter.membershipStatus = memberLookupCodes.Transferred; } if (cmbSearchBy.Text == "Membership ID") { filter.strMemberShipID = txtSearchValue.Text.Trim(); } else if (cmbSearchBy.Text == "Client ID") { filter.strClientID = txtSearchValue.Text.Trim(); } else if (cmbSearchBy.Text == "Member Name") { filter.strName = txtSearchValue.Text.Trim(); } else if (cmbSearchBy.Text == "Unit ID") { filter.strUnitID = txtSearchValue.Text.Trim(); } filter.bForProcess = this.bForProcess; return(filter); }