/// <summary>
/// Update user information in user table from frmCreateUser form.
/// </summary>
/// <returns></returns>
public bool UpdateUser(RBACD.DatalayerDef.sUser userInfo)
{
OdbcTransaction tran = null;
string sql = string.Empty;
try
{
OdbcConnection con = (OdbcConnection)this.DbConnection;
OdbcCommand cmd = new OdbcCommand();
cmd.CommandType = CommandType.Text;
cmd.Connection = con;
tran = con.BeginTransaction();
cmd.Transaction = tran;
sql = "UPDATE rbac.users SET UserName='******' , Password='******' , FirstName='" + userInfo.FirstName + "', LastName='" + userInfo.LastName + "', Citizenship='" + userInfo.Citizenship + "' WHERE UserId ='" + userInfo.UserId + "'";
cmd.CommandText = sql;
cmd.ExecuteNonQuery();
tran.Commit();
return(true);
}
catch
{
if (tran != null)
{
tran.Rollback();
}
return(false);
}
}
/// <summary>
/// Save user information in user table from frmCreateUser form.
/// </summary>
/// <returns></returns>
public bool SaveUser(RBACD.DatalayerDef.sUser userInfo)
{
OdbcTransaction tran = null;
string sql = string.Empty;
try
{
OdbcConnection con = (OdbcConnection)this.DbConnection;
OdbcCommand cmd = new OdbcCommand();
cmd.CommandType = CommandType.Text;
cmd.Connection = con;
tran = con.BeginTransaction();
cmd.Transaction = tran;
sql = "INSERT INTO rbac.users (UserName, Password, FirstName, LastName, Citizenship) VALUES('" + userInfo.UserName + "', '" + userInfo.Password + "', '" + userInfo.FirstName + "', '" + userInfo.LastName + "', '" + userInfo.Citizenship + "')";
cmd.CommandText = sql;
cmd.ExecuteNonQuery();
tran.Commit();
return(true);
}
catch
{
if (tran != null)
{
tran.Rollback();
}
return(false);
}
}
/*
* /// <summary>
* /// Get all the user from user table
* /// </summary>
* /// <returns>DataSet</returns>
* public DataSet GetAllUser()
* {
* DataSet ds = new DataSet();
* string sql = string.Empty;
* try
* {
* sql = "SELECT * FROM users";
* OdbcConnection con = (OdbcConnection)this.DbConnection;
* OdbcDataAdapter adp = new OdbcDataAdapter(sql, con);
* adp.Fill(ds, "User");
*
* return ds;
* }
* catch
* {
* return ds;
* }
* }
*/
/// <summary>
/// Retrieve all the user from users table
/// </summary>
/// <returns>Returns list of User</returns>
public List <RBACD.DatalayerDef.sUser> GetAllUser()
{
IDataReader ReturnValue;
List <RBACD.DatalayerDef.sUser> userList = new List <RBACD.DatalayerDef.sUser>();
// create a command object which we can use to get all user
IDbCommand DbCommand = CreateCommandObject(DbConnection, "SELECT * FROM users");
try
{
// open the database, query for the user
ReturnValue = DbCommand.ExecuteReader();
}
catch (Exception e)
{
throw new DataLayerException(GetString(DataAccessException));
}
// if the return value is null then we did not find the user
if (ReturnValue != null)
{
while (ReturnValue.Read())
{
RBACD.DatalayerDef.sUser user = new RBACD.DatalayerDef.sUser();
user.UserId = ReturnValue[0].ToString();
user.UserName = ReturnValue[1].ToString();
user.Password = ReturnValue[2].ToString();
user.FirstName = ReturnValue[3].ToString();
user.LastName = ReturnValue[4].ToString();
user.Citizenship = ReturnValue[5].ToString();
userList.Add(user);
}
}
return(userList);
}
private void lvwCreateUser_DoubleClick(object sender, EventArgs e)
{
mode = RBAC.Utils.Constants.EDIT;
if (lvwCreateUser.SelectedIndices.Count > 0)
{
int uIndex = lvwCreateUser.SelectedIndices[0];
userInfo = userList[uIndex];
txtUserName.Text = userInfo.UserName;
txtPassword.Text = userInfo.Password;
txtConfPassword.Text = userInfo.Password;
txtFirstName.Text = userInfo.FirstName;
txtLastName.Text = userInfo.LastName;
txtCitizenship.Text = userInfo.Citizenship;
}
}
private void lvwCreateUser_DoubleClick(object sender, EventArgs e)
{
mode = RBAC.Utils.Constants.EDIT;
if (lvwCreateUser.SelectedIndices.Count > 0)
{
int uIndex = lvwCreateUser.SelectedIndices[0];
userInfo = userList[uIndex];
txtUserName.Text = userInfo.UserName;
txtPassword.Text = userInfo.Password;
txtConfPassword.Text = userInfo.Password;
txtFirstName.Text = userInfo.FirstName;
txtLastName.Text = userInfo.LastName;
txtCitizenship.Text = userInfo.Citizenship;
}
}
private void cmdClear_Click(object sender, EventArgs e)
{
ClearFields();
mode = RBAC.Utils.Constants.SAVE;
userInfo = new RBACD.DatalayerDef.sUser();
}
private void cmdClear_Click(object sender, EventArgs e)
{
ClearFields();
mode = RBAC.Utils.Constants.SAVE;
userInfo = new RBACD.DatalayerDef.sUser();
}
/*
/// <summary>
/// Get all the user from user table
/// </summary>
/// <returns>DataSet</returns>
public DataSet GetAllUser()
{
DataSet ds = new DataSet();
string sql = string.Empty;
try
{
sql = "SELECT * FROM users";
OdbcConnection con = (OdbcConnection)this.DbConnection;
OdbcDataAdapter adp = new OdbcDataAdapter(sql, con);
adp.Fill(ds, "User");
return ds;
}
catch
{
return ds;
}
}
*/
/// <summary>
/// Retrieve all the user from users table
/// </summary>
/// <returns>Returns list of User</returns>
public List<RBACD.DatalayerDef.sUser> GetAllUser()
{
IDataReader ReturnValue;
List<RBACD.DatalayerDef.sUser> userList = new List<RBACD.DatalayerDef.sUser>();
// create a command object which we can use to get all user
IDbCommand DbCommand = CreateCommandObject(DbConnection, "SELECT * FROM users");
try
{
// open the database, query for the user
ReturnValue = DbCommand.ExecuteReader();
}
catch (Exception e)
{
throw new DataLayerException(GetString(DataAccessException));
}
// if the return value is null then we did not find the user
if (ReturnValue != null)
{
while (ReturnValue.Read())
{
RBACD.DatalayerDef.sUser user = new RBACD.DatalayerDef.sUser();
user.UserId = ReturnValue[0].ToString();
user.UserName = ReturnValue[1].ToString();
user.Password = ReturnValue[2].ToString();
user.FirstName = ReturnValue[3].ToString();
user.LastName = ReturnValue[4].ToString();
user.Citizenship = ReturnValue[5].ToString();
userList.Add(user);
}
}
return userList;
}
