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