Exemple #1
0
        public HttpResponseMessage UpdateLibraryCard(ApiModels.MstLibraryCardModel objLibraryCard, String id)
        {
            try
            {
                var libcards = from d in db.MstLibraryCard
                               where d.Id == Convert.ToInt32(id)
                               select d;

                if (libcards.Any())
                {
                    var updateLibraryCard = libcards.FirstOrDefault();
                    updateLibraryCard.LibraryCardNumber       = objLibraryCard.LibraryCardNumber;
                    updateLibraryCard.ManualLibraryCardNumber = objLibraryCard.ManualLibraryCardNumber;
                    updateLibraryCard.BorrowerId            = objLibraryCard.BorrowerId;
                    updateLibraryCard.IsPrinted             = objLibraryCard.IsPrinted;
                    updateLibraryCard.LibraryInChargeUserId = objLibraryCard.LibraryInChargeUserId;
                    updateLibraryCard.FootNote        = objLibraryCard.FootNote;
                    updateLibraryCard.CreatedByUserId = objLibraryCard.CreatedByUserId;
                    updateLibraryCard.CreatedDate     = objLibraryCard.CreatedDate;
                    updateLibraryCard.UpdatedByUserId = objLibraryCard.UpdatedByUserId;
                    updateLibraryCard.UpdatedDate     = objLibraryCard.UpdatedDate;
                    db.SubmitChanges();

                    return(Request.CreateResponse(HttpStatusCode.OK));
                }
                else
                {
                    return(Request.CreateResponse(HttpStatusCode.BadRequest));
                }
            }
            catch (Exception ex)
            {
                return(Request.CreateResponse(HttpStatusCode.InternalServerError, ex.Message));
            }
        }
Exemple #2
0
        public HttpResponseMessage AddLibraryCard(ApiModels.MstLibraryCardModel objLibraryCard)
        {
            try
            {
                Data.MstLibraryCard newLibraryCard = new Data.MstLibraryCard
                {
                    LibraryCardNumber       = objLibraryCard.LibraryCardNumber,
                    ManualLibraryCardNumber = objLibraryCard.ManualLibraryCardNumber,
                    BorrowerId            = objLibraryCard.BorrowerId,
                    IsPrinted             = objLibraryCard.IsPrinted,
                    LibraryInChargeUserId = objLibraryCard.LibraryInChargeUserId,
                    FootNote        = objLibraryCard.FootNote,
                    CreatedByUserId = objLibraryCard.CreatedByUserId,
                    CreatedDate     = objLibraryCard.CreatedDate,
                    UpdatedByUserId = objLibraryCard.UpdatedByUserId,
                    UpdatedDate     = objLibraryCard.UpdatedDate
                };
                db.MstLibraryCard.InsertOnSubmit(newLibraryCard);
                db.SubmitChanges();

                return(Request.CreateResponse(HttpStatusCode.OK));
            }
            catch (Exception ex)
            {
                return(Request.CreateResponse(HttpStatusCode.InternalServerError, ex.Message));
            }
        }