public ActionResult Index(string id)
{
int noPages = 0, noRecords = 0;
BlockUIExcelUploadModel uiModel = new BlockUIExcelUploadModel();
try
{
uiModel.CurrentPage = Int32.Parse(Request.Params["page"]);
}
catch (Exception)
{
uiModel.CurrentPage = 1;
}
this.CheckPermission();
ViewData["pagename"] = "upload_excel";
ViewData["action_block"] = "Excels/block_upload_excel";
this.SetCommonData();
this.GetLanguage();
//DECLARE PAGE MODEL
BI_Project.Models.UI.PageModel pageModel = new Models.UI.PageModel("upload_excel");
pageModel.SetLanguage(this.LANGUAGE_OBJECT);
pageModel.H1Title = pageModel.GetElementByPath("page_excel.menu" + id + ".h1");
pageModel.Title = pageModel.GetElementByPath("page_excel.menu" + id + ".title");
ViewData["page_model"] = pageModel;
BlockLangExcelUpload blockLang = new BlockLangExcelUpload();
BI_Project.Models.UI.BlockModel blockModel = new Models.UI.BlockModel("block_upload_excel", this.LANGUAGE_OBJECT, blockLang);
BlockDataExcelUploadModel blockData = new BlockDataExcelUploadModel();
blockData.PermissionID = id;
//BI_Project.Helpers.Utility.JTokenHelper.GetLanguage("~/" + this.LANGUAGE_FOLDER, this.LANGUAGE);
string xmlConfigFilePath = this.CONFIG_FOLDER + "\\excel_format_" + blockData.PermissionID.ToString() + ".xml";
blockData.HelpDoc = BI_Project.Helpers.Utility.JTokenHelper.GetElementValue(xmlConfigFilePath, "excel_source.HelpDocumentPath");
blockData.Note = BI_Project.Helpers.Utility.JTokenHelper.GetElementValue(xmlConfigFilePath, "excel_source.Note.#cdata-section");
ImporterServices services = new ImporterServices(this.DBConnection);
blockData.ListHistory = services.GetHistoryList(uiModel.CurrentPage, uiModel.PerPage, id, ref noPages, ref noRecords, uiModel.Month, uiModel.Year);
blockData.NumberPages = noPages;
blockData.NumberRecords = noPages;
blockData.CurrentPage = uiModel.CurrentPage;
blockData.FolderUpload = pageModel.GetElementByPath("page_excel.menu" + id + ".UploadedDirectory");
blockModel.DataModel = blockData;
//blockModel.DataModel = ViewData["block_menu_left_data"];
if (services.ERROR != null)
{
FileHelper.SaveFile(services.ERROR, this.LOG_FOLDER + "/ERROR_" + this.GetType().ToString() + APIStringHelper.GenerateFileId() + ".txt");
}
ViewData["BlockData"] = blockModel;
return(View("~/" + this.THEME_FOLDER + "/" + this.THEME_ACTIVE + "/index.cshtml"));
}
public ActionResult Index(int id)
{
//lay url tu menu voi id
ViewData["pagename"] = "Embed_Tableau";
ViewData["action_block"] = "Tableau/TableauView";
SetCommonData();
GetLanguage();
SetConnectionDB();
BI_Project.Models.UI.PageModel pageModel = new Models.UI.PageModel("Embed_Tableau");
// BI_Project.Models.UI.BlockModel blockModel = new BlockModel("TableauView");
pageModel.SetLanguage(this.LANGUAGE_OBJECT);
//pageModel.H1Title = pageModel.GetElementByPath("page_excel.menu" + id + ".h1");
pageModel.Title = pageModel.GetElementByPath("title");
ViewData["page_model"] = pageModel;
TableauModel param = new TableauModel();
ViewData["BlockData"] = param;
MenuServices _menuServices = new MenuServices(DBConnection);
EntityMenuModel _entityMenuModel = _menuServices.GetMenuModel(id.ToString());
UserServices _userServices = new UserServices(DBConnection);
DepartmentServices _departmentServices = new DepartmentServices(DBConnection);
EntityDepartmentModel _entityDepartmentModel = new EntityDepartmentModel();
//param.Site_Root = _entityMenuModel.Site_Root;
param.Ticket = Helpers.TableauHelper.GetTicket("");
param.TableauUrl = _entityMenuModel.TableauUrl;
param.Hidden = 1;
param.username = Session["UserName"].ToString();
ViewBag.Id = id;
var listFilter01 = _departmentServices.GetList().Select(x => x.Filter01).ToArray();
StringBuilder builderOrganization = new StringBuilder();
foreach (var _list in listFilter01)
{
builderOrganization.Append(_list).Append(',');
}
string _resultListOrganization = builderOrganization.ToString().TrimEnd(',');
ViewBag.ListDepartment = _resultListOrganization;
var getUser = _userServices.GetList();
var getUserCheck = getUser.FirstOrDefault(x => x.UserName == param.username);
var getDepartment = _departmentServices.GetEntityById(getUserCheck.DeptId);
if (getUserCheck.IsAdmin == false && (getDepartment.Filter01 != "PE" || getDepartment.Filter01 != "PA" || getDepartment.Filter01 != "PB" || getDepartment.Filter01 != "PC" || getDepartment.Filter01 != "PD"))
{
param.GetFilter(id);
}
//param.GetFilter(id);
Random rd = new Random();
int item = rd.Next(100, 999);
string log = DateTime.Now.ToString("yyyy-MM-dd", System.Globalization.CultureInfo.InvariantCulture) + "_" + item;
if (_menuServices.ERROR != null)
{
FileHelper.SaveFile(new { ERROR = _menuServices.ERROR }, this.LOG_FOLDER + "/ERROR_" + this.GetType().ToString() + APIStringHelper.GenerateFileId() + ".txt");
}
FileHelper.SaveFile(_entityMenuModel, this.LOG_FOLDER + "/MenuModel_" + log + ".txt");
FileHelper.SaveFile(param.Ticket, this.LOG_FOLDER + "/Ticket_" + log + ".txt");
return(View("~/" + this.THEME_FOLDER + "/" + this.THEME_ACTIVE + "/index.cshtml"));
}
