public HttpResponseMessage AddTrnBorrow(ApiModels.TrnBorrow objTrnBorrow) { try { Data.TrnBorrow newTrnBorrow = new Data.TrnBorrow { Id = objTrnBorrow.Id, BorrowNumber = objTrnBorrow.BookNumber, BookNumber = objTrnBorrow.BookNumber, BorrowDate = objTrnBorrow.BorrowDate, ManualBorrowNumber = objTrnBorrow.ManualBorrowNumber, BorrowerId = objTrnBorrow.BorrowerId, LibraryCardId = objTrnBorrow.LibraryCardId, PreparedByUser = objTrnBorrow.PreparedByUser, CreatedByUserId = objTrnBorrow.CreatedByUserId, CreatedDate = objTrnBorrow.CreatedDate, UpdatedByUserId = objTrnBorrow.UpdatedByUserId, UpdatedDate = objTrnBorrow.UpdatedDate }; db.TrnBorrows.InsertOnSubmit(newTrnBorrow); db.SubmitChanges(); return(Request.CreateResponse(HttpStatusCode.OK)); } catch (Exception e) { return(Request.CreateResponse(HttpStatusCode.InternalServerError, e.Message)); } }
public HttpResponseMessage UpdateTrnBorrow(ApiModels.TrnBorrow objTrnBorrow, String Id) { try { var trnBorrow = from d in db.TrnBorrows where d.Id == Convert.ToInt32(Id) select d; if (trnBorrow.Any()) { var updatetrnBorrow = trnBorrow.FirstOrDefault(); updatetrnBorrow.Id = objTrnBorrow.Id; updatetrnBorrow.BorrowNumber = objTrnBorrow.BookNumber; updatetrnBorrow.BookNumber = objTrnBorrow.BookNumber; updatetrnBorrow.BorrowDate = objTrnBorrow.BorrowDate; updatetrnBorrow.ManualBorrowNumber = objTrnBorrow.ManualBorrowNumber; updatetrnBorrow.BorrowerId = objTrnBorrow.BorrowerId; updatetrnBorrow.LibraryCardId = objTrnBorrow.LibraryCardId; updatetrnBorrow.PreparedByUser = objTrnBorrow.PreparedByUser; updatetrnBorrow.CreatedByUserId = objTrnBorrow.CreatedByUserId; updatetrnBorrow.CreatedDate = objTrnBorrow.CreatedDate; updatetrnBorrow.UpdatedByUserId = objTrnBorrow.UpdatedByUserId; updatetrnBorrow.UpdatedDate = objTrnBorrow.UpdatedDate; db.SubmitChanges(); return(Request.CreateResponse(HttpStatusCode.OK)); } else { return(Request.CreateResponse(HttpStatusCode.BadRequest, "trnBorrow not found!")); } } catch (Exception e) { return(Request.CreateResponse(HttpStatusCode.InternalServerError, e.Message)); } }