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