private static bool SetManagerAndDirector(clsUser user, String division) { bool mRetVal = false; Database db = MyDLLs.MyDBFactory.GetDatabase(OPGlobals.dbProvider); DbConnection conn = db.CreateDbConnection(Database.ConnectionType.ConnectionString, OPGlobals.connString); DataTable tb, tb2; string mUserPermission, strsql; strsql = "SELECT * FROM manager WHERE manager_subdept = '" + division + "';"; tb = db.GetDataTable(conn, strsql); if (tb.Rows.Count > 0) { user.DirectorID = tb.Rows[0]["manager_id"].ToString(); user.ManagerID = tb.Rows[0]["id"].ToString(); strsql = "SELECT * FROM manager WHERE manager_login_name = '" + user.UserID + "';"; tb2 = db.GetDataTable(conn, strsql); if (tb2.Rows.Count > 0) { mUserPermission = tb2.Rows[0]["manager_permission"].ToString(); } else { mUserPermission = tb.Rows[0]["manager_permission"].ToString(); } user.Permission = (UserRights)int.Parse(mUserPermission); if (user.LoginName == tb.Rows[0]["manager_login_name"].ToString()) { user.UserID = tb.Rows[0]["manager_login_name"].ToString(); } mRetVal = true; } return(mRetVal); }
private static void disableMenuItems(clsUser aduser) { Database db = MyDLLs.MyDBFactory.GetDatabase(OPGlobals.dbProvider); DbConnection conn = db.CreateDbConnection(Database.ConnectionType.ConnectionString, OPGlobals.connString); DataTable tb = db.GetDataTable(conn, "SELECT * FROM program_settings;"); if (aduser.LoginName.Equals("timm", StringComparison.OrdinalIgnoreCase) || aduser.LoginName.Equals("samanthar", StringComparison.OrdinalIgnoreCase) || aduser.LoginName.Equals("sudinthap", StringComparison.OrdinalIgnoreCase) || aduser.LoginName.Equals("stewartt", StringComparison.OrdinalIgnoreCase)) //if (aduser.UserName.Equals("mccleti", StringComparison.InvariantCultureIgnoreCase) // || aduser.UserName.Equals("ratlesa", StringComparison.InvariantCultureIgnoreCase) // || aduser.Permission == UserRights.Administrator) { OPGlobals.CapitalWorksEnabled = true; OPGlobals.DeliveryProgramEnabled = true; } else { OPGlobals.CapitalWorksEnabled = Convert.ToBoolean(Convert.ToInt32(tb.Rows[0][0].ToString())); OPGlobals.DeliveryProgramEnabled = Convert.ToBoolean(Convert.ToInt32(tb.Rows[0][1].ToString())); } }
private static void SetMenus(clsUser user) { List <string> default_usermenu = new List <string> { "D01", "D02", "D03", "D06", "D07" }; //Disable Options List <string> temp = new List <string> { }; switch (user.Permission) { case UserRights.Administrator: //user.DisableMenuOptions = new List<string> { }; break; case UserRights.GM: temp = new List <string> { "A07", "A08", "A07_1" }; break; case UserRights.Editor: temp = new List <string> { "A07" }; //user.DisableMenuOptions = default_usermenu.Concat(temp).ToList(); break; case UserRights.Director: temp = new List <string> { "A01", "A02", "A03", "A04", "A05", "A06", "A07", "A07_1", "A08", "E01" }; //user.DisableMenuOptions = default_usermenu.Concat(temp).ToList(); break; case UserRights.Manager: temp = new List <string> { "A01", "A02", "A03", "A04", "A05", "A06", "A07", "A07_1", "A08", "E01" }; //user.DisableMenuOptions = default_usermenu.Concat(temp).ToList(); break; case UserRights.Finance: temp = new List <string> { "A01", "A02", "A03", "A04", "A05", "A06", "A08", "E01" }; //user.DisableMenuOptions = default_usermenu.Concat(temp).ToList(); break; default: temp = new List <string> { "A01", "A02", "A03", "A04", "A05", "A06", "A07", "A07_1", "A08", "E01" }; //user.DisableMenuOptions = default_usermenu.Concat(temp).ToList(); break; } if (temp.Count > 0) { user.DisableMenuOptions = default_usermenu.Concat(temp).ToList(); } }