public void addWp(IList<WP> wp)
{
var db = new Database();
foreach(var w in wp)
db.WPs.InsertOnSubmit(w);
db.SubmitChanges();
}
public List<Vessel> getAllVessel()
{
var db = new Database();
List<Vessel> query = (from ves in db.Vessels
select ves).ToList<Vessel>();
return query;
}
public int AddNewRace(Race r)
{
var db = new Database();
db.Races.InsertOnSubmit(r);
db.SubmitChanges();
int id = r.Id;
return id;
}
public void AddVesselsToRace(int idR, int[] idV)
{
var db = new Database();
for(int i=0;i<idV.Length;i++)
{
var v = new VesselsInRace
{
RaceId = idR,
VesselId = idV[i]
};
db.VesselsInRaces.InsertOnSubmit(v);
}
db.SubmitChanges();
}
public void AddVesselToDB(string name, string class_,string nation, string nr,decimal tcf)
{
var vessel = new Vessel
{
Name = name,
Class = class_,
Nationality = nation,
RaceNumber = nr,
TCF = tcf
};
Database db = new Database();
db.Vessels.InsertOnSubmit(vessel);
db.SubmitChanges();
}