//this procedure inserts a new system user
public void InsertSystemUserInfo(CommonExchange.SysAccess userInfo, CommonExchange.SysAccess newUserInfo)
{
using (DatabaseLib.DbLibUserManager dbLib = new DatabaseLib.DbLibUserManager())
{
dbLib.InsertSystemUserInfo(userInfo, ref newUserInfo);
}
if (_classDataSet != null)
{
DataRow newRow = _classDataSet.Tables["SystemUserTable"].NewRow();
newRow["system_user_id"] = newUserInfo.UserId;
newRow["system_user_name"] = newUserInfo.UserName;
newRow["system_user_password"] = newUserInfo.Password;
newRow["system_user_status"] = newUserInfo.UserStatus;
newRow["access_code"] = newUserInfo.AccessCode;
newRow["last_name"] = newUserInfo.LastName;
newRow["first_name"] = newUserInfo.FirstName;
newRow["middle_name"] = newUserInfo.MiddleName;
newRow["position"] = newUserInfo.Position;
_classDataSet.Tables["SystemUserTable"].Rows.Add(newRow);
_classDataSet.AcceptChanges();
}
} //------------------------
} //-----------------------------
#endregion
#region Programmer-Defined Function Procedures
//this function determines if the user name and password already exists
public Boolean IsExistsNameSystemUserInformation(CommonExchange.SysAccess userInfo, CommonExchange.SysAccess newUserInfo)
{
Boolean isExist = false;
using (DatabaseLib.DbLibUserManager dbLib = new DatabaseLib.DbLibUserManager())
{
isExist = dbLib.IsExistsNameSystemUserInformation(userInfo, newUserInfo);
}
return(isExist);
} //------------------------------
} //---------------------------
//this procedure initializes the class
private void InitializeClass(CommonExchange.SysAccess userInfo)
{
using (DatabaseLib.DbLibUserManager dbLib = new DatabaseLib.DbLibUserManager())
{
_classDataSet = dbLib.GetUserInformationDataSet(userInfo);
}
using (DatabaseLib.DbLibGeneral dbLib = new DatabaseLib.DbLibGeneral())
{
_serverDateTime = dbLib.GetServerDateTime(userInfo.Connection);
}
} //-----------------------------
} //------------------------
//this procedure inserts a new system user
public void UpdateSystemUserInfo(CommonExchange.SysAccess userInfo, CommonExchange.SysAccess newUserInfo)
{
using (DatabaseLib.DbLibUserManager dbLib = new DatabaseLib.DbLibUserManager())
{
dbLib.UpdateSystemUserInfo(userInfo, newUserInfo);
}
if (_classDataSet != null)
{
Int32 index = 0;
foreach (DataRow userRow in _classDataSet.Tables["SystemUserTable"].Rows)
{
if (String.Equals(userRow["system_user_id"].ToString(), newUserInfo.UserId))
{
DataRow editRow = _classDataSet.Tables["SystemUserTable"].Rows[index];
editRow.BeginEdit();
editRow["system_user_name"] = newUserInfo.UserName;
editRow["system_user_password"] = newUserInfo.Password;
editRow["system_user_status"] = newUserInfo.UserStatus;
editRow["access_code"] = newUserInfo.AccessCode;
editRow["last_name"] = newUserInfo.LastName;
editRow["first_name"] = newUserInfo.FirstName;
editRow["middle_name"] = newUserInfo.MiddleName;
editRow["position"] = newUserInfo.Position;
editRow.EndEdit();
_classDataSet.AcceptChanges();
break;
}
index++;
}
}
} //-------------------------------------------
