|
private fn_show_users ( string username, byte password ) : IQueryable |
||
| username | string | |
| password | byte | |
| return | IQueryable |
|
/// <summary>
/// PSP 8.5
/// entfernt user anhand von usernameName
/// </summary>
/// <param name="username"></param>
/// <param name="password"></param>
/// <param name="usernameName"></param>
/// <returns>success -> ob erfolgreich oder nicht</returns>
public static bool removeUser(string username, string password, string usernameName)
{
bool success = false;
//Übergebenes Passwort hashen und in Var pwhash speichern für Übergabe an DB
Byte[] pwhash = HelperClass.GetHash(password);
using (itin18_aktEntities cont = new itin18_aktEntities())
{
//Durchlaufen der User mittels DB-Funktion
foreach (var item in cont.fn_show_users(username, pwhash))
{
//Prüfung des Usernamens
if (item.name == usernameName)
{
try
{
//Löschen des Users
//item.id = Id des Users
cont.sp_delete_user(username, pwhash, item.id);
success = true;
}
catch (Exception e)
{
success = false;
}
}
}
return success;
}
}
/// <summary>
/// User aus der User-Gruppe löschen
/// </summary>
/// <param name="username">Username</param>
/// <param name="password">Passwort</param>
/// <param name="userId">User Id</param>
/// <param name="groupId">Gruppen Id</param>
/// <returns>success</returns>
public static bool deleteUserFromUsergroup(string username, string password, int userId, int groupId)
{
bool success = false;
//Übergebenes Passwort hashen und in Var pwhash speichern für Übergabe an DB
Byte[] pwhash = HelperClass.GetHash(password);
using (itin18_aktEntities cont = new itin18_aktEntities())
{
List<fn_show_users_Result> sur = cont.fn_show_users(username, pwhash).ToList();
List<fn_show_usergroup_Result> ugr = cont.fn_show_usergroup(username, pwhash).ToList();
string ugrName = "";
foreach (var item in ugr)
{
if (item.id == groupId)
{
ugrName = item.groupname;
}
}
foreach (var item in sur)
{
//Überprüfung der User Id und des Gruppennamens
if (item.id == userId && item.group == ugrName)
{
try
{
//Löschen des Users aus der UserGruppe
cont.sp_delete_user_from_usergroup(username, pwhash, item.id, userId);
success = true;
}
catch (Exception e)
{
success = false;
}
}
}
}
return success;
}
/// <summary>
/// Die in der DB eingetragenen User als Liste
/// </summary>
/// <param name="username">Username</param>
/// <param name="password">Passwort</param>
/// <returns>Liste des Datentyp's "fn_show_users_Result". D.h. einen Table aller User</returns>
public static List<fn_show_users_Result> GetAllUser(string username, string password)
{
Byte[] pwhash = HelperClass.GetHash(password);
using (itin18_aktEntities cont = new itin18_aktEntities())
{
List<fn_show_users_Result> tmp = new List<fn_show_users_Result>();
try
{
return cont.fn_show_users(username, pwhash).ToList();
}
catch (Exception e)
{
//Fehlermeldung in die leere Liste hinzufügen, die FM wird als Username eingetragen
tmp.Add(new fn_show_users_Result { group = " ", name = "Keine Datenbankverbindung" });
tmp.Add(new fn_show_users_Result { group = " ", name = "No database connection" });
return tmp;
}
}
}