public void AddCompanies(string companynamein)
{
using (var db = new InsertClass())
{
db.OpenConnection();
db.CreateCommand("INSERT INTO Company(id,Maincompany_ID,Name) VALUES (@id,@maincompany,@name)");
db.AddParameter("@name", companynamein);
db.AddParameter("@id", "");
db.AddParameter("@maincompany", "");
db.Command.ExecuteNonQuery();
}
}
public void AddContainer(string containertype,string weight, string companyname,string port,string ship)
{
using (var db = new InsertClass())
{
db.OpenConnection();
db.CreateCommand("INSERT INTO CONTAINER (id, Company_ID, GPS_ID,Ship_ID,Port_ID,Weight,Type,transported)SELECT @id AS id, company.id, 1 AS GPS_ID, ship.id,port.id, @weight AS Weight, @type As type, 0 as transported FROM Company,Port,Ship WHERE Company.name = @companyname AND Port.Name = @port AND Ship.Type = @ship");
//WITHOUT SHIP db.CreateCommand("INSERT INTO CONTAINER (id, Company_ID, GPS_ID,Ship_ID,Port_ID,Weight,Type,transported)SELECT @id AS id, company.id, 1 AS GPS_ID, 1 AS Ship_ID,port.id, @weight AS Weight, @type As type, 0 as transported FROM Company,Port,Ship WHERE Company.name = @companyname AND Port.Name = @port");
db.AddParameter("@id", "");
db.AddParameter("@type", containertype);
db.AddParameter("@ship", ship);
db.AddParameter("@port", port);
db.AddParameter("@weight", weight);
db.AddParameter("@companyname", companyname);
db.Command.ExecuteNonQuery();
}
}