public ActionResult mapa(long?id) { if (id == null) { //RedirectToAction("locales", "Home"); return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } ModelClinica local = new ModelClinica(); String codigo = id.ToString(); var datos = (from x in local.Clinicas where x.cod_cli == codigo select x).First(); if (datos.Equals(null)) { ViewBag.Message = "No se encuentra Datos"; return(View()); } ViewBag.Lat = datos.Lat_cli; ViewBag.Log = datos.Log_cli; ViewBag.descrip = datos.des_cli; ViewBag.nom_cli = datos.nom_cli; ViewBag.tel_cli = datos.tel_cli; ViewBag.dir_cli = datos.dir_cli; return(View(datos)); }
public ActionResult ListaClinicas(int?page, string searchString) { if (TempData["mensaje"] != null) { ViewBag.mensaje = TempData["mensaje"]; TempData["mensaje"] = null; } string currentFilter = null; ModelClinica local = new ModelClinica(); //var datos = (from x in local.Clinicas where x.Est_cli == "1" orderby x.cod_cli select x); var datos = (from x in local.Clinicas where x.Est_cli == "1" select x); if (!String.IsNullOrEmpty(searchString)) { datos = datos.Where(s => s.nom_cli.Contains(searchString.ToString())); } datos = datos.OrderByDescending(x => x.cod_cli); if (searchString != null) { page = 1; } else { searchString = currentFilter; } ViewBag.CurrentFilter = searchString; int pageSize = 8; int pageNumber = (page ?? 1); return(View(datos.ToPagedList(pageNumber, pageSize))); }
//[Bind(Include = "nom_cont,emi_cont")] public ActionResult CreateClinica(Clinicas dbcont) { try { // this.ConnectionString = ConfigurationManager.ConnectionStrings["Movies"].ConnectionString; string Conexion = ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString; ModelClinica DBClinica = new ModelClinica(); using (var con = new SqlConnection(@Conexion)) { //result = Dapper.SqlMapper.Query<int>(Conexion,"SP_INSERTACLINICA",System.Data.CommandType.StoredProcedure); con.Open(); var parameter = new DynamicParameters(); parameter.Add("@nom_cli", dbcont.nom_cli); parameter.Add("@des_cli", dbcont.des_cli); parameter.Add("@dir_cli", dbcont.dir_cli); parameter.Add("@tel_cli", dbcont.tel_cli); parameter.Add("@Lat_cli", dbcont.Lat_cli); parameter.Add("@Log_cli", dbcont.Log_cli); Dapper.SqlMapper.Execute(con, "SP_INSERTACLINICA", parameter, commandType: CommandType.StoredProcedure); con.Close(); } TempData["mensaje"] = ("<div class='exito'>Su Mensaje Fue Registrado con Exito</div>"); return(RedirectToAction("CreateClinica")); } catch (Exception ex) { string mimsg = ex.Message; //ViewBag.mensaje = ("<div class='alerta'>Error al Registra Valores > " +ex.Message+" </div>"); ViewBag.mensaje = ("<div class='alerta'>Error al Registra Valores </div>"); return(View()); } }
public ActionResult EditClinicas(long?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } string codigo = id.ToString(); ModelClinica local = new ModelClinica(); Clinicas datos = (from x in local.Clinicas where x.cod_cli == codigo select x).First(); //Clinicas datos = DbClinica.Clinicas.Find(id); if (datos == null) { return(HttpNotFound()); } if (TempData["mensaje"] != null) { ViewBag.mensaje = TempData["mensaje"]; TempData["mensaje"] = null; } return(View(datos)); }
public ActionResult locales(int?page, string searchString) { string currentFilter = null; ModelClinica local = new ModelClinica(); //var datos = (from x in local.Clinicas where x.Est_cli == "1" orderby x.cod_cli select x); var datos = (from x in local.Clinicas where x.Est_cli == "1" select x); if (!String.IsNullOrEmpty(searchString)) { datos = datos.Where(s => s.nom_cli.Contains(searchString.ToString())); /* * datos = datos.Where(s => s.des_cli.Contains(searchString) || s.FirstMidName.Contains(searchString)); */ } datos = datos.OrderBy(x => x.cod_cli); if (searchString != null) { page = 1; } else { searchString = currentFilter; } ViewBag.CurrentFilter = searchString; //var datos = ( from x in local.Clinicas where x.Est_cli=="1" orderby x.cod_cli select x ); int pageSize = 8; int pageNumber = (page ?? 1); return(View(datos.ToPagedList(pageNumber, pageSize))); }