public clsSellsInfo CreateSales(clsSellsInfo sales, int i) { //if (btnItemClear.Text == "Item Delete") //{ TemporarySalesID = Convert.ToInt32(lvSalesInfo.Items[i].SubItems[0].Text.ToString().Trim()); } //else if (btnFinalSave.Text == "Update") //{ TemporarySalesID = Convert.ToInt32(lvSalesInfo.Items[i].SubItems[0].Text.ToString().Trim()); } sales.customerId = Convert.ToInt32(lvlInvoiceDetailce.Items[i].SubItems[2].Text.ToString().Trim()); sales.invoiceNo = Convert.ToString(lvlInvoiceDetailce.Items[i].SubItems[1].Text.ToString().Trim()); sales.productId = Convert.ToInt32(lvlInvoiceDetailce.Items[i].SubItems[4].Text.ToString().Trim()); sales.rate = Convert.ToInt32(lvlInvoiceDetailce.Items[i].SubItems[6].Text.ToString().Trim()); sales.quantity = Convert.ToInt32(lvlInvoiceDetailce.Items[i].SubItems[7].Text.ToString().Trim()); sales.amount = Convert.ToInt32(lvlInvoiceDetailce.Items[i].SubItems[8].Text.ToString().Trim()); sales.totalAmount = Convert.ToInt32(txtTotalAmount.Text.ToString().Trim()); sales.payAmount = Convert.ToInt32(txtPayAmount.Text.ToString().Trim()); sales.dueAmount = Convert.ToInt32(txtDueAmount.Text.ToString().Trim()); sales.UserId = Convert.ToInt32(1); sales.EntryDate = System.DateTime.Now.Date; sales.UpdateDate = System.DateTime.Now.Date; return(sales); }
private void InsertAllData() { String strQuery = ""; try { if (lvlInvoiceDetailce.Items.Count != 0) { for (int i = 0; i < lvlInvoiceDetailce.Items.Count; i++) { clsSellsInfo sales = new clsSellsInfo(); sales = CreateSales(sales, i); strQuery = ""; strQuery = "INSERT INTO tbl_SellesInfo([CustomerId],[InvoiceNo],[ProductId]," + "[Rate],[Quantity],[Amount],[TotalAmount],[PayAmount],[DueAmount],[GreatTotalAmount],[UserId],[EntryDate])VALUES('" + sales.CustomerId + "','" + sales.InvoiceNo + "','" + sales.ProductId + "','" + sales.Rate + "','" + sales.Quantity + "'" + "," + sales.Amount + "," + sales.TotalAmount + "," + sales.PayAmount + "," + sales.DueAmount + ",'" + sales.GreatTotalAmount + "'," + sales.UserId + "" + ",'" + sales.EntryDate + "')"; SqlHelper.ExecuteReader(clsUtil.ConnectionString, CommandType.Text, strQuery); } MessageBox.Show("Save Data Sucessfully ."); } } catch (Exception e) { MessageBox.Show(e.Message); } }