public void finilizeSale()
{
int saleId = db.getSaleId();
DataManager.sale saleData = new DataManager.sale();
saleData.total = float.Parse(textBox2.Text);
saleData.discount = Int32.Parse(numericUpDown1.Value.ToString());
saleData.gtotal = float.Parse(textBox4.Text);
saleData.id = saleId;
saleData.date = DateTime.Now;
if (radioButton1.Checked)
{
saleData.payment = "cash";
}
else
{
saleData.payment = "card";
}
List <DataManager.saleDetails> details = new List <DataManager.saleDetails>();
foreach (ListViewItem lvi in listView1.Items)
{
int tempId = Int32.Parse(lvi.SubItems[0].Text.ToString());
int tempQu = Int32.Parse(lvi.SubItems[3].Text.ToString());
DataManager.saleDetails tempdet = new DataManager.saleDetails();
tempdet.itemId = tempId;
tempdet.qun = tempQu;
details.Add(tempdet);
}
saleData.det = details;
db.addNewSale(saleData);
}
public List <DataManager.sale> getAllSales()
{
List <DataManager.sale> retVal = new List <DataManager.sale>();
conn.Open();
string sql = "SELECT * FROM sale";
SQLiteCommand sqCommand = new SQLiteCommand(sql, conn);
SQLiteDataReader sqReader = sqCommand.ExecuteReader();
while (sqReader.Read())
{
DataManager.sale temp = new DataManager.sale();
temp.id = sqReader.GetInt32(0);
temp.date = DateTime.Parse(sqReader.GetString(1));
temp.payment = sqReader.GetString(2);
temp.total = sqReader.GetFloat(3);
temp.discount = sqReader.GetInt32(4);
temp.gtotal = sqReader.GetFloat(5);
retVal.Add(temp);
}
for (int i = 0; i < retVal.Count; i++)
{
sql = "SELECT * FROM saleDet WHERE saleid='" + retVal[i].id + "'";
sqCommand = new SQLiteCommand(sql, conn);
sqReader = sqCommand.ExecuteReader();
List <DataManager.saleDetails> addToRetVal = new List <DataManager.saleDetails>();
while (sqReader.Read())
{
DataManager.saleDetails tmp = new DataManager.saleDetails();
tmp.itemId = sqReader.GetInt32(1);
tmp.qun = sqReader.GetInt32(2);
addToRetVal.Add(tmp);
}
retVal[i].det = addToRetVal;
}
sqReader.Close();
conn.Close();
return(retVal);
}
public void addNewSale(DataManager.sale sale)
{
conn.Open();
SQLiteCommand mycommand = new SQLiteCommand(conn);
mycommand.CommandText = "insert into sale (id,date,payment,total,discount,gtotal) values ('" + sale.id + "','" + sale.date.ToString() + "','" + sale.payment + "','" + sale.total + "','" + sale.discount + "','" + sale.gtotal + "')";
//string sql = "insert into product (id,name,des,price,image) values ('"+id+"', '"+name+"','"+des+"', '"+price+"','"+image+"')";
mycommand.ExecuteNonQuery();
string sql = "";
SQLiteCommand command;
foreach (DataManager.saleDetails temp in sale.det)
{
sql = "insert into saleDet (saleid,itemid,qun) values ('" + sale.id + "','" + temp.itemId + "','" + temp.qun + "')";
command = new SQLiteCommand(sql, conn);
command.ExecuteNonQuery();
}
conn.Close();
}