private static void InitUsersRoles()
{
try
{
int id = 0;
string name = string.Empty;
string description = string.Empty;
foreach (UserRole value in Enum.GetValues(typeof(UserRole)))
{
try
{
id = (int)value;
name = value.ToString();
description = string.Empty;
using (UsersDataSetTableAdapters.QueriesTableAdapter q = new UsersDataSetTableAdapters.QueriesTableAdapter())
{
q.MergeUserRole(id, name, description);
}
}
catch (Exception ex)
{
throw new Exception(ExceptionBuilder.ComposeMessage(
MethodBase.GetCurrentMethod().DeclaringType.Name, MethodBase.GetCurrentMethod().Name, ex,
new string[] { id.ToString(), name, description }));
}
}
}
catch (Exception ex)
{
throw new Exception(ExceptionBuilder.ComposeMessage(
MethodBase.GetCurrentMethod().DeclaringType.Name, MethodBase.GetCurrentMethod().Name, ex));
}
}
public static void MergeByWorkers()
{
try
{
using (UsersDataSetTableAdapters.QueriesTableAdapter q =
new UsersDataSetTableAdapters.QueriesTableAdapter())
{
q.MergeUsersByWorkers();
}
}
catch (Exception ex)
{
throw new DbException(
ExceptionBuilder.ComposeMessage(MethodBase.GetCurrentMethod().DeclaringType.Name, MethodBase.GetCurrentMethod().Name, ex));
}
}
public static void UpdateLogoutDate(int id, DateTime logoutDate)
{
try
{
using (UsersDataSetTableAdapters.QueriesTableAdapter q = new UsersDataSetTableAdapters.QueriesTableAdapter())
{
q.UpdateUserLogoutDate(id, logoutDate);
}
}
catch (Exception ex)
{
throw new Exception(ExceptionBuilder.ComposeMessage(
MethodBase.GetCurrentMethod().DeclaringType.Name, MethodBase.GetCurrentMethod().Name, ex,
new string[] { id.ToString(), logoutDate.ToString() }));
}
}
public static void MergeByWorker(int id, string name, string loginName, string password, string badgeCode, string roleName)
{
try
{
using (UsersDataSetTableAdapters.QueriesTableAdapter q = new UsersDataSetTableAdapters.QueriesTableAdapter())
{
q.MergeUserByWorker(id, name, loginName, password, badgeCode, roleName);
}
}
catch (Exception ex)
{
throw new Exception(ExceptionBuilder.ComposeMessage(
MethodBase.GetCurrentMethod().DeclaringType.Name, MethodBase.GetCurrentMethod().Name, ex,
new string[] { id.ToString(), name, loginName, password, badgeCode, roleName }));
}
}
public static void UpdatePassword(string loginName, string password)
{
try
{
using (UsersDataSetTableAdapters.QueriesTableAdapter q = new UsersDataSetTableAdapters.QueriesTableAdapter())
{
q.UpdateUserPassword(loginName, password);
}
}
catch (Exception ex)
{
throw new Exception(ExceptionBuilder.ComposeMessage(
MethodBase.GetCurrentMethod().DeclaringType.Name, MethodBase.GetCurrentMethod().Name, ex,
new string[] { loginName }));
}
}
public static void Merge(int id, string name, string loginName, string password, string badgeCode, string roleName, int autoLogoutTime, string emailAddress, bool messengerEnabled)
{
try
{
using (UsersDataSetTableAdapters.QueriesTableAdapter q = new UsersDataSetTableAdapters.QueriesTableAdapter())
{
q.MergeUser(id, name, loginName, password, badgeCode, roleName, autoLogoutTime, emailAddress, messengerEnabled);
}
}
catch (Exception ex)
{
throw new Exception(ExceptionBuilder.ComposeMessage(
MethodBase.GetCurrentMethod().DeclaringType.Name, MethodBase.GetCurrentMethod().Name, ex,
new string[] { id.ToString(), name, loginName, password, badgeCode, roleName,
autoLogoutTime.ToString(), emailAddress, messengerEnabled.ToString() }));
}
}
public static string GetName(int id)
{
string ret = string.Empty;
try
{
using (UsersDataSetTableAdapters.QueriesTableAdapter q = new UsersDataSetTableAdapters.QueriesTableAdapter())
{
ret = q.GetUserName(id);
}
}
catch (Exception ex)
{
throw new Exception(ExceptionBuilder.ComposeMessage(
MethodBase.GetCurrentMethod().DeclaringType.Name, MethodBase.GetCurrentMethod().Name, ex,
new string[] { id.ToString() }));
}
return(ret);
}
public static int GetId(string loginName)
{
int ret;
try
{
using (UsersDataSetTableAdapters.QueriesTableAdapter q = new UsersDataSetTableAdapters.QueriesTableAdapter())
{
ret = q.GetUserId(loginName) ?? 0;
}
}
catch (Exception ex)
{
throw new Exception(ExceptionBuilder.ComposeMessage(
MethodBase.GetCurrentMethod().DeclaringType.Name, MethodBase.GetCurrentMethod().Name, ex,
new string[] { loginName }));
}
return(ret);
}
public static bool Exists(string loginName)
{
bool ret = false;
try
{
using (UsersDataSetTableAdapters.QueriesTableAdapter q = new UsersDataSetTableAdapters.QueriesTableAdapter())
{
ret = q.UserExists(loginName) ?? false;
}
}
catch (Exception ex)
{
throw new Exception(ExceptionBuilder.ComposeMessage(
MethodBase.GetCurrentMethod().DeclaringType.Name, MethodBase.GetCurrentMethod().Name, ex,
new string[] { loginName }));
}
return(ret);
}
public static int Create(string name, string loginName, string password, string badgeCode, string roleName, int autoLogoutTime, string emailAddress, bool messengerEnabled)
{
int ret = 0;
try
{
using (UsersDataSetTableAdapters.QueriesTableAdapter q = new UsersDataSetTableAdapters.QueriesTableAdapter())
{
q.CreateUser(name, loginName, password, badgeCode, roleName, autoLogoutTime, emailAddress, messengerEnabled);
ret = q.GetLastId("Users") ?? 0;
}
}
catch (Exception ex)
{
throw new Exception(ExceptionBuilder.ComposeMessage(
MethodBase.GetCurrentMethod().DeclaringType.Name, MethodBase.GetCurrentMethod().Name, ex,
new string[] { name, loginName, password, badgeCode, roleName,
autoLogoutTime.ToString(), emailAddress, messengerEnabled.ToString() }));
}
return(ret);
}
