protected void Page_Load(object sender, EventArgs e)
{
if (Session["username"] == null)
{
Response.Redirect("Home_Page.aspx");
}
if (!IsPostBack)
{
//SqlCommand cmd = new SqlCommand("SELECT d.Id, d.nazwa, d.kategoria, d.przepis FROM Danie d, Dania_Menu dm, Menu m, Konto k WHERE d.Id=dm.Id_dania AND dm.Id_menu=m.id AND k.Id = m.id_klienta AND k.login='******' AND m.data='" + Calendar.SelectedDate + "' ORDER BY 2", new SqlConnection(constr));
//SqlCommand cmd = new SqlCommand("SELECT d.Id, d.nazwa, d.kategoria, d.przepis FROM Danie d, Dania_Menu dm, Menu m, Konto k WHERE d.Id=dm.Id_dania AND dm.Id_menu=m.id AND k.Id = m.id_klienta AND k.login='******' AND CONVERT(date, m.data, 103)=CONVERT(date, '" + Calendar.SelectedDate + "', 103) ORDER BY 2", new SqlConnection(constr));
SqlCommand cmd = new SqlCommand("SELECT d.Id, d.nazwa, d.kategoria, d.przepis FROM Danie d, Dania_Menu dm, Menu m, Konto k WHERE d.Id=dm.Id_dania AND dm.Id_menu=m.id AND k.Id = m.id_klienta AND k.login='******' AND CONVERT(date, m.data, 103)=CONVERT(date, '" + Calendar.SelectedDate.ToShortDateString() + "', 23) ORDER BY 2", new SqlConnection(constr));
SqlDataAdapter sda = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
sda.Fill(dt);
RepeaterKalendarz.DataSource = dt;
RepeaterKalendarz.DataBind();
}
SqlConnection con = new SqlConnection(constr);
con.Open();
SqlCommand sql = new SqlCommand("SELECT CONCAT(imie, ' ', nazwisko) FROM Konto WHERE login='******'", con);
sql.CommandType = CommandType.Text;
LabelName.Text = sql.ExecuteScalar() as string;
con.Close();
}
protected void Calendar_SelectionChanged(object sender, EventArgs e)
{
Label_Data.Text = "Twoje Menu na " + Calendar.SelectedDate.ToShortDateString();
//SqlCommand cmd = new SqlCommand("SELECT d.Id, d.nazwa, d.kategoria, d.przepis FROM Danie d, Dania_Menu dm, Menu m, Konto k WHERE d.Id=dm.Id_dania AND dm.Id_menu=m.id AND k.Id = m.id_klienta AND k.login='******' AND m.data='" + Calendar.SelectedDate + "' ORDER BY 2", new SqlConnection(constr));
//SqlCommand cmd = new SqlCommand("SELECT d.Id, d.nazwa, d.kategoria, d.przepis FROM Danie d, Dania_Menu dm, Menu m, Konto k WHERE d.Id=dm.Id_dania AND dm.Id_menu=m.id AND k.Id = m.id_klienta AND k.login='******' AND CONVERT(date, m.data, 103)=CONVERT(date, '" + Calendar.SelectedDate + "', 103) ORDER BY 2", new SqlConnection(constr));
SqlCommand cmd = new SqlCommand("SELECT d.Id, d.nazwa, d.kategoria, d.przepis FROM Danie d, Dania_Menu dm, Menu m, Konto k WHERE d.Id=dm.Id_dania AND dm.Id_menu=m.id AND k.Id = m.id_klienta AND k.login='******' AND CONVERT(date, m.data, 103)=CONVERT(date, '" + Calendar.SelectedDate.ToShortDateString() + "', 23) ORDER BY 2", new SqlConnection(constr));
SqlDataAdapter sda = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
sda.Fill(dt);
RepeaterKalendarz.DataSource = dt;
RepeaterKalendarz.DataBind();
KalendarzListDiv.Visible = true;
SkladnikiListDiv.Visible = false;
}
