public HttpResponseMessage AddUserRate(Entities.MstUserRate objUserRate)
        {
            try
            {
                var currentUser = from d in db.MstUsers
                                  where d.AspNetUserId == User.Identity.GetUserId()
                                  select d;

                var currentUserId = currentUser.FirstOrDefault().Id;

                Data.MstUserRate newUserRate = new Data.MstUserRate
                {
                    UserId = currentUserId,
                    ModalityProcedureId   = objUserRate.ModalityProcedureId,
                    ModalityProcedureCode = objUserRate.ModalityProcedureCode,
                    FacilityRate          = objUserRate.FacilityRate,
                    DoctorRate            = objUserRate.DoctorRate,
                    ImageRate             = objUserRate.ImageRate,
                    Remarks = objUserRate.Remarks
                };

                db.MstUserRates.InsertOnSubmit(newUserRate);
                db.SubmitChanges();

                return(Request.CreateResponse(HttpStatusCode.OK));
            }
            catch (Exception e)
            {
                Debug.WriteLine(e);
                return(Request.CreateResponse(HttpStatusCode.InternalServerError));
            }
        }
        public HttpResponseMessage UpdateUserRate(String id, Entities.MstUserRate objUserRate)
        {
            try
            {
                var userRate = from d in db.MstUserRates
                               where d.Id == Convert.ToInt32(id)
                               select d;

                if (userRate.Any())
                {
                    var currentUser = from d in db.MstUsers
                                      where d.AspNetUserId == User.Identity.GetUserId()
                                      select d;

                    var currentUserId = currentUser.FirstOrDefault().Id;

                    var updateUserRate = userRate.FirstOrDefault();
                    updateUserRate.UserId = currentUserId;
                    updateUserRate.ModalityProcedureId   = objUserRate.ModalityProcedureId;
                    updateUserRate.ModalityProcedureCode = objUserRate.ModalityProcedureCode;
                    updateUserRate.FacilityRate          = objUserRate.FacilityRate;
                    updateUserRate.DoctorRate            = objUserRate.DoctorRate;
                    updateUserRate.ImageRate             = objUserRate.ImageRate;
                    updateUserRate.Remarks = objUserRate.Remarks;

                    db.SubmitChanges();

                    return(Request.CreateResponse(HttpStatusCode.OK));
                }
                else
                {
                    return(Request.CreateResponse(HttpStatusCode.NotFound));
                }
            }
            catch (Exception e)
            {
                Debug.WriteLine(e);
                return(Request.CreateResponse(HttpStatusCode.InternalServerError));
            }
        }