void getDataBackGroundWorker_do(object sender, DoWorkEventArgs e)
{
string query = (string)e.Argument;
string S = "";
try
{
CatsAndAreasObject CATS = new CatsAndAreasObject();
CATS = JsonConvert.DeserializeObject <CatsAndAreasObject>(GlobalVariable.newCatsAndAreas);
List <gridVM> list = new List <gridVM>();
List <item> Listitem = manager.getList(query);
foreach (var item in Listitem)
{
if (GlobalVariable.searchTabghe == "")
{
GlobalVariable.searchTabghe = "1";
}
string tabaghe = GlobalVariable.searchTabghe;
string fullprice = item.tabaghe_1_total_price.ToString();
string metriprice = item.tabaghe_1_metri.ToString();
string rahnprice = item.tabaghe_1_rahn.ToString();
string ejareprice = item.tabaghe_1_ejare.ToString();
string tabagh = item.tabaghe1.ToString();
string kha = item.bed1.ToString();
string zirban = item.zirbana1.ToString();
string tb1 = item.tabaghe1.ToString();
string tb2 = item.tabaghe2.ToString();
string tb3 = item.tabaghe3.ToString();
if (tb1 == tabaghe)
{
fullprice = item.tabaghe_1_total_price.ToString();
metriprice = item.tabaghe_1_metri.ToString();
rahnprice = item.tabaghe_1_rahn.ToString();
ejareprice = item.tabaghe_1_ejare.ToString();
tabagh = item.tabaghe1.ToString();
kha = item.bed1.ToString();
zirban = item.zirbana1.ToString();
}
if (tb2 == tabaghe)
{
fullprice = item.tabaghe_2_total_price.ToString();
metriprice = item.tabaghe_2_metri.ToString();
rahnprice = item.tabaghe_2_rahn.ToString();
ejareprice = item.tabaghe_2_ejare.ToString();
tabagh = item.tabaghe2.ToString();
kha = item.bed2.ToString();
zirban = item.zirbana2.ToString();
}
if (tb3 == tabaghe)
{
fullprice = item.tabaghe_3_total_price.ToString();
metriprice = item.tabaghe_3_metri.ToString();
rahnprice = item.tabaghe_3_rahn.ToString();
ejareprice = item.tabaghe_3_ejare.ToString();
tabagh = item.tabaghe3.ToString();
kha = item.bed3.ToString();
zirban = item.zirbana3.ToString();
}
string serverid = item.ID.ToString();
string date = item.date_updated.ToString();
string address = item.address.ToString();
string owner = item.malek.ToString();
string senn = item.senn == 0 ? "-" : (from q in CATS.data.list.senn
where q.ID == item.senn.ToString()
select q.title).First();
string melkkind = "";
if (item.maghaze != "0")
{
melkkind = melkkind + "مغازه،";
}
if (item.apartment != "0")
{
melkkind = melkkind + "آپارتمان،";
}
if (item.villa != "0")
{
melkkind = melkkind + "ویلا،";
}
if (item.mostaghellat != "0")
{
melkkind = melkkind + "مستغلات،";
}
if (item.kolangi != "0")
{
melkkind = melkkind + "کلنگی،";
}
if (item.office != "0")
{
melkkind = melkkind + "دفتر،";
}
if (melkkind.Length > 0)
{
melkkind = melkkind.Remove(melkkind.Length - 1, 1);
}
string Dealkind = "";
if (Convert.ToInt32(item.isForoosh.ToString()) > 0)
{
Dealkind = Dealkind + "فروش،";
}
if (Convert.ToInt32(item.isRahn.ToString()) > 0)
{
Dealkind = Dealkind + "رهن،";
}
if (Convert.ToInt32(item.isEjare.ToString()) > 0)
{
Dealkind = Dealkind + "اجاره،";
}
if (Dealkind.Length > 0)
{
Dealkind = Dealkind.Remove(Dealkind.Length - 1, 1);
}
string totalrahn = item.isForoosh.ToString() == "1" ? fullprice : rahnprice;
string metriejare = item.isForoosh.ToString() == "1" ? metriprice : ejareprice;
string Rtabaghe = tabagh;
string khab = kha;
string zirbana = zirban;
bool mycheckbox = false;
totalrahn = totalrahn.Replace(".", "");
//// جهت بازیابی آیتم های تیک خورده استفاده می شود
//if (.Contains(serverid + ","))
//{
// mycheckbox = true;
//}
gridVM newitem = new gridVM()
{
phones = item.phones,
Address = item.address1 + item.address2 + item.address3,
Address1 = item.address1,
Address2 = item.address2,
Address3 = item.address3,
bed = kha,
codegrid = item.number.ToString(),
dategrid = dateTimeConvert.ToPersianDateString(item.date_updated),
datetime = item.date_updated,
ejare_metri = Convert.ToInt64(metriejare),
floorgrid = tabagh,
kindgrid = Dealkind,
typegrid = melkkind,
ownergrid = item.malek,
rahn_total = Convert.ToInt64(totalrahn),
zirbana = zirban,
checkbox = false,
Senn = senn,
mantagheName = item.mantaghe_name
};
list.Add(newitem);
}
string FILELIST = JsonConvert.SerializeObject(list);
e.Result = FILELIST;
}
catch (Exception error)
{
e.Result = "error";
}
}
void getDataBackGroundWorkerFileList_do(object sender, DoWorkEventArgs e)
{
queryModel model = new queryModel();
List <string> addressList = e.Argument.ToString().Split(',').ToList();
model.address1 = addressList[0];
model.address2 = addressList[1];
model.address3 = addressList[2];
string query = JsonConvert.SerializeObject(model);
try
{
CatsAndAreasObject CATS = JsonConvert.DeserializeObject <CatsAndAreasObject>(GlobalVariable.newCatsAndAreas);
List <gridVM> list = new List <gridVM>();
foreach (var item in manager.getList(query))
{
if (GlobalVariable.searchTabghe == "")
{
GlobalVariable.searchTabghe = "1";
}
string phones = item.phones;
string tabaghe = GlobalVariable.searchTabghe;
string fullprice = item.tabaghe_1_total_price.ToString();
string metriprice = item.tabaghe_1_metri.ToString();
string rahnprice = item.tabaghe_1_rahn.ToString();
string ejareprice = item.tabaghe_1_ejare.ToString();
string tabagh = item.tabaghe1.ToString();
string kha = item.bed1.ToString();
string zirban = item.zirbana1.ToString();
string tb1 = item.tabaghe1.ToString();
string tb2 = item.tabaghe2.ToString();
string tb3 = item.tabaghe3.ToString();
if (tb1 == tabaghe)
{
fullprice = item.tabaghe_1_total_price.ToString();
metriprice = item.tabaghe_1_metri.ToString();
rahnprice = item.tabaghe_1_rahn.ToString();
ejareprice = item.tabaghe_1_ejare.ToString();
tabagh = item.tabaghe1.ToString();
kha = item.bed1.ToString();
zirban = item.zirbana1.ToString();
}
if (tb2 == tabaghe)
{
fullprice = item.tabaghe_2_total_price.ToString();
metriprice = item.tabaghe_2_metri.ToString();
rahnprice = item.tabaghe_2_rahn.ToString();
ejareprice = item.tabaghe_2_ejare.ToString();
tabagh = item.tabaghe2.ToString();
kha = item.bed2.ToString();
zirban = item.zirbana2.ToString();
}
if (tb3 == tabaghe)
{
fullprice = item.tabaghe_3_total_price.ToString();
metriprice = item.tabaghe_3_metri.ToString();
rahnprice = item.tabaghe_3_rahn.ToString();
ejareprice = item.tabaghe_3_ejare.ToString();
tabagh = item.tabaghe3.ToString();
kha = item.bed3.ToString();
zirban = item.zirbana3.ToString();
}
string serverid = item.ID.ToString();
string date = item.date_updated.ToString();
string address = item.address.ToString();
string owner = item.malek.ToString();
string senn = item.senn == 0 ? "-" : (from q in CATS.data.list.senn
where q.ID == item.senn.ToString()
select q.title).First();
string melkkind = "";
if (item.maghaze != null && item.maghaze != "0")
{
melkkind = melkkind + "مغازه،";
}
if (item.apartment != null && item.apartment != "0")
{
melkkind = melkkind + "آپارتمان،";
}
if (item.villa != null && item.villa != "0")
{
melkkind = melkkind + "ویلا،";
}
if (item.mostaghellat != null && item.mostaghellat != "0")
{
melkkind = melkkind + "مستغلات،";
}
if (item.kolangi != null && item.kolangi != "0")
{
melkkind = melkkind + "کلنگی،";
}
if (item.office != null && item.office != "0")
{
melkkind = melkkind + "دفتر،";
}
if (melkkind.Length > 0)
{
melkkind = melkkind.Remove(melkkind.Length - 1, 1);
}
string Dealkind = "";
if (Convert.ToInt32(item.isForoosh.ToString()) > 0)
{
Dealkind = Dealkind + "فروش،";
}
if (Convert.ToInt32(item.isRahn.ToString()) > 0)
{
Dealkind = Dealkind + "رهن،";
}
if (Convert.ToInt32(item.isEjare.ToString()) > 0)
{
Dealkind = Dealkind + "اجاره،";
}
if (Dealkind.Length > 0)
{
Dealkind = Dealkind.Remove(Dealkind.Length - 1, 1);
}
string totalrahn = item.isForoosh.ToString() == "1" ? fullprice : rahnprice;
string metriejare = item.isForoosh.ToString() == "1" ? metriprice : ejareprice;
string Rtabaghe = tabagh;
string khab = kha;
string zirbana = zirban;
bool mycheckbox = false;
totalrahn = totalrahn.Replace(".", "");
if (totalrahn == "0")
{
totalrahn = "0";
}
else if (Convert.ToInt64(totalrahn) > 0)
{
string mytotal = string.Format(CultureInfo.InvariantCulture, "{0:0,0}", Convert.ToInt64(totalrahn));
totalrahn = mytotal;
}
//else if (totalrahn == "-1")
//{
// totalrahn = "توافقی";
//}
//else if (totalrahn == "-2")
//{
// totalrahn = "رایگان";
//}
metriejare = metriejare.Replace(".", "");
if (Convert.ToInt64(metriejare) == 0)
{
metriejare = "0";
}
else if (Convert.ToInt64(metriejare) > 0)
{
string mymetriejare = string.Format(CultureInfo.InvariantCulture, "{0:0,0}", Convert.ToInt64(metriejare));
metriejare = mymetriejare;
}
//else if (metriejare == "-1")
//{
// metriejare = "توافقی";
//}
//else if (metriejare == "-2")
//{
// metriejare = "رایگان";
//}
if (GlobalVariable.temporaryOwnList.Contains(serverid + ","))
{
mycheckbox = true;
}
gridVM newitem = new gridVM()
{
Address = item.address1 + item.address2 + item.address3,
Address1 = item.address1,
Address2 = item.address2,
Address3 = item.address3,
bed = kha,
codegrid = item.number.ToString(),
dategrid = dateTimeConvert.ToPersianDateString(item.date_updated),
datetime = item.date_updated,
ejare_metri = int.Parse(metriejare.Replace(",", "")),
floorgrid = tabagh,
kindgrid = Dealkind,
typegrid = melkkind,
ownergrid = item.malek,
rahn_total = int.Parse(totalrahn.Replace(",", "")),
zirbana = zirban,
checkbox = mycheckbox,
Senn = senn,
phones = phones
};
list.Add(newitem);
}
string FILELIST = JsonConvert.SerializeObject(list);
e.Result = FILELIST;
}
catch (Exception error)
{
e.Result = "error";
}
}
