/// <summary>
/// Возвращает названия блюд,вес и калораж на ужин
/// </summary>
public class_food[] get_food_supper(int date)
{
class_food[] food = new class_food[512];
string query = "select distinct F.ID_food,Fim.count_serve,Name_food, F.Finish_weight_of_food,F.Full_calories from Food_in_menu FIM" +
" join Foods F on F.ID_food = FIM.ID_food " +
" where FIM.Serve_time_of_food ='ужин'" + " and day_id='" + date + "'";
try
{
SqlCommand com = Program.data_module._conn.CreateCommand();
com.CommandText = query;
int i = 0;
SqlDataReader rd = com.ExecuteReader();
while (rd.Read())
{
i = i + 1;
food[i] = new class_food();
food[i].result = "OK";
food[i].food_id = rd.GetInt32(0).ToString();
food[i].name = rd.GetString(2);
if (rd.IsDBNull(1))
{ food[i].count_portc = ""; }
else
food[i].count_portc = rd.GetInt32(1).ToString();
if (rd.IsDBNull(2))
{ food[i].weight = ""; }
else
food[i].weight = rd.GetDouble(3).ToString();
food[i].calories = rd.GetDouble(4).ToString();
}
rd.Close();
rd.Dispose();
com.Dispose();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message + " " + ex.Data);
return null;
}
return food;
}
/// <summary>
/// Возвращает общий вес ингредиентов на ужин
/// </summary>
public class_ingr_in_food[] get_sum_supper(int day)
{
class_food[] food = new class_food[512];
class_ingr_in_food[] foods = new class_ingr_in_food[512];
string query = "select Sum( count_serve * Net_weight /1000 ) from Ingridients_in_food join Food_in_menu on Ingridients_in_food.ID_food = Food_in_menu.ID_food " + " where Food_in_menu.day_id='" + day + "'" + "and Food_in_menu.Serve_time_of_food='ужин'" + " group by Ingridients_in_food.Id_ingridients";
try
{
SqlCommand com = Program.data_module._conn.CreateCommand();
com.CommandText = query;
SqlDataReader rd = com.ExecuteReader();
int i = 0;
while (rd.Read())
{
i++;
foods[i] = new class_ingr_in_food();
foods[i].result = "OK";
if (rd.IsDBNull(0))
{
foods[i].net = "";
}
else
{
foods[i].net = rd.GetDouble(0).ToString();
}
}
rd.Close();
rd.Dispose();
com.Dispose();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message + " " + ex.Data);
return null;
}
return foods;
}
/// <summary>
/// Возвращает калории для блюда на ужин
/// </summary>
public class_food[] get_cal_supper(int day)
{
class_food[] foods = new class_food[512];
string query = "select Sum(Full_calories) From Foods join Food_in_menu on Foods.ID_food=Food_in_menu.ID_food where Food_in_menu.Serve_time_of_food='ужин' and Food_in_menu.day_id='" + day + "'";
try
{
SqlCommand com = Program.data_module._conn.CreateCommand();
com.CommandText = query;
SqlDataReader rd = com.ExecuteReader();
int i = 0;
while (rd.Read())
{
i++;
foods[i] = new class_food();
foods[i].result = "OK";
if (rd.IsDBNull(0))
{
foods[i].count_cal_food = "";
}
else
{
foods[i].count_cal_food = rd.GetDouble(0).ToString();
}
}
rd.Close();
rd.Dispose();
com.Dispose();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message + " " + ex.Data);
return null;
}
return foods;
}
/// <summary>
/// возвращает блюдо по указанному в параметрах идентификатору (коду)
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public class_food get_food(int id)
{
class_food food = new class_food();
string query = "select * from Foods where ID_food=";
query += id.ToString();
try
{
SqlCommand com = Program.data_module._conn.CreateCommand();
com.CommandText = query;
SqlDataReader rd = com.ExecuteReader();
if (rd.Read())
{
food.result = "OK";
food.food_id = id.ToString();
food.name = rd.GetString(1);
if (rd.IsDBNull(2))
{
food.calories = "";
}
else
{
food.calories = rd.GetDouble(2).ToString();
}
if (rd.IsDBNull(3))
{
food.proteins = "";
}
else
{
food.proteins = rd.GetDouble(3).ToString();
}
if (rd.IsDBNull(4))
{
food.fats = "";
}
else
{
food.fats = rd.GetDouble(4).ToString();
}
if (rd.IsDBNull(5))
{
food.carbo = "";
}
else
{
food.carbo = rd.GetDouble(5).ToString();
}
if (rd.IsDBNull(6))
{
food.weight = "";
}
else
{
food.weight = rd.GetDouble(6).ToString();
}
}
rd.Close();
rd.Dispose();
com.Dispose();
}
catch (Exception ex)
{
food.result = "ERROR_" + ex.Data + " " + ex.Message;
}
return food;
}
/// <summary>
/// Заполняем лист бокс номерами диет при выборе блюда
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void lb_food_name_SelectedValueChanged(object sender, EventArgs e)
{
//получаем ID выбранного блюда
class_food diet = new class_food();
string query = "select ID_food from Foods "
+ "where Name_food = '" + lb_food_name.Text + "'";
try
{
SqlCommand com = Program.data_module._conn.CreateCommand();
com.CommandText = query;
SqlDataReader rd = com.ExecuteReader();
if (rd.Read())
{
diet = new class_food();
diet.food_id = rd.GetInt32(0).ToString();
}
rd.Close();
rd.Dispose();
com.Dispose();
}
catch (Exception ex)
{
diet.result = "ERROR_" + ex.Data + " " + ex.Message;
}
//поолучаем список диет
class_diet_in_food[] diet_in_food = new class_diet_in_food[512];
diet_in_food = Program.add_read_module.get_list_diet_id(Convert.ToInt32(diet.food_id));
if (diet_in_food != null)
{
this.lb_diet_numb.Items.Clear();
for (int i = 1; i < diet_in_food.Count(); i++)
{
if (diet_in_food[i] != null)
{
this.lb_diet_numb.Items.Add(diet_in_food[i].diet_numb);
}
else
{
break;
}
}
}
//Записываем номер карты выбранного блюда в текст бокс
class_diet_in_food card = new class_diet_in_food();
card = Program.add_read_module.get_list_card_id(Convert.ToInt32(diet.food_id));
if (card != null)
{
tb_card_numb.Text = card.card_numb;
}
}
/// <summary>
/// Возвращает по наименованию блюда значения общий вес блюда и т.п
/// </summary>
/// <returns>Общий вес,общую калорийность и т.д </returns>
public class_food[] food1()
{
class_food[] foods_list1 = new class_food[512];
string query = "select * from Foods where Name_food='";
string query1 = this.cb_food.Text + "'";
string query3 = query + query1; ;
try
{
SqlCommand com = Program.data_module._conn.CreateCommand();
com.CommandText = query3;
int i = 0;
SqlDataReader rd = com.ExecuteReader();
while (rd.Read())
{
i = i + 1;
foods_list1[i] = new class_food();
foods_list1[i].result = "OK";
if (rd.IsDBNull(1))
{
foods_list1[i].food_id = ""; }
else
{
foods_list1[i].food_id = rd.GetInt32(0).ToString();
}
if (rd.IsDBNull(1))
{
foods_list1[i].name = "";
}
else
{
foods_list1[i].name = rd.GetString(1).ToString();
}
if (rd.IsDBNull(2))
{
foods_list1[i].calories = "0";
}
else
{
foods_list1[i].calories = rd.GetDouble(2).ToString();
}
if (rd.IsDBNull(3))
{
foods_list1[i].proteins = "0";
}
else
{
foods_list1[i].proteins = rd.GetDouble(3).ToString();
}
if (rd.IsDBNull(4))
{
foods_list1[i].fats = "0";
}
else
{
foods_list1[i].fats = rd.GetDouble(4).ToString();
}
if (rd.IsDBNull(5))
{
foods_list1[i].carbo = "0";
}
else
{
foods_list1[i].carbo = rd.GetDouble(5).ToString();
}
if (rd.IsDBNull(6))
{
foods_list1[i].weight = "0";
}
else
{
foods_list1[i].weight = rd.GetDouble(6).ToString();
}
}
rd.Close();
rd.Dispose();
com.Dispose();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message + " " + ex.Data);
return null;
}
return foods_list1;
}
/// <summary>
/// Метод который по sql запросу возвращает наименование блюд
/// </summary>
/// <returns> имя блюда </returns>
public class_food[] food()
{
class_food[] foods_list = new class_food[512];
string query = "select * from Foods ";
string query2 = query;
try
{
SqlCommand com = Program.data_module._conn.CreateCommand();
com.CommandText = query2;
int i = 0;
SqlDataReader rd = com.ExecuteReader();
while (rd.Read())
{
i = i + 1;
foods_list[i] = new class_food();
foods_list[i].result = "OK";
if (rd.IsDBNull(1))
{ foods_list[i].name = ""; }
else
foods_list[i].name = rd.GetString(1).ToString();
}
rd.Close();
rd.Dispose();
com.Dispose();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message + " " + ex.Data);
return null;
}
return foods_list;
}
/// <summary>
/// Возвращает название и id 8-го блюда падаваемого на обед
/// </summary>
public class_food[] food_dinner8()
{
class_food[] foods_list = new class_food[512];
string query = "select * from Foods Where ID_food ='";
if (_food_list_dinner[8] == null) { foods_list = null; }
else
{
string g1 = this._food_list_dinner[8].food_id + "'";
string query2 = query + g1;
try
{
SqlCommand com = Program.data_module._conn.CreateCommand();
com.CommandText = query2;
int i = 0;
SqlDataReader rd = com.ExecuteReader();
while (rd.Read())
{
i = i + 1;
foods_list[i] = new class_food();
foods_list[i].result = "OK";
foods_list[i].name = rd.GetString(1);
foods_list[i].weight = rd.GetDouble(6).ToString();
}
rd.Close();
rd.Dispose();
com.Dispose();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message + " " + ex.Data);
return null;
}
}
return foods_list;
}
