public User(UsersRow userData)
{
Username = userData.Username;
Password = userData.Password;
FirstName = userData.FirstName;
LastName = userData.LastName;
Created = userData.Created;
Updated = userData.Updated;
Removed = userData.Removed;
}
public UsersRow AddUsersRow(string Login, byte[] Password, string Name)
{
UsersRow rowUsersRow = ((UsersRow)(this.NewRow()));
rowUsersRow.ItemArray = new object[] {
null,
Login,
Password,
Name
};
this.Rows.Add(rowUsersRow);
return(rowUsersRow);
}
public UsersRow AddUsersRow(int UserID, string UserName, string UserLastName, string UserAddress)
{
UsersRow rowUsersRow = ((UsersRow)(this.NewRow()));
rowUsersRow.ItemArray = new object[] {
UserID,
UserName,
UserLastName,
UserAddress
};
this.Rows.Add(rowUsersRow);
return(rowUsersRow);
}
public UsersRow AddUsersRow(string UserName, string UserPassword, int GroupID, bool IsRemoved)
{
UsersRow rowUsersRow = ((UsersRow)(this.NewRow()));
rowUsersRow.ItemArray = new object[] {
null,
UserName,
UserPassword,
GroupID,
IsRemoved
};
this.Rows.Add(rowUsersRow);
return(rowUsersRow);
}
public UsersRow AddUsersRow(string UserName, string UserPassword, int GroupID, bool IsRemoved, bool IsAdmin)
{
UsersRow rowUsersRow = ((UsersRow)(this.NewRow()));
object[] columnValuesArray = new object[] {
null,
UserName,
UserPassword,
GroupID,
IsRemoved,
IsAdmin
};
rowUsersRow.ItemArray = columnValuesArray;
this.Rows.Add(rowUsersRow);
return(rowUsersRow);
}
public static UsersRow Login(string username, string password)
{
UsersRow returnUser = new UsersRow();
// Hash Password
password = (password + Server.Config.Salt).SHA512();
Provider.ProviderResult result = Server.Database.ExecuteQuery(
"SELECT ID, Username, Scope, LastLogin FROM Users WHERE Username = @Username AND Password = @Password LIMIT 1",
new Dictionary <string, object>()
{
{ "@Username", username },
{ "@Password", password }
}, System.Data.CommandBehavior.SingleResult);
if (result.Data != null && result.Data.HasRows)
{
result.Data.Read();
// Apply Data
returnUser.ID = result.Data.GetInt32(0);
returnUser.Username = result.Data.GetString(1);
returnUser.Scope.AddRange(result.Data.GetString(2).Split(' '));
// Create if the last login is null
if (!result.Data.IsDBNull(result.Data.GetOrdinal("LastLogin")))
{
returnUser.LastLogin = DateTime.Parse(result.Data.GetString(3));
}
// Update last login time
Server.Database.ExecuteNonQuery(
"UPDATE Users SET LastLogin = @LastLogin WHERE Username = @Username",
new Dictionary <string, object>()
{
{ "@LastLogin", DateTime.Now.ToLongDateString() },
{ "@Username", username },
}
);
}
return(returnUser);
}
public UsersRowChangeEvent(UsersRow row, global::System.Data.DataRowAction action)
{
this.eventRow = row;
this.eventAction = action;
}
public void RemoveUsersRow(UsersRow row)
{
this.Rows.Remove(row);
}
public void AddUsersRow(UsersRow row)
{
this.Rows.Add(row);
}
public UsersRowChangeEvent(UsersRow row, global::System.Data.DataRowAction action) {
this.eventRow = row;
this.eventAction = action;
}
public void RemoveUsersRow(UsersRow row) {
this.Rows.Remove(row);
}
public void AddUsersRow(UsersRow row) {
this.Rows.Add(row);
}
public SocketUser(Sender session, UsersRow data)
{
Session = session;
UserPermissions = data.Scope;
}
public UsersRowChangeEvent(UsersRow row, DataRowAction action)
{
this.eventRow = row;
this.eventAction = action;
}
public UsersRowChangeEvent(UsersRow row, DataRowAction action)
{
this.eventRow = row;
this.eventAction = action;
}
public Buddy_ListRow AddBuddy_ListRow(UsersRow parentUsersRowByUsersBuddy_x0020_List, int Friend, int Group) {
Buddy_ListRow rowBuddy_ListRow = ((Buddy_ListRow)(this.NewRow()));
object[] columnValuesArray = new object[] {
null,
Friend,
Group};
if ((parentUsersRowByUsersBuddy_x0020_List != null)) {
columnValuesArray[0] = parentUsersRowByUsersBuddy_x0020_List[0];
}
rowBuddy_ListRow.ItemArray = columnValuesArray;
this.Rows.Add(rowBuddy_ListRow);
return rowBuddy_ListRow;
}
public UserDataRow AddUserDataRow(
string First_Name,
string Last_Name,
string Address1,
string Address2,
string City,
string State,
string Zip_Code,
string Web_Site,
string Phone,
string Mobile_Phone,
string Password,
UsersRow parentUsersRowByUsersUserData,
string Username,
string Fax_Number,
string Optional_1_Name,
string Optional_1_Data,
string Optional_2_Name,
string Optional_2_Data,
string Message) {
UserDataRow rowUserDataRow = ((UserDataRow)(this.NewRow()));
object[] columnValuesArray = new object[] {
First_Name,
Last_Name,
Address1,
Address2,
City,
State,
Zip_Code,
Web_Site,
Phone,
Mobile_Phone,
Password,
null,
Username,
Fax_Number,
Optional_1_Name,
Optional_1_Data,
Optional_2_Name,
Optional_2_Data,
Message};
if ((parentUsersRowByUsersUserData != null)) {
columnValuesArray[11] = parentUsersRowByUsersUserData[0];
}
rowUserDataRow.ItemArray = columnValuesArray;
this.Rows.Add(rowUserDataRow);
return rowUserDataRow;
}
