private void next_Click(object sender, EventArgs e) { long inv; if (withoutstock.Checked) { if (manualinvoiceno.Text == "" || !long.TryParse(manualinvoiceno.Text, out inv)) { MessageBox.Show("Invoice field is empty or Value is not numeric"); return; } } if (billList.Rows.Count == 0) { MessageBox.Show("No Items added in the List"); return; } int count = 0; int flag = 0; FinalInvoice invoice = new FinalInvoice(); foreach (DataGridViewRow row in billList.Rows) { invoice.ItemList.Rows.Add(); invoice.ItemList.Rows[count].Cells[0].Value = row.Cells[0].Value.ToString(); invoice.ItemList.Rows[count].Cells[1].Value = row.Cells[1].Value.ToString(); invoice.ItemList.Rows[count].Cells[2].Value = row.Cells[2].Value.ToString(); invoice.ItemList.Rows[count].Cells[3].Value = row.Cells[3].Value.ToString(); invoice.ItemList.Rows[count].Cells[4].Value = row.Cells[4].Value.ToString(); invoice.ItemList.Rows[count].Cells[5].Value = row.Cells[5].Value.ToString(); invoice.ItemList.Rows[count].Cells[6].Value = row.Cells[6].Value.ToString(); invoice.ItemList.Rows[count].Cells[7].Value = row.Cells[7].Value.ToString(); invoice.ItemList.Rows[count].Cells[8].Value = row.Cells[8].Value.ToString(); if (float.Parse(row.Cells[7].Value.ToString()) > 0 || float.Parse(row.Cells[8].Value.ToString()) > 0) { flag = 1; } count++; } if (flag == 1) { invoice.finalsgsttb.Text = "0"; invoice.finalcgsttb.Text = "0"; invoice.finalsgsttb.Enabled = false; invoice.finalcgsttb.Enabled = false; } if (stockflag) { invoice.invoicenumber = manualinvoiceno.Text; } invoice.billForm = this; this.Visible = false; invoice.Show(); }
private void searchinvoicebtn_Click(object sender, EventArgs e) { FinalInvoice invoice = new FinalInvoice(); // Disabling the controls of FinalInvoice invoice.custNametb.Enabled = false; invoice.addrtb.Enabled = false; invoice.mobiletb.Enabled = false; invoice.paymenttypecb.Enabled = false; invoice.paymentDetailstb.Enabled = false; invoice.finalsgsttb.Enabled = false; invoice.finalcgsttb.Enabled = false; dboperation operation = new dboperation(); SqlCeConnection conn = operation.dbConnection(Settings.Default.DatabasePath); string query1 = "SELECT InvoiceNo, customerName, custAddress, custMobile, paymentDetails, totalSGST, totalCGST, totalDiscount, percentSGST, percentCGST, InvoiceTime FROM customerDetails WHERE InvoiceNo=@invoiceno"; // DATEPART(day,InvoiceTime), DATEPART(month,InvoiceTime), DATEPART(year,InvoiceTime) string query2 = "SELECT InvoiceNo,ItemName,quantity,TotalSellingPrice,TotalPurchasedPrice,perItemSGST,perItemCGST,discountPerItemType,measuringUnit,description FROM invoiceDetails WHERE InvoiceNo=@invoiceno"; // 0 1 2 3 4 5 6 7 8 9 string invoiceresult = ""; SqlCeCommand cmd1 = null; SqlCeCommand cmd2 = null; SqlCeDataReader reader = null; try { cmd1 = new SqlCeCommand(query1, conn); cmd1.Parameters.AddWithValue("@invoiceno", invoicenotb.Text); reader = cmd1.ExecuteReader(); if (reader.Read()) { string temp; string[] separator; char[] tag = new char[] { '^' }; invoiceresult = reader.GetInt64(0).ToString(); invoice.invoicenumber = invoiceresult; invoice.custNametb.Text = reader.GetString(1); invoice.addrtb.Text = reader.GetString(2); invoice.mobiletb.Text = reader.GetString(3); temp = reader.GetString(4); separator = temp.Split(tag); invoice.paymenttypecb.Text = separator[0]; if (separator.Length > 1) { invoice.paymentDetailstb.Text = separator[1]; } else { invoice.paymentDetailstb.Text = ""; } invoice.finalsgsttb.Text = reader.GetString(8); invoice.finalcgsttb.Text = reader.GetString(9); invoice.dt = reader.GetDateTime(10);//Convert.ToDateTime(reader.GetInt32(10).ToString() + "/" + reader.GetInt32(11).ToString() + "/" + reader.GetInt32(12)); } else { MessageBox.Show("Invoice No: " + invoicenotb.Text + " not exist in the Database"); } if (invoiceresult != "") { int count = 0; cmd2 = new SqlCeCommand(query2, conn); SqlCeDataReader read = null; cmd2.Parameters.AddWithValue("@invoiceno", invoiceresult); read = cmd2.ExecuteReader(); while (read.Read()) { invoice.ItemList.Rows.Add(); invoice.ItemList.Rows[count].Cells[1].Value = read.GetString(1); // Item Name invoice.ItemList.Rows[count].Cells[2].Value = read.GetString(9); // Description invoice.ItemList.Rows[count].Cells[3].Value = read.GetString(2); // Quantity invoice.ItemList.Rows[count].Cells[4].Value = read.GetString(8); // Measuring Unit invoice.ItemList.Rows[count].Cells[5].Value = read.GetString(3); // Total Selling Price invoice.ItemList.Rows[count].Cells[6].Value = read.GetString(7); // Total Discount per item invoice.ItemList.Rows[count].Cells[7].Value = read.GetDouble(5); // percent SGST invoice.ItemList.Rows[count].Cells[8].Value = read.GetDouble(6); // percent CGST count++; } invoice.searchflag = true; invoice.ShowDialog(); } } catch (Exception ex) { MessageBox.Show("" + ex); } }