public HttpResponseMessage UpdateLibraryCardDetail(Entities.MstLibraryCard objUpdateLibraryCard, String id) { try { var currentLibraryCardDetail = from d in db.MstLibaryCards where d.Id == Convert.ToInt32(id) select d; if (currentLibraryCardDetail.Any()) { var currentUser = from d in db.MstUsers where d.AspNetUserId == User.Identity.GetUserId() select d; var updateLibraryCard = currentLibraryCardDetail.FirstOrDefault(); updateLibraryCard.IsPrinted = objUpdateLibraryCard.IsPrinted; updateLibraryCard.FootNote = objUpdateLibraryCard.FootNote; updateLibraryCard.UpdatedByUserId = currentUser.FirstOrDefault().Id; updateLibraryCard.UpdatedDate = DateTime.Now; db.SubmitChanges(); return(Request.CreateResponse(HttpStatusCode.OK)); } else { return(Request.CreateResponse(HttpStatusCode.BadRequest, "Library card does not exist!")); } } catch (Exception e) { Debug.WriteLine(e); return(Request.CreateResponse(HttpStatusCode.InternalServerError)); } }
public HttpResponseMessage AddLibraryCard(Entities.MstLibraryCard objLibraryCard) { try { var libraryCard = from d in db.MstLibaryCards where d.Id == objLibraryCard.Id && d.LibraryCardNumber == objLibraryCard.LibraryCardNumber select d; if (libraryCard.Any()) { return(Request.CreateResponse(HttpStatusCode.BadRequest, "Library card already exist!")); } else { var currentUser = from d in db.MstUsers where d.AspNetUserId == User.Identity.GetUserId() select d; Data.MstLibaryCard newLibraryCard = new Data.MstLibaryCard { LibraryCardNumber = objLibraryCard.LibraryCardNumber, ManualLibraryCardNumber = objLibraryCard.ManualLibraryCardNumber, BorrowerId = objLibraryCard.BorrowerId, IsPrinted = objLibraryCard.IsPrinted, LibraryInChargeUserId = currentUser.FirstOrDefault().Id, FootNote = objLibraryCard.FootNote, CreatedByUserId = currentUser.FirstOrDefault().Id, CreatedDate = DateTime.Now, UpdatedByUserId = currentUser.FirstOrDefault().Id, UpdatedDate = DateTime.Now, }; db.MstLibaryCards.InsertOnSubmit(newLibraryCard); db.SubmitChanges(); return(Request.CreateResponse(HttpStatusCode.OK)); } } catch (Exception e) { Debug.WriteLine(e); return(Request.CreateResponse(HttpStatusCode.InternalServerError, "Something's went wrong from the server.")); } }