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));
}
}
public HttpResponseMessage UpdateLibraryBook(ApiModels.MstLibraryBookModel objLibraryBook, String id)
{
try
{
var libbooks = from d in db.MstLibraryBook
where d.Id == Convert.ToInt32(id)
select d;
if (libbooks.Any())
{
var updateLibraryBook = libbooks.FirstOrDefault();
updateLibraryBook.BookNumber = objLibraryBook.BookNumber;
updateLibraryBook.Title = objLibraryBook.Title;
updateLibraryBook.Author = objLibraryBook.Author;
updateLibraryBook.EditionNumber = objLibraryBook.EditionNumber;
updateLibraryBook.PlaceOfPublication = objLibraryBook.PlaceOfPublication;
updateLibraryBook.CopyRightDate = objLibraryBook.CopyRightDate;
updateLibraryBook.ISBN = objLibraryBook.ISBN;
updateLibraryBook.CreatedByUserId = objLibraryBook.CreatedByUserId;
updateLibraryBook.CreatedBy = objLibraryBook.CreatedBy;
updateLibraryBook.CreatedDate = objLibraryBook.CreatedDate;
updateLibraryBook.UpdatedByUserId = objLibraryBook.UpdatedByUserId;
updateLibraryBook.UpdatedBy = objLibraryBook.UpdatedBy;
updateLibraryBook.UpdatedDate = objLibraryBook.UpdatedDate;
db.SubmitChanges();
return(Request.CreateResponse(HttpStatusCode.OK));
}
else
{
return(Request.CreateResponse(HttpStatusCode.BadRequest));
}
}
catch (Exception ex)
{
return(Request.CreateResponse(HttpStatusCode.InternalServerError, ex.Message));
}
}
