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