//delete SecurityForm object by id public bool DeleteByID(long pSecurityFormID) { try { if (pSecurityFormID > 0) { SecurityForm vSecurityForm = rep.Find(pSecurityFormID); if (vSecurityForm != null) { ////Update DelFlag To "Y" For Soft Delete //vSecurityForm.ID = pSecurityForm.ID; //vSecurityForm.ApplicationCode = pSecurityForm.ApplicationCode; //vSecurityForm.FormCode = pSecurityForm.FormCode; //vSecurityForm.FormName = pSecurityForm.FormName; //vSecurityForm.ActiveFlag = pSecurityForm.ActiveFlag; //vSecurityForm.ApplicationID = pSecurityForm.ApplicationID; rep.Edit(vSecurityForm); rep.SaveChanges(); return(true); } } return(false); } catch (Exception ex) { throw ex; } }
public bool CreateUpdateSecurityForm(SecurityFormEntity securityForm) { using (var scope = new TransactionScope()) { SecurityForm sc = new SecurityForm() { Name = securityForm.Name, CreatedBy = securityForm.CreatedBy, CreatedDate = securityForm.CreatedDate, Description = securityForm.Description, Inactive = securityForm.Inactive, LastModBy = securityForm.LastModBy, LastModDate = securityForm.LastModDate, SecurityFormId = securityForm.SecurityFormId, ApplicationId = securityForm.ApplicationId }; if (securityForm.SecurityFormId > 0) { sc.LastModDate = DateTime.Now; _unitOfWork.SecurityFormRepository.Update(sc); _unitOfWork.Save(); scope.Complete(); } else { sc.LastModDate = DateTime.Now; sc.CreatedDate = DateTime.Now; _unitOfWork.SecurityFormRepository.Insert(sc); _unitOfWork.Save(); scope.Complete(); } return(true); } }
//update SecurityForm object public bool Update(SecurityForm pSecurityForm) { try { if (pSecurityForm.ID > 0) { SecurityForm vSecurityForm = rep.Find(pSecurityForm.ID); if (vSecurityForm != null) { //vSecurityForm.ID = pSecurityForm.ID; //vSecurityForm.ApplicationCode = pSecurityForm.ApplicationCode; //vSecurityForm.FormCode = pSecurityForm.FormCode; vSecurityForm.FormName = pSecurityForm.FormName; vSecurityForm.Remarks = pSecurityForm.Remarks; vSecurityForm.ActiveFlag = pSecurityForm.ActiveFlag; //vSecurityForm.ApplicationID = pSecurityForm.ApplicationID; rep.Edit(vSecurityForm); rep.SaveChanges(); return(true); } } return(false); } catch (Exception ex) { throw ex; } }
//POST: /User/Create public ActionResult Create(string pApplicationCode) { SecurityForm vForm = new SecurityForm(); SecurityApplication vApplication = oApplicationBLL.GetByCode(pApplicationCode); vForm.ApplicationCode = vApplication.ApplicationCode; vForm.ApplicationName = vApplication.ApplicationName; vForm.ActiveFlag2 = true; return(View(vForm)); }
public ActionResult Edit(string pApplicationCode, string FormCode) { SecurityForm vSecurityForm = oFormBLL.GetByCode(pApplicationCode, FormCode); if (vSecurityForm == null) { return(HttpNotFound()); } return(View(vSecurityForm)); }
public ActionResult Edit(SecurityForm pSecurityForm) { if (ModelState.IsValid) { if (oFormBLL.Update(pSecurityForm)) { return(RedirectToAction("Index", new { pApplicationCode = pSecurityForm.ApplicationCode })); } } return(View(pSecurityForm)); }
//POST: /User/Create public ActionResult Create(string pApplicationCode, string pFormCode) { SecurityForm vForm = oFormBLL.GetByCode(pApplicationCode, pFormCode); SecurityFormAction vFormAction = new SecurityFormAction(); vFormAction.ApplicationCode = vForm.ApplicationCode; vFormAction.ApplicationName = vForm.ApplicationName; vFormAction.FormCode = vForm.FormCode; vFormAction.FormName = vForm.FormName; vFormAction.ActiveFlag = "Y"; return(View(vFormAction)); }
public SecurityFormAction GetBasic_SecurityFormAction(SecurityForm pSecurityForm, string pFormActionCode, string pFormActionName) { SecurityFormAction vAction = new SecurityFormAction(); vAction.ID = 0; vAction.ApplicationCode = pSecurityForm.ApplicationCode; vAction.FormCode = pSecurityForm.FormCode; vAction.FormActionCode = pFormActionCode; //<<<<<<<<<<<<<<<<< vAction.FormActionName = pFormActionName; //<<<<<<<<<<<<<<<<< vAction.Remarks = string.Empty; vAction.ActiveFlag = "Y"; return(vAction); }
public ActionResult Edit(string pApplicationCode, string pFormCode, string pFormActionCode) { SecurityFormAction vFormAction = oFormActionBLL.GetByCode(pApplicationCode, pFormCode, pFormActionCode); if (vFormAction == null) { return(HttpNotFound()); } SecurityForm vForm = oFormBLL.GetByCode(pApplicationCode, pFormCode); vFormAction.ApplicationName = vForm.ApplicationName; vFormAction.FormName = vForm.FormName; return(View(vFormAction)); }
//000000000 public List <SecurityRoleAccess> GetByRoleForm(SecurityRole pSecurityRole, SecurityForm pSecurityForm) { List <SecurityRoleAccess> vList = new List <SecurityRoleAccess>(); IRepository <SecurityRoleAccess> repSUA = new Repository <SecurityRoleAccess>(ctx); try { var query = from a in ctx.SecurityFormActions join b in ctx.SecurityRoleAccesses.Where(o => o.RoleCode == pSecurityRole.RoleCode) on new { a.ApplicationCode, a.FormCode, a.FormActionCode } equals new { b.ApplicationCode, b.FormCode, b.FormActionCode } into Details from ra in Details.DefaultIfEmpty() where a.ApplicationCode == pSecurityForm.ApplicationCode && a.FormCode == pSecurityForm.FormCode select new { a, ra }; //string strQuery = "exec sp_SecurityUserActionALL @UserID='" + pSecurityUser.ID + "', @UserCode='" + pSecurityUser.UserCode + "', @FormID='" + pSecurityForm.ID + "'"; foreach (var eachItem in query) { if (eachItem.ra == null) { SecurityRoleAccess oNew = new SecurityRoleAccess(); oNew.RoleCode = pSecurityRole.RoleCode; oNew.ApplicationCode = eachItem.a.ApplicationCode; oNew.FormCode = eachItem.a.FormCode; oNew.FormActionCode = eachItem.a.FormActionCode; oNew.FormActionName = eachItem.a.FormActionName; oNew.ActionValue = "N"; vList.Add(oNew); } else { eachItem.ra.FormActionName = eachItem.a.FormActionName; vList.Add(eachItem.ra); } } return(vList); } catch (Exception ex) { throw ex; } }
//insert SecurityForm object public bool Insert(SecurityForm pSecurityForm) { try { pSecurityForm.ApplicationCode = pSecurityForm.ApplicationCode; pSecurityForm.FormCode = GetMaxCode(pSecurityForm.ApplicationCode); pSecurityForm.FormName = pSecurityForm.FormName; pSecurityForm.ActiveFlag = pSecurityForm.ActiveFlag; rep.Add(pSecurityForm); rep.SaveChanges(); return(true); } catch (Exception ex) { throw ex; } }
public ActionResult Create(SecurityForm pSecurityForm) { if (ModelState.IsValid) { if (oFormBLL.Insert(pSecurityForm)) { SecurityFormActionBLL faBLL = new SecurityFormActionBLL(); List <SecurityFormAction> vList_BasicAction = new List <SecurityFormAction>(); vList_BasicAction.Add(GetBasic_SecurityFormAction(pSecurityForm, "001", "View")); vList_BasicAction.Add(GetBasic_SecurityFormAction(pSecurityForm, "002", "Add")); vList_BasicAction.Add(GetBasic_SecurityFormAction(pSecurityForm, "003", "Edit")); vList_BasicAction.Add(GetBasic_SecurityFormAction(pSecurityForm, "004", "Delete")); vList_BasicAction.Add(GetBasic_SecurityFormAction(pSecurityForm, "005", "Post")); vList_BasicAction.Add(GetBasic_SecurityFormAction(pSecurityForm, "006", "Print")); faBLL.InsertList(vList_BasicAction); return(RedirectToAction("Index", new { pApplicationCode = pSecurityForm.ApplicationCode })); } } return(View(pSecurityForm)); }