public List <Auth_Role> GetPage(int page, int pageSize, string whereCondition)
{
List <SqlParameter> param = new List <SqlParameter>();
param.Add(new SqlParameter("@Page", page));
param.Add(new SqlParameter("@PageSize", pageSize));
param.Add(new SqlParameter("@WhereCondition", whereCondition));
DataTable dt = new SqlHelper().ExecuteQuery("p_Auth_Role_Select_By_Page", param);
var lst = new List <Auth_Role>();
foreach (DataRow row in dt.Rows)
{
var item = new Auth_Role();
item.RoleID = !row.IsNull("RoleID") ? Convert.ToInt32(row["RoleID"]) : 0;
item.RoleName = !row.IsNull("RoleName") ? row["RoleName"].ToString() : "";
item.IsActive = !row.IsNull("IsActive") ? Convert.ToBoolean(row["IsActive"]) : false;
item.Note = !row.IsNull("Note") ? row["Note"].ToString() : "";
item.RowCreatedAt = !row.IsNull("RowCreatedAt") ? DateTime.Parse(row["RowCreatedAt"].ToString()) : DateTime.Parse("01/01/1900");
item.RowCreatedBy = !row.IsNull("RowCreatedBy") ? row["RowCreatedBy"].ToString() : "";
lst.Add(item);
}
DataSourceResult result = new DataSourceResult();
result.Data = lst;
result.Total = dt.Rows.Count > 0 ? Convert.ToInt32(dt.Rows[0]["RowCount"]) : 0;
return(lst);
}
public List<Auth_Role> GetDataForDropDownList()
{
List<SqlParameter> param = new List<SqlParameter>();
DataTable dt = new SqlHelper().ExecuteQuery("p_Auth_Role_Select_For_DropDownList", param);
var lst = new List<Auth_Role>();
foreach (DataRow row in dt.Rows)
{
var item = new Auth_Role();
item.RoleID = !row.IsNull("RoleID") ? Convert.ToInt32(row["RoleID"]) : 0;
item.RoleName = !row.IsNull("RoleName") ? row["RoleName"].ToString() : "";
lst.Add(item);
}
return lst;
}
public List <Auth_Role> GetDataForDropDownList()
{
List <SqlParameter> param = new List <SqlParameter>();
DataTable dt = new SqlHelper().ExecuteQuery("p_Auth_Role_Select_For_DropDownList", param);
var lst = new List <Auth_Role>();
foreach (DataRow row in dt.Rows)
{
var item = new Auth_Role();
item.RoleID = !row.IsNull("RoleID") ? Convert.ToInt32(row["RoleID"]) : 0;
item.RoleName = !row.IsNull("RoleName") ? row["RoleName"].ToString() : "";
lst.Add(item);
}
return(lst);
}
public List<Auth_Role> GetPage(int page, int pageSize, string whereCondition)
{
List<SqlParameter> param = new List<SqlParameter>();
param.Add(new SqlParameter("@Page", page));
param.Add(new SqlParameter("@PageSize", pageSize));
param.Add(new SqlParameter("@WhereCondition", whereCondition));
DataTable dt = new SqlHelper().ExecuteQuery("p_Auth_Role_Select_By_Page", param);
var lst = new List<Auth_Role>();
foreach (DataRow row in dt.Rows)
{
var item = new Auth_Role();
item.RoleID = !row.IsNull("RoleID") ? Convert.ToInt32(row["RoleID"]) : 0;
item.RoleName = !row.IsNull("RoleName") ? row["RoleName"].ToString() : "";
item.IsActive = !row.IsNull("IsActive") ? Convert.ToBoolean(row["IsActive"]) : false;
item.Note = !row.IsNull("Note") ? row["Note"].ToString() : "";
item.RowCreatedAt = !row.IsNull("RowCreatedAt") ? DateTime.Parse(row["RowCreatedAt"].ToString()) : DateTime.Parse("01/01/1900");
item.RowCreatedBy = !row.IsNull("RowCreatedBy") ? row["RowCreatedBy"].ToString() : "";
lst.Add(item);
}
DataSourceResult result = new DataSourceResult();
result.Data = lst;
result.Total = dt.Rows.Count > 0 ? Convert.ToInt32(dt.Rows[0]["RowCount"]) : 0;
return lst;
}
public ActionResult Create(FormCollection form)
{
IDbConnection db = new OrmliteConnection().openConn();
try
{
if (!string.IsNullOrEmpty(form["RoleName"]))
{
var item = new Auth_Role();
item.RoleName = form["RoleName"];
item.IsActive = form["IsActive"] != null ? Convert.ToBoolean(form["IsActive"]) : false;
item.Note = !string.IsNullOrEmpty(form["Note"]) ? form["Note"] : "";
if (userAsset.ContainsKey("Insert") && userAsset["Insert"] &&
string.IsNullOrEmpty(form["RoleID"])) // Tạo mới
{
item.RowCreatedAt = DateTime.Now;
item.RowCreatedBy = currentUser.UserID;
db.Insert<Auth_Role>(item);
long lastID = db.GetLastInsertId();
if (lastID > 0)
{
// Thêm Role vào Auth_Action
db.ExecuteSql("EXEC p_Auth_Role_GenerateAction_By_RoleID " + lastID + "," + currentUser.UserID);
}
return Json(new { success = true, insert = true, RoleID = lastID, createdat = item.RowCreatedAt, createdby = item.RowCreatedBy });
}
else if (userAsset.ContainsKey("Insert") && userAsset["Insert"] &&
Convert.ToInt32(form["RoleID"]) > 0 &&
Convert.ToInt32(form["IsCopy"]) == 1) // Sao chép
{
item.RoleID = Convert.ToInt32(form["RoleID"]);
item.RowCreatedAt = DateTime.Now;
item.RowCreatedBy = currentUser.UserID;
db.Insert<Auth_Role>(item);
long lastID = db.GetLastInsertId();
if (lastID > 0)
{
// Sao chép Action RoleID đã chọn vào RoleID vừa tạo
db.ExecuteSql("p_Auth_Role_CopyAction_By_RoleID " + item.RoleID + "," + lastID + "," + currentUser.UserID);
}
return Json(new { success = true, insert = true, RoleID = lastID, createdat = item.RowCreatedAt, createdby = item.RowCreatedBy });
}
else if (userAsset.ContainsKey("Update") && userAsset["Update"] &&
Convert.ToInt32(form["RoleID"]) > 0) // Cập nhật
{
item.RoleID = Convert.ToInt32(form["RoleID"]);
item.RowCreatedAt = DateTime.Parse(form["RowCreatedAt"]);
item.RowCreatedBy = form["RowCreatedBy"];
item.RowUpdatedAt = DateTime.Now;
item.RowUpdatedBy = currentUser.UserID;
if (item.RowCreatedBy != "system")
{
db.Update<Auth_Role>(item);
}
return Json(new { success = true, RoleID = item.RoleID });
}
else
return Json(new { success = false, message = "Bạn không có quyền" });
}
else
{
return Json(new { success = false, message = "Chưa nhập giá trị" });
}
}
catch (Exception e)
{
log.Error("HOAdminAuthRole - Create - " + e.Message);
return Json(new { success = false, message = e.Message });
}
finally { db.Close(); }
}
public ActionResult Read([DataSourceRequest]DataSourceRequest request)
{
log4net.Config.XmlConfigurator.Configure();
string whereCondition = "";
if (request.Filters.Count > 0)
{
whereCondition = " AND " + new KendoApplyFilter().ApplyFilter(request.Filters[0]);
}
var data = new Auth_Role().GetPage(request.Page, request.PageSize, whereCondition);
return Json(data.ToDataSourceResult(request));
}
//=====================================================================================================
public ActionResult PartialUser()
{
if (userAsset.ContainsKey("View") && userAsset["View"])
{
IDbConnection dbConn = new OrmliteConnection().openConn();
var dict = new Dictionary<string, object>();
dict["asset"] = userAsset;
dict["activestatus"] = new CommonLib().GetActiveStatus();
//dict["listrole"] = dbConn.Select<Auth_Role>("SELECT * FROM Auth_Role WHERE IsActive = 1");
dict["listrole"] = new Auth_Role().GetDataForDropDownList();
dbConn.Close();
return PartialView("_AD_User", dict);
}
else
return RedirectToAction("NoAccess", "Error");
}
