private void isDigit(object sender, CancelEventArgs e)
{
var cnt = sender as TextBox;
var boolianvar = fns.IsDigitsOnly(cnt.Text);
if (cnt.Text.Count() < 1 || !boolianvar)
{
e.Cancel = true;
messageLable.Text = "فیلد مورد باید شامل عدد باشد";
}
else
{
messageLable.Text = "";
}
}
public List <item> getList(string query, string sortname)
{
queryModel log = JsonConvert.DeserializeObject <queryModel>(query);
IQueryable <item> q = context.items;
if (log.address != "")
{
q = q.Where(x => x.address.Contains(log.address));
}
if (log.anbari == "1")
{
q = q.Where(x => x.anbari1 == "1" || x.anbari2 == "1" || x.anbari3 == "1");
}
if (log.apartment != "")
{
q = q.Where(x => x.apartment == log.apartment);
}
if (log.asansor == "1")
{
q = q.Where(x => x.asansor1 == "1" || x.asansor2 == "1" || x.asansor3 == "1");
}
if (log.ashpazkhane != "")
{
q = q.Where(x => x.ashpazkhane == log.ashpazkhane);
}
if (log.bed_from != "")
{
long needed = Convert.ToInt64(log.bed_from);
q = q.Where(x => x.bed1 >= needed || x.bed2 >= needed || x.bed3 >= needed);
}
if (log.bed_to != "")
{
long needed = Convert.ToInt64(log.bed_to);
q = q.Where(x => x.bed1 <= needed || x.bed2 <= needed || x.bed3 <= needed);
}
if (log.date_from != "")
{
DateTime needed = dateTimeConvert.ToGeorgianDateTime(log.date_from);
q = q.Where(x => x.date_updated >= needed);
}
if (log.date_to != "")
{
DateTime needed = dateTimeConvert.ToGeorgianDateTime(log.date_to);
q = q.Where(x => x.date_updated <= needed);
}
if (log.desc != "")
{
q = q.Where(x => x.desc.Contains(log.desc));
}
if (log.ejare_from != "")
{
long needed = Convert.ToInt64(log.ejare_from);
q = q.Where(x => x.tabaghe_1_ejare >= needed || x.tabaghe_2_ejare >= needed || x.tabaghe_3_ejare >= needed);
}
if (log.ejare_to != "")
{
long needed = Convert.ToInt64(log.ejare_to);
q = q.Where(x => x.tabaghe_1_ejare <= needed || x.tabaghe_2_ejare <= needed || x.tabaghe_3_ejare <= needed);
}
if (log.ertefa != "")
{
q = q.Where(x => x.ertefa == log.ertefa);
}
if (log.eslahi != "")
{
q = q.Where(x => x.eslahi == log.eslahi);
}
if (log.garmayesh_sarmayesh != "")
{
q = q.Where(x => x.garmayesh_sarmayesh == log.garmayesh_sarmayesh);
}
if (log.hasEstakhr != "")
{
q = q.Where(x => x.hasEstakhr == log.hasEstakhr);
}
if (log.hasGym != "")
{
q = q.Where(x => x.hasGym == log.hasGym);
}
if (log.hasHall != "")
{
q = q.Where(x => x.hasHall == log.hasHall);
}
if (log.hasJakoozi != "")
{
q = q.Where(x => x.hasJakoozi == log.hasJakoozi);
}
if (log.hasRoofGarden != "")
{
q = q.Where(x => x.hasRoofGarden == log.hasRoofGarden);
}
if (log.hasSauna != "")
{
q = q.Where(x => x.hasSauna == log.hasSauna);
}
if (log.hasSeraydar != "")
{
q = q.Where(x => x.hasSauna == log.hasSauna);
}
if (log.hasShooting != "")
{
q = q.Where(x => x.hasShooting == log.hasShooting);
}
if (log.hasShooting != "")
{
q = q.Where(x => x.hasShooting == log.hasShooting);
}
if (log.ID != "")
{
if (FUNS.IsDigitsOnly(log.ID))
{
long needed = Convert.ToInt64(log.ID);
q = q.Where(x => x.number == needed);
}
}
if (log.id_from != "")
{
if (FUNS.IsDigitsOnly(log.id_from))
{
long needed = Convert.ToInt64(log.id_from);
q = q.Where(x => x.number >= needed);
}
}
if (log.id_to != "")
{
if (FUNS.IsDigitsOnly(log.id_to))
{
long needed = Convert.ToInt64(log.id_to);
q = q.Where(x => x.number >= needed);
}
}
if (log.isEjare != "")
{
q = q.Where(x => x.isEjare == log.isEjare);
}
if (log.isForoosh != "")
{
q = q.Where(x => x.isForoosh == log.isForoosh);
}
if (log.isMoaveze != "")
{
q = q.Where(x => x.isMoaveze == log.isMoaveze);
}
if (log.isMoble != "")
{
q = q.Where(x => x.isMoble == log.isMoble);
}
if (log.isMosharekat != "")
{
q = q.Where(x => x.isMosharekat == log.isMosharekat);
}
if (log.isRahn != "")
{
q = q.Where(x => x.isRahn == log.isRahn);
}
if (log.kaf_type != "")
{
q = q.Where(x => x.kaf_type == log.kaf_type);
}
if (log.kind != "")
{
//{ "-", "آپارتمان", "دفتر کار", "کلنگی", "مستغلات", "ویلا","مغازه" };
switch (log.kind)
{
case "آپارتمان":
q = q.Where(x => x.apartment != "");
break;
case "ویلا":
q = q.Where(x => x.villa != "");
break;
case "مستغلات":
q = q.Where(x => x.mostaghellat != "");
break;
case "کلنگی":
q = q.Where(x => x.kolangi != "");
break;
case "دفتر کار":
q = q.Where(x => x.office != "");
break;
case "مغازه":
q = q.Where(x => x.maghaze != "");
break;
}
}
if (log.malek != "")
{
q = q.Where(x => x.malek == log.malek);
}
if (log.mantaghe_id != "")
{
q = q.Where(x => x.mantaghe_id == log.mantaghe_id);
}
if (log.mantaghe_name != "")
{
string mnt = log.mantaghe_name.Substring(1, log.mantaghe_name.Length - 2);
List <string> mantaghelst = mnt.Split(',').ToList();
foreach (var mantaghe in mantaghelst)
{
q = q.Where(x => x.mantaghe_name == mantaghe);
}
}
if (log.masahat_from != "")
{
long needed = Convert.ToInt64(log.masahat_from);
q = q.Where(x => x.zirbana1 >= needed || x.zirbana2 >= needed || x.zirbana3 >= needed);
}
if (log.masahat_to != "")
{
long needed = Convert.ToInt64(log.masahat_to);
q = q.Where(x => x.zirbana1 <= needed || x.zirbana2 <= needed || x.zirbana3 <= needed);
}
if (log.masahat_zamin != "")
{
long needed = Convert.ToInt64(log.masahat_zamin);
q = q.Where(x => x.masahat_zamin == needed);
}
if (log.metri_from != "")
{
long needed = Convert.ToInt64(log.metri_from);
q = q.Where(x => x.tabaghe_1_metri >= needed || x.tabaghe_2_metri >= needed || x.tabaghe_3_metri >= needed);
}
if (log.metri_to != "")
{
long needed = Convert.ToInt64(log.metri_to);
q = q.Where(x => x.tabaghe_1_metri <= needed || x.tabaghe_1_metri <= needed || x.tabaghe_1_metri <= needed);
}
if (log.mostaghellat != "")
{
q = q.Where(x => x.mostaghellat == log.mostaghellat);
}
if (log.office != "")
{
q = q.Where(x => x.office == log.office);
}
if (log.parking != "")
{
q = q.Where(x => x.parking3 == log.parking || x.parking3 == log.parking || x.parking3 == log.parking);
}
if (log.phones != "")
{
q = q.Where(x => x.phones.Contains(log.phones));
}
if (log.rahn_from != "")
{
long needed = Convert.ToInt64(log.rahn_from);
q = q.Where(x => x.tabaghe_1_rahn >= needed || x.tabaghe_2_rahn >= needed || x.tabaghe_3_rahn >= needed);
}
if (log.rahn_to != "")
{
long needed = Convert.ToInt64(log.rahn_to);
q = q.Where(x => x.tabaghe_1_rahn <= needed || x.tabaghe_2_rahn <= needed || x.tabaghe_3_rahn <= needed);
}
if (log.samt != "")
{
q = q.Where(x => x.samt == log.samt);
}
if (log.sell2khareji != "")
{
q = q.Where(x => x.sell2khareji == log.sell2khareji);
}
if (log.senn_from != "" && log.senn_to == "")
{
if (FUNS.IsDigitsOnly(log.senn_from))
{
long needed = Convert.ToInt64(log.senn_from) - 2;
q = q.Where(x => x.senn >= needed || x.senn == 0);
}
}
else if (log.senn_from == "" && log.senn_to != "")
{
if (FUNS.IsDigitsOnly(log.senn_to))
{
long needed = Convert.ToInt64(log.senn_to) - 2;
q = q.Where(x => x.senn <= needed && x.senn != 1);
}
}
else if (log.senn_from != "" && log.senn_to != "")
{
if (FUNS.IsDigitsOnly(log.senn_to) && FUNS.IsDigitsOnly(log.senn_from))
{
long neededfrom = Convert.ToInt64(log.senn_from) - 2;
long neededto = Convert.ToInt64(log.senn_to) - 2;
q = q.Where(x => x.senn <= neededto && x.senn >= neededfrom);
}
}
if (log.seraydar != "")
{
q = q.Where(x => x.seraydar == log.seraydar);
}
if (log.suit != "")
{
q = q.Where(x => x.suit == log.suit);
}
if (log.tabaghe != "")
{
if (FUNS.IsDigitsOnly(log.tabaghe))
{
long needed = Convert.ToInt64(log.tabaghe_from);
q = q.Where(x => x.tabaghe1 == needed || x.tabaghe2 == needed || x.tabaghe3 == needed);
}
}
if (log.tabaghe_from != "")
{
if (FUNS.IsDigitsOnly(log.tabaghe_from))
{
long needed = Convert.ToInt64(log.tabaghe_from);
q = q.Where(x => x.total_floor >= needed);
}
}
if (log.tabaghe_to != "")
{
if (FUNS.IsDigitsOnly(log.tabaghe_to))
{
long needed = Convert.ToInt64(log.tabaghe_to);
q = q.Where(x => x.total_floor >= needed);
}
}
if (log.takhlie != "")
{
q = q.Where(x => x.takhlie == log.takhlie);
}
if (log.tarakom != "")
{
q = q.Where(x => x.tarakom == log.tarakom);
}
if (log.title != "")
{
q = q.Where(x => x.title.Contains(log.title));
}
if (log.toole_bar != "")
{
q = q.Where(x => x.toole_bar == log.toole_bar);
}
if (log.total_price_from != "")
{
if (FUNS.IsDigitsOnly(log.total_price_from))
{
long needed = Convert.ToInt64(log.total_price_from);
q = q.Where(x => x.tabaghe_1_total_price >= needed || x.tabaghe_2_total_price >= needed || x.tabaghe_3_total_price >= needed);
}
}
if (log.total_price_to != "")
{
if (FUNS.IsDigitsOnly(log.total_price_to))
{
long needed = Convert.ToInt64(log.total_price_to);
q = q.Where(x => x.tabaghe_1_total_price <= needed || x.tabaghe_2_total_price <= needed || x.tabaghe_3_total_price <= needed);
}
}
if (log.total_vahed != "")
{
long needed = Convert.ToInt64(log.total_vahed);
q = q.Where(x => x.total_vahed == needed);
}
if (log.villa != "")
{
q = q.Where(x => x.villa == log.villa);
}
if (log.wc != "")
{
q = q.Where(x => x.wc1 == log.wc || x.wc2 == log.wc || x.wc3 == log.wc);
}
if (log.zirbana_from != "")
{
if (FUNS.IsDigitsOnly(log.zirbana_from))
{
long needed = Convert.ToInt64(log.zirbana_from);
q = q.Where(x => x.zirbana1 <= needed || x.zirbana2 <= needed || x.zirbana3 <= needed);
}
}
if (log.zirbana_to != "")
{
if (FUNS.IsDigitsOnly(log.zirbana_to))
{
long needed = Convert.ToInt64(log.zirbana_from);
q = q.Where(x => x.zirbana1 >= needed || x.zirbana2 >= needed || x.zirbana3 >= needed);
}
}
if (log.zirzamin != "")
{
q = q.Where(x => x.zirzamin == log.zirzamin);
}
list = q.ToList();
return(list);
}