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; } }