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