public MealSearcher(int idDiet)
{
InitializeComponent();
this.ClientSize = new System.Drawing.Size(815, 570);
/// FoodType load
foodTypeDict = LoadDB.LoadDBByte("FoodTypes", "IdFoodTypes", "Type");
foodStyleDict = LoadDB.LoadDBByte("FoodStyle", "IdStyle", "Style");
foodDietDict = LoadDB.LoadDBByte("FoodDiet", "IdDiet", "Diet");
/// CheckBoxLoad
LoadCheckListBox(chLBFoodType, foodTypeDict);
LoadCheckListBox(chLBDiet, foodDietDict);
LoadCheckListBox(chLBStyle, foodStyleDict);
/// Ingridients load
LoadIngridients();
Search();
this.idDiet = idDiet;
datTimPickDate.Value = DateTime.Today.Date + new TimeSpan(12, 00, 00);
datTimPickDate.CustomFormat = "HH:mm - dddd d MMMM yyyy";
}
public Diet()
{
InitializeComponent();
this.ClientSize = new System.Drawing.Size(324, 155);
dateTPMin.CustomFormat = "ddd d.MM.yyyy";
dateTPMax.CustomFormat = "ddd d.MM.yyyy";
LoadDietsToLV();
UserDiets = LoadDB.LoadDInt("[" + X.IdUser + "_diets]", "IdDiet", "Name");
LoadUserDietsToCheckB();
}
public AddNewRecipe()
{
InitializeComponent();
LoadIngridients();
/// FoodType/Style/Diet load
foodTypeDict = LoadDB.LoadDBByte("FoodTypes", "IdFoodTypes", "Type");
foodStyleDict = LoadDB.LoadDBByte("FoodStyle", "IdStyle", "Style");
foodDietDict = LoadDB.LoadDBByte("FoodDiet", "IdDiet", "Diet");
LoadComboBox(comBDiet, foodDietDict);
LoadComboBox(comBStyle, foodStyleDict);
LoadComboBox(comBType, foodTypeDict);
LoadMeasureTypes();
}
public Main()
{
InitializeComponent();
this.ClientSize = new System.Drawing.Size(818, 575);
/// FoodType load
foodTypeDict = LoadDB.LoadDBByte("FoodTypes", "IdFoodTypes", "Type");
foodStyleDict = LoadDB.LoadDBByte("FoodStyle", "IdStyle", "Style");
foodDietDict = LoadDB.LoadDBByte("FoodDiet", "IdDiet", "Diet");
/// CheckBoxLoad
LoadCheckListBox(chLBFoodType, foodTypeDict);
LoadCheckListBox(chLBDiet, foodDietDict);
LoadCheckListBox(chLBStyle, foodStyleDict);
/// Ingridients load
LoadIngridients();
Search();
}
/// Delete diet
private void DeleteToolStripMenuItem_Click(object sender, EventArgs e)
{
if (MessageBox.Show("Are you sure you want to delete " + listVDiets.SelectedItems[0].SubItems[0].Text + " diet?", "Delete Diet", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.Yes)
{
using (SqlConnection sqlConnection = new SqlConnection(X.ConnectionString("DB")))
{
SqlCommand sqlCommandDelDiet = new SqlCommand("DELETE FROM [" + X.IdUser + "_diets] WHERE IdDiet = " + listVDiets.SelectedItems[0].SubItems[1].Text, sqlConnection)
{
CommandType = CommandType.Text
};
SqlCommand sqlCommandDropDiet = new SqlCommand("DROP TABLE [" + X.IdUser + "_" + listVDiets.SelectedItems[0].SubItems[1].Text + "_diet];", sqlConnection)
{
CommandType = CommandType.Text
};
sqlConnection.Open();
sqlCommandDelDiet.ExecuteNonQuery();
sqlCommandDropDiet.ExecuteNonQuery();
sqlConnection.Close();
sqlCommandDelDiet.Dispose();
sqlCommandDropDiet.Dispose();
}
}
if (idDiet == int.Parse(listVDiets.SelectedItems[0].SubItems[1].Text))
{
listVDiet.Items.Clear();
}
UserDiets.Clear();
UserDiets = LoadDB.LoadDInt("[" + X.IdUser + "_diets]", "IdDiet", "Name");
LoadUserDietsToCheckB();
LoadDietsToLV();
}
private void ButConfirm_Click(object sender, EventArgs e)
{
///Number of diets check
if (UserDiets.Count == MaxDietsPerUser)
{
lblNameInfo.Text = "You have the maximum number of diets";
lblNameInfo.Visible = true;
return;
}
///Name validation
string name = txtName.Text.ToString().Trim();
if (name.Length == 0)
{
lblNameInfo.Text = "Give correct name";
lblNameInfo.Visible = true;
return;
}
/// checking same name in DB
using (SqlConnection sqlConnection = new SqlConnection(X.ConnectionString("DB")))
{
SqlDataAdapter sqlDataAdapter = new SqlDataAdapter("select * from [" + X.IdUser + "_diets] where name = '" + name + "'", sqlConnection);
DataTable dataTable = new DataTable();
sqlDataAdapter.Fill(dataTable);
sqlDataAdapter.Dispose();
if (dataTable.Rows.Count == 1)
{
lblNameInfo.Text = "There already is a diet with same name";
lblNameInfo.Visible = true;
return;
}
}
/// adding diet to user diet list
using (SqlConnection sqlConnection = new SqlConnection(X.ConnectionString("DB")))
{
SqlCommand sqlCommandAddDiet = new SqlCommand("Insert into [" + X.IdUser + "_diets] (Name) values ('" + name + "') ", sqlConnection)
{
CommandType = CommandType.Text
};
sqlConnection.Open();
sqlCommandAddDiet.ExecuteNonQuery();
sqlConnection.Close();
sqlCommandAddDiet.Dispose();
}
/// adding diet DB
using (SqlConnection sqlConnection = new SqlConnection(X.ConnectionString("DB")))
{
SqlDataAdapter sqlDataAdapter = new SqlDataAdapter("select * from [" + X.IdUser + "_diets] where name = '" + name + "'", sqlConnection);
DataTable dataTable = new DataTable();
sqlDataAdapter.Fill(dataTable);
sqlDataAdapter.Dispose();
SqlCommand sqlCommandAddNewDietDB = new SqlCommand("CreateDiet", sqlConnection)
{
CommandType = CommandType.StoredProcedure
};
sqlCommandAddNewDietDB.Parameters.AddWithValue("@IdDiet", dataTable.Rows[0].Field <int>("IdDiet"));
sqlCommandAddNewDietDB.Parameters.AddWithValue("@IdUser", X.IdUser);
sqlConnection.Open();
sqlCommandAddNewDietDB.ExecuteNonQuery();
sqlConnection.Close();
}
UserDiets.Clear();
UserDiets = LoadDB.LoadDInt("[" + X.IdUser + "_diets]", "IdDiet", "Name");
LoadDietsToLV();
LoadUserDietsToCheckB();
lblName.Visible = false;
txtName.Visible = false;
butConfirm.Visible = false;
lblNameInfo.Visible = false;
txtName.Text = "";
}
