public JsonResult GetSearchResult(string StreetNumber, string StreetName, string StreetDirection, string StreetSuffix, string City, string Zip, string APN, string bims2cb, string rent2cb, string hims2cb, string prop_site_address2cb)
{
// prepare a list of variants of street type
Dictionary <int, List <string> > StSuffAbbv = new Dictionary <int, List <string> >();
StSuffAbbv.Add(0, new List <string> {
"", "", "", ""
});
StSuffAbbv.Add(1, new List <string> {
" st", " st", " st", " st"
});
StSuffAbbv.Add(2, new List <string> {
" av", " av", " av", " av"
});
StSuffAbbv.Add(3, new List <string> {
" blvd", " boul", " boul", " boul"
});
StSuffAbbv.Add(4, new List <string> {
" high", " hwy", " hiwy", " way"
});
StSuffAbbv.Add(5, new List <string> {
" dr", " dr", " dr", " dr"
});
StSuffAbbv.Add(6, new List <string> {
" pl", " pl", " pl", " pl"
});
StSuffAbbv.Add(7, new List <string> {
" lane", " ln", " ln", " ln"
});
StSuffAbbv.Add(8, new List <string> {
" route", " rte", " rte", " rte"
});
StSuffAbbv.Add(9, new List <string> {
" way", " wy", " wy", " wy"
});
//StreetSuffix has value of null when the page is first loaded. This causes the following code line to mess up.
StreetSuffix = StreetSuffix == null ? "0" : StreetSuffix;
int SSInt = int.Parse(StreetSuffix);
string abbv1 = StSuffAbbv[SSInt][0];
string abbv2 = StSuffAbbv[SSInt][1];
string abbv3 = StSuffAbbv[SSInt][2];
string abbv4 = StSuffAbbv[SSInt][3];
//Number of records on a page;
int pageSize = 10;
int setSize = 20;//number of page displayed each set
int bimcount, himcount, rentcount, propcount;
// Number of record
bimcount = himcount = rentcount = propcount = 0;
//Number of page
int bimnp, himnp, rentnp, propnp;
bimnp = himnp = rentnp = propnp = 1;
//Number of set, each set has 20 pages
int bimns, himns, rentns, propns;
bimns = himns = rentns = propns = 1;
List <bims2> bvm2 = new List <bims2>();
List <bims2> bvm3 = new List <bims2>();
List <hims2> hvm2 = new List <hims2>();
List <rent2> rvm2 = new List <rent2>();
List <prop_site_address2> pvm2 = new List <prop_site_address2>();
if (bims2cb != "")
{
bimcount = (from bim in dbBim.bims2
let APNString = SqlFunctions.StringConvert((double)bim.APN)
where (bim.Property_Address.Contains(abbv1) || bim.Property_Address.Contains(abbv2) || bim.Property_Address.Contains(abbv3) || bim.Property_Address.Contains(abbv4)) &&
(bim.Property_Address.Contains(StreetName) || StreetName == null) &&
(bim.Property_Address.Contains(StreetNumber) || StreetNumber == null) &&
(bim.Property_Address.Contains(StreetDirection) || StreetDirection == null) &&
(bim.Property_City_State_Zip.Contains(City) || City == null) &&
(bim.Property_City_State_Zip.Contains(Zip) || Zip == null) &&
(APNString.Contains(APN) || APN == null)
select bim).ToList().Count();
bimnp = Convert.ToInt32(Math.Ceiling((double)bimcount / pageSize));
bimns = Convert.ToInt32(Math.Ceiling((double)bimnp / setSize));
bvm2 = (from bim in dbBim.bims2
let APNString = SqlFunctions.StringConvert((double)bim.APN)
where (bim.Property_Address.Contains(abbv1) || bim.Property_Address.Contains(abbv2) || bim.Property_Address.Contains(abbv3) || bim.Property_Address.Contains(abbv4)) &&
(bim.Property_Address.Contains(StreetName) || StreetName == null) &&
(bim.Property_Address.Contains(StreetNumber) || StreetNumber == null) &&
(bim.Property_Address.Contains(StreetDirection) || StreetDirection == null) &&
(bim.Property_City_State_Zip.Contains(City) || City == null) &&
(bim.Property_City_State_Zip.Contains(Zip) || Zip == null) &&
(APNString.Contains(APN) || APN == null)
orderby(bim.id)
select bim).Take(pageSize).ToList();
}
;
if (hims2cb != "")
{
himcount = (from bim in dbHim.hims2
let ZipCodeString = SqlFunctions.StringConvert((double)bim.ZipCode)
where (bim.StreetTypeCd.Contains(abbv1) || bim.StreetTypeCd.Contains(abbv2) || bim.StreetTypeCd.Contains(abbv3) || bim.StreetTypeCd.Contains(abbv4)) &&
(bim.StreetName.Contains(StreetName) || StreetName == null) &&
(bim.HouseNum.Contains(StreetNumber) || StreetNumber == null) &&
(bim.PreDirCd.Contains(StreetDirection) || StreetDirection == null) &&
(bim.City.Contains(City) || City == null || bim.City.Equals(null) || bim.City.Equals("")) &&
(ZipCodeString.Contains(Zip) || Zip == null) &&
(bim.APN.Contains(APN) || APN == null)
select bim).ToList().Count();
himnp = Convert.ToInt32(Math.Ceiling((double)himcount / pageSize));
himns = Convert.ToInt32(Math.Ceiling((double)himnp / setSize));
hvm2 = (from bim in dbHim.hims2
let ZipCodeString = SqlFunctions.StringConvert((double)bim.ZipCode)
where (bim.StreetTypeCd.Contains(abbv1) || bim.StreetTypeCd.Contains(abbv2) || bim.StreetTypeCd.Contains(abbv3) || bim.StreetTypeCd.Contains(abbv4)) &&
(bim.StreetName.Contains(StreetName) || StreetName == null) &&
(bim.HouseNum.Contains(StreetNumber) || StreetNumber == null) &&
(bim.PreDirCd.Contains(StreetDirection) || StreetDirection == null) &&
(bim.City.Contains(City) || City == null || bim.City.Equals(null) || bim.City.Equals("")) &&
(ZipCodeString.Contains(Zip) || Zip == null) &&
(bim.APN.Contains(APN) || APN == null)
orderby(bim.id)
select bim).Take(pageSize).ToList();
}
;
if (rent2cb != "")
{
rentcount = (from bim in dbRent.rent2
let APNString = SqlFunctions.StringConvert((double)bim.APN)
where (bim.Secondary_Address.Contains(abbv1) || bim.Secondary_Address.Contains(abbv2) || bim.Secondary_Address.Contains(abbv3) || bim.Secondary_Address.Contains(abbv4)) &&
(bim.Secondary_Address.Contains(StreetName) || StreetName == null) &&
(bim.Secondary_Address.Contains(StreetNumber) || StreetNumber == null) &&
(bim.Secondary_Address.Contains(StreetDirection) || StreetDirection == null) &&
(bim.Secondary_Address.Contains(City) || City == null) &&
(bim.Secondary_Address.Contains(Zip) || Zip == null) &&
(APNString.Contains(APN) || APN == null)
select bim).ToList().Count();
rentnp = Convert.ToInt32(Math.Ceiling((double)rentcount / pageSize));
rentns = Convert.ToInt32(Math.Ceiling((double)rentnp / setSize));
rvm2 = (from bim in dbRent.rent2
let APNString = SqlFunctions.StringConvert((double)bim.APN)
where (bim.Secondary_Address.Contains(abbv1) || bim.Secondary_Address.Contains(abbv2) || bim.Secondary_Address.Contains(abbv3) || bim.Secondary_Address.Contains(abbv4)) &&
(bim.Secondary_Address.Contains(StreetName) || StreetName == null) &&
(bim.Secondary_Address.Contains(StreetNumber) || StreetNumber == null) &&
(bim.Secondary_Address.Contains(StreetDirection) || StreetDirection == null) &&
(bim.Secondary_Address.Contains(City) || City == null) &&
(bim.Secondary_Address.Contains(Zip) || Zip == null) &&
(APNString.Contains(APN) || APN == null)
orderby(bim.id)
select bim).Take(pageSize).ToList();
}
;
if (prop_site_address2cb != "")
{
propcount = (from bim in dbProp.prop_site_address2
let APNString = SqlFunctions.StringConvert((double)bim.Apn)
let HouseNumString = SqlFunctions.StringConvert((double)bim.HouseNum)
let ZipCodeString = SqlFunctions.StringConvert((double)bim.Zip)
where (bim.StreetTypeCd.Contains(abbv1) || bim.StreetTypeCd.Contains(abbv2) || bim.StreetTypeCd.Contains(abbv3) || bim.StreetTypeCd.Contains(abbv4)) &&
(bim.StreetName.Contains(StreetName) || StreetName == null) &&
(HouseNumString.Contains(StreetNumber) || StreetNumber == null) &&
(bim.PreDirCd.Contains(StreetDirection) || StreetDirection == null) &&
(bim.City.Contains(City) || City == null || bim.City.Equals(null) || bim.City.Equals("")) &&
(ZipCodeString.Contains(Zip) || Zip == null) &&
(APNString.Contains(APN) || APN == null)
select bim).ToList().Count();
propnp = Convert.ToInt32(Math.Ceiling((double)propcount / pageSize));
propns = Convert.ToInt32(Math.Ceiling((double)propnp / setSize));
pvm2 = (from bim in dbProp.prop_site_address2
let APNString = SqlFunctions.StringConvert((double)bim.Apn)
let HouseNumString = SqlFunctions.StringConvert((double)bim.HouseNum)
let ZipCodeString = SqlFunctions.StringConvert((double)bim.Zip)
where (bim.StreetTypeCd.Contains(abbv1) || bim.StreetTypeCd.Contains(abbv2) || bim.StreetTypeCd.Contains(abbv3) || bim.StreetTypeCd.Contains(abbv4)) &&
(bim.StreetName.Contains(StreetName) || StreetName == null) &&
(HouseNumString.Contains(StreetNumber) || StreetNumber == null) &&
(bim.PreDirCd.Contains(StreetDirection) || StreetDirection == null) &&
(bim.City.Contains(City) || City == null || bim.City.Equals(null) || bim.City.Equals("")) &&
(ZipCodeString.Contains(Zip) || Zip == null) &&
(APNString.Contains(APN) || APN == null)
orderby(bim.id)
select bim).Take(pageSize).ToList();
}
var data = new
{
PageSize = pageSize,
SetSize = setSize,
SearchBim = bims2cb,
SearchHim = hims2cb,
SearchRent = rent2cb,
SearchProp = prop_site_address2cb,
CountBim = bimcount,
DataBim = bvm2,
NoofPageBim = bimnp,
CurrentPageBim = 1,
CurrentSetBim = 1,
NoofSetBim = bimns,
CountHim = himcount,
DataHim = hvm2,
NoofPageHim = himnp,
CurrentPageHim = 1,
CurrentSetHim = 1,
NoofSetHim = himns,
CountRent = rentcount,
DataRent = rvm2,
NoofPageRent = rentnp,
CurrentPageRent = 1,
CurrentSetRent = 1,
NoofSetRent = rentns,
CountProp = propcount,
DataProp = pvm2,
NoofPageProp = propnp,
CurrentPageProp = 1,
CurrentSetProp = 1,
NoofSetProp = propns
};
return(Json(data, JsonRequestBehavior.AllowGet));
}
//Get paged data from Prop table
public JsonResult GetPropSearchResult(string StreetNumber, string StreetName, string StreetDirection, string StreetSuffix, string City, string Zip, string APN, string PageNum, string CurrentSet)
{
// prepare a list of variants of street type
Dictionary <int, List <string> > StSuffAbbv = new Dictionary <int, List <string> >();
StSuffAbbv.Add(0, new List <string> {
"", "", "", ""
});
StSuffAbbv.Add(1, new List <string> {
"st", "st", "st", "st"
});
StSuffAbbv.Add(2, new List <string> {
"av", "av", "av", "av"
});
StSuffAbbv.Add(3, new List <string> {
"blvd", "boul", "boul", "boul"
});
StSuffAbbv.Add(4, new List <string> {
"high", "hwy", "hiwy", "way"
});
StSuffAbbv.Add(5, new List <string> {
"dr", "dr", "dr", "dr"
});
StSuffAbbv.Add(6, new List <string> {
"pl", "pl", "pl", "pl"
});
StSuffAbbv.Add(7, new List <string> {
"lane", "ln", "ln", "ln"
});
StSuffAbbv.Add(8, new List <string> {
"route", "rte", "rte", "rte"
});
StSuffAbbv.Add(9, new List <string> {
"way", "wy", "wy", "wy"
});
int SSInt = int.Parse(StreetSuffix);
string abbv1 = StSuffAbbv[SSInt][0];
string abbv2 = StSuffAbbv[SSInt][1];
string abbv3 = StSuffAbbv[SSInt][2];
string abbv4 = StSuffAbbv[SSInt][3];
//Number of records on a page;
int pageSize = 10;
int setSize = 20;//number of page displayed each set
int bimcount, himcount, rentcount, propcount;
// Number of record
bimcount = himcount = rentcount = propcount = 0;
//Number of page
int bimnp, himnp, rentnp, propnp;
bimnp = himnp = rentnp = propnp = 1;
//Number of set, each set has 20 pages
int bimns, himns, rentns, propns;
bimns = himns = rentns = propns = 1;
List <prop_site_address2> pvm2 = new List <prop_site_address2>();
pvm2 = (from bim in dbProp.prop_site_address2
let APNString = SqlFunctions.StringConvert((double)bim.Apn)
let HouseNumString = SqlFunctions.StringConvert((double)bim.HouseNum)
let ZipCodeString = SqlFunctions.StringConvert((double)bim.Zip)
where (bim.StreetTypeCd.Contains(abbv1) || bim.StreetTypeCd.Contains(abbv2) || bim.StreetTypeCd.Contains(abbv3) || bim.StreetTypeCd.Contains(abbv4)) &&
(bim.StreetName.Contains(StreetName) || StreetName == null) &&
(HouseNumString.Contains(StreetNumber) || StreetNumber == null) &&
(bim.PreDirCd.Contains(StreetDirection) || StreetDirection == null) &&
(bim.City.Contains(City) || City == null || bim.City.Equals(null) || bim.City.Equals("")) &&
(ZipCodeString.Contains(Zip) || Zip == null) &&
(APNString.Contains(APN) || APN == null)
orderby(bim.id)
select bim).Skip((Convert.ToInt32(PageNum) - 1) * pageSize).Take(pageSize).ToList();
var data = new
{
DataProp = pvm2,
CurrentPageProp = PageNum,
CurrentSetProp = CurrentSet
};
return(Json(data, JsonRequestBehavior.AllowGet));
}
