public ActionResult UNOfficialBook(ManageViewModel mine, int id = 0)
{
BookstoreContext dba = new BookstoreContext();
OfficialPosting tmp = (from ec in dba.OfficialPostings
where ec.PostingID == id
select ec).FirstOrDefault();
try
{
if (tmp != null)
{
dba.OfficialPostings.Remove(tmp);
}
dba.SaveChanges();
}
catch (Exception e)
{
}
//Add Audit
var userIds = WebSecurity.GetUserId(User.Identity.Name);
var postId = id;
AuditController.AuditEntry(userIds, postId, AuditController.REMOVEOFFICIAL);
return RedirectToAction("Index", "manage", mine);
}
public ActionResult OfficialBook(ManageViewModel mine, int id = 0)
{
BookstoreContext dba = new BookstoreContext();
if (ModelState.IsValid)
{
try
{
if (mine.isOfficial)
{
mine.Officialpostings.PostingID = id;
dba.OfficialPostings.Add(mine.Officialpostings);
}
dba.SaveChanges();
}
catch (DbEntityValidationException e)
{
//display all the validation error on the postingview model
foreach (var eve in e.EntityValidationErrors)
{
Console.WriteLine("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:",
eve.Entry.Entity.GetType().Name, eve.Entry.State);
foreach (var ve in eve.ValidationErrors)
{
Console.WriteLine("- Property: \"{0}\", Error: \"{1}\"",
ve.PropertyName, ve.ErrorMessage);
}
}
}
//Add Audit
var userIds = WebSecurity.GetUserId(User.Identity.Name);
var postId = id;
AuditController.AuditEntry(userIds, postId, AuditController.CREATEOFFICIAL);
return RedirectToAction("Index", "manage", mine );
}
return View(mine.postings.ToPostingViewModel());
}
public ActionResult Manage(ManageViewModel mine)
{
BookstoreContext dba = new BookstoreContext();
//Get infor for posting adn set it
var userId = WebSecurity.GetUserId(User.Identity.Name);
mine.InstitutionID = GetInstituion(User.Identity.Name);
if (mine == null)
{
mine = new ManageViewModel();
}
List<Posting> postings = null;
postings = (from ec in dba.Postings
where ec.Institution_ID == mine.InstitutionID && ec.UserID == userId
select ec).ToList<Posting>();
if (postings == null)
{
postings = new List<Posting>();
}
//set the value foreach of the postings
foreach (Posting ec in postings)
{
ec.UserID = dba.Postings.Where(e => e.PostingID == ec.PostingID).FirstOrDefault().UserID;
ec.PostTitle = dba.Postings.Where(e => e.PostingID == ec.PostingID).FirstOrDefault().PostTitle;
ec.PostDescription = dba.Postings.Where(e => e.PostingID == ec.PostingID).FirstOrDefault().PostDescription;
ec.price = dba.Postings.Where(e => e.PostingID == ec.PostingID).FirstOrDefault().price;
ec.author = dba.Postings.Where(e => e.PostingID == ec.PostingID).FirstOrDefault().author;
ec.BookTitle = dba.Postings.Where(e => e.PostingID == ec.PostingID).FirstOrDefault().BookTitle;
ec.PostingID = dba.Postings.Where(e => e.PostingID == ec.PostingID).FirstOrDefault().PostingID;
ec.Posting_Date = dba.Postings.Where(e => e.PostingID == ec.PostingID).FirstOrDefault().Posting_Date;
ec.Institution_ID = dba.Postings.Where(e => e.PostingID == ec.PostingID).FirstOrDefault().Institution_ID;
}
var postingViewModels = postings.Select(post => post.ToOfficialPostingViewModel()).ToList();
mine.AllPostings = postingViewModels;
return View(mine);
}
public ActionResult OfficialBook(int id = 0)
{
BookstoreContext dba = new BookstoreContext();
Posting post = dba.Postings.Find(id);
if (post == null)
{
post = new Posting();
}
var manageViewModel = new ManageViewModel();
manageViewModel.postings = post;
return View(manageViewModel);
}
public ActionResult Index(string booktitle, string author, ManageViewModel mine)
{
BookstoreContext dba = new BookstoreContext();
//Get infor for posting adn set it
var userId = WebSecurity.GetUserId(User.Identity.Name);
//get institution from email.
mine.InstitutionID = UserController.GetInstituion(User.Identity.Name);
if (mine == null)
{
mine = new ManageViewModel();
}
List<Posting> postings = null;
//get list of all posting from an instituiton for the admin
if (User.IsInRole("admin"))
{
if ((!String.IsNullOrEmpty(booktitle)) && (!String.IsNullOrEmpty(author)))
{
postings = (from ec in dba.Postings
where ec.BookTitle.Contains(booktitle) && ec.author.Contains(author) && ec.Institution_ID == mine.InstitutionID && DateTime.Compare((DateTime)ec.ExpiryDate, DateTime.Today) > 0
select ec).ToList<Posting>();
}
else if ((String.IsNullOrEmpty(booktitle)) && (!String.IsNullOrEmpty(author)) )
{
postings = (from ec in dba.Postings
where ec.author.Contains(author) && ec.Institution_ID == mine.InstitutionID && DateTime.Compare((DateTime)ec.ExpiryDate, DateTime.Today) > 0
select ec).ToList<Posting>();
}
else if ((!String.IsNullOrEmpty(booktitle)) && (String.IsNullOrEmpty(author)))
{
postings = (from ec in dba.Postings
where ec.BookTitle.Contains(booktitle) && ec.Institution_ID == mine.InstitutionID && DateTime.Compare((DateTime)ec.ExpiryDate, DateTime.Today) > 0
select ec).ToList<Posting>();
}
else if ((String.IsNullOrEmpty(booktitle)) && (String.IsNullOrEmpty(author)))
{
postings = (from ec in dba.Postings
where ec.Institution_ID == mine.InstitutionID && DateTime.Compare((DateTime)ec.ExpiryDate, DateTime.Today) > 0
select ec).ToList<Posting>();
}
}
if (postings == null)
{
postings = new List<Posting>();
}
//set the value foreach of the postings
foreach (Posting ec in postings)
{
ec.UserID = dba.Postings.Where(e => e.PostingID == ec.PostingID).FirstOrDefault().UserID;
ec.PostTitle = dba.Postings.Where(e => e.PostingID == ec.PostingID).FirstOrDefault().PostTitle;
ec.PostDescription = dba.Postings.Where(e => e.PostingID == ec.PostingID).FirstOrDefault().PostDescription;
ec.price = dba.Postings.Where(e => e.PostingID == ec.PostingID).FirstOrDefault().price;
ec.author = dba.Postings.Where(e => e.PostingID == ec.PostingID).FirstOrDefault().author;
ec.BookTitle = dba.Postings.Where(e => e.PostingID == ec.PostingID).FirstOrDefault().BookTitle;
ec.PostingID = dba.Postings.Where(e => e.PostingID == ec.PostingID).FirstOrDefault().PostingID;
ec.Posting_Date = dba.Postings.Where(e => e.PostingID == ec.PostingID).FirstOrDefault().Posting_Date;
ec.Institution_ID = dba.Postings.Where(e => e.PostingID == ec.PostingID).FirstOrDefault().Institution_ID;
}
var postingViewModels = postings.Select(post => post.ToOfficialPostingViewModel()).ToList();
mine.AllPostings = postingViewModels;
// List<OfficialPosting> Opostings = null;
return View(mine);
}
