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