public void addChemicalsAndEquipments(chemicalsAndEquipments obj) { string query = "IF OBJECT_ID('dbo.ChemicalsAndEquipments', 'U') IS NULL "; query += "BEGIN "; query += "CREATE TABLE [dbo].[ChemicalsAndEquipments]("; query += "[Name] VARCHAR(250) NOT NULL CONSTRAINT pkId PRIMARY KEY,"; query += "[Date] VARCHAR(25) NOT NULL,"; query += "[Price] VARCHAR(100) NOT NULL,"; query += "[Quantity] VARCHAR(20) NOT NULL,"; query += "[EmployeeNic] VARCHAR(25) NOT NULL CONSTRAINT fpkempId FOREIGN KEY (EmployeeNic) REFERENCES dbo.Employee(EmployeeNic),"; query += "[Reference] VARCHAR(1000) ,"; query += ")"; query += " END"; Console.WriteLine(obj.Name); String sqlQuery = "INSERT INTO dbo.ChemicalsAndEquipments(Name,Date,Price,Quantity,EmployeeNic,Reference) " + "VALUES ('" + obj.Name + "','" + obj.Date + "','" + obj.Price + "','" + obj.Quantity + "','" + obj.User + "','" + obj.Reference + "')"; getConnection(); SqlCommand cmd = new SqlCommand(query, getConnection()); cmd.ExecuteNonQuery(); SqlCommand cmd1 = new SqlCommand(sqlQuery, getConnection()); cmd1.ExecuteNonQuery(); getConnection().Close(); }
private void button1_Click(object sender, EventArgs e) { if (core.Text.Trim() == string.Empty) { MessageBox.Show("Empty Chemical or ID Field!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } else if (name.Text.Trim() == string.Empty) { MessageBox.Show("Empty Name Field!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } else if (price.Text.Trim() == string.Empty) { MessageBox.Show("Empty Price Field!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } else if (quantity.Text.Trim() == string.Empty) { MessageBox.Show("Empty Quantity Field!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } else { DialogResult answer; answer = MessageBox.Show("Are you sure want to add Employee?", this.Text, MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (answer == DialogResult.Yes) { //******database connect ****** try { string date1 = date.Value.ToString(); if (core.Text.Equals("Chemical") || core.Text.Equals("Equipment")) { //float cPrice = float.Parse(price.Text); string cPrice = price.Text; string cQuantity = quantity.Text + cmbQuantity.Text; string cReference = reference.Text; string cName = name.Text; DBconnection dbconnection = new DBconnection(); if (dbconnection.findChemicalEquipment(cName)) { string currentQuantity = dbconnection.getCurrentQuantity(name.Text); int q = Convert.ToInt32(currentQuantity) + Convert.ToInt32(cQuantity); string newQuantity = q.ToString(); dbconnection.updateChemicalAndEquipment(cName, newQuantity); } else { chemicalsAndEquipments chemicalsAndequipments = new chemicalsAndEquipments(date1, cName, cPrice, cQuantity, global.UserID, cReference); dbconnection.addChemicalsAndEquipments(chemicalsAndequipments); } availableEquipmentsAndChemicals(); clearFileds(); } else { MessageBox.Show("Enter valid Type(Chemical or Equipment)", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } } catch (Exception ex) { MessageBox.Show("Error:\n" + ex, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); Console.WriteLine("Error: \n" + ex); } } } }