public AniDB_Review GetReviewUDP(int reviewID) { if (!Login()) { return(null); } enHelperActivityType ev = enHelperActivityType.NoSuchReview; AniDBCommand_GetReview cmd = null; lock (lockAniDBConnections) { cmd = new AniDBCommand_GetReview(); cmd.Init(reviewID); SetWaitingOnResponse(true); ev = cmd.Process(ref soUdp, ref remoteIpEndPoint, curSessionID, new UnicodeEncoding(true, false)); SetWaitingOnResponse(false); } AniDB_Review review = null; if (ev == enHelperActivityType.GotReview && cmd.ReviewInfo != null) { review = RepoFactory.AniDB_Review.GetByReviewID(reviewID); if (review == null) { review = new AniDB_Review(); } review.Populate(cmd.ReviewInfo); RepoFactory.AniDB_Review.Save(review); } return(review); }
public AniDB_Review GetByReviewID(int id) { using (var session = JMMService.SessionFactory.OpenSession()) { AniDB_Review cr = session .CreateCriteria(typeof(AniDB_Review)) .Add(Restrictions.Eq("ReviewID", id)) .UniqueResult <AniDB_Review>(); return(cr); } }
public void Save(AniDB_Review obj) { using (var session = JMMService.SessionFactory.OpenSession()) { // populate the database using (var transaction = session.BeginTransaction()) { session.SaveOrUpdate(obj); transaction.Commit(); } } }
public static void Populate(this AniDB_Review review, Raw_AniDB_Review rawReview) { review.ReviewID = rawReview.ReviewID; review.AuthorID = rawReview.AuthorID; review.RatingAnimation = rawReview.RatingAnimation; review.RatingSound = rawReview.RatingSound; review.RatingStory = rawReview.RatingStory; review.RatingCharacter = rawReview.RatingCharacter; review.RatingValue = rawReview.RatingValue; review.RatingEnjoyment = rawReview.RatingEnjoyment; review.ReviewText = rawReview.ReviewText; }
public void Delete(int id) { using (var session = JMMService.SessionFactory.OpenSession()) { // populate the database using (var transaction = session.BeginTransaction()) { AniDB_Review cr = GetByID(id); if (cr != null) { session.Delete(cr); transaction.Commit(); } } } }