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