public ActionResult ReAdminDocumentoSondajesAdd(String HOLEID)
{
crud = new CRUDDocumentos();
ViewBag.MenuHeadSondaje = crud.listaFileListCategory(HOLEID).ToList();
ViewBag.MenuItemSondaje = crud.listaFileList(HOLEID).ToList();
return(View());
}
public ActionResult FotografiaDetalle(String FISCAL_YEAR, String PROJECTCODE, String HOLEID)
{
crud = new CRUDDocumentos();
ViewBag.MenuItemSondaje = crud.listaFileListFOTO(HOLEID).ToArray().ToList();
return(View());
}
public ActionResult Petrografia()
{
crud = new CRUDDocumentos();
ViewBag.SampleID = crud.listaPetrografia().Select(x => new SelectListItem {
Value = x.SAMPLEID.ToString(), Text = x.SAMPLEID.ToString()
}).Distinct().ToList();
return(View());
}
public ActionResult ListadoDocumentos(String FISCAL_YEAR, String PROJECTCODE, String HOLEID)
{
crud = new CRUDDocumentos();
ViewBag.MenuHeadSondaje = crud.listaFileListCategory(HOLEID).ToList();
ViewBag.MenuItemSondaje = crud.listaFileList(HOLEID).ToList();
return(View());
}
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());
}
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 JsonResult GetSondPetro(string id)
{
crud = new CRUDDocumentos();
List <SelectListItem> sondpetroDDL = new List <SelectListItem>();
sondpetroDDL = crud.listaPetrografia().Where(x => x.SAMPLEID.Equals(id)).Select(x => x.HOLEID_ME.ToString()).Distinct().ToList().Select(x => new SelectListItem {
Value = x, Text = x
}).ToList();
return(Json(sondpetroDDL, JsonRequestBehavior.AllowGet));
}
//############################################### 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));
}
public ActionResult AdminDocumentoSondajesAdd(String HOLEID, String PROJECTCODE)
{
crud = new CRUDDocumentos();
ViewBag.holeidv = HOLEID;
ViewBag.projectv = PROJECTCODE;
ViewBag.subcatergoria = crud.listaSubCategority(HOLEID).Select(x => new SelectListItem {
Value = x.DESCRIPTION, Text = x.DESCRIPTION
}).ToList();
ViewBag.MenuHeadSondaje = crud.listaFileListCategory(HOLEID).ToList();
ViewBag.MenuItemSondaje = crud.listaFileList(HOLEID).ToList();
return(View());
}
public ActionResult getDepartment()
{
crud = new CRUDDocumentos();
return(Json(crud.listaSubCategority(vid).Select(x => new { ID = x.DESCRIPTION, DESCRIPTION = x.DESCRIPTION }).ToList(), JsonRequestBehavior.AllowGet));
}
