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