|
public sp_delete_user ( string username, byte password, Nullable |
||
| username | string | |
| password | byte | |
| del_id | Nullable |
|
| return | int | |
/// <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>
/// PSP 8.3
/// Entfernt User anhand von usernameId
/// </summary>
/// <param name="username"></param>
/// <param name="password"></param>
/// <param name="usernameId"></param>
/// <returns>success -> ob erfolgreich oder nicht</returns>
public static bool removeUser(string username, string password, int usernameId)
{
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())
{
try
{
//User wird gelöscht
cont.sp_delete_user(username, pwhash, usernameId);
success = true;
}
catch (Exception e)
{
success = false;
}
}
return success;
}