private static void InitWorkerFunctions()
{
try
{
int id = 0;
string name = string.Empty;
string description = string.Empty;
foreach (WorkerFunction value in Enum.GetValues(typeof(WorkerFunction)))
{
try
{
id = (int)value;
name = value.ToString();
description = name;
using (WorkersDataSetTableAdapters.QueriesTableAdapter q = new WorkersDataSetTableAdapters.QueriesTableAdapter())
{
q.MergeWorkerFunction(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 Merge(int id, string name, string description, int accessLevel)
{
try
{
using (WorkersDataSetTableAdapters.QueriesTableAdapter q = new WorkersDataSetTableAdapters.QueriesTableAdapter())
{
q.MergeRole(id, name, description, accessLevel);
}
}
catch (Exception ex)
{
throw new Exception(ExceptionBuilder.ComposeMessage(
MethodBase.GetCurrentMethod().DeclaringType.Name, MethodBase.GetCurrentMethod().Name, ex,
new string[] { id.ToString(), name, description, accessLevel.ToString() }));
}
}
public static void Delete(string name)
{
try
{
using (WorkersDataSetTableAdapters.QueriesTableAdapter q = new WorkersDataSetTableAdapters.QueriesTableAdapter())
{
q.DeleteRole(name);
}
}
catch (Exception ex)
{
throw new Exception(ExceptionBuilder.ComposeMessage(
MethodBase.GetCurrentMethod().DeclaringType.Name, MethodBase.GetCurrentMethod().Name, ex,
new string[] { name }));
}
}
public static void UpdateLogoutDateOnStation(int id, string stationName, DateTime logoutDate)
{
try
{
using (WorkersDataSetTableAdapters.QueriesTableAdapter q = new WorkersDataSetTableAdapters.QueriesTableAdapter())
{
q.UpdateStationWorkerLogoutDate(id, stationName, logoutDate);
}
}
catch (Exception ex)
{
throw new Exception(ExceptionBuilder.ComposeMessage(
MethodBase.GetCurrentMethod().DeclaringType.Name, MethodBase.GetCurrentMethod().Name, ex,
new string[] { id.ToString(), stationName, logoutDate.ToString() }));
}
}
public static void UpdatePassword(string loginName, string password)
{
try
{
using (WorkersDataSetTableAdapters.QueriesTableAdapter q = new WorkersDataSetTableAdapters.QueriesTableAdapter())
{
q.UpdateWorkerPassword(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 code, string roleName, string userRoleName)
{
try
{
using (WorkersDataSetTableAdapters.QueriesTableAdapter q = new WorkersDataSetTableAdapters.QueriesTableAdapter())
{
q.MergeWorker(id, name, loginName, password, badgeCode, code, roleName);
}
}
catch (Exception ex)
{
throw new Exception(ExceptionBuilder.ComposeMessage(
MethodBase.GetCurrentMethod().DeclaringType.Name, MethodBase.GetCurrentMethod().Name, ex,
new string[] { name, loginName, password, badgeCode, code, roleName }));
}
}
public static bool Exists(string name)
{
bool ret = false;
try
{
using (WorkersDataSetTableAdapters.QueriesTableAdapter q = new WorkersDataSetTableAdapters.QueriesTableAdapter())
{
ret = q.RoleExists(name) ?? false;
}
}
catch (Exception ex)
{
throw new Exception(ExceptionBuilder.ComposeMessage(
MethodBase.GetCurrentMethod().DeclaringType.Name, MethodBase.GetCurrentMethod().Name, ex,
new string[] { name }));
}
return(ret);
}
public static bool GetFunctionPermission(string loginName, WorkerFunction workerFunction)
{
bool ret = false;
try
{
using (WorkersDataSetTableAdapters.QueriesTableAdapter q = new WorkersDataSetTableAdapters.QueriesTableAdapter())
{
ret = q.GetWorkerPermission(loginName, workerFunction.ToString()) ?? false;
}
}
catch (Exception ex)
{
throw new Exception(ExceptionBuilder.ComposeMessage(
MethodBase.GetCurrentMethod().DeclaringType.Name, MethodBase.GetCurrentMethod().Name, ex,
new string[] { loginName, workerFunction.ToString() }));
}
return(ret);
}
public static string GetName(int id)
{
string ret = string.Empty;
try
{
using (WorkersDataSetTableAdapters.QueriesTableAdapter q = new WorkersDataSetTableAdapters.QueriesTableAdapter())
{
ret = q.GetWorkerName(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 = 0;
try
{
using (WorkersDataSetTableAdapters.QueriesTableAdapter q = new WorkersDataSetTableAdapters.QueriesTableAdapter())
{
ret = q.GetWorkerId(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 int Create(string name, string description, int accessLevel)
{
int ret = 0;
try
{
using (WorkersDataSetTableAdapters.QueriesTableAdapter q = new WorkersDataSetTableAdapters.QueriesTableAdapter())
{
q.CreateRole(name, description, accessLevel);
ret = q.GetLastId("Roles") ?? 0;
}
}
catch (Exception ex)
{
throw new Exception(ExceptionBuilder.ComposeMessage(
MethodBase.GetCurrentMethod().DeclaringType.Name, MethodBase.GetCurrentMethod().Name, ex,
new string[] { name, description, accessLevel.ToString() }));
}
return(ret);
}
public static int Create(string name, string loginName, string password, string badgeCode, string code, string roleName)
{
int ret = 0;
try
{
using (WorkersDataSetTableAdapters.QueriesTableAdapter q = new WorkersDataSetTableAdapters.QueriesTableAdapter())
{
q.CreateWorker(name, loginName, password, badgeCode, code, roleName);
ret = q.GetLastId("Workers") ?? 0;
}
}
catch (Exception ex)
{
throw new Exception(ExceptionBuilder.ComposeMessage(
MethodBase.GetCurrentMethod().DeclaringType.Name, MethodBase.GetCurrentMethod().Name, ex,
new string[] { name, loginName, password, badgeCode, code, roleName }));
}
return(ret);
}
