public ActionResult Create(Models.AppFunction o)
{
/// Authentication and authorisation.
if (Session["UserId"] == null)
{
return(RedirectToAction("Login", "home"));
}
if (!BAL.AccessBO.CanAccessAppFunctionByUserId(Session["UserId"].ToString(), "appfunc_create"))
{
return(RedirectToAction("NoAccess", "home"));
}
if (!ModelState.IsValid)
{
return(View(o));
}
if (o == null)
{
ModelState.AddModelError(string.Empty, "AppFunction is NULL.");
return(View(o));
}
/// check whether name already exists in database.
if (string.IsNullOrEmpty(o.UniqueName))
{
o.UniqueName = o.UniqueName.Trim();
}
if (DAO.AppFunctionDao.UniqueNameExists(o.UniqueName))
{
ModelState.AddModelError(string.Empty, "Unique Name already exists.");
return(View(o));
}
return(View("CreateConfirm", o));
}
protected override void Down(MigrationBuilder migrationBuilder)
{
using (var db = new AumentumSecurityContext())
{
Models.AppFunction permission = db.Permissions.Single(p => p.AppFunctionType == "field" &&
p.Name == LegalPartySearchRebuildAllName);
db.Permissions.Remove(permission);
db.SaveChanges();
}
}
protected override void Down(MigrationBuilder migrationBuilder)
{
using (var db = new AumentumSecurityContext())
{
Models.AppFunction permission = db.Permissions.Single(p => p.AppFunctionType == "field" &&
p.Name == OperationsSystemStopwords);
db.Permissions.Remove(permission);
db.SaveChanges();
}
}
public ActionResult EditResult(Models.AppFunction o)
{
/// Authentication and authorisation.
if (Session["UserId"] == null)
{
return(RedirectToAction("Login", "home"));
}
if (!BAL.AccessBO.CanAccessAppFunctionByUserId(Session["UserId"].ToString(), "appfunc_edit"))
{
return(RedirectToAction("NoAccess", "home"));
}
return(View(o));
}
protected override void Up(MigrationBuilder migrationBuilder)
{
using (var db = new AumentumSecurityContext())
{
var permissionSeeder = new PermissionSeeder(db);
Models.AppFunction parent = db.Permissions.Single(p => p.AppFunctionType == "Application" &&
p.App == "api.LegalPartySearchService");
db.Permissions.AddRange(permissionSeeder.CreateFields(parent.Id, parent.Name, LegalPartySearchRebuildAllName));
db.SaveChanges();
}
}
public ActionResult EditConfirm(Models.AppFunction o)
{
/// Authentication and authorisation.
if (Session["UserId"] == null)
{
return(RedirectToAction("Login", "home"));
}
if (!BAL.AccessBO.CanAccessAppFunctionByUserId(Session["UserId"].ToString(), "appfunc_edit"))
{
return(RedirectToAction("NoAccess", "home"));
}
if (o == null || string.IsNullOrWhiteSpace(o.UniqueName))
{
return(RedirectToAction("Index"));
}
/// If clicking the "Confirm".
if ("confirm".Equals(BAL.CommonHelper.GetSessionValue(Request, "UiConfirm")?.ToLower()))
{
int userId = DAO.UserDao.GetIdByLoginname("admin");
if (userId < 0)
{
userId = 0;
}
o.UpdatedBy = o.CreatedBy = userId;
/// Update database.
int i = DAO.AppFunctionDao.UpdateUnit(o);
if (i == 1)
{
return(View("EditResult", o));
}
else if (i < 1)
{
ModelState.AddModelError(string.Empty, "Fail to update it in database.");
return(View("Edit", o));
}
else
{
ModelState.AddModelError(string.Empty, "More than ONE record are updated in database.");
return(View("Edit", o));
}
}
else
{
return(View("Edit", o));
}
}
private static List <Models.AppFunction> GetListByDataTable(DataTable dt)
{
if ((dt?.Rows.Count ?? 0) < 1)
{
return(null);
}
List <Models.AppFunction> rList = new List <Models.AppFunction>();
foreach (DataRow dr in dt.Rows)
{
Models.AppFunction o = Mapping(dr);
if (o != null)
{
rList.Add(o);
}
}
return(rList);
}
public static IEnumerable <Models.AppFunction> GetAllParentList()
{
List <Models.AppFunction> rList;
DataTable dt = null;
try
{
rList = new List <Models.AppFunction>()
{
new Models.AppFunction()
{
AppFunctionId = 0,
UniqueName = "system",
DisplayName = "System",
AppFuncLevelId = 0,
ParentId = 0,
SequentialNum = 0,
IsDisabled = false,
IsNavItem = false
}
};
string sql = "SELECT * FROM AppFunctions WHERE AppFuncLevelId<3 ORDER BY AppFuncLevelId,SequentialNum,DisplayName,UniqueName";
dt = DbHandler.IsMssqlConnected ?
DbHandler.MSSQL.SelectDataTable(sql) :
DbHandler.SQLite.SelectDataTable(sql);
if ((dt?.Rows.Count ?? 0) > 0)
{
foreach (DataRow dr in dt.Rows)
{
Models.AppFunction o = Mapping(dr);
if (o != null)
{
rList.Add(o);
}
}
}
return(rList);
}
finally { DbHandler.DisposeDataTable(ref dt); }
}
public ActionResult Delete(Models.AppFunction o)
{
/// Authentication and authorisation.
if (Session["UserId"] == null)
{
return(RedirectToAction("Login", "home"));
}
if (!BAL.AccessBO.CanAccessAppFunctionByUserId(Session["UserId"].ToString(), "appfunc_delete"))
{
return(RedirectToAction("NoAccess", "home"));
}
if (o == null)
{
return(RedirectToAction("Index"));
}
/// update database.
if (DAO.AppFunctionDao.DeleteUnit(o.AppFunctionId) < 1)
{
ModelState.AddModelError(string.Empty, "Fail to delete it in database.");
return(View(o));
}
return(RedirectToAction("Index"));
}
public static List <Models.AppFunction> GetList(int AppFuncLevelId, int ParentId, bool?IsNavItem, bool isShort)
{
if (AppFuncLevelId > 3 || AppFuncLevelId < 0)
{
return(null);
}
DataTable dt = null;
List <SqlParameter> listOfPara = null;
List <System.Data.SQLite.SQLiteParameter> listOfPara2 = null;
try
{
string sql;
if (isShort)
{
sql = "SELECT AppFunctionId,UniqueName,DisplayName,ActionName,ControllerName,ParentId,AppFuncLevelId FROM AppFunctions WHERE AppFuncLevelId=@AppFuncLevelId AND ParentId=@ParentId" + (IsNavItem.HasValue ? " AND IsNavItem=@IsNavItem" : "") + " ORDER BY SequentialNum,DisplayName,UniqueName";
}
else
{
sql = "SELECT * FROM AppFunctions WHERE AppFuncLevelId=@AppFuncLevelId AND ParentId=@ParentId" + (IsNavItem.HasValue ? " AND IsNavItem=@IsNavItem" : "") + " ORDER BY SequentialNum,DisplayName,UniqueName";
}
if (DbHandler.IsMssqlConnected)
{
listOfPara = new List <SqlParameter>()
{
new SqlParameter("@AppFuncLevelId", SqlDbType.Int)
{
Value = AppFuncLevelId
},
new SqlParameter("@ParentId", SqlDbType.Int)
{
Value = ParentId
}
};
if (IsNavItem.HasValue)
{
listOfPara.Add(new SqlParameter("@IsNavItem", SqlDbType.Bit)
{
Value = IsNavItem.GetValueOrDefault()
});
}
dt = DbHandler.MSSQL.SelectDataTable(sql, listOfPara.ToArray());
}
else
{
listOfPara2 = new List <System.Data.SQLite.SQLiteParameter>()
{
new System.Data.SQLite.SQLiteParameter("@AppFuncLevelId", DbType.Int32)
{
Value = AppFuncLevelId
},
new System.Data.SQLite.SQLiteParameter("@ParentId", DbType.Int32)
{
Value = ParentId
}
};
if (IsNavItem.HasValue)
{
listOfPara2.Add(new System.Data.SQLite.SQLiteParameter("@IsNavItem", DbType.Boolean)
{
Value = IsNavItem.GetValueOrDefault()
});
}
dt = DbHandler.SQLite.SelectDataTable(sql, listOfPara2.ToArray());
}
if ((dt?.Rows.Count ?? 0) < 1)
{
return(null);
}
List <Models.AppFunction> rList = new List <Models.AppFunction>();
foreach (DataRow dr in dt.Rows)
{
Models.AppFunction o = Mapping(dr);
if (o != null)
{
//o.ParentId = ParentId;
//o.AppFuncLevelId = AppFuncLevelId;
o.ChildList = GetList(AppFuncLevelId + 1, o.AppFunctionId, IsNavItem, isShort);
rList.Add(o);
}
}
return(rList);
}
finally
{
DbHandler.DisposeDataTable(ref dt);
if (listOfPara != null)
{
listOfPara.Clear(); listOfPara = null;
}
if (listOfPara2 != null)
{
listOfPara2.Clear(); listOfPara2 = null;
}
}
}
/// Return value = number of records affected.
public static int UpdateUnit(Models.AppFunction o)
{
//if (o == null) return -1;
string sql = "UPDATE AppFunctions SET UniqueName=@UniqueName,DisplayName=@DisplayName" +
",ControllerName=@ControllerName,ActionName=@ActionName,AppFuncLevelId=@AppFuncLevelId,ParentId=@ParentId,SequentialNum=@SequentialNum,IsNavItem=@IsNavItem" +
",IsDisabled=@IsDisabled,UpdatedDt=GETDATE(),UpdatedBy=@UpdatedBy,Description=@Description" +
" WHERE AppFunctionId=@AppFunctionId";
return(o == null ? -1 : (
DbHandler.IsMssqlConnected ?
DbHandler.MSSQL.ExecuteNonQuery(sql,
new SqlParameter("@AppFunctionId", SqlDbType.Int)
{
Value = o.AppFunctionId
},
new SqlParameter("@UniqueName", SqlDbType.VarChar)
{
Value = DbHandler.GetObjectToDb(o.UniqueName)
},
new SqlParameter("@DisplayName", SqlDbType.VarChar)
{
Value = DbHandler.GetObjectToDb(o.DisplayName)
},
new SqlParameter("@ControllerName", SqlDbType.VarChar)
{
Value = DbHandler.GetObjectToDb(o.ControllerName)
},
new SqlParameter("@ActionName", SqlDbType.VarChar)
{
Value = DbHandler.GetObjectToDb(o.ActionName)
},
new SqlParameter("@AppFuncLevelId", SqlDbType.Int)
{
Value = o.AppFuncLevelId
},
new SqlParameter("@ParentId", SqlDbType.Int)
{
Value = o.ParentId
},
new SqlParameter("@SequentialNum", SqlDbType.Int)
{
Value = o.SequentialNum
},
new SqlParameter("@IsDisabled", SqlDbType.Bit)
{
Value = o.IsDisabled
},
new SqlParameter("@IsNavItem", SqlDbType.Bit)
{
Value = o.IsNavItem
},
new SqlParameter("@UpdatedBy", SqlDbType.Int)
{
Value = o.UpdatedBy
},
new SqlParameter("@Description", SqlDbType.VarChar)
{
Value = DbHandler.GetObjectToDb(o.Description)
}
):
DbHandler.SQLite.ExecuteNonQuery(sql,
new System.Data.SQLite.SQLiteParameter("@AppFunctionId", DbType.Int32)
{
Value = o.AppFunctionId
},
new System.Data.SQLite.SQLiteParameter("@UniqueName", DbType.AnsiString)
{
Value = DbHandler.GetObjectToDb(o.UniqueName)
},
new System.Data.SQLite.SQLiteParameter("@DisplayName", DbType.AnsiString)
{
Value = DbHandler.GetObjectToDb(o.DisplayName)
},
new System.Data.SQLite.SQLiteParameter("@ControllerName", DbType.AnsiString)
{
Value = DbHandler.GetObjectToDb(o.ControllerName)
},
new System.Data.SQLite.SQLiteParameter("@ActionName", DbType.AnsiString)
{
Value = DbHandler.GetObjectToDb(o.ActionName)
},
new System.Data.SQLite.SQLiteParameter("@AppFuncLevelId", DbType.Int32)
{
Value = o.AppFuncLevelId
},
new System.Data.SQLite.SQLiteParameter("@ParentId", DbType.Int32)
{
Value = o.ParentId
},
new System.Data.SQLite.SQLiteParameter("@SequentialNum", DbType.Int32)
{
Value = o.SequentialNum
},
new System.Data.SQLite.SQLiteParameter("@IsDisabled", DbType.Boolean)
{
Value = o.IsDisabled
},
new System.Data.SQLite.SQLiteParameter("@IsNavItem", DbType.Boolean)
{
Value = o.IsNavItem
},
new System.Data.SQLite.SQLiteParameter("@UpdatedBy", DbType.Int32)
{
Value = o.UpdatedBy
},
new System.Data.SQLite.SQLiteParameter("@Description", DbType.AnsiString)
{
Value = DbHandler.GetObjectToDb(o.Description)
}
)));
}
/// Insert the record.
public static int InsertUnit(Models.AppFunction o)
{
string sql = "INSERT INTO AppFunctions (UniqueName,DisplayName,ControllerName,ActionName,AppFuncLevelId,ParentId,SequentialNum,IsDisabled,IsNavItem,CreatedDt,CreatedBy,UpdatedDt,UpdatedBy,Description) VALUES (@UniqueName,@DisplayName,@ControllerName,@ActionName,@AppFuncLevelId,@ParentId,@SequentialNum,@IsDisabled,@IsNavItem,GETDATE(),@CreatedBy,GETDATE(),@UpdatedBy,@Description)";
return(o == null ? -1 : (
DbHandler.IsMssqlConnected ?
DbHandler.MSSQL.ExecuteNonQuery(sql,
new SqlParameter("@UniqueName", SqlDbType.VarChar)
{
Value = DbHandler.GetObjectToDb(o.UniqueName)
},
new SqlParameter("@DisplayName", SqlDbType.VarChar)
{
Value = DbHandler.GetObjectToDb(o.DisplayName)
},
new SqlParameter("@ControllerName", SqlDbType.VarChar)
{
Value = DbHandler.GetObjectToDb(o.ControllerName)
},
new SqlParameter("@ActionName", SqlDbType.VarChar)
{
Value = DbHandler.GetObjectToDb(o.ActionName)
},
new SqlParameter("@AppFuncLevelId", SqlDbType.Int)
{
Value = o.AppFuncLevelId
},
new SqlParameter("@ParentId", SqlDbType.Int)
{
Value = o.ParentId
},
new SqlParameter("@SequentialNum", SqlDbType.Int)
{
Value = o.SequentialNum
},
new SqlParameter("@IsDisabled", SqlDbType.Bit)
{
Value = o.IsDisabled
},
new SqlParameter("@IsNavItem", SqlDbType.Bit)
{
Value = o.IsNavItem
},
//new SqlParameter("@CreatedDt", SqlDbType.DateTime) { Value = o.CreatedDt },
new SqlParameter("@CreatedBy", SqlDbType.Int)
{
Value = o.CreatedBy
},
//new SqlParameter("@CreatedByDisplayName", SqlDbType.VarChar) { Value = o.CreatedByDisplayName },
//new SqlParameter("@UpdatedDt", SqlDbType.DateTime) { Value = o.UpdatedDt },
new SqlParameter("@UpdatedBy", SqlDbType.Int)
{
Value = o.UpdatedBy
},
//new SqlParameter("@UpdatedByDisplayName", SqlDbType.VarChar) { Value = o.UpdatedByDisplayName },
new SqlParameter("@Description", SqlDbType.VarChar)
{
Value = DbHandler.GetObjectToDb(o.Description)
}
):
DbHandler.SQLite.ExecuteNonQuery(sql,
new System.Data.SQLite.SQLiteParameter("@UniqueName", DbType.AnsiString)
{
Value = DbHandler.GetObjectToDb(o.UniqueName)
},
new System.Data.SQLite.SQLiteParameter("@DisplayName", DbType.AnsiString)
{
Value = DbHandler.GetObjectToDb(o.DisplayName)
},
new System.Data.SQLite.SQLiteParameter("@ControllerName", DbType.AnsiString)
{
Value = DbHandler.GetObjectToDb(o.ControllerName)
},
new System.Data.SQLite.SQLiteParameter("@ActionName", DbType.AnsiString)
{
Value = DbHandler.GetObjectToDb(o.ActionName)
},
new System.Data.SQLite.SQLiteParameter("@AppFuncLevelId", DbType.Int32)
{
Value = DbHandler.GetObjectToDb(o.AppFuncLevelId)
},
new System.Data.SQLite.SQLiteParameter("@ParentId", DbType.Int32)
{
Value = DbHandler.GetObjectToDb(o.ParentId)
},
new System.Data.SQLite.SQLiteParameter("@SequentialNum", DbType.Int32)
{
Value = DbHandler.GetObjectToDb(o.SequentialNum)
},
new System.Data.SQLite.SQLiteParameter("@IsDisabled", DbType.Boolean)
{
Value = DbHandler.GetObjectToDb(o.IsDisabled)
},
new System.Data.SQLite.SQLiteParameter("@IsNavItem", DbType.Boolean)
{
Value = DbHandler.GetObjectToDb(o.IsNavItem)
},
//new System.Data.SQLite.SQLiteParameter("@CreatedDt", DbType.DateTime) { Value = DbHandler.GetObjectToDb(o.CreatedDt) },
new System.Data.SQLite.SQLiteParameter("@CreatedBy", DbType.Int32)
{
Value = DbHandler.GetObjectToDb(o.CreatedBy)
},
//new System.Data.SQLite.SQLiteParameter("@UpdatedDt", DbType.DateTime) { Value = DbHandler.GetObjectToDb(o.UpdatedDt) },
new System.Data.SQLite.SQLiteParameter("@UpdatedBy", DbType.Int32)
{
Value = DbHandler.GetObjectToDb(o.UpdatedBy)
},
new System.Data.SQLite.SQLiteParameter("@Description", DbType.AnsiString)
{
Value = DbHandler.GetObjectToDb(o.Description)
}
)));
}
