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