public HttpResponseMessage postMstUserForm(Entities.MstUserForm userForm) { try { Data.MstUserForm newUserForm = new Data.MstUserForm(); newUserForm.FormId = userForm.FormId; newUserForm.UserId = userForm.UserId; newUserForm.CanDelete = userForm.CanDelete; newUserForm.CanAdd = userForm.CanAdd; newUserForm.CanLock = userForm.CanLock; newUserForm.CanUnlock = userForm.CanUnlock; newUserForm.CanPrint = userForm.CanPrint; newUserForm.CanPreview = userForm.CanPreview; newUserForm.CanEdit = userForm.CanEdit; newUserForm.CanTender = userForm.CanTender; newUserForm.CanDiscount = userForm.CanDiscount; newUserForm.CanView = userForm.CanView; newUserForm.CanSplit = userForm.CanSplit; newUserForm.CanCancel = userForm.CanCancel; newUserForm.CanReturn = userForm.CanReturn; db.MstUserForms.InsertOnSubmit(newUserForm); db.SubmitChanges(); return(Request.CreateResponse(HttpStatusCode.OK)); } catch (Exception ex) { Debug.WriteLine(ex); return(Request.CreateResponse(HttpStatusCode.InternalServerError, "Something's went wrong from the server.")); } }
public Int32 postUserForm() { try { Data.MstUserForm newUserForm = new Data.MstUserForm(); newUserForm.FormId = FormId(); newUserForm.UserId = UserId(); newUserForm.CanDelete = false; newUserForm.CanAdd = false; newUserForm.CanLock = false; newUserForm.CanUnlock = false; newUserForm.CanPrint = false; newUserForm.CanPreview = false; newUserForm.CanEdit = false; newUserForm.CanTender = false; newUserForm.CanDiscount = false; newUserForm.CanView = false; newUserForm.CanSplit = false; newUserForm.CanCancel = false; newUserForm.CanReturn = false; db.MstUserForms.InsertOnSubmit(newUserForm); db.SubmitChanges(); return(newUserForm.Id); } catch (Exception e) { return(0); } }
public HttpResponseMessage copyRightsUserForms(String name, String userId) { try { var userForms = from d in db.MstUserForms where d.MstUser.UserName == name select new Models.MstUserForm { Id = d.Id, UserId = d.UserId, User = d.MstUser.FullName, FormId = d.FormId, Form = d.SysForm.FormName, Particulars = d.SysForm.Particulars, CanAdd = d.CanAdd, CanEdit = d.CanEdit, CanDelete = d.CanDelete, CanLock = d.CanLock, CanUnlock = d.CanUnlock, CanPrint = d.CanPrint }; if (userForms.Any()) { var deleteUserForms = from d in db.MstUserForms where d.UserId == Convert.ToInt32(userId) select d; db.MstUserForms.DeleteAllOnSubmit(deleteUserForms.ToList()); db.SubmitChanges(); foreach (var userForm in userForms) { Data.MstUserForm newUserForm = new Data.MstUserForm(); newUserForm.UserId = Convert.ToInt32(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(Request.CreateResponse(HttpStatusCode.OK)); } else { return(Request.CreateResponse(HttpStatusCode.NotFound)); } } catch { return(Request.CreateResponse(HttpStatusCode.BadRequest)); } }
public HttpResponseMessage copyRightsUserForms(String name, String userId) { try { var userForms = from d in db.MstUserForms where d.MstUser.UserName == name select new Models.MstUserForm { Id = d.Id, UserId = d.UserId, User = d.MstUser.FullName, FormId = d.FormId, Form = d.SysForm.FormName, Particulars = d.SysForm.Particulars, CanAdd = d.CanAdd, CanEdit = d.CanEdit, CanDelete = d.CanDelete, CanLock = d.CanLock, CanUnlock = d.CanUnlock, CanPrint = d.CanPrint }; if (userForms.Any()) { var deleteUserForms = from d in db.MstUserForms where d.UserId == Convert.ToInt32(userId) select d; db.MstUserForms.DeleteAllOnSubmit(deleteUserForms.ToList()); db.SubmitChanges(); foreach (var userForm in userForms) { Data.MstUserForm newUserForm = new Data.MstUserForm(); newUserForm.UserId = Convert.ToInt32(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 Request.CreateResponse(HttpStatusCode.OK); } else { return Request.CreateResponse(HttpStatusCode.NotFound); } } catch { return Request.CreateResponse(HttpStatusCode.BadRequest); } }
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); } }
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; } }
public int Post(Models.MstUserForm userForm) { try { Data.MstUserForm newUserForm = new Data.MstUserForm(); newUserForm.FormId = userForm.FormId; newUserForm.UserId = userForm.UserId; newUserForm.CanDelete = userForm.CanDelete; newUserForm.CanAdd = userForm.CanAdd; newUserForm.CanLock = userForm.CanLock; newUserForm.CanUnlock = userForm.CanUnlock; newUserForm.CanPrint = userForm.CanPrint; newUserForm.CanPreview = userForm.CanPreview; newUserForm.CanEdit = userForm.CanEdit; newUserForm.CanTender = userForm.CanTender; newUserForm.CanDiscount = userForm.CanDiscount; newUserForm.CanView = userForm.CanView; newUserForm.CanSplit = userForm.CanSplit; newUserForm.CanCancel = userForm.CanCancel; newUserForm.CanReturn = userForm.CanReturn; db.MstUserForms.InsertOnSubmit(newUserForm); db.SubmitChanges(); return newUserForm.Id; } catch { return 0; } }
public HttpResponseMessage CopyRightsUserForms(String name, String userId) { try { var currentUser = from d in db.MstUsers where d.UserId == User.Identity.GetUserId() select d; if (currentUser.Any()) { var currentUserId = currentUser.FirstOrDefault().Id; var userForms = from d in db.MstUserForms where d.UserId == currentUserId && d.SysForm.FormName.Equals("UserDetail") select d; if (userForms.Any()) { if (userForms.FirstOrDefault().CanAdd) { Boolean canCopy = false; var currentUserName = currentUser.FirstOrDefault().UserName; if (currentUserName.Equals("admin")) { canCopy = true; } else { if (!name.Equals("admin")) { canCopy = true; } } if (canCopy) { var userFormSource = from d in db.MstUserForms where d.MstUser.UserName.Equals(name) //&& d.MstUser.IsLocked == true select d; if (userFormSource.Any()) { String oldObject = "["; var deleteUserForms = from d in db.MstUserForms where d.UserId == Convert.ToInt32(userId) select d; if (deleteUserForms.Any()) { db.MstUserForms.DeleteAllOnSubmit(deleteUserForms.ToList()); Int32 oldObjectCount = 0; foreach (var deleteUserForm in deleteUserForms) { oldObjectCount += 1; if (deleteUserForms.Count() == 1) { oldObject += at.GetObjectString(deleteUserForm); } else { if (oldObjectCount == deleteUserForms.Count()) { oldObject += at.GetObjectString(deleteUserForm); } else { oldObject += at.GetObjectString(deleteUserForm) + ", "; } } } db.SubmitChanges(); } oldObject += "]"; String newObject = "["; Int32 newObjectCount = 0; foreach (var userForm in userFormSource) { newObjectCount += 1; Data.MstUserForm newUserForm = new Data.MstUserForm { UserId = Convert.ToInt32(userId), FormId = userForm.FormId, CanAdd = userForm.CanAdd, CanEdit = userForm.CanEdit, CanDelete = userForm.CanDelete, CanLock = userForm.CanLock, CanUnlock = userForm.CanUnlock, CanCancel = userForm.CanCancel, CanPrint = userForm.CanPrint }; db.MstUserForms.InsertOnSubmit(newUserForm); if (userFormSource.Count() == 1) { newObject += at.GetObjectString(newUserForm); } else { if (newObjectCount == userFormSource.Count()) { newObject += at.GetObjectString(newUserForm); } else { newObject += at.GetObjectString(newUserForm) + ", "; } } } db.SubmitChanges(); newObject += "]"; at.InsertAuditTrail(currentUser.FirstOrDefault().Id, GetType().Name, MethodBase.GetCurrentMethod().Name, oldObject, newObject); return(Request.CreateResponse(HttpStatusCode.OK)); } else { return(Request.CreateResponse(HttpStatusCode.BadRequest, "No user rights found.")); } } else { return(Request.CreateResponse(HttpStatusCode.BadRequest, "No rights.")); } } else { return(Request.CreateResponse(HttpStatusCode.BadRequest, "Sorry. You have no rights to add user form.")); } } else { return(Request.CreateResponse(HttpStatusCode.BadRequest, "Sorry. You have no access for this user page.")); } } else { return(Request.CreateResponse(HttpStatusCode.BadRequest, "Theres no current user logged in.")); } } catch (Exception e) { Debug.WriteLine(e); return(Request.CreateResponse(HttpStatusCode.InternalServerError, "Something's went wrong from the server.")); } }
public HttpResponseMessage AddUserForm(Entities.MstUserForm objUserForm, String userId) { try { var currentUser = from d in db.MstUsers where d.UserId == User.Identity.GetUserId() select d; if (currentUser.Any()) { var currentUserId = currentUser.FirstOrDefault().Id; var userForms = from d in db.MstUserForms where d.UserId == currentUserId && d.SysForm.FormName.Equals("UserDetail") select d; if (userForms.Any()) { if (userForms.FirstOrDefault().CanAdd) { var user = from d in db.MstUsers where d.Id == Convert.ToInt32(userId) select d; if (user.Any()) { if (!user.FirstOrDefault().IsLocked) { Data.MstUserForm newUserForm = new Data.MstUserForm { UserId = Convert.ToInt32(userId), FormId = objUserForm.FormId, CanAdd = objUserForm.CanAdd, CanEdit = objUserForm.CanEdit, CanDelete = objUserForm.CanDelete, CanLock = objUserForm.CanLock, CanUnlock = objUserForm.CanUnlock, CanCancel = objUserForm.CanCancel, CanPrint = objUserForm.CanPrint }; db.MstUserForms.InsertOnSubmit(newUserForm); db.SubmitChanges(); String newObject = at.GetObjectString(newUserForm); at.InsertAuditTrail(currentUser.FirstOrDefault().Id, GetType().Name, MethodBase.GetCurrentMethod().Name, "NA", newObject); return(Request.CreateResponse(HttpStatusCode.OK)); } else { return(Request.CreateResponse(HttpStatusCode.BadRequest, "You cannot add new user form if the current user detail is locked.")); } } else { return(Request.CreateResponse(HttpStatusCode.NotFound, "These current user details are not found in the server. Please add new user first before proceeding.")); } } else { return(Request.CreateResponse(HttpStatusCode.BadRequest, "Sorry. You have no rights to add user form.")); } } else { return(Request.CreateResponse(HttpStatusCode.BadRequest, "Sorry. You have no access for this user page.")); } } else { return(Request.CreateResponse(HttpStatusCode.BadRequest, "Theres no current user logged in.")); } } catch (Exception e) { Debug.WriteLine(e); return(Request.CreateResponse(HttpStatusCode.InternalServerError, "Something's went wrong from the server.")); } }