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())); } }