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