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();
}
}
/// <summary>
/// The bt add company_ click.
/// </summary>
/// <param name="sender">
/// The sender.
/// </param>
/// <param name="e">
/// The e.
/// </param>
private void btAddCompany_Click(object sender, EventArgs e)
{
var company = new InsertClass();
if (this.tbAddCompany.Text != string.Empty)
{
company.AddCompanies(this.tbAddCompany.Text);
this.UpdateList();
this.tbAddCompany.Clear();
lbComGood.Visible = true;
}
else
{
this.tbAddCompany.Text = "Voer bedrijfsnaam in";
}
}
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();
}
}
/// <summary>
/// The bt add container_ click.
/// </summary>
/// <param name="sender">
/// The sender.
/// </param>
/// <param name="e">
/// The e.
/// </param>
private void btAddContainer_Click(object sender, EventArgs e)
{
var container = new InsertClass();
string containertype = this.comboContainerType.SelectedItem.ToString();
string weight = this.numricWeight.Text;
string companyname = this.comboBedrijfsNaam.SelectedItem.ToString();
string ship = this.comboContainerOnShip.SelectedItem.ToString();
string port = this.comboPort.SelectedItem.ToString();
if (containertype != null && companyname != null)
{
container.AddContainer(containertype, weight, companyname, port, ship); //passes everything to the insertclass
lbGood.Visible = true;
}
}
