public IList <SEG_ROL> GetById(SEG_ROL entity) { List <SEG_ROL> roles = new List <SEG_ROL>(); using (var comando = _database.GetStoredProcCommand(string.Format("{0}{1}", ConectionStringRepository.EsquemaName, "p_SEG_ROL_GetById"))) { _database.AddInParameter(comando, "@Id_rol", DbType.Int32, entity.id_rol); using (var lector = _database.ExecuteReader(comando)) { if (lector.Read()) { roles.Add(new SEG_ROL { id_rol = lector.IsDBNull(lector.GetOrdinal("Id_rol")) ? default(int) : lector.GetInt32(lector.GetOrdinal("Id_rol")), rol = lector.IsDBNull(lector.GetOrdinal("rol")) ? default(string) : lector.GetString(lector.GetOrdinal("rol")), descripcion = lector.IsDBNull(lector.GetOrdinal("Descripcion")) ? default(string) : lector.GetString(lector.GetOrdinal("Descripcion")), estado = lector.IsDBNull(lector.GetOrdinal("Estado")) ? default(string) : lector.GetString(lector.GetOrdinal("Estado")), UsuarioCreacion = lector.IsDBNull(lector.GetOrdinal("usuario_registro")) ? default(string) : lector.GetString(lector.GetOrdinal("usuario_registro")), FechaCreacion = lector.IsDBNull(lector.GetOrdinal("fecha_registro")) ? default(DateTime) : lector.GetDateTime(lector.GetOrdinal("fecha_registro")), UsuarioModificacion = lector.IsDBNull(lector.GetOrdinal("usuario_modifica")) ? default(string) : lector.GetString(lector.GetOrdinal("usuario_modifica")), FechaModificacion = lector.IsDBNull(lector.GetOrdinal("fecha_modifica")) ? default(DateTime) : lector.GetDateTime(lector.GetOrdinal("fecha_modifica")) }); } } } return(roles); }
public int Delete(SEG_ROL entity) { int idResult; using (var comando = _database.GetStoredProcCommand(string.Format("{0}{1}", ConectionStringRepository.EsquemaName, "p_SEG_ROL_Delete"))) { _database.AddInParameter(comando, "@id_rol", DbType.Int32, entity.id_rol); _database.AddOutParameter(comando, "@Response", DbType.Int32, 11); _database.ExecuteNonQuery(comando); idResult = Convert.ToInt32(_database.GetParameterValue(comando, "@Response")); } return(idResult); }
public bool Exists(SEG_ROL entity) { bool existe = false; using (var comando = _database.GetStoredProcCommand(string.Format("{0}{1}", ConectionStringRepository.EsquemaName, "p_SEG_ROL_VerifyExists"))) { _database.AddInParameter(comando, "@rol", DbType.String, entity.rol); using (var lector = _database.ExecuteReader(comando)) { if (lector.Read()) { existe = Convert.ToBoolean(lector.GetInt32(0)); } } } return(existe); }
public int Add(SEG_ROL entity) { int id; using (var comando = _database.GetStoredProcCommand(string.Format("{0}{1}", ConectionStringRepository.EsquemaName, "p_SEG_ROL_Insert"))) { _database.AddInParameter(comando, "@rol", DbType.String, entity.rol); _database.AddInParameter(comando, "@descripcion", DbType.String, entity.descripcion); _database.AddInParameter(comando, "@estado", DbType.String, entity.estado); _database.AddInParameter(comando, "@UsuarioCreacion", DbType.String, entity.UsuarioCreacion); _database.AddInParameter(comando, "@fecha_registro", DbType.DateTime, entity.FechaCreacion); _database.AddOutParameter(comando, "@Response", DbType.Int32, 11); _database.ExecuteNonQuery(comando); id = Convert.ToInt32(_database.GetParameterValue(comando, "@Response")); } return(id); }
public IList <SEG_ROL> GetAllFilters(SEG_ROL entity) { throw new NotImplementedException(); }
public int Update(SEG_ROL entity) { return(SEG_ROLRepository.Instancia.Update(entity)); }
public IList <SEG_ROL> GetById(SEG_ROL entity) { return(SEG_ROLRepository.Instancia.GetById(entity)); }
public bool Exists(SEG_ROL entity) { return(SEG_ROLRepository.Instancia.Exists(entity)); }
public int Delete(SEG_ROL entity) { return(SEG_ROLRepository.Instancia.Delete(entity)); }
public int Add(SEG_ROL entity) { return(SEG_ROLRepository.Instancia.Add(entity)); }