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