private void AddProdus_Load(object sender, EventArgs e)
{
materii = new List <Materie>(500);
used = new List <Materie>(500);
if (!newEntry)
{
string[] qq = usedStr.Split(',');
for (int i = 0; i < qq.Length; i++)
{
if (qq[i] != "")
{
Materie matt = new Materie(qq[i]);
used.Add(matt);
}
}
}
DataTable dt = Database.Select("SELECT * FROM Materii");
if (!newEntry)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
Materie matt = new Materie();
matt.set((int)dt.Rows[i][0], 0, Decimal.Parse(dt.Rows[i][2].ToString()), dt.Rows[i][1].ToString());
materii.Add(matt);
}
}
else
{
for (int i = 0; i < dt.Rows.Count; i++)
{
Materie matt = new Materie();
matt.set((int)dt.Rows[i][0], 0, Decimal.Parse(dt.Rows[i][2].ToString()), dt.Rows[i][1].ToString());
if (!used.Exists(x => x.id == matt.id))
{
materii.Add(matt);
}
}
}
updatePrice();
refreshTable();
}
private void dataGridView2_CellEndEdit(object sender, DataGridViewCellEventArgs e)
{
string str = dataGridView2.Rows[e.RowIndex].Cells[e.ColumnIndex].Value.ToString();
decimal f;
if (Decimal.TryParse(str, out f))
{
Materie q = used.Find(x => x.name == dataGridView2.Rows[e.RowIndex].Cells[0].Value.ToString());
q.quantity = f;
decimal price = q.getFinalPrice();
updatePrice();
dataGridView2.Rows[e.RowIndex].Cells["Pret"].Value = "" + price;
}
else
{
dataGridView2.Rows[e.RowIndex].Cells[e.ColumnIndex].Value = "0";
MessageBox.Show("Va rugam sa introduceti un numar valid");
}
}
public static decimal getPrice(int id)
{
string materii = Value("SELECT materii FROM Produse WHERE id_produs = '" + id + "'");
return(Materie.getPrice(materii));
}
