public ActionResult DeleteConfirmed(int id)
{
Book_Publisher book_Publisher = db.Book_Publishers.Find(id);
db.Book_Publishers.Remove(book_Publisher);
db.SaveChanges();
return(RedirectToAction("Index"));
}
// GET: Admin/Book_Publisher/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Book_Publisher book_Publisher = db.Book_Publishers.Find(id);
if (book_Publisher == null)
{
return(HttpNotFound());
}
return(View(book_Publisher));
}
public ActionResult Edit([Bind(Include = "ID,publisherid,Bookid,CreateDate,CreateUserID,UpdateDate,UpdateUserID")] Book_Publisher book_Publisher)
{
if (ModelState.IsValid)
{
User user = Session["AdminLogin"] as User;
book_Publisher.UpdateDate = DateTime.Now;
book_Publisher.UpdateUserID = user.ID;
db.Entry(book_Publisher).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Bookid = new SelectList(db.Books, "ID", "Name", book_Publisher.Bookid);
ViewBag.publisherid = new SelectList(db.Publishers, "ID", "publisherName", book_Publisher.publisherid);
return(View(book_Publisher));
}
// GET: Admin/Book_Publisher/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Book_Publisher book_Publisher = db.Book_Publishers.Find(id);
if (book_Publisher == null)
{
return(HttpNotFound());
}
ViewBag.Bookid = new SelectList(db.Books, "ID", "Name", book_Publisher.Bookid);
ViewBag.publisherid = new SelectList(db.Publishers, "ID", "publisherName", book_Publisher.publisherid);
return(View(book_Publisher));
}
public void BookGive(BookViewModel bookVm, string session)
{
TimeSpan?interval;
DateTime?receivingDate, givingDate;
receivingDate = null;
interval = null;
BookOperation bkO = null;
if (bookVm.PublisherName == null)
{
bkO = (from bo in bookDC.BookOperations
where bo.UserName == session && bo.BookName == bookVm.BookName && bo.ReceivingDate != null
select bo).FirstOrDefault();
}
else
{
bkO = (from bo in bookDC.BookOperations
where bo.UserName == session && bo.BookName == bookVm.BookName
select bo).FirstOrDefault();
}
var authr = (from a in bookDC.Authors
where a.AuthorName == bookVm.AuthorName
select a).FirstOrDefault();
Penalty penalty = new Penalty();
BookOperation BO = new BookOperation();
if (bkO == null)
{
BO.UserName = session;
BO.CategoryName = bookVm.CategoryName;
BO.BookName = bookVm.BookName;
BO.PublisherName = bookVm.PublisherName;
BO.GivingDate = DateTime.Now;
if (!string.IsNullOrEmpty(bookVm.AuthorName))
{
BO.AuthorName = bookVm.AuthorName;
}
else
{
BO.AuthorName = "-";
}
bookDC.BookOperations.Add(BO);
bookDC.SaveChanges();
penalty.BookOperationId = BO.Id;
penalty.PenaltyQuantity = 0;
bookDC.Penalties.Add(penalty);
}
else
{
if (bkO.ReceivingDate == null)
{
BO.UserName = session;
BO.CategoryName = bookVm.CategoryName;
BO.BookName = bookVm.BookName;
BO.PublisherName = bookVm.PublisherName;
BO.GivingDate = DateTime.Now;
BO.ReceivingDate = null;
if (!string.IsNullOrEmpty(bookVm.AuthorName))
{
BO.AuthorName = bookVm.AuthorName;
}
else
{
BO.AuthorName = "-";
}
bookDC.BookOperations.Add(BO);
bookDC.SaveChanges();
penalty.BookOperationId = BO.Id;
penalty.PenaltyQuantity = 0;
bookDC.Penalties.Add(penalty);
}
else
{
receivingDate = bkO.ReceivingDate;
bkO.GivingDate = DateTime.Now;
givingDate = bkO.GivingDate;
interval = givingDate - receivingDate;
foreach (var item in bookDC.Penalties)
{
if (item.BookOperationId == bkO.Id)
{
if (interval.Value.Days <= 7)
{
item.PenaltyQuantity = 0;
}
else
{
item.PenaltyQuantity = (double)interval.Value.Days * 0.50;
break;
}
}
}
}
var bk = (from b in bookDC.Books
where b.BookName == bookVm.BookName
select b).FirstOrDefault();
Book book = new Book();
if (bk == null)
{
book.BookName = bookVm.BookName;
book.CategoryId = (from item in bookDC.Categories
where item.CategoryName == bookVm.CategoryName
select item.CategoryId).FirstOrDefault();
book.BookQuantity = 1;
bookDC.Books.Add(book);
}
else
{
bk.BookQuantity++;
}
Author author = new Author();
if (authr == null)
{
if (bookVm.AuthorName != null)
{
author.AuthorName = bookVm.AuthorName;
bookDC.Authors.Add(author);
Book_Author BA = new Book_Author();
BA.AuthorId = author.AuthorId;
BA.BookId = book.BookId;
bookDC.Book_Author.Add(BA);
}
else
{
if (bkO.GivingDate != null)
{
}
else
{
author.AuthorName = "-";
bookDC.Authors.Add(author);
Book_Author BA = new Book_Author();
BA.AuthorId = author.AuthorId;
BA.BookId = book.BookId;
bookDC.Book_Author.Add(BA);
}
}
}
var publishr = (from p in bookDC.Publishers
where p.PublisherName == bookVm.PublisherName
select p).FirstOrDefault();
Publisher publshr = new Publisher();
if (publishr == null)
{
if (bookVm.PublisherName != null)
{
publshr.PublisherName = bookVm.PublisherName;
bookDC.Publishers.Add(publshr);
Book_Publisher BP = new Book_Publisher();
BP.PublisherId = publshr.PublisherId;
BP.BookId = book.BookId;
bookDC.Book_Publisher.Add(BP);
}
else
{
if (bkO.GivingDate != null)
{
}
else
{
publshr.PublisherName = "-";
bookDC.Publishers.Add(publshr);
Book_Publisher BP = new Book_Publisher();
BP.PublisherId = publshr.PublisherId;
BP.BookId = book.BookId;
bookDC.Book_Publisher.Add(BP);
}
}
}
bookDC.SaveChanges();
}
}