public static void SaveCollector(GuildCollector collector)
{
if (collector.IsNewCollector && !collector.MustDelete)
{
CreateCollector(collector);
return;
}
else if (collector.MustDelete)
{
DeleteCollector(collector.ID);
return;
}
else if (!collector.MustDelete && !collector.IsNewCollector)
{
var sqlText = "UPDATE collectors SET ID=@ID, Name=@Name, OwnerID=@Owner, Mappos=@Mappos, GuildID=@GuildID WHERE ID=@ID";
var sqlCommand = new MySqlCommand(sqlText, Program.DBHelper.Use());
var P = sqlCommand.Parameters;
P.Add(new MySqlParameter("@ID", collector.ID));
P.Add(new MySqlParameter("@Name", string.Join(";", collector.Name)));
P.Add(new MySqlParameter("@Owner", collector.Owner));
P.Add(new MySqlParameter("@Mappos", string.Concat(collector.Map.Model.ID, ";", collector.Cell, ";", collector.Dir)));
P.Add(new MySqlParameter("@GuildID", collector.Guild.ID));
sqlCommand.ExecuteNonQuery();
}
}
private static void CreateCollector(GuildCollector collector)
{
var sqlText = "INSERT INTO collectors VALUES(@ID, @Owner, @Mappos, @Name, @GuildID)";
var sqlCommand = new MySqlCommand(sqlText, Program.DBHelper.Use());
var P = sqlCommand.Parameters;
P.Add(new MySqlParameter("@ID", collector.ID));
P.Add(new MySqlParameter("@Name", string.Join(";", collector.Name)));
P.Add(new MySqlParameter("@Owner", collector.Owner));
P.Add(new MySqlParameter("@Mappos", string.Concat(collector.Map.Model.ID, ";", collector.Cell, ";", collector.Dir)));
P.Add(new MySqlParameter("@GuildID", collector.Guild.ID));
sqlCommand.ExecuteNonQuery();
collector.IsNewCollector = false;
}
public static void LoadCollectors()
{
var sqlText = "SELECT * FROM collectors";
var sqlCommand = new MySqlCommand(sqlText, Program.DBHelper.Use());
var sqlResult = sqlCommand.ExecuteReader();
while (sqlResult.Read())
{
var mappos = sqlResult.GetString("Mappos").Split(';');
var map = MapsRequests.MapsList.First(x => x.Model.ID == int.Parse(mappos[0]));
var character = CharactersRequests.CharactersList.First(x => x.ID == sqlResult.GetInt32("OwnerID"));
var collector = new GuildCollector(map, character, sqlResult.GetInt32("ID"))
{
IsNewCollector = false
};
collector.Name[0] = int.Parse(sqlResult.GetString("Name").Split(';')[0]);
collector.Name[1] = int.Parse(sqlResult.GetString("Name").Split(';')[1]);
collector.Map = map;
collector.Cell = int.Parse(mappos[1]);
collector.Dir = int.Parse(mappos[2]);
if (character.Guild == null || character.Guild.ID != sqlResult.GetInt32("GuildID"))
{
collector.Guild = GuildsRequest.GuildsList.First(x => x.ID == sqlResult.GetInt32("GuildID"));
}
collector.Guild.Collectors.Add(collector);
CollectorsList.Add(collector);
}
sqlResult.Close();
Utilities.Loggers.Status.Write(string.Format("Loaded '{0}' collectors from the database !", CollectorsList.Count));
}