public HttpResponseMessage AddMstBorrower(ApiModels.MstBorrower objBorrower)
        {
            try
            {
                Data.MstBorrower newBorrower = new Data.MstBorrower
                {
                    Id                   = objBorrower.Id,
                    BorrowerNumber       = objBorrower.BorrowerNumber,
                    ManualBorrowerNumber = objBorrower.ManualBorrowerNumber,
                    FullName             = objBorrower.FullName,
                    Department           = objBorrower.Department,
                    Course               = objBorrower.Course,
                    CreatedByUserId      = objBorrower.CreatedByUserId,
                    CreatedDate          = objBorrower.CreatedDate,
                    UpdatedByUserId      = objBorrower.UpdatedByUserId,
                    UpdatedDate          = objBorrower.UpdatedDate,
                    BorrowerTypeId       = objBorrower.BorrowerTypeId,
                    LibraryCardId        = objBorrower.LibraryCardId
                };
                db.MstBorrowers.InsertOnSubmit(newBorrower);
                db.SubmitChanges();

                return(Request.CreateResponse(HttpStatusCode.OK));
            }
            catch (Exception e)
            {
                return(Request.CreateResponse(HttpStatusCode.InternalServerError, e.Message));
            }
        }
        public HttpResponseMessage UpdateBorrower(ApiModels.MstBorrower objBorrower, String Id)
        {
            try
            {
                var Borrower = from d in db.MstBorrowers
                               where d.Id == Convert.ToInt32(Id)
                               select d;

                if (Borrower.Any())
                {
                    var updateBorrower = Borrower.FirstOrDefault();
                    updateBorrower.Id                   = objBorrower.Id;
                    updateBorrower.BorrowerNumber       = objBorrower.BorrowerNumber;
                    updateBorrower.ManualBorrowerNumber = objBorrower.ManualBorrowerNumber;
                    updateBorrower.FullName             = objBorrower.FullName;
                    updateBorrower.Department           = objBorrower.Department;
                    updateBorrower.Course               = objBorrower.Course;
                    updateBorrower.CreatedByUserId      = objBorrower.CreatedByUserId;
                    updateBorrower.CreatedDate          = objBorrower.CreatedDate;
                    updateBorrower.UpdatedByUserId      = objBorrower.UpdatedByUserId;
                    updateBorrower.UpdatedDate          = objBorrower.UpdatedDate;
                    updateBorrower.LibraryCardId        = objBorrower.LibraryCardId;
                    updateBorrower.BorrowerTypeId       = objBorrower.BorrowerTypeId;


                    db.SubmitChanges();

                    return(Request.CreateResponse(HttpStatusCode.OK));
                }
                else
                {
                    return(Request.CreateResponse(HttpStatusCode.BadRequest, "Borrower not found!"));
                }
            }
            catch (Exception e)
            {
                return(Request.CreateResponse(HttpStatusCode.InternalServerError, e.Message));
            }
        }