コード例 #1
0
        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));
            }
        }
コード例 #2
0
        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."));
            }
        }