public ActionResult GetEditItemById(int id, int idTable)
{
var db = new Sec_MenuDal();
var result = db.GetSecMenuById(1, idTable, id);
return(Content(JsonConvert.SerializeObject(new
{
result
})));
}
public ActionResult GetListParent()
{
var db = new Sec_MenuDal();
var result = db.ListParent();
return(Content(JsonConvert.SerializeObject(new
{
result
})));
}
private string GetHtmlMenu()
{
var db = new Sec_MenuDal();
var currentUser = Global.CurrentUser;
var lstMenu = db.GetMenuSystem(currentUser.UserID, currentUser.UserType);
var html = new StringBuilder();
html.AppendLine("<ul>");
html.AppendLine(GetHtml(lstMenu));
html.AppendLine("</ul>");
return(html.ToString());
}
public ActionResult _DeleteSecMenu(int id, int idTable)
{
var db = new Sec_MenuDal();
var result = db.DeleteSecMenu(1, idTable, id);
if (result.IsSuccess == true)
{
result.Message = AppRes.MS_Delete_success;
}
else
{
result.Message = AppRes.NotFound;
}
return(Content(JsonConvert.SerializeObject(new
{
result
})));
}
public ActionResult _SaveSecMenu(Sec_Menu obj)
{
var db = new Sec_MenuDal();
var result = db.SaveSecMenu(1, 1, obj);
if (result.IsSuccess == true)
{
result.Message = AppRes.MS_Update_success;
}
else
{
result.Message = AppRes.MS_Update_error;
}
return(Content(JsonConvert.SerializeObject(new
{
result
})));
}
public ActionResult TableServerSideGetData(int pageIndex, int pageSize, string filter = "")
{
var db = new Sec_MenuDal();
int total = 0;
int Language = Global.CurrentLanguage;
var result = db.GetSecMenu(pageIndex, pageSize, filter, out total, Language);
var lstTotal = new TableColumnsTotalModel();
lstTotal.Total1 = "15";
lstTotal.Total2 = "25";
lstTotal.Total3 = "35";
return(Content(JsonConvert.SerializeObject(new
{
employees = result,
totalCount = total,
lstTotal = lstTotal
})));
}
public ActionResult SecMenuExportExcel(string filterString)
{
DataTable dt = new DataTable("Grid");
dt.Columns.AddRange(new DataColumn[10]
{
new DataColumn("MenuID"),
new DataColumn(AppRes.NameVi),
new DataColumn(AppRes.NameEn),
new DataColumn("ActionName"),
new DataColumn("IncludeMenu"),
new DataColumn("MenuPositionID"),
new DataColumn("OrderNo"),
new DataColumn("ParentID"),
new DataColumn("IsActive"),
new DataColumn("Url")
});
dt.Columns[0].DataType = typeof(int);
dt.Columns[1].DataType = typeof(string);
var db = new Sec_MenuDal();
int total = 0;
var lstData = db.ExportExcelSecMenu(filterString);
foreach (var item in lstData)
{
dt.Rows.Add(item.MenuID, item.Name, item.NameEN, item.ActionName, item.IncludeMenu, item.MenuPositionID, item.OrderNo, item.ParentID, item.IsActive, item.Url);
}
var wb = new XLWorkbook();
wb.Worksheets.Add(dt);
byte[] data = null;
using (var stream = new MemoryStream())
{
wb.SaveAs(stream);
data = stream.ToArray();
}
return(File(data, "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", "SecMenu.xlsx"));
}
