public ActionResult EditRoleAndFunc(int Id)
{
try
{
HienThiDanhSachRole();
HienThiDanhSachFunc();
UserRoleAndFunction objRAF = DataProvider.Entities.UserRoleAndFunctions.Where(c => c.Id == Id).Single();
return(View(objRAF));
}
catch (Exception ex)
{
logger.Error(ex.ToString());
return(Redirect("~/ErrorPage/Return"));
}
}
public ActionResult RemoveRoleAndFunc(int Id)
{
try
{
UserRoleAndFunction objRAF = DataProvider.Entities.UserRoleAndFunctions.Find(Id);
if (objRAF != null)
{
//Xóa
DataProvider.Entities.UserRoleAndFunctions.Remove(objRAF);
//Lưu thay đổi
DataProvider.Entities.SaveChanges();
logger.Info("Delete a Role And Function ");
}
return(RedirectToAction("DanhSachRoleAndFunc"));
}
catch (Exception ex)
{
logger.Error(ex.ToString());
return(Redirect("~/ErrorPage/Return"));
}
}
public ActionResult AddRoleAndFunc(UserRoleAndFunction objRoleAndFunc, int?idFunction, int?idRole)
{
try
{
HienThiDanhSachRole();
HienThiDanhSachFunc();
if (ModelState.IsValid)
{
DataProvider.Entities.UserRoleAndFunctions.Add(objRoleAndFunc);
//Lưu thay đổi
DataProvider.Entities.SaveChanges();
logger.Info("Add a UserRole and Function " + objRoleAndFunc.UserRole.TenRole
+ objRoleAndFunc.Function.TenChucNang);
}
return(RedirectToAction("DanhSachRoleAndFunc"));
}
catch (Exception ex)
{
logger.Error(ex.ToString());
return(Redirect("~/ErrorPage/Return"));
}
}
public ActionResult EditRoleAndFunc(int Id, UserRoleAndFunction objRAF)
{
try
{
HienThiDanhSachRole();
HienThiDanhSachFunc();
var objOld_RAF = DataProvider.Entities.UserRoleAndFunctions.Find(Id);
//Xử lý upload file
if (objOld_RAF != null)
{
DataProvider.Entities.Entry(objOld_RAF).CurrentValues.SetValues(objRAF);
//Lưu thay đổi
DataProvider.Entities.SaveChanges();
}
logger.Info("Update a UserRole and Function ");
return(RedirectToAction("DanhSachRoleAndFunc"));
}
catch (Exception ex)
{
logger.Error(ex.ToString());
return(Redirect("~/ErrorPage/Return"));
}
}
public ActionResult ImpRoleAndFunc(HttpPostedFileBase FileUpload)
{
try
{
List <UserRole> ListRole = DataProvider.Entities.UserRoles.ToList();
List <Function> ListFunction = DataProvider.Entities.Function.ToList();
if (ListFunction.Count == 0)
{
TempData["FunctionEmpty"] = ("Vui lòng import dữ liệu về chức năng trước");
return(RedirectToAction("ImpFunc", "Data", "Admin"));
}
List <string> data = new List <string>();
if (FileUpload != null && FileUpload.ContentLength > 0)
{
if (FileUpload.ContentType == "application/vnd.ms-excel" ||
FileUpload.ContentType == "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet")
{
string filename = FileUpload.FileName;
//tạo đường dẫn
string uploadPath = ConfigurationManager.AppSettings["fileUpload"];
//nếu đường dẫn ko có thì tạo
if (!Directory.Exists(uploadPath))
{
Directory.CreateDirectory(uploadPath);
}
FileUpload.SaveAs(uploadPath + filename);
//đọc file Excel
string pathToExcelFile = uploadPath + filename;
var connectionString = "";
if (filename.EndsWith(".xls"))
{
connectionString = string.
Format("Provider=Microsoft.Jet.OLEDB.4.0; data source={0}; " +
"Extended Properties=Excel 8.0;", pathToExcelFile);
}
else if (filename.EndsWith(".xlsx"))
{
connectionString = string.
Format("Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0};" +
"Extended Properties=\"Excel 12.0;IMEX=1;HDR=NO;TypeGuessRows=0;ImportMixedTypes=Text\";", pathToExcelFile);
}
var adapter = new OleDbDataAdapter("SELECT * FROM [Sheet1$]", connectionString);
var ds = new DataSet();
adapter.Fill(ds, "ExcelTable");
DataTable dtable = ds.Tables["ExcelTable"];
string sheetName = "Sheet1";
var excelFile = new ExcelQueryFactory(pathToExcelFile);
var artistAlbums = from a in excelFile.Worksheet(sheetName)
select a;
List <Row> list = artistAlbums.ToList();
//Xóa các cột cũ trong DB
var rows = from o in DataProvider.Entities.UserRoleAndFunctions
select o;
DataProvider.Entities.UserRoleAndFunctions.RemoveRange((IEnumerable <UserRoleAndFunction>)rows);
DataProvider.Entities.SaveChanges();
//Add các cột mới vào DB
foreach (var a in artistAlbums)
{
try
{
if (a[0].Value != null &&
a[1].Value != null)
{
UserRoleAndFunction RF = new UserRoleAndFunction();
Function F = new Function();
UserRole R = new UserRole();
F = ListFunction.FirstOrDefault(o => o.TenChucNang == a[0].Value.ToString());
R = ListRole.FirstOrDefault(o => o.TenRole == a[1].Value.ToString());
RF.FuctionId = F.Id;
RF.UserRoleId = R.Id;
DataProvider.Entities.UserRoleAndFunctions.Add(RF);
DataProvider.Entities.SaveChanges();
}
else
{
data.Add("<ul>");
if (a[0].Value.ToString() == null)
{
data.Add("<li> Yêu cầu nhập tên chức năng</li>");
}
if (a[1].Value.ToString() == null)
{
data.Add("<li> Yêu cầu nhập tên quyền</li>");
}
data.Add("</ul>");
data.ToArray();
return(Json(data, JsonRequestBehavior.AllowGet));
}
}
catch (DbEntityValidationException ex)
{
foreach (var entityValidationErrors in ex.EntityValidationErrors)
{
foreach (var validationError in entityValidationErrors.ValidationErrors)
{
logger.Info("Import thất bại " + ex.ToString());
Response.Write("Property: " + validationError.PropertyName + " Error: " + validationError.ErrorMessage);
}
}
}
}
return(Json("success", JsonRequestBehavior.AllowGet));
}
else
{
//alert message for invalid file format
data.Add("<ul>");
data.Add("<li>Chỉ được tải file Excel</li>");
data.Add("</ul>");
data.ToArray();
return(Json(data, JsonRequestBehavior.AllowGet));
}
}
else
{
data.Add("<ul>");
if (FileUpload == null)
{
data.Add("<li>Yêu cầu chọn file</li>");
}
data.Add("</ul>");
data.ToArray();
return(Json(data, JsonRequestBehavior.AllowGet));
}
}
catch (Exception ex)
{
logger.Info("Import thất bại " + ex.ToString());
throw;
}
}
