public bool Delete(Photo photo) { bool result = false; Database db = DatabaseFactory.CreateDatabase(Constants.CONNECTIONSTRING); DbConnection connection = db.CreateConnection(); connection.Open(); DbTransaction transaction = connection.BeginTransaction(); try { result = new PhotoDAO().Delete(photo, db, transaction); transaction.Commit(); } catch (System.Exception ex) { transaction.Rollback(); result = false; throw ex; } finally { connection.Close(); } return(result); }
public static List <Photo> SelectAllByContextId(Guid contextId) { return(PhotoDAO.GetAllByFieldValue("ContextId", contextId)); }
public List <Photo> SelectAllByContextSubTypeId(Guid contextId, Guid ContextSubId, Enums.ContextSubType ContextSubTypeId, Enums.PhotoCategory PhotoCategoryId) { return(PhotoDAO.GetAllByFieldValue("ContextId", contextId, "ContextSubId", ContextSubId, ContextSubTypeId, PhotoCategoryId)); }
public List <Photo> SelectAllByPhotoCategoryId(Guid contextId, Enums.PhotoCategory PhotoCategoryId) { return(PhotoDAO.GetAllByFieldValue("ContextId", contextId, PhotoCategoryId)); }
public bool Update(Photo photo) { bool result; Database db = DatabaseFactory.CreateDatabase(Constants.CONNECTIONSTRING); DbConnection connection = db.CreateConnection(); connection.Open(); DbTransaction transaction = connection.BeginTransaction(); try { result = new PhotoDAO().Update(photo, db, transaction); transaction.Commit(); } catch (System.Exception ex) { transaction.Rollback(); result = false; throw ex; } finally { connection.Close(); } return result; }