/// <summary>
/// This method loads the information from the sqlreader into the Employee object
/// </summary>
/// <param name="reader"></param>
/// <param name="employee"></param>
private static void LoadEmployeeObject(MySqlDataReader reader, Employee employee)
{
employee.FKCompanyUID = Convert.ToInt32(reader[FieldName.FKCompanyUID]);
employee.UID = Convert.ToInt32(reader[FieldName.UID].ToString());
employee.Name = reader[FieldName.Name].ToString();
employee.RoleType = reader[FieldName.RoleType].ToString();
employee.Address = reader[FieldName.Address].ToString();
employee.Phone = reader[FieldName.Phone].ToString();
employee.Fax = reader[FieldName.Fax].ToString();
employee.UserIdCreatedBy = reader[FieldName.UserIdCreatedBy].ToString();
employee.UserIdUpdatedBy = reader[FieldName.UserIdCreatedBy].ToString();
employee.RoleDescription = CodeValue.GetCodeValueDescription(MakConstant.CodeTypeString.RoleType, employee.RoleType);
try { employee.IsAContact = Convert.ToChar(reader[FieldName.IsAContact].ToString()); }
catch { employee.IsAContact = 'N'; }
try { employee.EmailAddress = reader[FieldName.EmailAddress].ToString(); }
catch { employee.EmailAddress = ""; }
try
{
employee.UpdateDateTime = Convert.ToDateTime(reader[FieldName.UpdateDateTime].ToString());
}
catch
{
employee.UpdateDateTime = DateTime.Now;
}
try
{
employee.CreationDateTime = Convert.ToDateTime(reader[FieldName.CreationDateTime].ToString());
}
catch
{
employee.CreationDateTime = DateTime.Now;
}
}
/// <summary>
/// Show error message.
/// </summary>
/// <param name="errorCode"></param>
public static void ShowFCMMessage(
string errorCode,
string userID,
string additionalMessage = "",
string programName = "")
{
if (string.IsNullOrEmpty(errorCode))
{
return;
}
string messageType = errorCode.Substring(3, 3);
MessageBoxIcon icon = MessageBoxIcon.Error;
switch (messageType)
{
case "ERR":
icon = MessageBoxIcon.Error;
break;
case "WAR":
icon = MessageBoxIcon.Warning;
break;
case "INF":
icon = MessageBoxIcon.Information;
break;
}
string errorDescription =
CodeValue.GetCodeValueDescription(
FCMConstant.CodeTypeString.ErrorCode,
errorCode);
MessageBox.Show(errorDescription + " " + additionalMessage,
errorCode,
MessageBoxButtons.OK,
icon);
LogFile.WriteToTodaysLogFile(
errorDescription + " " + additionalMessage,
userID,
errorCode,
programName);
return;
}
/// <summary>
/// Get List of screens of user
/// </summary>
/// <param name="userID"></param>
/// <returns></returns>
public static List <CodeValue> GetListScreensForUser(string userID)
{
var list = new List <CodeValue>();
var listOfRoles = new List <SecurityUserRole>();
SecurityUserRole userRole = new SecurityUserRole(HeaderInfo.Instance);
var response = userRole.ListRoleForUser(userID, listOfRoles);
foreach (var role in listOfRoles)
{
// get list of screen for role
//
var listOfScreen = SecurityRoleScreen.List(role.FK_Role);
foreach (var cvScreen in listOfScreen)
{
var screenAsCodeValue = new CodeValue();
screenAsCodeValue.ID = cvScreen.FKScreenCode;
screenAsCodeValue.Description = CodeValue.GetCodeValueDescription(
FCMConstant.CodeTypeString.SCREENCODE, cvScreen.FKScreenCode);
bool found = false;
foreach (var alreadyInListScreen in list)
{
if (cvScreen.FKScreenCode == alreadyInListScreen.ID)
{
found = true;
break;
}
}
if (found)
{
continue;
}
list.Add(screenAsCodeValue);
}
}
return(list);
}
/// <summary>
/// Get List of screens of user
/// </summary>
/// <param name="userID"></param>
/// <returns></returns>
public static List <CodeValue> GetListScreensForUser(string userID)
{
List <CodeValue> list = new List <CodeValue>();
// Retrieve list of roles for user
var listOfRoles = FCMUserRole.ListRoleForUser(userID);
foreach (var role in listOfRoles)
{
// get list of screen for role
//
var listOfScreen = FCMRoleScreen.List(role.FK_Role);
foreach (var cvScreen in listOfScreen)
{
var screenAsCodeValue = new CodeValue();
screenAsCodeValue.ID = cvScreen.FKScreenCode;
screenAsCodeValue.Description = CodeValue.GetCodeValueDescription(
FCMConstant.CodeTypeString.SCREENCODE, cvScreen.FKScreenCode);
bool found = false;
foreach (var alreadyInListScreen in list)
{
if (cvScreen.FKScreenCode == alreadyInListScreen.ID)
{
found = true;
break;
}
}
if (found)
{
continue;
}
list.Add(screenAsCodeValue);
}
}
return(list);
}
