public static bool Update(Catalogo catalogo, CatalogoEnum tableName) { bool Result = false; try { var Query = CatalogoQuerys.Update(catalogo, tableName.ToString()); Result = Commands.ExecuteNonQuery(Query); } catch (Exception ex) { ExceptionUtility.LogError(ex); } return(Result); }
public static Catalogo Create(Catalogo catalogo, CatalogoEnum tableName) { try { var Query = CatalogoQuerys.Create(catalogo, tableName.ToString()); var Result = Convert.ToInt32(Commands.ExecuteScalar(Query)); catalogo.Id = Result; } catch (Exception ex) { ExceptionUtility.LogError(ex); } return(catalogo); }
public static bool Delete(int id, CatalogoEnum tableName, bool removePhysical = false) { bool Result = false; try { var Query = CatalogoQuerys.Delete(id, tableName.ToString(), removePhysical); Result = Commands.ExecuteNonQuery(Query); } catch (Exception ex) { ExceptionUtility.LogError(ex); } return(Result); }
public static Catalogo GetById(int id, CatalogoEnum tableName, bool onlyActives = true) { Catalogo Catalogo = null; try { var Query = CatalogoQuerys.GetById(id, tableName.ToString(), onlyActives); var Result = Commands.ExecuteQuery(Query); Catalogo = GetData(Result).First(); } catch (Exception ex) { ExceptionUtility.LogError(ex); } return(Catalogo); }
public static List <Catalogo> GetList(CatalogoEnum tableName, bool onlyActives = true) { List <Catalogo> ListCatalogo = new List <Catalogo>(); try { var Query = CatalogoQuerys.GetList(tableName.ToString(), onlyActives); var Result = Commands.ExecuteQuery(Query); ListCatalogo = GetData(Result); } catch (Exception ex) { ExceptionUtility.LogError(ex); } return(ListCatalogo); }