private void BtnSave_Click(object sender, EventArgs e)
{
InvoiceSellingDetails insd = new InvoiceSellingDetails();
insd.InvoiceNo = txtInvoiceNumber.Text;
insd.InvoiceDate = Convert.ToDateTime(txtInvoiceDate.Text);
insd.CustomerId = customerid;
insd.GrandTotal = Convert.ToDecimal(txtGrandTotal.Text);
int k = blinsell.CreateSellingInvoice(insd);
SellingDetails sellingDetails = new SellingDetails();
for (int j = 0; j < dataGridView.Rows.Count; j++)
{
sellingDetails.InvoiceSellingId = k;
sellingDetails.ProductId = Convert.ToInt32(dataGridView.Rows[j].Cells["colProductId"].Value.ToString());
sellingDetails.CategoryId = Convert.ToInt32(dataGridView.Rows[j].Cells["colCategoryId"].Value.ToString());
sellingDetails.Quantity = Convert.ToInt32(dataGridView.Rows[j].Cells["colQuantity"].Value.ToString());
sellingDetails.SellingPrice = Convert.ToDecimal(dataGridView.Rows[j].Cells["colSellingPrice"].Value.ToString());
sellingDetails.Total = Convert.ToDecimal(dataGridView.Rows[j].Cells["colTotal"].Value.ToString());
sellingDetails.InvoiceDate = Convert.ToDateTime(txtInvoiceDate.Text);
blselling.CreateSells(sellingDetails);
}
MessageBox.Show("Sells Done");
dataGridView.Rows.Clear();
i = 0;
LoadInvoice();
}
public InvoiceSellingDetails GetMaxInvoice()
{
InvoiceSellingDetails insd = new InvoiceSellingDetails();
SqlConnection con = new SqlConnection(@"Data Source=PRASHISH\SQLEXPRESS;Integrated Security=true; Database=BroadwayDB");
SqlCommand cmd = new SqlCommand("select top 1 InvoiceNo from tblInvoiceSelling order by InvoiceSellingId desc", con);
SqlDataReader dr = null;
con.Open();
dr = cmd.ExecuteReader();
if (dr.Read())
{
insd.InvoiceNo = (string)dr["InvoiceNo"];
}
dr.Close();
con.Close();
return(insd);
}
private void LoadInvoice()
{
txtInvoiceDate.Text = DateTime.Today.ToShortDateString();
InvoiceSellingDetails insd = blinsell.GetMaxInvoice();
if (insd.InvoiceNo != null)
{
string[] str = insd.InvoiceNo.Split('-');
int maxno = Convert.ToInt32(str[1].ToString()) + 1;
txtInvoiceNumber.Text = ("INVSE-" + maxno);
}
else
{
txtInvoiceNumber.Text = "INVSE-1";
}
cboProduct.Enabled = false;
txtGrandTotal.Text = "0.00";
}
public int CreateSellingInvoice(InvoiceSellingDetails ind)
{
SqlConnection con = new SqlConnection(@"Data Source=PRASHISH\SQLEXPRESS;Integrated Security=true; Database=BroadwayDB");
SqlCommand cmd = new SqlCommand("insert into tblInvoiceSelling values(@a,@b,@c,@d);SELECT SCOPE_IDENTITY();", con);
cmd.Parameters.AddWithValue("@a", ind.CustomerId);
cmd.Parameters.AddWithValue("@b", ind.InvoiceNo);
cmd.Parameters.AddWithValue("@c", ind.InvoiceDate);
cmd.Parameters.AddWithValue("@d", ind.GrandTotal);
con.Open();
int i = Convert.ToInt32(cmd.ExecuteScalar());
con.Close();
return(i);
}
