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