public FilterSearchEntity ConvertToEntity(ComboBox cmbSelectArea, TextBox txtRentLowerLimit, TextBox txtRentUpperLimit, TextBox txtSquareFeetLowerLimit, TextBox txtSquareFeetUpperLimit, ComboBox cmbFlatType) { FilterSearchEntity filterSearchEntity = new FilterSearchEntity(); filterSearchEntity.SelectArea = cmbSelectArea.Text; filterSearchEntity.RentLowerLimit = txtRentLowerLimit.Text; filterSearchEntity.RentUpperLimit = txtRentUpperLimit.Text; filterSearchEntity.SquareFeetLowerLimit = txtSquareFeetLowerLimit.Text; filterSearchEntity.SquareFeetUpperLimit = txtSquareFeetUpperLimit.Text; filterSearchEntity.FlatType = cmbFlatType.Text; return(filterSearchEntity); }
public int ValidateEntity(FilterSearchEntity filterSearchEn) { if (!filterSearchEn.FlatType.Equals("") && !filterSearchEn.RentLowerLimit.Equals("") && !filterSearchEn.RentUpperLimit.Equals("") && !filterSearchEn.SquareFeetLowerLimit.Equals("") && !filterSearchEn.SquareFeetUpperLimit.Equals("") && !filterSearchEn.FlatType.Equals("")) { if (Convert.ToInt32(filterSearchEn.RentLowerLimit) <= Convert.ToInt32(filterSearchEn.RentUpperLimit) && Convert.ToInt32(filterSearchEn.SquareFeetLowerLimit) <= Convert.ToInt32(filterSearchEn.SquareFeetUpperLimit)) { return(1); } else { return(-1); } } return(0); }
public string GenerateQuery(FilterSearchEntity filterSearchEn) { string sql = "select * from ad where location = '" + filterSearchEn.SelectArea + "' and rent >= " + filterSearchEn.RentLowerLimit + " and rent <= " + filterSearchEn.RentUpperLimit + " and squarefeet >= " + filterSearchEn.SquareFeetLowerLimit + " and squarefeet <= " + filterSearchEn.SquareFeetUpperLimit + " and flattype = " + filterSearchEn.FlatType + " "; return(sql); }