public void IncreaseBookCountAvailability(BorrowedBy borrowedBy)
{
var books = db.Books.Find(borrowedBy.BookId);
books.AvailableCount += 1;
books.BorrowedCount -= 1;
db.SaveChanges();
}
public ActionResult Create([Bind(Include = "Id,Name,Specification")] Author author)
{
if (ModelState.IsValid)
{
db.Authors.Add(author);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(author));
}
public ActionResult Create([Bind(Include = "ID,TransactionStatus,transactionDate,dueDate,BookID")] Transaction transaction)
{
if (ModelState.IsValid)
{
db.Transactions.Add(transaction);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(transaction));
}
public ActionResult Create([Bind(Include = "bookID,transactionID,bookTitle,author,loanStatus")] Book book)
{
if (ModelState.IsValid)
{
bookDataGateway.Insert(book);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(book));
}
public ActionResult Create([Bind(Include = "Id,AddressLine1,AddressLine2,City,State,Country,Pincode")] Address address)
{
if (ModelState.IsValid)
{
db.Addresses.Add(address);
db.SaveChanges();
return RedirectToAction("Index");
}
return View(address);
}
public ActionResult Create([Bind(Include = "Id,Name,AddressId")] Publisher publisher)
{
if (ModelState.IsValid)
{
db.Publishers.Add(publisher);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.AddressId = new SelectList(db.Addresses, "Id", "AddressLine1", publisher.AddressId);
return(View(publisher));
}
public ActionResult Create([Bind(Include = "Id,TypeOfMembership,IsStudent,ExpiryDate,UserId")] Member member)
{
if (ModelState.IsValid)
{
db.Members.Add(member);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.UserId = new SelectList(db.Users, "Id", "Name", member.UserId);
return(View(member));
}
public ActionResult Create([Bind(Include = "Id,Title,AuthorId,PublisherId,TotalCount,AvailableCount,BorrowedCount")] Book book)
{
if (ModelState.IsValid)
{
db.Books.Add(book);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.AuthorId = new SelectList(db.Authors, "Id", "Name", book.AuthorId);
ViewBag.PublisherId = new SelectList(db.Publishers, "Id", "Name", book.PublisherId);
return(View(book));
}
public ActionResult Create([Bind(Include = "Id,Name,MobileNumber,AddressId,IsActive,LoginDetailId")] User user)
{
if (ModelState.IsValid)
{
db.Users.Add(user);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.AddressId = new SelectList(db.Addresses, "Id", "AddressLine1", user.AddressId);
ViewBag.LoginDetailId = new SelectList(db.LoginDetails, "Id", "LoginName", user.LoginDetailId);
return(View(user));
}
public ActionResult Create(RegisteredPerson collection)
{
try
{
// TODO: Add insert logic here
_context.Person.Add(collection);
_context.SaveChanges();
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
public ActionResult Create(BookCategory collection)
{
try
{
// TODO: Add insert logic here
_context.BookCategory.Add(collection);
_context.SaveChanges();
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
public ActionResult Create(Book collection)
{
try
{
// TODO: Add insert logic here
collection.NumberOfBooksIsBorrowed = 0;
_context.Books.Add(collection);
_context.SaveChanges();
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
public ActionResult DeleteConfirm(int?id)
{
using (LibraryManagementContext db = new LibraryManagementContext())
{
Models.Book book = db.Books.Find(id);
db.Books.Remove(book);
db.SaveChanges();
return(RedirectToAction("Index"));
}
}
public ActionResult DeleteConfirm(int?id)
{
using (LibraryManagementContext db = new LibraryManagementContext())
{
User user = db.Users.Find(id);
db.Users.Remove(user);
db.SaveChanges();
return(RedirectToAction("Index"));
}
}
public ActionResult Create(BookBorrow collection)
{
try
{
// TODO: Add insert logic here
collection.BorrowDate = DateTime.Today;
collection.ReturnDate = "--";
_context.Borrow.Add(collection);
_context.SaveChanges();
int BookId = _context.Books.FirstOrDefault(x => x.BookName == collection.BookName).Id;
Book Book = _context.Books.Find(BookId);
Book.NumberOfBooksIsBorrowed += 1;
_context.Entry(Book).State = System.Data.Entity.EntityState.Modified;
_context.SaveChanges();
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
public ActionResult Edit(User user)
{
if (ModelState.IsValid)
{
using (LibraryManagementContext db = new LibraryManagementContext())
{
db.Entry(user).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
}
return(View(user));
}
public ActionResult Create(User user)
{
using (LibraryManagementContext db = new LibraryManagementContext())
{
if (ModelState.IsValid)
{
db.Users.Add(user);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(user));
}
}
public ActionResult Create([Bind(Include = "Id,IssueDate,ReturnDate,IsReturned,MemberId,BookId")] BorrowedBy borrowedBy)
{
try
{
if (ModelState.IsValid)
{
db.borrowedBies.Add(borrowedBy);
db.SaveChanges();
var createBorrowedBy = new CreateBorrowedBy();
createBorrowedBy.ReduceBookCountAvailability(borrowedBy);
return(RedirectToAction("Index"));
}
ViewBag.BookId = new SelectList(db.Books, "Id", "Title", borrowedBy.BookId);
ViewBag.MemberId = new SelectList(db.Members, "Id", "Id", borrowedBy.MemberId);
return(View(borrowedBy));
}
catch (Exception ex)
{
return(View("Error", new HandleErrorInfo(ex, "BorrowedBy", "Create")));
}
}
public ActionResult CreateLogin([Bind(Include = "Id,LoginName,Password,IsActive,TypeofUser")] LoginDetail logindetail)
{
bool ErrorFlag = false;
if (ModelState.IsValid)
{
db.LoginDetails.Add(logindetail);
int NumCount = 0;
int splCharCount = 0;
int Uppercase = 0;
int Lowercase = 0;
foreach (char c in logindetail.Password)
{
if (Regex.IsMatch(c.ToString(), @"[A-Z]"))
{
Uppercase++;
}
if (Regex.IsMatch(c.ToString(), @"[a-z]"))
{
Lowercase++;
}
if (Regex.IsMatch(c.ToString(), @"[0-9]"))
{
NumCount++;
}
if (Regex.IsMatch(c.ToString(), @"[^a-zA-Z0-9]"))
{
splCharCount++;
}
}
if (logindetail.Password.Length < 4 || Uppercase < 1 || Lowercase < 1 || NumCount < 1 || splCharCount < 1)
{
ErrorFlag = true;
ModelState.AddModelError("Password", "Passwords must be at least 4 characters and contain the following: upper case (A - Z), lower case (a - z), number(0 - 9) and special character(e.g. !@#$%^&*)");
}
if (!ErrorFlag)
{
db.SaveChanges();
}
else
{
return(View(logindetail));
}
return(RedirectToAction("Login"));
}
return(View(logindetail));
}
public ActionResult PostUser([FromBody] UsersPoco poco)
{
_context.UsersPocos.Add(poco);
_context.SaveChanges();
return(Ok());
}