public AdminCitaBEList GETAdminCitasVehPropietario(AdminCitaBE ent)
{
AdminCitaBEList lista = new AdminCitaBEList();
IDataReader DReader = null;
try
{
using (Database db = new Database())
{
db.ProcedureName = "[SRC_SPS_CITAS_VEH_PROPIETARIO]";
db.AddParameter("@nid_cita", DbType.Int32, ParameterDirection.Input, int.Parse(ent.grid_nid_cita.ToString().Trim()));
DReader = db.GetDataReader();
}
while (DReader.Read())
{
AdminCitaBE oAdminCitaBE = CrearEntidad_AdminCitaVehPropietario(DReader);
lista.Add(oAdminCitaBE);
}
DReader.Close();
}
catch (Exception)
{
if (DReader != null && !DReader.IsClosed)
{
DReader.Close();
}
throw;
}
return(lista);
}
public AdminCitaBEList GETListaAdminCitasDetalle(AdminCitaBE ent)
{
AdminCitaBEList lista = new AdminCitaBEList();
IDataReader DReader = null;
try
{
using (Database db = new Database())
{
db.ProcedureName = "[SRC_SPS_CITAS_VER_DETALLE]";
db.AddParameter("@nid_cita", DbType.Int32, ParameterDirection.Input, int.Parse(ent.grid_nid_cita));
db.AddParameter("@nid_estado", DbType.Int32, ParameterDirection.Input, int.Parse(ent.grid_nid_estado));
DReader = db.GetDataReader();
}
while (DReader.Read())
{
lista.Add(CrearEntidad_AdminCitaDet(DReader));
}
DReader.Close();
}
catch (Exception)
{
if (DReader != null && !DReader.IsClosed)
{
DReader.Close();
}
throw;
}
return(lista);
}
public AdminCitaBEList GETListaAdminCitasP(AdminCitaBE ent, int Nid_usuario)
{
AdminCitaBEList lista = new AdminCitaBEList();
IDataReader DReader = null;
try
{
using (Database db = new Database())
{
db.ProcedureName = "[SRC_SPS_CITAS]";
db.AddParameter("@cod_reserva_cita", DbType.String, ParameterDirection.Input, ent.cod_reserva_cita);
db.AddParameter("@coddpto", DbType.String, ParameterDirection.Input, ent.coddpto);
db.AddParameter("@codprov", DbType.String, ParameterDirection.Input, ent.codprov);
db.AddParameter("@coddist", DbType.String, ParameterDirection.Input, ent.coddist);
db.AddParameter("@nid_ubica", DbType.Int32, ParameterDirection.Input, ent.nid_ubica);
db.AddParameter("@nid_taller", DbType.Int32, ParameterDirection.Input, ent.nid_taller);
db.AddParameter("@AsesorServicio", DbType.String, ParameterDirection.Input, ent.AsesorServicio);
db.AddParameter("@Estadoreserva", DbType.String, ParameterDirection.Input, ent.Estadoreserva);
db.AddParameter("@IndPendiente", DbType.String, ParameterDirection.Input, ent.IndPendiente);
db.AddParameter("@fecreg1", DbType.String, ParameterDirection.Input, ent.fecreg1);
db.AddParameter("@fecreg2", DbType.String, ParameterDirection.Input, ent.fecreg2);
db.AddParameter("@feccita1", DbType.String, ParameterDirection.Input, ent.feccita1);
db.AddParameter("@feccita2", DbType.String, ParameterDirection.Input, ent.feccita2);
db.AddParameter("@horacita1", DbType.String, ParameterDirection.Input, ent.horacita1);
db.AddParameter("@horacita2", DbType.String, ParameterDirection.Input, ent.horacita2);
db.AddParameter("@nu_placa", DbType.String, ParameterDirection.Input, ent.nu_placa);
db.AddParameter("@nid_marca", DbType.Int32, ParameterDirection.Input, ent.nid_marca);
db.AddParameter("@nid_modelo", DbType.Int32, ParameterDirection.Input, ent.nid_modelo);
db.AddParameter("@co_tipo_documento", DbType.String, ParameterDirection.Input, ent.co_tipo_documento);
db.AddParameter("@nu_documento", DbType.String, ParameterDirection.Input, ent.nu_documento);
db.AddParameter("@no_cliente", DbType.String, ParameterDirection.Input, ent.no_cliente);
db.AddParameter("@no_apellidos", DbType.String, ParameterDirection.Input, ent.no_apellidos);
db.AddParameter("@Nid_usuario", DbType.String, ParameterDirection.Input, Nid_usuario);
DReader = db.GetDataReader();
}
while (DReader.Read())
{
lista.Add(CrearEntidad_AdminCitasP(DReader));
}
DReader.Close();
}
catch (Exception)
{
if (DReader != null && !DReader.IsClosed)
{
DReader.Close();
}
throw;
}
return(lista);
}
