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"));
}
}
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(); }
}
