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