public JsonResult AllIndicationNames(string prefix) { DrugInformationContext db = new DrugInformationContext(); var indicationNames = (from names in db.Indications where names.IndicationName.Contains(prefix) select new { id = names.Id, indicationName = names.IndicationName }).Take(30).ToList(); return(Json(indicationNames)); }
public JsonResult AllCompanyNames(string prefix) { DrugInformationContext db = new DrugInformationContext(); var pharmaNames = (from names in db.PharmaCompanies where names.PharmaName.Contains(prefix) select new { id = names.Id, pharmaNames = names.PharmaName }).Take(30).ToList(); return(Json(pharmaNames)); }
public JsonResult AllGenericNames(string prefix) { DrugInformationContext db = new DrugInformationContext(); var genericNames = (from names in db.DrugGenerics where names.GenericName.StartsWith(prefix) select new { id = names.Id, genericName = names.GenericName }).Take(15).ToList(); return(Json(genericNames)); }
public JsonResult AllBrandNames(string prefix) { DrugInformationContext db = new DrugInformationContext(); var drugsName = (from names in db.DrugBrandInfos where names.BrandName.StartsWith(prefix) select new { brandName = names.BrandName, drugForm = names.DrugForm, drugStrength = names.DrugStrength }).Take(10).ToList(); return(Json(drugsName)); }
public ActionResult LoadData([ModelBinder(typeof(DataTablesBinder))] IDataTablesRequest requestModel) { //Get parameters // get Start (paging start index) and length (page size for paging) var draw = Request.Form.GetValues("draw").FirstOrDefault(); var start = Request.Form.GetValues("start").FirstOrDefault(); var length = Request.Form.GetValues("length").FirstOrDefault(); //Get Sort columns value var sortColumn = Request.Form.GetValues("columns[" + Request.Form.GetValues("order[0][column]").FirstOrDefault() + "][name]").FirstOrDefault(); var sortColumnDir = Request.Form.GetValues("order[0][dir]").FirstOrDefault(); int pageSize = length != null?Convert.ToInt32(length) : 0; int skip = start != null?Convert.ToInt32(start) : 0; int totalRecords = 0; using (DrugInformationContext dc = new DrugInformationContext()) { dc.Configuration.LazyLoadingEnabled = false; var v = (from a in dc.DrugBrandInfos.Where(c => c.BrandName != null) select a); // Apply filters if (requestModel.Search.Value != String.Empty) { var value = requestModel.Search.Value.Trim(); v = v.Where(p => p.BrandName.Contains(value) || p.DrugForm.Contains(value) || p.PackSize.Contains(value)); } //Sorting if (!(string.IsNullOrEmpty(sortColumn) && string.IsNullOrEmpty(sortColumnDir))) { v = v.OrderBy(sortColumn + " " + sortColumnDir); } totalRecords = v.Count(); var data = v.Skip(skip).Take(pageSize).ToList(); return(Json(new { draw = draw, recordsFiltered = totalRecords, recordsTotal = totalRecords, data = data }, JsonRequestBehavior.AllowGet)); } }