public static void insertData(string method, QueryParamter[] parameters) { connect(); command = new SqlCommand(method, connection); command.CommandType = CommandType.StoredProcedure; foreach (QueryParamter parameter in parameters) { command.Parameters.Add("@" + parameter.Name, paramTypes[parameter.Type]).Value = parameter.Value; } command.ExecuteNonQuery(); }
private void button2_Click(object sender, EventArgs e) { QueryParamter[] parameters = new QueryParamter[] { new QueryParamter("Id", comboBox2.SelectedValue.ToString(), "int") }; DataTable table = DBUtils.getDataTable("GetProducts", parameters); int itemTotal = Int32.Parse(textBox3.Text) * Int32.Parse(table.Rows[0][4].ToString()); dataGridView1.Rows.Add(table.Rows[0][1], table.Rows[0][2], table.Rows[0][3], table.Rows[0][4], textBox3.Text, itemTotal); int total = Int32.Parse(textBox1.Text) + itemTotal; textBox1.Text = total.ToString(); }
public static DataSet getDataSet(string method, QueryParamter[] parameters) { connect(); command = new SqlCommand(method, connection); command.CommandType = CommandType.StoredProcedure; foreach (QueryParamter parameter in parameters) { command.Parameters.Add("@" + parameter.Name, paramTypes[parameter.Type]).Value = parameter.Value; } SqlDataAdapter adapter = new SqlDataAdapter(command); DataSet dataset = new DataSet(); adapter.Fill(dataset); return dataset; }
private void button1_Click(object sender, EventArgs e) { QueryParamter[] parameters = new QueryParamter[] { new QueryParamter("Name", textBox1.Text, "varchar"), new QueryParamter("Description", textBox2.Text, "varchar"), new QueryParamter("Price", textBox3.Text, "varchar"), new QueryParamter("SellingPrice", textBox4.Text, "varchar"), }; DBUtils.insertData("AddProducts", parameters); textBox1.Text = ""; textBox2.Text = ""; textBox3.Text = ""; textBox4.Text = ""; MessageBox.Show("New Product added"); }
public static string getValue(string method, QueryParamter[] parameters, QueryParamter result) { connect(); command = new SqlCommand(method, connection); command.CommandType = CommandType.StoredProcedure; foreach (QueryParamter parameter in parameters) { command.Parameters.Add("@" + parameter.Name, paramTypes[parameter.Type]).Value = parameter.Value; } SqlParameter parameterResult = command.Parameters.Add("@" + result.Name, paramTypes[result.Type]); parameterResult.Direction = ParameterDirection.Output; parameterResult.Size = 50; command.ExecuteNonQuery(); return parameterResult.Value.ToString(); }
private void button1_Click(object sender, EventArgs e) { string dateTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); QueryParamter[] parameters = new QueryParamter[] { new QueryParamter("SuplrId", comboBox1.SelectedValue.ToString(), "int"), new QueryParamter("DateTime", dateTime, "varchar"), new QueryParamter("Total", textBox1.Text, "varchar"), new QueryParamter("AmountPaid", textBox2.Text, "varchar"), }; DBUtils.insertData("AddPurchase", parameters); textBox1.Text = ""; textBox2.Text = ""; textBox3.Text = ""; dataGridView1.Rows.Clear(); MessageBox.Show("Purchase data added"); }
private void button1_Click(object sender, EventArgs e) { if (textBox3.Text.Equals("")) { MessageBox.Show("Please enter an account no"); return; } else if (!textBox3.Text.StartsWith("2")) { MessageBox.Show("Account no must start with 2"); return; } else if (textBox3.Text.Length != 6) { MessageBox.Show("Account no must be 6 digit"); return; } else { try { long.Parse(textBox3.Text); } catch (Exception ex) { MessageBox.Show("Account no must a number"); return; } } if (textBox2.Text.Equals("")) { MessageBox.Show("Please enter a name"); return; } else if ((textBox2.Text.Length < 5) || (textBox2.Text.Length > 20)) { MessageBox.Show("Name must be 5 to 20 characters"); return; } if (textBox4.Text.Equals("")) { MessageBox.Show("Please enter an address"); return; } string suplrId = textBox1.Text.Split(new char[] { '_' })[1]; QueryParamter[] parameters = new QueryParamter[] { new QueryParamter("Id", suplrId, "int"), new QueryParamter("Name", textBox2.Text, "varchar"), new QueryParamter("AccountNo", textBox3.Text, "varchar"), new QueryParamter("Address", textBox4.Text, "varchar"), }; DBUtils.insertData("AddSupplier", parameters); textBox2.Text = ""; textBox3.Text = ""; textBox4.Text = ""; GetNextKey(); MessageBox.Show("New Supplier added"); }
private void GetNextKey() { QueryParamter outputParam = new QueryParamter("SuplrId", "", "varchar"); string custId = DBUtils.getValue("NextSuplrId", new QueryParamter[] { }, outputParam); textBox1.Text = custId; }