public override System.Data.DataTable getMyTable()
{
DataTable dt = null;
dt = new Datasets.Prestadores.PRESTADORESDataTable();
return(dt);
}
public override bool Update(System.Data.DataRow r)
{
bool result = false;
try
{
DBRepository repository = DBRepository.GetDbRepository();
List <IDbDataParameter> paramList = new List <IDbDataParameter>();
Datasets.Prestadores.PRESTADORESDataTable dt = (Datasets.Prestadores.PRESTADORESDataTable)r.Table;
paramList.Add(repository.DbFactory.getDataParameter("P_ID", DbType.Int32, Int32.Parse(r[dt.IDPRESTADORColumn].ToString())));
paramList.Add(repository.DbFactory.getDataParameter("P_NOMBRE", DbType.String, r[dt.NOMBREColumn]));
paramList.Add(repository.DbFactory.getDataParameter("P_DESCRIPCION", DbType.String, r[dt.DESCRIPCIONColumn]));
paramList.Add(repository.DbFactory.getDataParameter("P_ESTADO", DbType.Int32, Int32.Parse(r[dt.ESTADOColumn].ToString())));
paramList.Add(repository.DbFactory.getDataParameter("P_TELEFONO1", DbType.String, r[dt.TELEFONO1Column]));
paramList.Add(repository.DbFactory.getDataParameter("P_TELEFONO2", DbType.String, r[dt.TELEFONO2Column]));
paramList.Add(repository.DbFactory.getDataParameter("P_CELULAR1", DbType.String, r[dt.CELULAR1Column]));
paramList.Add(repository.DbFactory.getDataParameter("P_CELULAR2", DbType.String, r[dt.CELULAR2Column]));
paramList.Add(repository.DbFactory.getDataParameter("P_NEXTEL", DbType.String, r[dt.NEXTELColumn]));
paramList.Add(repository.DbFactory.getDataParameter("P_DOMICILIO", DbType.String, r[dt.DOMICILIOColumn]));
paramList.Add(repository.DbFactory.getDataParameter("P_IDCIUDAD", DbType.Int32, Int32.Parse(r[dt.IDCIUDADColumn].ToString())));
paramList.Add(repository.DbFactory.getDataParameter("P_IDPROVINCIA", DbType.Int32, Int32.Parse(r[dt.IDPROVINCIAColumn].ToString())));
paramList.Add(repository.DbFactory.getDataParameter("P_IDPAIS", DbType.Int32, Int32.Parse(r[dt.IDPAISColumn].ToString())));
paramList.Add(repository.DbFactory.getDataParameter("p_IDLOCALIDAD", DbType.Int32, Int32.Parse(r[dt.IDLOCALIDADColumn].ToString())));
paramList.Add(repository.DbFactory.getDataParameter("P_EMAIL", DbType.String, r[dt.EMAILColumn]));
paramList.Add(repository.DbFactory.getDataParameter("P_CUIT", DbType.String, r[dt.CUITColumn]));
paramList.Add(repository.DbFactory.getDataParameter("P_IVA", DbType.String, r[dt.IVAColumn]));
paramList.Add(repository.DbFactory.getDataParameter("P_LIV_MOVIDA", DbType.Decimal, r[dt.LIV_MOVIDAColumn]));
paramList.Add(repository.DbFactory.getDataParameter("P_LIV_KM", DbType.Decimal, r[dt.LIV_KMColumn]));
paramList.Add(repository.DbFactory.getDataParameter("P_SP1_MOVIDA", DbType.Decimal, r[dt.SP1_MOVIDAColumn]));
paramList.Add(repository.DbFactory.getDataParameter("P_SP1_KM", DbType.Decimal, r[dt.SP1_KMColumn]));
paramList.Add(repository.DbFactory.getDataParameter("P_SP2_MOVIDA", DbType.Decimal, r[dt.SP2_MOVIDAColumn]));
paramList.Add(repository.DbFactory.getDataParameter("P_SP2_KM", DbType.Decimal, r[dt.SP2_KMColumn]));
paramList.Add(repository.DbFactory.getDataParameter("P_PS1_MOVIDA", DbType.Decimal, r[dt.PS1_MOVIDAColumn]));
paramList.Add(repository.DbFactory.getDataParameter("P_PS1_KM", DbType.Decimal, r[dt.PS1_KMColumn]));
paramList.Add(repository.DbFactory.getDataParameter("P_PS2_MOVIDA", DbType.Decimal, r[dt.PS2_MOVIDAColumn]));
paramList.Add(repository.DbFactory.getDataParameter("P_PS2_KM", DbType.Decimal, r[dt.PS2_KMColumn]));
result = repository.ExecuteUpdateProcedure(CONST_UPDATE_PROCEDURE_NAME, paramList, r[dt.OBJECTHASHColumn].ToString()) == 1;
}
catch (Exception ex)
{
throw ex;
}
return(result);
}
public override System.Data.DataTable getMyTable()
{
DataTable dt = null;
dt = new Datasets.Prestadores.PRESTADORESDataTable();
return dt;
}
public override int Create(System.Data.DataRow r)
{
int result = 0;
try
{
DBRepository repository = DBRepository.GetDbRepository();
List <IDbDataParameter> paramList = new List <IDbDataParameter>();
Datasets.Prestadores.PRESTADORESDataTable dt = (Datasets.Prestadores.PRESTADORESDataTable)r.Table;
/*
* P_ID OUT PRESTADORES.idPRESTADOR%TYPE,
* P_NOMBRE IN PRESTADORES.nombre%TYPE,
* P_DESCRIPCION IN PRESTADORES.descripcion%TYPE,
* P_ESTADO IN PRESTADORES.estado%TYPE,
* P_OBJECTHASH IN PRESTADORES.objecthash%TYPE,
* P_TELEFONO1 IN PRESTADORES.TELEFONO1%TYPE,
* P_TELEFONO2 IN PRESTADORES.TELEFONO2%TYPE,
* P_CELULAR1 IN PRESTADORES.CELULAR1%TYPE,
* P_CELULAR2 IN PRESTADORES.CELULAR2%TYPE,
* P_NEXTEL IN PRESTADORES.NEXTEL%TYPE,
* P_DOMICILIO IN PRESTADORES.DOMICILIO%TYPE,
* P_IDCIUDAD IN PRESTADORES.IDCIUDAD%TYPE,
* P_IDPROVINCIA IN PRESTADORES.IDPROVINCIA%TYPE,
* P_IDPAIS IN PRESTADORES.IDPAIS%TYPE,
* P_EMAIL IN PRESTADORES.EMAIL%TYPE,
* P_CUIT IN PRESTADORES.CUIT%TYPE,
* P_IVA IN PRESTADORES.IVA%TYPE,
* P_LIV_MOVIDA IN PRESTADORES.LIV_MOVIDA%TYPE,
* P_LIV_KM IN PRESTADORES.LIV_KM%TYPE,
* P_SP1_MOVIDA IN PRESTADORES.SP1_MOVIDA%TYPE,
* P_SP1_KM IN PRESTADORES.SP1_KM%TYPE,
* P_SP2_MOVIDA IN PRESTADORES.SP2_MOVIDA%TYPE,
* P_SP2_KM IN PRESTADORES.SP2_KM%TYPE,
* P_PS1_MOVIDA IN PRESTADORES.PS1_MOVIDA%TYPE,
* P_PS1_KM IN PRESTADORES.PS1_KM%TYPE,
* P_PS2_MOVIDA IN PRESTADORES.PS2_MOVIDA%TYPE,
* P_PS2_KM IN PRESTADORES.PS2_KM%TYPE
*
*
*/
paramList.Add(repository.DbFactory.getDataParameter("P_NOMBRE", DbType.String, r[dt.NOMBREColumn]));
paramList.Add(repository.DbFactory.getDataParameter("P_DESCRIPCION", DbType.String, r[dt.DESCRIPCIONColumn]));
paramList.Add(repository.DbFactory.getDataParameter("P_ESTADO", DbType.Int32, Int32.Parse(r[dt.ESTADOColumn].ToString())));
paramList.Add(repository.DbFactory.getDataParameter("P_TELEFONO1", DbType.String, r[dt.TELEFONO1Column]));
paramList.Add(repository.DbFactory.getDataParameter("P_TELEFONO2", DbType.String, r[dt.TELEFONO2Column]));
paramList.Add(repository.DbFactory.getDataParameter("P_CELULAR1", DbType.String, r[dt.CELULAR1Column]));
paramList.Add(repository.DbFactory.getDataParameter("P_CELULAR2", DbType.String, r[dt.CELULAR2Column]));
paramList.Add(repository.DbFactory.getDataParameter("P_NEXTEL", DbType.String, r[dt.NEXTELColumn]));
paramList.Add(repository.DbFactory.getDataParameter("P_DOMICILIO", DbType.String, r[dt.DOMICILIOColumn]));
paramList.Add(repository.DbFactory.getDataParameter("P_IDCIUDAD", DbType.Int32, Int32.Parse(r[dt.IDCIUDADColumn].ToString())));
paramList.Add(repository.DbFactory.getDataParameter("P_IDPROVINCIA", DbType.Int32, Int32.Parse(r[dt.IDPROVINCIAColumn].ToString())));
paramList.Add(repository.DbFactory.getDataParameter("P_IDPAIS", DbType.Int32, Int32.Parse(r[dt.IDPAISColumn].ToString())));
paramList.Add(repository.DbFactory.getDataParameter("p_IDLOCALIDAD", DbType.Int32, Int32.Parse(r[dt.IDLOCALIDADColumn].ToString())));
paramList.Add(repository.DbFactory.getDataParameter("P_EMAIL", DbType.String, r[dt.EMAILColumn]));
paramList.Add(repository.DbFactory.getDataParameter("P_CUIT", DbType.String, r[dt.CUITColumn]));
paramList.Add(repository.DbFactory.getDataParameter("P_IVA", DbType.String, r[dt.IVAColumn]));
paramList.Add(repository.DbFactory.getDataParameter("P_LIV_MOVIDA", DbType.Decimal, r[dt.LIV_MOVIDAColumn]));
paramList.Add(repository.DbFactory.getDataParameter("P_LIV_KM", DbType.Decimal, r[dt.LIV_KMColumn]));
paramList.Add(repository.DbFactory.getDataParameter("P_SP1_MOVIDA", DbType.Decimal, r[dt.SP1_MOVIDAColumn]));
paramList.Add(repository.DbFactory.getDataParameter("P_SP1_KM", DbType.Decimal, r[dt.SP1_KMColumn]));
paramList.Add(repository.DbFactory.getDataParameter("P_SP2_MOVIDA", DbType.Decimal, r[dt.SP2_MOVIDAColumn]));
paramList.Add(repository.DbFactory.getDataParameter("P_SP2_KM", DbType.Decimal, r[dt.SP2_KMColumn]));
paramList.Add(repository.DbFactory.getDataParameter("P_PS1_MOVIDA", DbType.Decimal, r[dt.PS1_MOVIDAColumn]));
paramList.Add(repository.DbFactory.getDataParameter("P_PS1_KM", DbType.Decimal, r[dt.PS1_KMColumn]));
paramList.Add(repository.DbFactory.getDataParameter("P_PS2_MOVIDA", DbType.Decimal, r[dt.PS2_MOVIDAColumn]));
paramList.Add(repository.DbFactory.getDataParameter("P_PS2_KM", DbType.Decimal, r[dt.PS2_KMColumn]));
result = repository.ExecuteCreateProcedure(CONST_CREATE_PROCEDURE_NAME, paramList, r[dt.OBJECTHASHColumn].ToString());
}
catch (Exception ex)
{
throw ex;
}
return(result);
}
