public HttpResponseMessage addLibraryBook(Entities.MtsLibraryBook objLibraryBook)
{
try
{
var currentUserType = from d in db.MstUsers
where d.AspNetUserId == User.Identity.GetUserId()
select d.MstUserType.UserType;
var userType = currentUserType.FirstOrDefault();
if (userType == "Admin")
{
var bookNumber = from d in db.MstLibraryBooks
where d.BookNumber == objLibraryBook.BookNumber
select d.BookNumber;
if (bookNumber.Any())
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, "Book No. already taken!"));
}
else
{
var currentUser = from d in db.MstUsers
where d.AspNetUserId == User.Identity.GetUserId()
select d;
Data.MstLibraryBook newLibraryBook = new Data.MstLibraryBook
{
BookNumber = objLibraryBook.BookNumber,
Title = objLibraryBook.Title,
Author = objLibraryBook.Author,
EditionNumber = objLibraryBook.EditionNumber,
PlaceOfPublication = objLibraryBook.PlaceOfPublication,
CopyRightDate = Convert.ToDateTime(objLibraryBook.CopyRightDate),
ISBN = objLibraryBook.ISBN,
CreatedByUserId = currentUser.FirstOrDefault().Id,
CreatedBy = currentUser.FirstOrDefault().FirstName,
CreatedDate = DateTime.Now,
UpdatedByUserId = currentUser.FirstOrDefault().Id,
UpdatedBy = currentUser.FirstOrDefault().FirstName,
UpdatedDate = DateTime.Now,
};
db.MstLibraryBooks.InsertOnSubmit(newLibraryBook);
db.SubmitChanges();
return(Request.CreateResponse(HttpStatusCode.OK));
}
}
else
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, "Sorry. You're not authorize!"));
}
}
catch (Exception e)
{
Debug.WriteLine(e);
return(Request.CreateResponse(HttpStatusCode.InternalServerError, "Something's went wrong from the server."));
}
}
public HttpResponseMessage UpdateBook(Entities.MtsLibraryBook objUpdateBook, String id)
{
try
{
var currentBook = from d in db.MstLibraryBooks
where d.Id == Convert.ToInt32(id)
select d;
if (currentBook.Any())
{
var currentUser = from d in db.MstUsers
where d.AspNetUserId == User.Identity.GetUserId()
select d;
var updateBook = currentBook.FirstOrDefault();
updateBook.BookNumber = objUpdateBook.BookNumber;
updateBook.Title = objUpdateBook.Title;
updateBook.Author = objUpdateBook.Author;
updateBook.EditionNumber = objUpdateBook.EditionNumber;
updateBook.PlaceOfPublication = objUpdateBook.PlaceOfPublication;
updateBook.CopyRightDate = Convert.ToDateTime(objUpdateBook.CopyRightDate);
updateBook.ISBN = objUpdateBook.ISBN;
updateBook.UpdatedByUserId = currentUser.FirstOrDefault().Id;
updateBook.UpdatedBy = currentUser.FirstOrDefault().FirstName;
updateBook.UpdatedDate = DateTime.Now;
db.SubmitChanges();
return(Request.CreateResponse(HttpStatusCode.OK));
}
else
{
return(Request.CreateResponse(HttpStatusCode.NotFound));
}
}
catch (Exception e)
{
Debug.WriteLine(e);
return(Request.CreateResponse(HttpStatusCode.InternalServerError));
}
}
