private void grid_UserAcc_cell_click(object sender, MouseButtonEventArgs e) { try { UASUSR userAccData = (UASUSR)grid_UserAcc.SelectedItem; if (userAccData == null) { return; } UA_UserID.txt_Content.Text = userAccData.USER_ID == null ? string.Empty : userAccData.USER_ID; UA_Password.pwd_Password.Password = userAccData.PASSWD == null ? string.Empty : userAccData.PASSWD; UA_ConfrimPassword.pwd_Password.Password = userAccData.PASSWD == null ? string.Empty : userAccData.PASSWD; UA_UserName.txt_Content.Text = userAccData.USER_NAME == null ? string.Empty : userAccData.USER_NAME; UA_Group.combo_Content.Text = userAccData.USER_GRP == null ? string.Empty : userAccData.USER_GRP; UA_BadgeNumber.txt_Content.Text = userAccData.BADGE_NUMBER == null ? string.Empty : userAccData.BADGE_NUMBER; if (userAccData.isDisable()) { UA_AccountActivation.radbtn_Yes.IsChecked = false; UA_AccountActivation.radbtn_No.IsChecked = true; } else { UA_AccountActivation.radbtn_Yes.IsChecked = true; UA_AccountActivation.radbtn_No.IsChecked = false; } UA_Department.txt_Content.Text = userAccData.DEPARTMENT == null ? string.Empty : userAccData.DEPARTMENT; } catch (Exception ex) { logger.Error(ex, "Exception"); } }
public Boolean checkUserPassword(string user_id, string password) { DBConnection_EF conn = null; Boolean result = false; try { conn = DBConnection_EF.GetContext(); conn.BeginTransaction(); UASUSR loginUser = userDao.getUser(conn, false, user_id); if (loginUser == null) { result = false; } else if (SCUtility.isMatche(loginUser.PASSWD, password)) { result = true; } conn.Commit(); } catch (Exception ex) { logger.Warn("Load User Function Failed from UASUFNC [user_id:{0}]", user_id, ex); result = false; } finally { if (conn != null) { try { conn.Close(); } catch { } } } return(result); }
//A0.02 Start public UASUSR getUserByBadge(string badge_no) { UASUSR rtnUser = new UASUSR(); DBConnection_EF conn = null; try { conn = DBConnection_EF.GetContext(); conn.BeginTransaction(); rtnUser = userDao.getUserByBadge(conn, badge_no); conn.Commit(); } catch (Exception ex) { logger.Warn("Load User Failed from UASUSR", ex); } finally { if (conn != null) { try { conn.Close(); } catch (Exception exception) { logger.Warn("Close Connection Failed.", exception); } } } return(rtnUser); }
public UASUSR getAdminUser() { UASUSR admin = null; DBConnection_EF conn = null; try { conn = DBConnection_EF.GetContext(); conn.BeginTransaction(); admin = userDao.getAdminUser(conn); conn.Commit(); } catch (Exception ex) { logger.Warn("Get Admin User Failed from UASUSR", ex); } finally { if (conn != null) { try { conn.Close(); } catch (Exception exception) { logger.Warn("Close Connection Failed.", exception); } } } return(admin); }
//A0.01 public Boolean createUser(string user_id, string user_name, string passwd, Boolean isDisable, Boolean isPowerUser) public Boolean createUser(string user_id, string user_name, string passwd, Boolean isDisable, string user_grp, string badge_no, string department) //A0.01 { DBConnection_EF conn = null; try { UASUSR newUser = new UASUSR { USER_ID = user_id.ToUpper(), USER_NAME = user_name, PASSWD = passwd, DISABLE_FLG = (isDisable ? SCAppConstants.YES_FLAG : SCAppConstants.NO_FLAG), //POWER_USER_FLG = (isPowerUser ? SCAppConstants.YES_FLAG : SCAppConstants.NO_FLAG), POWER_USER_FLG = SCAppConstants.NO_FLAG, USER_GRP = user_grp, //A0.01 BADGE_NUMBER = badge_no, //ADMIN_FLG = (isAdmin ? SCAppConstants.YES_FLAG : SCAppConstants.NO_FLAG), ADMIN_FLG = SCAppConstants.NO_FLAG, DEPARTMENT = department }; conn = DBConnection_EF.GetContext(); conn.BeginTransaction(); userDao.insertUser(conn, newUser); conn.Commit(); } catch (Exception ex) { logger.Warn("Insert Failed to UASUSR [user_id:{0}]", user_id, ex); if (conn != null) { try { conn.Rollback(); } catch (Exception exception) { logger.Warn("Rollback Failed.", exception); } } return(false); } finally { if (conn != null) { try { conn.Close(); } catch (Exception exception) { logger.Warn("Close Connection Failed.", exception); } } } return(true); }
//A0.01 public Boolean updateUser(string user_id, string user_name, string passwd, Boolean isDisable, Boolean isPowerUser) public Boolean updateUser(string user_id, string user_name, string passwd, Boolean isDisable, string user_grp, string badgeNo, string department) //A0.01 { DBConnection_EF conn = null; try { conn = DBConnection_EF.GetContext(); conn.BeginTransaction(); UASUSR updUser = userDao.getUser(conn, true, user_id); updUser.USER_NAME = user_name; if (passwd != null && passwd.Trim().Length > 0) { updUser.PASSWD = passwd; } updUser.DISABLE_FLG = (isDisable ? SCAppConstants.YES_FLAG : SCAppConstants.NO_FLAG); //updUser.POWER_USER_FLG = (isPowerUser ? SCAppConstants.YES_FLAG : SCAppConstants.NO_FLAG); //updUser.ADMIN_FLG = (isAdmin ? SCAppConstants.YES_FLAG : SCAppConstants.NO_FLAG); updUser.USER_GRP = user_grp; updUser.BADGE_NUMBER = badgeNo; updUser.DEPARTMENT = department; userDao.updateUser(conn, updUser); conn.Commit(); } catch (Exception ex) { logger.Warn("Update Failed to UASUSR [user_id:{0}]", user_id, ex); if (conn != null) { try { conn.Rollback(); } catch (Exception exception) { logger.Warn("Rollback Failed.", exception); } } return(false); } finally { if (conn != null) { try { conn.Close(); } catch (Exception exception) { logger.Warn("Close Connection Failed.", exception); } } } return(true); }
private void UserDataGridView_Click(object sender, EventArgs e) { UASUSR selectUser = getSelectedRowToTextBox(); if (selectUser == null) { return; } //A0.01 fillUserDataToTextBox(selectUser.User_ID, selectUser.User_Name, selectUser.Disable_Flg, selectUser.Power_User_Flg); fillUserDataToTextBox(selectUser.USER_ID, selectUser.USER_NAME, selectUser.DISABLE_FLG, selectUser.POWER_USER_FLG, selectUser.USER_GRP); //A0.01 }
/// <summary> /// Logins as admin. /// </summary> /// <param name="bcApp">The bc application.</param> /// <returns>Boolean.</returns> public static Boolean loginAsAdmin(BCApplication bcApp) { UASUSR admin = bcApp.SCApplication.UserBLL.getAdminUser(); if (admin == null) { return(false); } bcApp.login(admin); return(true); }
public void updateUser(DBConnection_EF conn, UASUSR user) { try { conn.SaveChanges(); } catch (Exception ex) { logger.Warn(ex); throw; } }
public void insertUser(DBConnection_EF conn, UASUSR user) { try { conn.UASUSR.Add(user); conn.SaveChanges(); } catch (Exception ex) { logger.Warn(ex); throw; } }
public Boolean checkUserAuthority(string user_id, string function_code) { DBConnection_EF conn = null; Boolean result = true; try { conn = DBConnection_EF.GetContext(); conn.BeginTransaction(); UASUSR loginUser = userDao.getUser(conn, false, user_id); if (loginUser == null) { result = false; } else if (loginUser.isPowerUser()) { result = true; } else { //A0.01 UserFunc userFunc = userFuncDao.getUserFunc(conn, user_id, function_code); UASUFNC userFunc = userFuncDao.getUserFunc(conn, loginUser.USER_GRP, function_code); if (userFunc == null) { result = false; } } conn.Commit(); } catch (Exception ex) { logger.Warn("Load User Function Failed from UASUFNC [user_id:{0}]", user_id, ex); result = false; } finally { if (conn != null) { try { conn.Close(); } catch (Exception exception) { logger.Warn("Close Connection Failed.", exception); } } } return(result); }
public Boolean updatePassword(string user_id, string passwd) { DBConnection_EF conn = null; try { conn = DBConnection_EF.GetContext(); conn.BeginTransaction(); UASUSR updUser = userDao.getUser(conn, true, user_id); if (passwd != null && passwd.Trim().Length > 0) { updUser.PASSWD = passwd; } userDao.updateUser(conn, updUser); conn.Commit(); } catch (Exception ex) { logger.Warn("Update Failed to UASUSR [user_id:{0}]", user_id, ex); if (conn != null) { try { conn.Rollback(); } catch (Exception exception) { logger.Warn("Rollback Failed.", exception); } } return(false); } finally { if (conn != null) { try { conn.Close(); } catch (Exception exception) { logger.Warn("Close Connection Failed.", exception); } } } return(true); }
public Boolean deleteUser(string user_id) { DBConnection_EF conn = null; try { conn = DBConnection_EF.GetContext(); conn.BeginTransaction(); UASUSR delUser = userDao.getUser(conn, true, user_id); if (!delUser.isAdmin()) { userDao.deleteUserByID(conn, user_id); } conn.Commit(); } catch (Exception ex) { logger.Warn("Delete Failed From UASUSR [user_id:{0}]", user_id, ex); if (conn != null) { try { conn.Rollback(); } catch (Exception exception) { logger.Warn("Rollback Failed.", exception); } } return(false); } finally { if (conn != null) { try { conn.Close(); } catch (Exception exception) { logger.Warn("Close Connection Failed.", exception); } } } return(true); }
public void deleteUserByID(DBConnection_EF conn, string user_id) { try { UASUSR rtnUser = null; var query = from user in conn.UASUSR where user.ADMIN_FLG == SCAppConstants.YES_FLAG.Trim() select user; conn.UASUSR.Remove(rtnUser); conn.SaveChanges(); } catch (Exception ex) { logger.Warn(ex); throw; } }
public void deleteUserByID(DBConnection_EF conn, string user_id) { try { UASUSR rtnUser = null; var query = from user in conn.UASUSR select user; rtnUser = query.FirstOrDefault(); conn.UASUSR.Remove(rtnUser); conn.SaveChanges(); } catch (Exception ex) { logger.Warn(ex); throw; } }
public Boolean createUser(UASUSR user) { DBConnection_EF conn = null; try { if (user == null) { return(false); } conn = DBConnection_EF.GetContext(); userDao.insertUser(conn, user); } catch (Exception ex) { logger.Warn("Insert Failed to UASUSR [user_id:{0}]", user.USER_ID, ex); if (conn != null) { try { conn.Rollback(); } catch (Exception exception) { logger.Warn("Rollback Failed.", exception); } } return(false); } finally { if (conn != null) { try { conn.Close(); } catch (Exception exception) { logger.Warn("Close Connection Failed.", exception); } } } return(true); }
private UASUSR getSelectedRowToTextBox() { int selectedRowCnt = UserDataGridView.Rows.GetRowCount(DataGridViewElementStates.Selected); if (selectedRowCnt <= 0) { return(null); } int selectedIndex = UserDataGridView.SelectedRows[0].Index; if (userDataList.Count <= selectedIndex) { return(null); } UASUSR selectUser = userDataList[selectedIndex]; return(selectUser); }
public UASUSR getUser(DBConnection_EF conn, Boolean readLock, string user_id) { UASUSR rtnUser = null; try { var query = from user in conn.UASUSR where user.USER_ID == user_id.Trim() select user; rtnUser = query.SingleOrDefault(); } catch (Exception ex) { logger.Warn(ex); throw; } return(rtnUser); }
//A0.01 Start public UASUSR getUserByBadge(DBConnection_EF conn, string badge_no) { UASUSR rtnUser = null; try { var query = from user in conn.UASUSR where user.BADGE_NUMBER == badge_no.Trim() select user; rtnUser = query.SingleOrDefault(); } catch (Exception ex) { logger.Warn(ex); throw; } return(rtnUser); }
//A0.01 End public UASUSR getAdminUser(DBConnection_EF conn) { UASUSR rtnUser = null; try { var query = from user in conn.UASUSR where user.ADMIN_FLG == SCAppConstants.YES_FLAG.Trim() select user; rtnUser = query.SingleOrDefault(); } catch (Exception ex) { logger.Warn(ex); throw; } return(rtnUser); }
private void DelBtn_Click(object sender, EventArgs e) { UASUSR selectUser = getSelectedRowToTextBox(); if (selectUser == null) { return; } if (!BCUtility.doLogin(this, bcApp, BCAppConstants.FUNC_USER_MANAGEMENT)) { return; } var confirmResult = MessageBox.Show(this, "Are you sure to delete this item ?", "Confirm Delete!", MessageBoxButtons.YesNo); if (confirmResult != DialogResult.Yes) { return; } Boolean deleteSuccess = bcApp.SCApplication.UserBLL.deleteUser(selectUser.USER_ID); if (deleteSuccess) { //MessageBox.Show(this, BCApplication.getMessageString("DELETE_SUCCESS")); BCUtility.showMsgBox_Info(this, BCApplication.getMessageString("DELETE_SUCCESS")); Refresh(); } else { //MessageBox.Show(this, BCApplication.getMessageString("DELETE_FAILED")); BCUtility.showMsgBox_Info(this, BCApplication.getMessageString("DELETE_FAILED")); } }
/// <summary> /// Logins the specified user. /// </summary> /// <param name="user">The user.</param> public void login(UASUSR user) { login(user.USER_ID); }