public static string PinLink_Alta(PinLink unPinLink) { String mjeRdo = String.Empty; String sql = "PinLink_A"; Database db = DatabaseFactory.CreateDatabase("DAT_V01"); DbCommand dbCommand = db.GetStoredProcCommand(sql); try { db.AddInParameter(dbCommand, "@nroTarjeta", DbType.Int64, unPinLink.NroTarjeta); db.AddInParameter(dbCommand, "@cuil", DbType.Int64, unPinLink.Cuil); db.AddInParameter(dbCommand, "@idEstadoPin", DbType.Int16, unPinLink.UnTipoEstadoPin.IdEstadoPin); db.AddInParameter(dbCommand, "@oficina", DbType.String, unPinLink.UnAuditoria.IDOficina); db.AddInParameter(dbCommand, "@ip", DbType.String, unPinLink.UnAuditoria.IP); db.AddInParameter(dbCommand, "@usuario", DbType.String, unPinLink.UnAuditoria.Usuario); db.AddInParameter(dbCommand, "@IdPrestador", DbType.Int64, unPinLink.UnPrestador.ID); db.AddInParameter(dbCommand, "@idTipoDocumentoPresentado", DbType.Int16, unPinLink.TipoDocPresentado); db.AddOutParameter(dbCommand, "@mensaje", DbType.String, 300); using (TransactionScope scope = new TransactionScope()) { db.ExecuteNonQuery(dbCommand); scope.Complete(); } mjeRdo = db.GetParameterValue(dbCommand, "@mensaje").ToString(); } catch (DbException sqlErr) { if (((System.Data.SqlClient.SqlException)(sqlErr)).Number >= 50000) { return(((System.Exception)(sqlErr)).Message); } else { throw sqlErr; } } catch (Exception ex) { mjeRdo = ex.Message; throw ex; } finally { db = null; dbCommand.Dispose(); } return(mjeRdo); }
public static List <PinLink> PinLink_Trae(Int64 cuil, Int64 nroTarjeta) { List <PinLink> lista = new List <PinLink>(); String sql = "PinLink_Trae"; Database db = DatabaseFactory.CreateDatabase("DAT_V01"); DbCommand dbCommand = db.GetStoredProcCommand(sql); try{ db.AddInParameter(dbCommand, "@nroTarjeta", DbType.Int64, nroTarjeta); db.AddInParameter(dbCommand, "@cuil", DbType.Int64, cuil); using (IDataReader dr = db.ExecuteReader(dbCommand)) { while (dr.Read()) { PinLink unPinLink = new PinLink(Int64.Parse(dr["nroTarjeta"].ToString()), Int64.Parse(dr["cuil"].ToString()), new TipoEstadoPin(dr["idEstadoPin"].Equals(DBNull.Value) ? 0 : int.Parse(dr["idEstadoPin"].ToString()), dr["descripcionEstadoPin"].ToString()), dr["nombreArchivo"].ToString(), new Entidad_Prest_Comer(dr["IdPrestador"].Equals(DBNull.Value) ? 0 : Int64.Parse(dr["IdPrestador"].ToString()), dr["RazonSocial"].Equals(DBNull.Value) ? string.Empty : dr["RazonSocial"].ToString()), dr["idTipoDocumentoPresentado"].Equals(DBNull.Value) ? Int16.Parse("0") : Int16.Parse(dr["idTipoDocumentoPresentado"].ToString()), dr["codigoAValidar"].Equals(DBNull.Value) ? null: new CodigoPreAprobado(Int64.Parse(dr["cuil"].ToString()), dr["codigoAValidar"].ToString())); if (!dr["idEstadoPin"].Equals(DBNull.Value)) { unPinLink.FechaNovedad = DateTime.Parse(dr["fNovedad"].ToString()); } lista.Add(unPinLink); } } return(lista); }catch (Exception ex) { throw ex; }finally { db = null; dbCommand.Dispose(); lista = null; } }
public static string PinLink_Alta(PinLink unPinLink, CodigoPreAprobado unCodigoPreAprobado) { String mjeRdo = String.Empty; try { using (TransactionScope oTransactionScope = new TransactionScope()) { mjeRdo = PinLinkDAO.PinLink_Alta(unPinLink); if (unCodigoPreAprobado != null) { mjeRdo += CodigoPreAprobacionDAO.Novedades_CodigoPreAprobacion_Modificacion(unCodigoPreAprobado); } oTransactionScope.Complete(); } return(mjeRdo); } catch (Exception ex) { throw ex; } }
public String PinLink_Alta(PinLink unPinLink, CodigoPreAprobado unCodigoPreAprobado) { return(PinLinkNegocio.PinLink_Alta(unPinLink, unCodigoPreAprobado)); }