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