public static bool HasPermission(int moduleId, String username, TypeAudit audit) { var _cnttDB = new CNTTDHXDEntities(); /*GroupPermissionServices groupPermissionServices = new GroupPermissionServices(); List<GroupPermissionModels> lstGroupPermission = groupPermissionServices.selectPermission(moduleId, username); foreach (var item in lstGroupPermission) { if (Utils.HassPermission(audit, item.PermissionNumber)) return true; }*/ //List<gov_group_permission> lstGroupPermission = select from var lstGroupPermission = (from ggp in _cnttDB.gov_group_permission join ggm in _cnttDB.gov_group_members on ggp.group_id equals ggm.group_id where (ggm.username.Equals(username) && ggp.module_id == moduleId) select ggp).ToList(); var a = lstGroupPermission.Count(); foreach (var item in lstGroupPermission) { if (Utils.HassPermission(audit, item.permission_number)) return true; } return false; }
public static string getLinkMenu(int id) { CNTTDHXDEntities _cnttDB = new CNTTDHXDEntities(); string rs = ""; gov_menu menuInfo = _cnttDB.gov_menu.Find(id); if (menuInfo != null) { rs = "/chanel/" + ConvertToUnSign(menuInfo.title) + "-" + id.ToString(); } return rs; }
public static string getLinkNew(int id) { CNTTDHXDEntities _cnttDB = new CNTTDHXDEntities(); string rs = ""; gov_news newInfo = _cnttDB.gov_news.Find(id); if (newInfo != null) { rs = "/new/" + ConvertToUnSign(newInfo.gov_menu.title) + "/" + ConvertToUnSign(newInfo.title) + "-" + id.ToString(); } return rs; }
public void Execute(IJobExecutionContext context) { var fileFolder = Constant.BACKUP_FOLDER_PATH; var fileDir = System.AppDomain.CurrentDomain.BaseDirectory + "\\" + Constant.BACKUP_FOLDER_PATH; if (!System.IO.Directory.Exists(fileDir)) System.IO.Directory.CreateDirectory(fileDir); String filePath = fileDir + "\\" + "TAKS_" + DateTime.Now.ToString("yyyyMMdd-HHmmss") + ".bak"; using (var db = new CNTTDHXDEntities()) { var cmd = String.Format("BACKUP DATABASE {0} TO DISK='{1}' WITH FORMAT, MEDIANAME='DbBackups', MEDIADESCRIPTION='Media set for {0} database';" , "CNTTDHXD", filePath); try { int rs = db.Database.ExecuteSqlCommand(cmd); } catch (Exception ex) { throw ex; //nothing } } }
public static string getLinkDefault(int id, TypeLink typeLink) { CNTTDHXDEntities _cnttDB = new CNTTDHXDEntities(); string rs = ""; switch((int) typeLink){ case (int)TypeLink.tintuc : gov_news newInfo = _cnttDB.gov_news.Find(id); if (newInfo != null) { rs = "/new/" + ConvertToUnSign(newInfo.gov_menu.title) + "/" + ConvertToUnSign(newInfo.title) + "-" + id.ToString(); } break; case (int)TypeLink.danhmuc: gov_menu menuInfo = _cnttDB.gov_menu.Find(id); if (menuInfo != null) { rs = "/chanel/" + ConvertToUnSign(menuInfo.title) + "-" + id.ToString(); } break; case (int)TypeLink.album: gov_album albumInfo = _cnttDB.gov_album.Find(id); if (albumInfo != null) { rs = "/album/" + ConvertToUnSign(albumInfo.album_title) + "-" + id.ToString(); } break; case (int)TypeLink.video: gov_video videoInfo = _cnttDB.gov_video.Find(id); if (videoInfo != null) { rs = "/video/" + ConvertToUnSign(videoInfo.title) + "-" + id.ToString(); } break; } return rs; }
public ActionResult Backup() { if (Session.getCurrentUser() == null) return Redirect("/admin/account/logon"); if (!SercurityServices.HasPermission((int)TypeModule.MODULE_HETHONG, Session.getCurrentUser().username, TypeAudit.BackupDatabase)) { return Redirect("/admin/error/error403"); } //var fileFolder = Constant.BACKUP_FOLDER_PATH; var fileDir = System.AppDomain.CurrentDomain.BaseDirectory + Constant.BACKUP_FOLDER_PATH; if (!System.IO.Directory.Exists(fileDir)) System.IO.Directory.CreateDirectory(fileDir); string dbPath = fileDir + "\\" + DateTime.Now.ToString("yyyyMMdd-HHmmss") + ".bak"; using (var db = new CNTTDHXDEntities()) { var cmd = String.Format("BACKUP DATABASE {0} TO DISK='{1}' WITH FORMAT, MEDIANAME='DbBackups', MEDIADESCRIPTION='Media set for {0} database';" , "[fit.nuce.edu.vn]", dbPath); try { int rs = db.Database.ExecuteSqlCommand(cmd); TempData["message"] = "Backup dữ liệu thành công!"; } catch (Exception ex) { throw ex; TempData["err"] = "Backup dữ liệu thất bại!"; } } return Redirect("Index"); }