/// <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); }