public async Task DeleteUser(IUser iuser)
{
try
{
if (iuser != null)
{
BotGearUser user = await this.GetUserbyId(Convert.ToString(iuser.Id));
if (user != null)
{
var serv = await this.srvMngr.getServerbymeMeberId(user.Id);
if (serv != null)
{
foreach (var s in serv)
{
await this.srvMngr.deleteMemberfromServer(s.Id, iuser);
}
}
db.Users.Remove(user);
await db.SaveChangesAsync();
}
}
}
catch (Exception ex)
{
CommonTools.ErrorReporting(ex);
}
}
public BotGearUser IUserToBotGearUser(IUser iuser)
{
try
{
BotGearUser btuset = null;
if (iuser != null)
{
btuset = new BotGearUser();
// btuset.AvatarId = iuser.AvatarId;
btuset.Discriminator = iuser.Discriminator;
btuset.DiscriminatorValue = iuser.DiscriminatorValue;
// btuset.AvatarUrl = iuser.GetAvatarUrl();
btuset.Username = iuser.Username;
btuset.Id = Convert.ToString(iuser.Id);
btuset.CreatedAt = iuser.CreatedAt.DateTime;
}
return(btuset);
}
catch (Exception ex)
{
CommonTools.ErrorReporting(ex);
return(null);
}
}
public async Task deleteMemberfromServer(IGuild iguild, IUser iuser)
{
try
{
var tuser = conv.IUserToBotGearUser(iuser);
var tser = conv.IGuildToBotGearServer(iguild);
BotGearUser user = await usrmngr.GetUserbyId(tuser.Id);
if (tser != null && await this.ServerExists(tser.Id) == true && await IsMembersToServer(tser.Id, user.Id) == false && user != null)
{
string sid = tser.Id;
tser = await this.getServerbyId(sid);
var suser = db.UsersServers.FirstOrDefault(x => x.ServerId == sid && x.UserId == user.Id);
if (tuser != null)
{
db.UsersServers.Remove(suser);
await db.SaveChangesAsync();
}
}
}
catch (Exception ex)
{
CommonTools.ErrorReporting(ex);
}
}
public async Task EditUser(IUser iuser, IUser iuser2)
{
try
{
if (iuser != null && iuser2 != null)
{
BotGearUser tuser = conv.IUserToBotGearUser(iuser);
BotGearUser tuser2 = conv.IUserToBotGearUser(iuser2);
BotGearUser user = await this.GetUserbyId(Convert.ToString(tuser.Id));
if (user != null)
{
tuser2.Id = user.Id;
tuser2.Birthday = user.Birthday;
db.Entry(user).CurrentValues.SetValues(tuser2);
await db.SaveChangesAsync();
}
}
}
catch (Exception ex)
{
CommonTools.ErrorReporting(ex);
}
}
public async Task <BotGearUser> GetAMemberToServer(IGuild iguild, IUser iuser)
{
try
{
var tuser = conv.IUserToBotGearUser(iuser);
var tser = conv.IGuildToBotGearServer(iguild);
BotGearUser user = await usrmngr.GetUserbyId(tuser.Id);
BotGearUser ap = null;
if (tser != null && await this.ServerExists(tser.Id) == true && await IsMembersToServer(tser.Id, user.Id) == false && user == null)
{
string sid = tser.Id;
tser = await this.getServerbyId(sid);
var t = db.UsersServers.FirstOrDefault(x => x.ServerId == sid && x.UserId == user.Id);
if (t != null)
{
ap = await usrmngr.GetUserbyId(t.UserId);
}
}
return(ap);
}
catch (Exception ex)
{
CommonTools.ErrorReporting(ex);
return(null);
}
}
public async Task AddMemberToServer(IGuild iguild, IUser iuser)
{
try
{
var tuser = conv.IUserToBotGearUser(iuser);
var tser = conv.IGuildToBotGearServer(iguild);
BotGearUser user = await usrmngr.GetUserbyId(tuser.Id);
if (tser != null && await this.ServerExists(tser.Id) == true && await IsMembersToServer(tser.Id, user.Id) == false && user != null)
{
string sid = tser.Id;
tser = await this.getServerbyId(sid);
BotGearUsersServers usserv = new BotGearUsersServers();
usserv.ServerId = tser.Id;
usserv.UserId = user.Id;
db.UsersServers.Add(usserv);
await db.SaveChangesAsync();
}
}
catch (Exception ex)
{
CommonTools.ErrorReporting(ex);
}
}
public async Task <Boolean> IsMembersToServer(string sid, string uid)
{
try
{
List <BotGearUser> users = await this.getServerMembersbyServerId(sid);
BotGearUser user = await usrmngr.GetUserbyId(uid);
Boolean ap = false;
if (sid != null && await this.ServerExists(sid) == true && users != null && uid != null && user != null)
{
var tuser = db.UsersServers.FirstOrDefault(x => x.ServerId == sid && x.UserId == uid);
if (tuser != null)
{
ap = true;
}
}
return(ap);
}
catch (Exception ex)
{
CommonTools.ErrorReporting(ex);
return(false);
}
}
public async Task <List <BotGearUser> > getServerMembersbyServerId(string id)
{
try
{
List <BotGearUser> ap = null;
if (id != null && await this.ServerExists(id) == true)
{
BotGearServer srv = await this.getServerbyId(id);
List <BotGearUsersServers> usrvs = db.UsersServers.ToList().FindAll(x => x.ServerId == id);
if (usrvs != null)
{
ap = new List <BotGearUser>();
foreach (var u in usrvs)
{
BotGearUser user = await usrmngr.GetUserbyId(u.UserId);
if (user != null)
{
ap.Add(user);
}
}
}
}
return(ap);
}
catch (Exception ex)
{
CommonTools.ErrorReporting(ex);
return(null);
}
}
public async Task addUser(IUser iuser, DateTime birthday, IGuild iguild)
{
try
{
if (iuser != null && birthday != null && iguild != null)
{
BotGearUser user = conv.IUserToBotGearUser(iuser);
BotGearUser exuser = await this.GetUserbyId(user.Id);
BotGearServer srv = this.conv.IGuildToBotGearServer(iguild);
if (user != null && exuser == null && srv != null)
{
if (await srvMngr.ServerExists(srv.Id) != true)
{
await this.srvMngr.addServer(iguild);
}
else
{
string id = srv.Id;
srv = await srvMngr.getServerbyId(id);
}
user.Birthday = birthday;
user.RegisteredAt = DateTime.Now;
db.Users.Add(user);
db.SaveChanges();
user = await this.GetUserbyId(user.Id);
if (await srvMngr.IsMembersToServer(srv.Id, user.Id) == false)
{
await this.srvMngr.AddMemberToServer(iguild, iuser);
}
}
else if (user != null && exuser != null && srv != null)
{
if (await srvMngr.ServerExists(srv.Id) != true)
{
await this.srvMngr.addServer(iguild);
}
else
{
string id = srv.Id;
srv = await srvMngr.getServerbyId(id);
}
if (await srvMngr.IsMembersToServer(srv.Id, exuser.Id) == false)
{
await this.srvMngr.AddMemberToServer(iguild, iuser);
}
}
}
}
catch (Exception ex)
{
CommonTools.ErrorReporting(ex);
}
}
public async Task <BotGearUser> GetUserbyId(string id)
{
try
{
BotGearUser user = null;
if (id != null)
{
user = db.Users.FirstOrDefault(x => x.Id == id);
}
return(user);
}
catch (Exception ex)
{
CommonTools.ErrorReporting(ex);
return(null);
}
}
public async void ImportFromModel(BotGearUser model)
{
try
{
if (model != null)
{
this.Id = model.Id;
this.Birthday = model.Birthday;
this.CreatedAt = model.CreatedAt;
this.Discriminator = model.Discriminator;
this.DiscriminatorValue = model.DiscriminatorValue;
this.RegisteredAt = model.RegisteredAt;
this.Username = model.Username;
this.Servers = await this.srvMngr.getServerbymeMeberId(this.Id);
}
}
catch (Exception ex)
{
CommonTools.ErrorReporting(ex);
}
}
public BotGearUser ExportTomodel()
{
try
{
BotGearUser ap = new BotGearUser();
ap.Id = this.Id;
ap.Birthday = this.Birthday;
ap.CreatedAt = this.CreatedAt;
ap.Discriminator = this.Discriminator;
ap.DiscriminatorValue = this.DiscriminatorValue;
ap.RegisteredAt = this.RegisteredAt;
ap.Username = this.Username;
return(ap);
}
catch (Exception ex)
{
CommonTools.ErrorReporting(ex);
return(null);
}
}
public async Task EditUser(IUser iuser, DateTime birthday)
{
try
{
if (iuser != null && birthday != null)
{
BotGearUser tuser = conv.IUserToBotGearUser(iuser);
BotGearUser user = await this.GetUserbyId(tuser.Id);
if (user != null)
{
user.Birthday = birthday;
db.Entry(user).CurrentValues.SetValues(user);
await db.SaveChangesAsync();
}
}
}
catch (Exception ex)
{
CommonTools.ErrorReporting(ex);
}
}
