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