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