public JsonResult GetSondajeImg(string projectid) { crud = new CRUDDocumentos(); List <SelectListItem> sondajesDDL = new List <SelectListItem>(); var data = crud.listaSondaje(); sondajesDDL = crud.listaSondaje().Where(x => x.FISCAL_YEAR == FISCALYEARGLOBAL && x.PROJECTCODE.Equals(projectid) && x.DH_DRILLTYPE_LIST.Contains('D')).Select(x => x.HOLEID.ToString()).Distinct().ToList().Select(x => new SelectListItem { Value = x, Text = x }).ToList(); return(Json(sondajesDDL, JsonRequestBehavior.AllowGet)); }
public ActionResult AdminDocumentoSondajes() { crud = new CRUDDocumentos(); var listFY = crud.listaSondaje().OrderBy(z => z.FISCAL_YEAR).Select(x => x.FISCAL_YEAR).Distinct().ToList(); ViewBag.Fiscal_Year = listFY.Select(x => new SelectListItem { Value = x.ToString(), Text = x.ToString() }).ToList(); return(View()); }
//############################################### DOCUMENTOS PDF - FOTOGRAFIA - PETROGRAFIA public JsonResult GetProjecto(string id) { crud = new CRUDDocumentos(); FISCALYEARGLOBAL = int.Parse(id); List <SelectListItem> proyectosDDL = new List <SelectListItem>(); proyectosDDL = crud.listaSondaje().Where(x => x.FISCAL_YEAR == FISCALYEARGLOBAL).Select(x => x.PROJECTCODE.ToString()).Distinct().ToList().Select(x => new SelectListItem { Value = x, Text = x }).ToList(); return(Json(proyectosDDL, JsonRequestBehavior.AllowGet)); }