public static List <MeniuModel> Get(int idUtilizator)
{
List <MeniuModel> comenzi = new List <MeniuModel>();
using (SqlConnection con = new SqlConnection(SqlDataAcces.ConnectionString))
{
con.Open();
string cmdText = "Select kcal, denumire_produs " +
"from Comenzi c, Subcomenzi s, Meniu m " +
"where c.id_client = @id and c.id_comanda = s.id_comanda and s.id_produs = m.id_produs;";
using (SqlCommand cmd = new SqlCommand(cmdText, con))
{
cmd.Parameters.AddWithValue("id", idUtilizator);
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
MeniuModel item = new MeniuModel
{
DenumereaProdus = (string)reader["denumire_produs"],
KCal = (int)reader["kcal"]
};
comenzi.Add(item);
}
}
}
}
return(comenzi);
}
public static void Initializare()
{
SqlDataAcces.ClearDB();
string filePath = "Resurse\\meniu.txt";
using (StreamReader reader = new StreamReader(filePath))
{
reader.ReadLine();
while (reader.Peek() >= 0)
{
var line = reader.ReadLine().Split(';').ToList();
if (line[0] == "")
{
break;
}
MeniuModel meniu = new MeniuModel
{
Id = int.Parse(line[0]),
DenumereaProdus = line[1],
Descriere = line[2],
Pret = int.Parse(line[3]),
KCal = int.Parse(line[4]),
Felul = int.Parse(line[5])
};
using (SqlConnection con = new SqlConnection(SqlDataAcces.ConnectionString))
{
con.Open();
string cmdText = "Insert into Meniu (id_produs, denumire_produs, descriere, pret, kcal, felul) " +
"Values (@id, @nume, @descriere, @pret, @kcal, @felul) ;";
using (SqlCommand cmd = new SqlCommand(cmdText, con))
{
cmd.Parameters.AddWithValue("id", meniu.Id);
cmd.Parameters.AddWithValue("nume", meniu.DenumereaProdus);
cmd.Parameters.AddWithValue("descriere", meniu.Descriere);
cmd.Parameters.AddWithValue("pret", meniu.Pret);
cmd.Parameters.AddWithValue("kcal", meniu.KCal);
cmd.Parameters.AddWithValue("felul", meniu.Felul);
cmd.ExecuteNonQuery();
}
}
}
}
}
private void button3_Click(object sender, EventArgs e)
{
DataTable table = DataAcces.SqlDataAcces.GetMeniu();
List <MeniuModel> mancaruri = new List <MeniuModel>();
foreach (DataRow item in table.Rows)
{
MeniuModel men = new MeniuModel
{
Id = (int)item["id_produs"],
DenumereaProdus = (string)item["denumire_produs"],
KCal = (int)item["kcal"],
Pret = (int)item["pret"],
Felul = (int)item["felul"]
};
mancaruri.Add(men);
}
DataTable newTable = new DataTable();
newTable.Columns.Add("IdFelul1");
newTable.Columns.Add("IdFelul2");
newTable.Columns.Add("IdFelul3");
newTable.Columns.Add("Felul1");
newTable.Columns.Add("Felul2");
newTable.Columns.Add("Felul3");
newTable.Columns.Add("Total Kcal");
newTable.Columns.Add("Pret total");
int budget = 0;
int kcalMax = 0;
int.TryParse(textBox8.Text, out budget);
int.TryParse(textBox10.Text, out kcalMax);
List <MeniuModel> feluri1 = mancaruri.Where(x => x.Felul == 1).ToList();
List <MeniuModel> feluri2 = mancaruri.Where(x => x.Felul == 2).ToList();
List <MeniuModel> feluri3 = mancaruri.Where(x => x.Felul == 3).ToList();
(from fel1 in feluri1
from fel2 in feluri2
from fel3 in feluri3
where fel1.Pret + fel2.Pret + fel3.Pret <= budget && fel1.KCal + fel2.KCal + fel3.KCal <= kcalMax
select new
{
IdFelul1 = fel1.Id,
IdFelul2 = fel2.Id,
IdFelul3 = fel3.Id,
Felul1 = fel1.DenumereaProdus,
Felul2 = fel2.DenumereaProdus,
Felul3 = fel3.DenumereaProdus,
TotalKCal = fel1.KCal + fel2.KCal + fel3.KCal,
PretTotal = fel1.Pret + fel2.Pret + fel3.Pret
}).ToList().Select(x =>
{
DataRow temp = newTable.NewRow();
temp["IdFelul1"] = x.IdFelul1;
temp["IdFelul2"] = x.IdFelul2;
temp["IdFelul3"] = x.IdFelul3;
temp["Felul1"] = x.Felul1;
temp["Felul2"] = x.Felul2;
temp["Felul3"] = x.Felul3;
temp["Total Kcal"] = x.TotalKCal;
temp["Pret total"] = x.PretTotal;
return(temp);
}).ToList().ForEach(x => newTable.Rows.Add(x));
dataGridView2.DataSource = newTable;
dataGridView2.Columns["IdFelul1"].Visible = dataGridView2.Columns["IdFelul2"].Visible = dataGridView2.Columns["IdFelul3"].Visible = false;
DataGridViewButtonColumn btn = new DataGridViewButtonColumn();
btn.HeaderText = "Alege";
btn.Text = "Alege";
btn.UseColumnTextForButtonValue = true;
dataGridView2.Columns.Add(btn);
}