public void SaveToDatabase()
{
using (LeattyContext DBContext = new LeattyContext())
{
DB.Models.Guild UpdateGuild = DBContext.Guilds.Single(x => x.Id == GuildId);
UpdateGuild.Id = GuildId;
UpdateGuild.Leader = LeaderId;
UpdateGuild.GP = GP;
UpdateGuild.Logo = Logo;
UpdateGuild.LogoColor = LogoColor;
UpdateGuild.LogoBG = LogoBG;
UpdateGuild.LogoBGColor = LogoBGColor;
UpdateGuild.Rank1Title = RankTitles[0];
UpdateGuild.Rank2Title = RankTitles[1];
UpdateGuild.Rank3Title = RankTitles[2];
UpdateGuild.Rank4Title = RankTitles[3];
UpdateGuild.Rank5Title = RankTitles[4];
UpdateGuild.Capacity = Capacity;
UpdateGuild.Notice = Notice;
UpdateGuild.Signature = Signature;
UpdateGuild.AllianceId = Alliance;
DBContext.Entry <DB.Models.Guild>(UpdateGuild).State = System.Data.Entity.EntityState.Modified;
DBContext.SaveChanges();
}
}
public static MapleGuild CreateGuild(string name, MapleCharacter leader)
{
foreach (MapleGuild g in Guilds.Values)
{
if (g.Name.Equals(name, StringComparison.CurrentCultureIgnoreCase))
{
return(null);
}
}
using (LeattyContext DBContext = new LeattyContext())
{
DB.Models.Guild InsertGuild = new DB.Models.Guild();
InsertGuild.Leader = leader.Id;
InsertGuild.Name = name;
DBContext.Guilds.Add(InsertGuild);
Character DbChar = DBContext.Characters.SingleOrDefault(x => x.Id == leader.Id);
DbChar.GuildContribution = 500;
DbChar.AllianceRank = 5;
DbChar.GuildRank = 1;
DBContext.Entry <Character>(DbChar).State = System.Data.Entity.EntityState.Modified;
DBContext.SaveChanges();
MapleGuild gld = new MapleGuild();
gld.GuildId = InsertGuild.Id;
gld.LeaderId = leader.Id;
gld.GP = 0;
gld.Logo = 0;
gld.LogoColor = 0;
gld.Name = name;
gld.Capacity = 10;
gld.LogoBG = 0;
gld.LogoBGColor = 0;
gld.Notice = null;
gld.Signature = 0;
gld.Alliance = 0;
Guilds.Add(gld.GuildId, gld);
return(gld);
}
}