public ActionResult DoUpload(IFormFile file)
{
using (var stream = file.OpenReadStream())
{
var xs = new XmlSerializer(typeof(PartyModel));
var party = (PartyModel)xs.Deserialize(stream);
using (var db = new PartyDbContext())
{
var dbs = new DbParty()
{
TypeofEvent = party.TypeofEvent,
Distination = party.Distination,
Services = party.Services,
};
dbs.Workers = new Collection <DbWorkers>();
foreach (var worker in party.Workers)
{
dbs.Workers.Add(new DbWorkers()
{
Name = worker.Name,
Position = worker.Position,
Experience = worker.Experience,
});
}
db.ManyParties.Add(dbs);
db.SaveChanges();
}
return(View(party));
}
}
public Form1()
{
InitializeComponent();
dbUser = new DbUser();
dbParty = new DbParty();
dbPerson = new DbPerson();
}
public DbInterface()
{
_campaignDb = new SqLiteDb(Properties.Settings.Default.CampaignDatabaseName);
_mapDb = new SqLiteDb(Properties.Settings.Default.MapDatabaseName);
Party = new DbParty(this, _campaignDb);
Session = new DbSession(this, _campaignDb);
Hexes = new DbHex(this, _mapDb);
HexConnections = new DbHexConnection(this, _mapDb);
DbUpdater.CheckForCampaignDbSchemaUpdates(_campaignDb, Party, Session);
DbUpdater.CheckForMapDbSchemaUpdates(_mapDb, Hexes, HexConnections);
}
public static void CheckForCampaignDbSchemaUpdates(IDbInstance db, DbParty party, DbSession session)
{
long version = db.GetVersion();
if (version == 0)
{
db.CreateTables(new IDbModule[] { party });
party.CreateDefault();
}
if (version <= 1)
{
db.CreateTables(new IDbModule[] { session });
session.CreateDefault();
}
if (version == 2)
{
db.AlterAddColumn(session.TableName, DbSession.Year, DbColumn.Integer, true, "382");
db.AlterAddColumn(session.TableName, DbSession.Day, DbColumn.Integer, true, "218");
db.AlterAddColumn(session.TableName, DbSession.Minutes, DbColumn.Integer, true, "1080");
}
db.SetVersion(CurrentCampaignDbVersion);
}
