public JsonResult ListCodeMaster(string searchText, int maxResults, string type) { OAMSEntities db = new OAMSEntities(); var result = db.CodeMasters.Where(r => r.Note.Contains(searchText) && r.Type == type) .Take(maxResults) .Select(r => new { r.ID, r.Code, r.Note }) .ToList(); return Json(result); }
public JsonResult ListClient(string searchText, int maxResults) { OAMSEntities db = new OAMSEntities(); var result = db.Clients .Where(r => r.Name != null) .ToList() .Where(r => r.Name.ToLower().Contains(searchText.ToLower()) || r.Name.ToLower().RemoveDiacritics().Contains(searchText.ToLower())) .Take(maxResults) .Select(r => new { r.ID, r.Name }) .ToList(); return Json(result); }
public JsonResult ListCats(string searchText, int? level = null) { OAMSEntities db = new OAMSEntities(); var result = db.Categories.Where(r => (r.FullName.Contains(searchText) || r.FullNameNoDiacritics.Contains(searchText)) && (level == null || r.Level == level) ) .Distinct() //.Take(maxResults) .Select(r => new { r.ID, Name = r.FullName }) .ToList(); return Json(result); }
public JsonResult ListContractor(string searchText, int maxResults) { OAMSEntities db = new OAMSEntities(); var result = db.Contractors .ToList() .Where(r => r.Name != null) .Where(r => r.Name.ToLower().Contains(searchText.ToLower()) || r.Name.ToLower().RemoveDiacritics().Contains(searchText.ToLower()) || r.Name.Replace(" ", "").ToLower().Contains(searchText.Replace(" ","").ToLower()) || (r.ContractorContacts.Count > 0 && r.ContractorContacts.SelectMany(r1 => r1.ContractorContactDetails).Count() > 0 && r.ContractorContacts .SelectMany(r1 => r1.ContractorContactDetails) .Where(r1 => r1.Value != null) .Select(r1 => r1.Value.Replace(" ", "").ToLower()) .Where(r1 => r1.Contains(searchText.Replace(" ", "").ToLower())) .Count() > 0 ) ) .Take(maxResults) .Select(r => new { r.ID, r.Name }) .ToList(); //var result = db.ContractorContactDetails // .ToList() // .Where(r => r.ContractorContact.Contractor.Name != null ) // .Where(r => r.ContractorContact.Contractor.Name.ToLower().Contains(searchText.ToLower()) // || r.ContractorContact.Contractor.Name.ToLower().RemoveDiacritics().Contains(searchText.ToLower()) // || (r.Value != null && r.Value.Replace(" ", "").ToLower().Contains(searchText.Replace(" ", "").ToLower())) // ) // .Select(r => r.ContractorContact.Contractor) // .Distinct() // .Take(maxResults) // .Select(r => new { r.ID, r.Name }) // .ToList(); return Json(result); }
public JsonResult ListInstallationPosition1(string searchText) { OAMSEntities db = new OAMSEntities(); var result = db.CodeMasters .Where(r => r.Type == CodeMasterType.InstallationPosition1 && r.Note.Contains(searchText) ) .Distinct() .Select(r => new { ID = r.Code, Name = r.Note }) .ToList(); return Json(result); }
public JsonResult JsonList() { OAMSEntities db = new OAMSEntities(); var result = db.Sites.Where(r => r.Lng > 0 && r.Lat > 0) .Select(r => new { r.Lat, r.Lng, r.Code, Note = r.Code }) .ToList(); return Json(result); }