public void DatabaseEntry(Challan t) { MySqlConnection conn = new MySqlConnection(ConnectionString); MySqlCommand cmd = conn.CreateCommand(); cmd.CommandText = "INSERT INTO tblChallan " + "VALUES(@Invoice,@IDate,@Qty,@Amount,@Cartoons,@DDate,@DId,@CId)"; cmd.Parameters.AddWithValue("@Invoice", t.getInvoice().ToString()); cmd.Parameters.AddWithValue("@IDate", t.getIDate()); cmd.Parameters.AddWithValue("@Qty", t.getQty().ToString()); cmd.Parameters.AddWithValue("@Amount", t.getAmount().ToString()); cmd.Parameters.AddWithValue("@Cartoons", t.getCartoons().ToString()); cmd.Parameters.AddWithValue("@DDate", t.getDDate()); cmd.Parameters.AddWithValue("@DId", t.getDId().ToString()); cmd.Parameters.AddWithValue("@CId", t.getCId().ToString()); conn.Open(); cmd.ExecuteNonQuery(); conn.Close(); }
private void btnGenerate_Click(object sender, EventArgs e) { #region New Challan Button if (btnGenerate.Text == "New Challan") { #region Enabling All Controls cmbDistributorName.Enabled = true; txtIDate.Enabled = true; txtQuantity.Enabled = true; txtAmount.Enabled = true; txtCartoons.Enabled = true; txtDDate.Enabled = true; #endregion #region Setting All Controls To Default Values cmbCompanyName.SelectedValue = -1; cmbDistributorName.SelectedValue = -1; txtInvoice.Text = ""; txtIDate.Text = ""; txtQuantity.Text = ""; txtAmount.Text = ""; txtCartoons.Text = ""; txtDDate.Text = ""; #endregion btnGenerate.Text = "Generate"; return; } #endregion #region Validation Check if (!ValidateForm()) { return; } #endregion #region Object Creation Challan t = new Challan(int.Parse(txtInvoice.Text), txtIDate.Text, int.Parse(txtQuantity.Text), double.Parse(txtAmount.Text), int.Parse(txtCartoons.Text), txtDDate.Text, int.Parse(cmbDistributorName.SelectedValue.ToString()), int.Parse(cmbCompanyName.SelectedValue.ToString()) ); #endregion D.DatabaseEntry(t); DocumentPrint(CreateDocument); }