public void Dequeue(int letter_id) { db_mssql db_mssql = new db_mssql(); Queued deque = (from m in db_mssql.Queueds where m.LetterID == letter_id && m.State == 0 select m).FirstOrDefault(); if (deque != null) { db_mssql.Queueds.Attach(deque); var entry = db_mssql.Entry(deque); entry.Property(e => e.State).IsModified = true; deque.State = 1; db_mssql.SaveChanges(); } }
public Letter PublishQueue() { db_mssql db_mssql = new db_mssql(); db_mysql db_mysql = new db_mysql(); List<Queued> qry = (from m in db_mssql.Queueds where m.State == 0 orderby m.LetterID ascending select m).ToList(); if (qry.Count() == 0) { return null; } Queued latest_unpublished_queued = qry.First(); letter latest_front_page = (from l in db_mysql.letters where l.letterLevel == 1 orderby l.letterPostDate descending select l).First(); letter lucky_letter = (from l in db_mysql.letters where l.Id == latest_unpublished_queued.LetterID select l).FirstOrDefault(); if (lucky_letter == null) { return null; } db_mysql.letters.Attach(lucky_letter); var letter = db_mysql.Entry(lucky_letter); letter.Property(e => e.letterLevel).IsModified = true; lucky_letter.letterLevel = 1; db_mssql.Queueds.Attach(latest_unpublished_queued); var queued = db_mssql.Entry(latest_unpublished_queued); queued.Property(e => e.State).IsModified = true; latest_unpublished_queued.State = 1; db_mysql.SaveChanges(); db_mssql.SaveChanges(); edit new_edit = new edit(); new_edit.editComment = "Published from queue."; new_edit.previousLetter = lucky_letter.letterMessage; new_edit.newLetter = lucky_letter.letterMessage; new_edit.editDate = DateTime.Now; new_edit.letterID = lucky_letter.Id; new_edit.status = "accepted"; new_edit.editor = "auto post"; db_mssql.edits.Add(new_edit); db_mssql.SaveChanges(); return Mapper.Map<letter, Letter>(lucky_letter); }