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."));
}
}
