List <CitaOriginal> ListCitaxUsuario(string codigo) { CitaOriginal mascO = ListCitaOriginal().Where(x => x.ID_USU == codigo).FirstOrDefault(); List <CitaOriginal> aPedido = new List <CitaOriginal>(); SqlCommand cmd = new SqlCommand("SP_LISTACITALXUSUARIO", cn); cmd.Parameters.AddWithValue("@USU", codigo); cmd.CommandType = CommandType.StoredProcedure; cn.Open(); SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { aPedido.Add(new CitaOriginal() { ID_CITA = dr[0].ToString(), FECHA_REG = DateTime.Parse(dr[1].ToString()), ID_USU = dr[2].ToString(), ID_AREA = dr[3].ToString(), ID_MASC = dr[4].ToString(), ID_HORAR = dr[5].ToString(), ID_HORA = dr[6].ToString(), ID_ESTA = dr[7].ToString(), IMPORTE = double.Parse(dr[8].ToString()), }); } dr.Close(); cn.Close(); return(aPedido); }
public ActionResult editarCita(string id) { CitaOriginal usuaO = ListCitaOriginal().Where(x => x.ID_CITA == id).FirstOrDefault(); ViewBag.codigo = codigoCorrelativo(); ViewBag.usuario = new SelectList(ListUsuario(), "ID_USU", "NOMBRES"); ViewBag.mascota = new SelectList(ListMascota(), "ID_MASC", "NOMBRE"); ViewBag.area = new SelectList(ListArea(), "ID_AREA", "NOMB_AREA"); ViewBag.hora = new SelectList(ListHora(), "ID_HORA", "NOM_HOR"); ViewBag.horario = new SelectList(ListHorar(), "ID_HORAR", "NOMB_HORA"); ViewBag.estado = new SelectList(ListEstado(), "ID_ESTA", "NOMB_ESTA"); return(View(usuaO)); }
public ActionResult registrarCita(CitaOriginal obju) { List <SqlParameter> parametros = new List <SqlParameter>() { new SqlParameter() { ParameterName = "@IDCIT", SqlDbType = SqlDbType.Char, Value = obju.ID_CITA }, new SqlParameter() { ParameterName = "@FECHA", SqlDbType = SqlDbType.DateTime, Value = obju.FECHA_REG }, new SqlParameter() { ParameterName = "@IDUSU", SqlDbType = SqlDbType.Char, Value = obju.ID_USU }, new SqlParameter() { ParameterName = "@AREA", SqlDbType = SqlDbType.Char, Value = obju.ID_AREA }, new SqlParameter() { ParameterName = "@IDMASC", SqlDbType = SqlDbType.Char, Value = obju.ID_MASC }, new SqlParameter() { ParameterName = "@HORAR", SqlDbType = SqlDbType.Char, Value = obju.ID_HORAR }, new SqlParameter() { ParameterName = "@HORA", SqlDbType = SqlDbType.Char, Value = obju.ID_HORA }, new SqlParameter() { ParameterName = "@IDESTA", SqlDbType = SqlDbType.Char, Value = obju.ID_ESTA }, new SqlParameter() { ParameterName = "@IMPOR", SqlDbType = SqlDbType.SmallMoney, Value = obju.IMPORTE } }; ViewBag.mensaje = CRUD("SP_MANTENIMIENTOCITA", parametros); return(RedirectToAction("IndexUsuario")); }
public ActionResult listadoCitaxUsuario(string id) { CitaOriginal mascO = ListCitaOriginal().Where(x => x.ID_USU == id).FirstOrDefault(); return(View(ListCitaxUsuario(id))); }