public HttpResponseMessage AddLibraryBook(ApiModels.MstLibraryBookModel objLibraryBook) { try { Data.MstLibraryBook newLibraryBook = new Data.MstLibraryBook { BookNumber = objLibraryBook.BookNumber, Title = objLibraryBook.Title, Author = objLibraryBook.Author, EditionNumber = objLibraryBook.EditionNumber, PlaceOfPublication = objLibraryBook.PlaceOfPublication, CopyRightDate = objLibraryBook.CopyRightDate, ISBN = objLibraryBook.ISBN, CreatedByUserId = objLibraryBook.CreatedByUserId, CreatedBy = objLibraryBook.CreatedBy, CreatedDate = objLibraryBook.CreatedDate, UpdatedByUserId = objLibraryBook.UpdatedByUserId, UpdatedBy = objLibraryBook.UpdatedBy, UpdatedDate = objLibraryBook.UpdatedDate }; db.MstLibraryBook.InsertOnSubmit(newLibraryBook); db.SubmitChanges(); return(Request.CreateResponse(HttpStatusCode.OK)); } catch (Exception ex) { return(Request.CreateResponse(HttpStatusCode.InternalServerError, ex.Message)); } }
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.")); } }