public HttpResponseMessage AddLibraryBooks(ApiModels.MstLibraryBook objLibraryBooks)
{
try
{
Data.MstLibraryBook newLibraryBooks = new Data.MstLibraryBook
{
Id = objLibraryBooks.Id,
BookNumber = objLibraryBooks.BookNumber,
Title = objLibraryBooks.Title,
Author = objLibraryBooks.Author,
EditionNumber = objLibraryBooks.EditionNumber,
PlaceOfPublication = objLibraryBooks.PlaceOfPublication,
CopyRightDate = objLibraryBooks.CopyRightDate,
ISBN = objLibraryBooks.ISBN,
CreatedByUserId = objLibraryBooks.CreatedByUserId,
CreatedBy = objLibraryBooks.CreatedBy,
CreatedDate = objLibraryBooks.CreatedDate,
UpdatedByUserId = objLibraryBooks.UpdatedByUserId,
UpdatedBy = objLibraryBooks.UpdatedBy,
UpdatedDate = objLibraryBooks.UpdatedDate
};
db.MstLibraryBooks.InsertOnSubmit(newLibraryBooks);
db.SubmitChanges();
return(Request.CreateResponse(HttpStatusCode.OK));
}
catch (Exception e)
{
return(Request.CreateResponse(HttpStatusCode.InternalServerError, e.Message));
}
}
public HttpResponseMessage UpdateLibraryBooks(ApiModels.MstLibraryBook objLibraryBooks, String Id)
{
try
{
var libraryBooks = from d in db.MstLibraryBooks
where d.Id == Convert.ToInt32(Id)
select d;
if (libraryBooks.Any())
{
var updateLibraryBooks = libraryBooks.FirstOrDefault();
updateLibraryBooks.Id = objLibraryBooks.Id;
updateLibraryBooks.BookNumber = objLibraryBooks.BookNumber;
updateLibraryBooks.Title = objLibraryBooks.Title;
updateLibraryBooks.Author = objLibraryBooks.Author;
updateLibraryBooks.EditionNumber = objLibraryBooks.EditionNumber;
updateLibraryBooks.PlaceOfPublication = objLibraryBooks.PlaceOfPublication;
updateLibraryBooks.CopyRightDate = objLibraryBooks.CopyRightDate;
updateLibraryBooks.ISBN = objLibraryBooks.ISBN;
updateLibraryBooks.CreatedByUserId = objLibraryBooks.CreatedByUserId;
updateLibraryBooks.CreatedBy = objLibraryBooks.CreatedBy;
updateLibraryBooks.CreatedDate = objLibraryBooks.CreatedDate;
updateLibraryBooks.UpdatedByUserId = objLibraryBooks.UpdatedByUserId;
updateLibraryBooks.UpdatedBy = objLibraryBooks.UpdatedBy;
updateLibraryBooks.UpdatedDate = objLibraryBooks.UpdatedDate;
db.SubmitChanges();
return(Request.CreateResponse(HttpStatusCode.OK));
}
else
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, "libraryBooks not found!"));
}
}
catch (Exception e)
{
return(Request.CreateResponse(HttpStatusCode.InternalServerError, e.Message));
}
}
