public HttpResponseMessage updateUserForm(String id, Models.MstUserForm userForm) { try { var userForms = from d in db.MstUserForms where d.Id == Convert.ToInt32(id) select d; if (userForms.Any()) { var updateUserForm = userForms.FirstOrDefault(); updateUserForm.UserId = userForm.UserId; updateUserForm.FormId = userForm.FormId; updateUserForm.CanAdd = userForm.CanAdd; updateUserForm.CanEdit = userForm.CanEdit; updateUserForm.CanDelete = userForm.CanDelete; updateUserForm.CanLock = userForm.CanLock; updateUserForm.CanUnlock = userForm.CanUnlock; updateUserForm.CanPrint = userForm.CanPrint; db.SubmitChanges(); return(Request.CreateResponse(HttpStatusCode.OK)); } else { return(Request.CreateResponse(HttpStatusCode.NotFound)); } } catch { return(Request.CreateResponse(HttpStatusCode.BadRequest)); } }
public HttpResponseMessage UpdateUserForm(String id, Models.MstUserForm objUserForm) { try { var currentUser = from d in db.MstUsers where d.AspNetUserId == User.Identity.GetUserId() select d; if (currentUser.Any()) { if (currentUser.FirstOrDefault().UserTypeId != 3) { var userForm = from d in db.MstUserForms where d.Id == Convert.ToInt32(id) select d; if (userForm.Any()) { var updateCurrentUserForm = userForm.FirstOrDefault(); updateCurrentUserForm.UserId = objUserForm.UserId; updateCurrentUserForm.FormId = objUserForm.FormId; updateCurrentUserForm.CanAdd = objUserForm.CanAdd; updateCurrentUserForm.CanEdit = objUserForm.CanEdit; updateCurrentUserForm.CanUpdate = objUserForm.CanUpdate; updateCurrentUserForm.CanDelete = objUserForm.CanDelete; db.SubmitChanges(); return(Request.CreateResponse(HttpStatusCode.OK)); } else { return(Request.CreateResponse(HttpStatusCode.NotFound, "Sorry. Your user form was not found in the server.")); } } else { return(Request.CreateResponse(HttpStatusCode.BadRequest, "Sorry. You have no rights to update user forms.")); } } else { return(Request.CreateResponse(HttpStatusCode.BadRequest, "Sorry. No current user logged in.")); } } catch (Exception e) { Debug.WriteLine(e); return(Request.CreateResponse(HttpStatusCode.InternalServerError, "Something's went wrong from the server. " + e.Message)); } }
public HttpResponseMessage AddUserForm(Models.MstUserForm objUserForm) { try { var currentUser = from d in db.MstUsers where d.AspNetUserId == User.Identity.GetUserId() select d; if (currentUser.Any()) { if (currentUser.FirstOrDefault().UserTypeId != 3) { Data.MstUserForm newUserForm = new Data.MstUserForm { UserId = objUserForm.UserId, FormId = objUserForm.FormId, CanAdd = objUserForm.CanAdd, CanEdit = objUserForm.CanEdit, CanUpdate = objUserForm.CanUpdate, CanDelete = objUserForm.CanDelete }; db.MstUserForms.InsertOnSubmit(newUserForm); db.SubmitChanges(); return(Request.CreateResponse(HttpStatusCode.OK)); } else { return(Request.CreateResponse(HttpStatusCode.BadRequest, "Sorry. You have no rights to add user forms.")); } } else { return(Request.CreateResponse(HttpStatusCode.BadRequest, "Sorry. No current user logged in.")); } } catch (Exception e) { Debug.WriteLine(e); return(Request.CreateResponse(HttpStatusCode.InternalServerError, "Something's went wrong from the server. " + e.Message)); } }
public Int32 insertUserForm(Models.MstUserForm userForm) { try { Data.MstUserForm newUserForm = new Data.MstUserForm(); newUserForm.UserId = userForm.UserId; newUserForm.FormId = userForm.FormId; newUserForm.CanAdd = userForm.CanAdd; newUserForm.CanEdit = userForm.CanEdit; newUserForm.CanDelete = userForm.CanDelete; newUserForm.CanLock = userForm.CanLock; newUserForm.CanUnlock = userForm.CanUnlock; newUserForm.CanPrint = userForm.CanPrint; db.MstUserForms.InsertOnSubmit(newUserForm); db.SubmitChanges(); return(newUserForm.Id); } catch { return(0); } }