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