public int Create(System.Data.DataRow r, DBRepository repository) { int result = 0; try { Datasets.Observaciones.OBSERVACIONESRow dr = (Datasets.Observaciones.OBSERVACIONESRow)r; List<IDbDataParameter> Paramlist = new List<IDbDataParameter>(); Paramlist.Add(repository.DbFactory.getDataParameter("P_IDOPERADOR", DbType.Int32, dr.IDOPERADOR)); Paramlist.Add(repository.DbFactory.getDataParameter("P_DESCRIPCION", DbType.String, dr.DESCRIPCION)); Paramlist.Add(repository.DbFactory.getDataParameter("P_IDTICKET", DbType.Int32, dr.IDTICKET)); result = repository.ExecuteCreateProcedure(CONST_CREATE_PROCEDURE_NAME, Paramlist, dr.OBJECTHASH.ToString()); } catch (Exception ex) { throw ex; } return result; }
private void PersistPrestadores(int idTicketAsociado, Datasets.Ticket_Prestador.TICKET_PRESTADORESDataTable Prestadores, DBRepository repository) { foreach (Datasets.Ticket_Prestador.TICKET_PRESTADORESRow r in Prestadores) { if (r.PERSISTOPERATION != (int)Utils.InterAssist.Constants.PersistOperationType.Void) { // Si es distinto de void hace una actualización en la base de datos. if (r.PERSISTOPERATION == (int)Utils.InterAssist.Constants.PersistOperationType.Persist) { if (r.IDTICKETPRESTADOR == NULL_INT) { Insert_Proveedor_Ticket(repository, idTicketAsociado, r.IDPRESTADOR, r.IDTIPOSERVICIO, r.COMENTARIOS, r.KILOMETROS, r.COSTO, "ObjectHash"); } else { Update_Proveedor_Ticket(repository, r.IDTICKETPRESTADOR, idTicketAsociado, r.IDPRESTADOR, r.IDTIPOSERVICIO, r.COMENTARIOS, r.KILOMETROS, r.COSTO, "ObjectHash"); } } else { if (r.PERSISTOPERATION == ((int)Utils.InterAssist.Constants.PersistOperationType.Delete)) { Delete_Proveedor_Ticket(r.IDTICKETPRESTADOR, repository); } } } } }
public bool Update_Proveedor_Ticket(DBRepository repository, Int32 idTicketPrestador, Int32 idTicket, Int32 idPrestador, Int32 idTipoServicio, string comentarios, decimal kIlometos, decimal Costo, string ObjectHash) { bool result = false; try { /* P_ID IN TICKET_PRESTADORES.IDTICKETPRESTADOR%TYPE, P_IDTICKET IN NUMBER, P_IDPRESTADOR IN NUMBER, P_IDTIPOSERVICIO IN NUMBER, P_OBJECTHASH IN PRESTADORES.objecthash%TYPE, P_COMENTARIOS IN TICKET_PRESTADORES.COMENTARIOS%TYPE, P_KILOMETROS IN TICKET_PRESTADORES.KILOMETROS%TYPE, P_COSTO IN TICKET_PRESTADORES.COSTO%TYPE */ List<IDbDataParameter> paramList = new List<IDbDataParameter>(); paramList.Add(repository.DbFactory.getDataParameter("P_ID", DbType.Int32, idTicketPrestador)); paramList.Add(repository.DbFactory.getDataParameter("P_IDTICKET", DbType.Int32, idTicket)); paramList.Add(repository.DbFactory.getDataParameter("P_IDPRESTADOR", DbType.Int32, idPrestador)); paramList.Add(repository.DbFactory.getDataParameter("P_IDTIPOSERVICIO", DbType.Int32, idTipoServicio)); paramList.Add(repository.DbFactory.getDataParameter("P_COMENTARIOS", DbType.String, comentarios)); paramList.Add(repository.DbFactory.getDataParameter("P_KILOMETROS", DbType.Decimal, kIlometos)); paramList.Add(repository.DbFactory.getDataParameter("P_COSTO", DbType.Decimal, Costo)); repository.ExecuteUpdateProcedure(CONST_UPDATTE_TICKET_PRESTADOR_PROCEDURE_NAME, paramList, ObjectHash); result = true; } catch(Exception ex) { throw ex; } return result; }
public int Insert_Proveedor_Ticket(DBRepository repository, Int32 idTicket, Int32 idPrestador, Int32 idTipoServicio, string comentarios, decimal kIlometos, decimal Costo, string ObjectHash) { int resultID = -1; try { List<IDbDataParameter> paramList = new List<IDbDataParameter>(); paramList.Add(repository.DbFactory.getDataParameter("P_IDTICKET", DbType.Int32, idTicket)); paramList.Add(repository.DbFactory.getDataParameter("P_IDPRESTADOR", DbType.Int32, idPrestador)); paramList.Add(repository.DbFactory.getDataParameter("P_IDTIPOSERVICIO", DbType.Int32, idTipoServicio)); paramList.Add(repository.DbFactory.getDataParameter("P_COMENTARIOS", DbType.String, comentarios)); paramList.Add(repository.DbFactory.getDataParameter("P_KILOMETROS", DbType.Decimal, kIlometos)); paramList.Add(repository.DbFactory.getDataParameter("P_COSTO", DbType.Decimal, Costo)); resultID = repository.ExecuteCreateProcedure(CONST_CREATE_TICKET_PRESTADOR_PROCEDURE_NAME, paramList, ObjectHash); }catch(Exception ex) { throw ex; } return resultID; }
public bool Delete_Proveedor_Ticket(int idTicketProveedor, DBRepository repository) { bool result = false; try { List<IDbDataParameter> paramList = new List<IDbDataParameter>(); paramList.Add(repository.DbFactory.getDataParameter("P_ID", DbType.Int32, idTicketProveedor)); result = repository.ExecuteNonQueryProcedure(CONST_DELETE_TICKET_PRESTADOR_PROCEDURE_NAME, paramList); result = true; } catch (Exception ex) { throw ex; } return result; }
public static DBRepository GetDbRepository(DBRepository DBRepository) { DBRepository result = DBRepository.GetDbRepository(false); result._dbConnection = DBRepository._dbConnection; result._dbTransaction = DBRepository._dbTransaction; return result; }