public ActionResult Login(LoginModel loginModel)
{
Char charRange = '/';
//STEP1: GOI HAM LOGIN TOI CSDL *****************************************************
this.SetConnectionDB();
BI_Project.Services.User.UserServices userServices = new UserServices(this.DBConnection);
BI_Project.Services.Departments.DepartmentServices departmentServices = new DepartmentServices(this.DBConnection);
EntityUserModel entityUser = userServices.CheckLogin(loginModel);
EntityDepartmentModel entityDepartment = departmentServices.GetEntityById(entityUser.DeptId);
SetDefaultPageService setDefault = new SetDefaultPageService(DBConnection);
if (entityUser.UserName != null)
{
Session["UserName"] = entityUser.UserName;
Session["FullName"] = entityUser.FullName;
Session[this.SESSION_NAME_USER_NAME] = entityUser.UserName;
Session[this.SESSION_NAME_USERID] = entityUser.UserId;
Session["DepartIdUserLogin"] = entityUser.DeptId;
Session["IsAdmin"] = entityUser.IsAdmin;
Session["IsSuperAdmin"] = entityUser.IsSuperAdmin;
Session["CodeIsAdmin"] = entityDepartment.Code;
Session["Filter01IsAdmin"] = entityDepartment.Filter01;
List <EntityUserMenuModel> entityUserMenuModel = setDefault.GetListDefaultPage(entityUser.UserId);
foreach (EntityUserMenuModel item in entityUserMenuModel)
{
if (item.IsDefaultPage == true)
{
var _path = item.Path;
string _controller = _path.Split(charRange)[0];
string _action = _path.Split(charRange)[1];
int _menuId = item.MenuId;
return(RedirectToAction(_action + "/" + _menuId, _controller));
}
}
return(RedirectToAction("Index"));
}
if (userServices.ERROR != null)
{
Session["msgcode"] = MessageType.ServerError;
FileHelper.SaveFile(userServices.ERROR, this.LOG_FOLDER + "/ERROR_" + this.GetType().ToString() + BI_Project.Helpers.Utility.APIStringHelper.GenerateFileId() + ".txt");
}
else
{
Session["msgcode"] = MessageType.BusinessError;
}
this.GetLanguage();
ViewData["VIEWDATA_LANGUAGE"] = this.LANGUAGE_OBJECT;
return(View("~/" + this.THEME_FOLDER + "/" + this.THEME_ACTIVE + "/login.cshtml", loginModel));
//STEP2: NEU DANG NHAP KHONG THANH CONG
}
public ActionResult Create()
{
this.SaveAccessLog("create");
if (null == Session[this.SESSION_NAME_USERID])
{
return(RedirectToAction("Login", "Home"));
}
if (Session["IsAdmin"] is false)
{
return(RedirectToAction("Logout", "Home"));
}
this.SetCommonData();
ViewData["pagename"] = "department_create";
ViewData["action_block"] = "Departments/block_department_create";
ViewData["data-form"] = TempData["data"];
string departId = (Request.QueryString["departid"] == null ? "0" : Request.QueryString["departid"].ToString());
this.SetConnectionDB();
DepartmentServices services = new DepartmentServices(this.DBConnection);
EntityDepartmentModel model = new EntityDepartmentModel();
if (ViewData["data-form"] != null)
{
model = (EntityDepartmentModel)ViewData["data-form"];
}
else
{
model = services.GetEntityById(Int32.Parse(departId));
}
//EntityDepartmentModel modelResponse = services.GetEntityById(Int32.Parse(departId));
this.GetLanguage();
if (model.DepartId > 0)
{
ViewData["pagename"] = "department_edit";
}
if (services.ERROR != null)
{
FileHelper.SaveFile(new { data = model, ERROR = services.ERROR }, this.LOG_FOLDER + "/ERROR_" + this.GetType().ToString() + APIStringHelper.GenerateFileId() + ".txt");
}
BlockDepartmentCreateLangModel blockLang = new BlockDepartmentCreateLangModel();
BI_Project.Models.UI.BlockModel blockModel = new Models.UI.BlockModel("block_department_create", this.LANGUAGE_OBJECT, blockLang);
blockModel.DataModel = model;
ViewData["BlockData"] = blockModel;
return(View("~/" + this.THEME_FOLDER + "/" + this.THEME_ACTIVE + "/index.cshtml"));
}
public EntityDepartmentModel GetEntityById(int id)
{
EntityDepartmentModel output = new EntityDepartmentModel();
try
{
DBConnection.OpenDBConnect();
if (this.DBConnection.ERROR != null)
{
throw new Exception("Can't connect to db");
}
//STEP1: ***************************************************************/
Dictionary <string, object> dicParas = new Dictionary <string, object>();
Dictionary <string, object> dicParaOuts = new Dictionary <string, object>();
dicParas.Add("DEPARTID", id);
DataSet dataSet = DBConnection.ExecSelectSP("SP_DEPART_GET_BY_ID", dicParas, ref dicParaOuts, true);
//**********************TABLE: ROLE***************************************
DataTable table1 = dataSet.Tables[0];
foreach (DataRow row in table1.Rows)
{
output.Name = row["Name"].ToString();
output.DepartId = Int32.Parse(row["Id"].ToString());
output.Filter01 = row["Filter01"].ToString();
output.Code = row["Code"].ToString();
}
//**********************TABLE: ROLEMENU ***********************************************
//DataTable table2 = dataSet.Tables[1];
//foreach (DataRow row in table2.Rows)
//{
// output.ListRoleMenus.Add(Int32.Parse(row["menuid"].ToString()));
//}
}
catch (Exception ex)
{
this.ERROR = ex.ToString();
}
finally
{
this.DBConnection.CloseDBConnect();
}
return(output);
}
public int CreateDepart(EntityDepartmentModel departModel)
{
int output = 0;
try
{
DBConnection.OpenDBConnect();
//STEP1: ***************************************************************/
Dictionary <string, object> dicParas = new Dictionary <string, object>();
Dictionary <string, object> dicParaOuts = new Dictionary <string, object>();
if (departModel.Name != null)
{
dicParas.Add("Name", departModel.Name);
dicParas.Add("Filter01", departModel.Filter01);
dicParas.Add("Code", departModel.Code);
dicParas.Add("Filter02", departModel.Filter02);
if (departModel.DepartId == 0)
{
//dicParas.Add("")
output = DBConnection.ExecSPNonQuery("SP_DEPARTMENT_INSERT", dicParas, ref dicParaOuts, true);
}
else
{
dicParas.Add("DepartId", departModel.DepartId);
output = DBConnection.ExecSPNonQuery("SP_DEPARTMENT_UPDATE", dicParas, ref dicParaOuts, true);
}
}
}
catch (Exception ex)
{
this.ERROR = ex.ToString();
output = -1;
}
finally
{
DBConnection.CloseDBConnect();
}
return(output);
}
public List <EntityDepartmentModel> GetListAdminLogin(string code)
{
List <EntityDepartmentModel> output = new List <EntityDepartmentModel>();
this.DBConnection.OpenDBConnect();
if (this.DBConnection.ERROR != null)
{
throw new Exception("Can't connect to db");
}
try
{
string sqlSelectDepart = " select * from Department where Code = @Code ";
this.DBConnection.command.Parameters.Clear();
this.DBConnection.command.Parameters.AddWithValue("@Code", code);
this.DBConnection.command.CommandText = sqlSelectDepart;
using (SqlDataReader reader = DBConnection.command.ExecuteReader())
{
if (reader.HasRows)
{
while (reader.Read())
{
EntityDepartmentModel entityRole = new EntityDepartmentModel();
entityRole.DepartId = reader.GetInt32(reader.GetOrdinal("Id"));
entityRole.Name = reader.IsDBNull(reader.GetOrdinal("Name")) ? null : reader.GetString(reader.GetOrdinal("Name"));
entityRole.Filter01 = reader.IsDBNull(reader.GetOrdinal("Filter01")) ? null : reader.GetString(reader.GetOrdinal("Filter01"));
entityRole.Code = reader.IsDBNull(reader.GetOrdinal("Code")) ? null : reader.GetString(reader.GetOrdinal("Code"));
output.Add(entityRole);
}
}
}
}
catch (Exception ex)
{
this.ERROR = ex.ToString();
}
finally
{
this.DBConnection.CloseDBConnect();
}
return(output);
}
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"));
}
public ActionResult Create(EntityDepartmentModel model)
{
if (null == Session[this.SESSION_NAME_USERID])
{
return(RedirectToAction("Login", "Home"));
}
if (Session["IsAdmin"] == null)
{
return(RedirectToAction("Logout", "Home"));
}
this.SetConnectionDB();
this.GetLanguage();
int output = 0;
if (model.Code == null)
{
Session["msg_code"] = -1;
Session["msg_text"] = BlockLanguageModel.GetElementLang(this.LANGUAGE_OBJECT, "messages.block_department_create.error_code");
TempData["data"] = model;
return(RedirectToAction("Create"));
}
model.Code = model.Filter01.Substring(0, 2);
DepartmentServices departServices = new DepartmentServices(this.DBConnection);
output = departServices.CreateDepart(model);
/****************************************RESPONSE FAILE OR SUCCESS******************************************/
//this.GetLanguage();
BlockDepartmentCreateLangModel blockLang = new BlockDepartmentCreateLangModel();
blockLang.BlockName = "block_department_create";
blockLang.SetLanguage(this.LANGUAGE_OBJECT);
Session["msg_text"] = blockLang.GetMessage(output);
Session["msg_code"] = output;
if (departServices.ERROR != null)
{
BI_Project.Helpers.FileHelper.SaveFile(departServices.ERROR, this.LOG_FOLDER + "/ERROR_" + this.GetType().ToString() + BI_Project.Helpers.Utility.APIStringHelper.GenerateFileId() + ".txt");
}
if (model.DepartId > 0 && output > 0)
{
Session["msg_text"] = blockLang.GetLangByPath("messages.block_department_create.success_edit", this.LANGUAGE_OBJECT);
}
if (output == 0)
{
Session["msg_text"] = blockLang.GetLangByPath("messages.block_department_create.error_business_1", this.LANGUAGE_OBJECT);
//return RedirectToAction("Create?roleid=" + model.RoleId);
}
if (output > 0)
{
return(RedirectToAction("List"));
}
TempData["data"] = model;
return(RedirectToAction("Create"));
}
