public ActionResult AjaxRead(string serialNumber, StoreRequestParams parameters)
{
using (DatisEntities pe = new DatisEntities())
{
var all = pe.SerialNumbers.Where(x => (x.SerialNumber1.Contains(serialNumber) || serialNumber == null)).Select(m => new SerialNumberVM()
{
Id = m.Id,
SerialNumber = m.SerialNumber1,
Name = m.Name,
BuyDate = m.BuyDate,
Description = m.Description,
Email = m.Email,
InsertDate1 = m.InsertDate ?? DateTime.MinValue,
LastName = m.LastName,
Mobile = m.Mobile,
Product = pe.Products.Where(p => p.Id == m.ProductId).Select(n => n.Model + n.BrandCategory.Category.Name + n.BrandCategory.Brand.Name).FirstOrDefault()
});
var result = all.OrderBy(x => x.Id).ApplyPaging(parameters).ToList();
foreach (var res in result)
{
DateTime d = DateTime.Parse(res.InsertDate1.ToString());
PersianCalendar pc = new PersianCalendar();
res.InsertDate = string.Format("{0}/{1}/{2}", pc.GetYear(d), pc.GetMonth(d), pc.GetDayOfMonth(d));
}
return(this.Store(result, all.Count()));
}
}
//
// GET: /BrandAdmin/
public ActionResult AjaxRead(RepairSearchVM searchOptions, StoreRequestParams parameters)
{
using (DatisEntities pe = new DatisEntities())
{
var all = pe.Repairs.Where(x => (x.Eshkal.Contains(searchOptions.Eshkal) || searchOptions.Eshkal == null) &&
(x.NameSherkat.Contains(searchOptions.NameSherkat) || searchOptions.NameSherkat == null)).Select(m => new RepairVM()
{
Id = m.Id,
TamirOrMarjoo = m.TamirOrMarjoo == 0 ? "تعمیر" : "مرجوعی از فروش",
NameSherkat = m.NameSherkat,
NameMasool = m.NameMasool,
Ostan = pe.States.Where(b => b.Id == m.Ostan).FirstOrDefault().Name,
Shahrestan = pe.Cities.Where(b => b.Id == m.Shahrestan).FirstOrDefault().Name,
CodePosti = m.CodePosti,
Tel = m.Tel,
Mobile = m.Mobile,
Email = m.Email,
ModelDastgah = m.ModelDastgah,
ShomareSerialDastgah = m.ShomareSerialDastgah,
ShomareFactor = m.ShomareFactor,
FactorDate = m.FactorDate,
Address = m.Address,
Eshkal = m.Eshkal
});
var result = all.OrderBy(x => x.Id).ApplyPaging(parameters).ToList();
return(this.Store(result, all.Count()));
}
}
//
// GET: /AnalogBoxAdmin/
public ActionResult AjaxRead(TermsOfGarrantySearchVM searchOptions, StoreRequestParams parameters)
{
var pe = new DatisEntities();
var all = pe.SiteContents.Where(x => (x.Title.Contains(searchOptions.Name) || searchOptions.Name == null)
&&
(x.Article.Contains(searchOptions.Description) || searchOptions.Description == null) &&
x.ArticleType == (int)DatisEnums.ArticleType.NewsRoom);
var result = all.OrderBy(x => x.Id).ApplyPaging(parameters).ToList();
return(this.Store(result, all.Count()));
}
//
// GET: /BrandAdmin/
public ActionResult AjaxRead(BrandSearchVM searchOptions, StoreRequestParams parameters)
{
using (DatisEntities pe = new DatisEntities())
{
var all = pe.Brands.Where(x => (x.Name.Contains(searchOptions.Name) || searchOptions.Name == null)).Select(m => new BrandVM()
{
Id = m.Id,
Name = m.Name,
Description = m.Description
});
var result = all.OrderBy(x => x.Id).ApplyPaging(parameters).ToList();
return(this.Store(result, all.Count()));
}
}
public ActionResult AjaxRead(TermsOfGarrantySearchVM searchOptions, StoreRequestParams parameters)
{
using (DatisEntities pe = new DatisEntities())
{
var all = pe.SiteContents.Where(x => (x.Title.Contains(searchOptions.Name) || searchOptions.Name == null) &&
(x.Article.Contains(searchOptions.Description) || searchOptions.Description == null) &&
x.ArticleType == (int)DatisEnums.ArticleType.Technology).Select(m => new SiteContentVM()
{
Id = m.Id,
Title = m.Title,
Article = m.Article
});
var result = all.OrderBy(x => x.Id).ApplyPaging(parameters).ToList();
return(this.Store(result, all.Count()));
}
}
public ActionResult AjaxRead(AgancySearchVM searchOptions, StoreRequestParams parameters)
{
using (DatisEntities pe = new DatisEntities())
{
var all = pe.Agancies.Where(x => (x.NameSherkatForushgah.Contains(searchOptions.NameSherkatForushgah) || searchOptions.NameSherkatForushgah == null) &&
(x.NameModiramelMasool.Contains(searchOptions.NameModiramelMasool) || searchOptions.NameModiramelMasool == null)).Select(m => new AgancyRequestVM()
{
Id = m.Id,
NameSherkatForushgah = m.NameSherkatForushgah,
NameModiramelMasool = m.NameModiramelMasool,
Fax = m.Fax,
RegisterDate = m.RegisterDate,
RegisterPlace = m.RegisterPlace,
TedadPersonnelFanni = m.TedadPersonnelFanni,
TedadPersonnelEdari = m.TedadPersonnelEdari,
TedadPersonnelForush = m.TedadPersonnelForush,
ProjeAnjamDadeid = m.ProjeAnjamDadeid,
NamayandegBrandDashte = m.NamayandegBrandDashte,
TavanayiSaliane = m.TavanayiSaliane,
AshnayiBaPrada = m.AshnayiBaPrada,
EjareShakhsi = m.EjareShakhsi == 0 ? "اجاره" : "شخصی",
SanadMelki = m.SanadMelki ?? false,
Safte = m.Safte ?? false,
CheckeZemanat = m.CheckeZemanat ?? false,
ZemanatNamehBanki = m.ZemanatNamehBanki ?? false,
VajhNaghd = m.VajhNaghd ?? false,
Shahrestan = pe.Cities.Where(b => b.Id == m.Shahrestan).FirstOrDefault().Name,
Ostan = pe.States.Where(b => b.Id == m.Ostan).FirstOrDefault().Name,
Tel = m.Tel,
Mobile = m.Mobile,
Email = m.Email,
Address = m.Address,
});
var result = all.OrderBy(x => x.Id).ApplyPaging(parameters).ToList();
foreach (var res in result)
{
res.NoeZemanat = String.Format("{0} {1} {2} {3} {4}", res.SanadMelki ? "سند ملکی" : ""
, res.Safte ? "سفته" : ""
, res.CheckeZemanat ? "چک ضمانت" : ""
, res.ZemanatNamehBanki ? "ضمانت نامه بانکی" : ""
, res.VajhNaghd ? "وجه نقد" : "");
}
return(this.Store(result, all.Count()));
}
}
//
// GET: /BrandAdmin/
public ActionResult AjaxRead(ProductSearchVM searchOptions, StoreRequestParams parameters)
{
using (DatisEntities pe = new DatisEntities())
{
var all = pe.Products.Where(x => (x.Model.Contains(searchOptions.Model) || searchOptions.Model == null)).Select(m => new ProductVM()
{
Id = m.Id,
Model = m.Model,
BrandCategoryId = m.BrandCategoryId ?? 0,
FeaturesSummary = m.FeaturesSummary,
Summary = m.Summary,
Description = m.Description
});
var result = all.OrderBy(x => x.Id).ApplyPaging(parameters).ToList();
return(this.Store(result, all.Count()));
}
}
//
// GET: /BrandAdmin/
public ActionResult AjaxRead(FeatureValueSearchVM searchOptions, StoreRequestParams parameters)
{
using (DatisEntities pe = new DatisEntities())
{
var brandCategory = pe.BrandCategories.Where(n => n.Id == searchOptions.BrandCategoryId).FirstOrDefault();
Category cat = brandCategory.Category;
var features = pe.Features.Where(p => p.CategoryId == cat.Id).ToList();
List <FeatureValuesVM> all = new List <FeatureValuesVM>();
foreach (Feature item in features)
{
var featureProduct = pe.FeatureProducts.Where(p => p.ProductId == searchOptions.ProductId && p.FeatureId == item.Id).FirstOrDefault();
FeatureValuesVM fvvm;
if (featureProduct != null)
{
fvvm = new FeatureValuesVM()
{
Id = featureProduct.Id,
Name = item.Name,
CategoryId = cat.Id,
BrandCategoryId = searchOptions.BrandCategoryId,
FeatureId = item.Id,
ProductId = searchOptions.ProductId,
Value = featureProduct.Value
};
}
else
{
fvvm = new FeatureValuesVM()
{
Id = 0,
Name = item.Name,
CategoryId = cat.Id,
BrandCategoryId = searchOptions.BrandCategoryId,
FeatureId = item.Id,
ProductId = searchOptions.ProductId,
Value = ""
};
}
all.Add(fvvm);
}
//var result = all.OrderBy(x => x.Id).ApplyPaging(parameters).ToList();
return(this.Store(all, all.Count()));
}
}
public ActionResult AjaxRead(CareerSearchVM searchOptions, StoreRequestParams parameters)
{
using (DatisEntities pe = new DatisEntities())
{
var all = pe.Careers.Where(x => (x.Name.Contains(searchOptions.Name) || searchOptions.Name == null) &&
(x.LastName.Contains(searchOptions.LastName) || searchOptions.LastName == null) &&
(x.CodeMelli.Contains(searchOptions.CodeMelli) || searchOptions.CodeMelli == null)).Select(m => new CareerVM()
{
Id = m.Id,
Name = m.Name,
LastName = m.LastName,
CodeMelli = m.CodeMelli,
ResumeFilePath = m.ResumeFilePath,
});
var result = all.OrderBy(x => x.Id).ApplyPaging(parameters).ToList();
return(this.Store(result, all.Count()));
}
}
//
// GET: /BrandAdmin/
public ActionResult AjaxRead(ClientMessageVM searchOptions, StoreRequestParams parameters)
{
using (DatisEntities pe = new DatisEntities())
{
var all = pe.ClientsMessages.Where(x => (x.Name.Contains(searchOptions.Name) || searchOptions.Name == null) &&
(x.Email.Contains(searchOptions.Email) || searchOptions.Email == null) &&
(x.Subject.Contains(searchOptions.Subject) || searchOptions.Subject == null) &&
(x.Message.Contains(searchOptions.Message) || searchOptions.Message == null)).Select(m => new ClientMessageVM()
{
Id = m.Id,
Name = m.Name,
Subject = m.Subject,
Email = m.Email,
Message = m.Message
});
var result = all.OrderBy(x => x.Id).ApplyPaging(parameters).ToList();
return(this.Store(result, all.Count()));
}
}
//
// GET: /BrandAdmin/
public ActionResult AjaxRead(CategorySearchVM searchOptions, StoreRequestParams parameters)
{
using (DatisEntities pe = new DatisEntities())
{
var all = pe.Categories.Where(x => (x.Name.Contains(searchOptions.Name) || searchOptions.Name == null)).Select(m => new CategoryVM()
{
Id = m.Id,
Name = m.Name,
ParentId = m.ParentId ?? 0
//BrandsIds = m.BrandCategories.Select(n=>n.BrandId).ToList()
});
var result = all.OrderBy(x => x.Id).ApplyPaging(parameters).ToList();
foreach (var categoryVM in result)
{
categoryVM.BrandsIds = pe.BrandCategories.Where(p => p.CategoryId == categoryVM.Id).Select(n => n.BrandId).ToList();
}
return(this.Store(result, all.Count()));
}
}
//
// GET: /BrandAdmin/
public ActionResult AjaxRead(CategorySearchVM searchOptions, StoreRequestParams parameters)
{
using (DatisEntities pe = new DatisEntities())
{
var all = pe.Features.Where(x => (x.Name.Contains(searchOptions.Name) || searchOptions.Name == null) && (x.CategoryId == searchOptions.CategoryId || searchOptions.CategoryId == 0)).Select(m => new FeatureVM()
{
Id = m.Id,
Name = m.Name,
CategoryId = m.CategoryId ?? 0,
CategoryName = ""
});
var result = all.OrderBy(x => x.Id).ApplyPaging(parameters).ToList();
foreach (var item in result)
{
var cat = pe.Categories.Where(m => m.Id == item.CategoryId).FirstOrDefault();
item.CategoryName = cat.Name;
}
return(this.Store(result, all.Count()));
}
}
