protected void Raport_Click(object sender, EventArgs e)
{
if (ddlRez.SelectedValue != "toate")
{
lblRez.Text = "Numar rezervari: " + Conexiune.NrRezervari(Convert.ToInt32(ddlCam.SelectedValue), ddlRez.SelectedValue, Calendar1.SelectedDate, Calendar2.SelectedDate).ToString();
LblNopti.Text = "Numar nopti: " + Conexiune.NrNopti(Convert.ToInt32(ddlCam.SelectedValue), ddlRez.SelectedValue, Calendar1.SelectedDate, Calendar2.SelectedDate).ToString();
}
else
{
int na = Conexiune.NrNopti(Convert.ToInt32(ddlCam.SelectedValue), "anulata", Calendar1.SelectedDate, Calendar2.SelectedDate);
int no = Conexiune.NrNopti(Convert.ToInt32(ddlCam.SelectedValue), "onorata", Calendar1.SelectedDate, Calendar2.SelectedDate);
int nr = Conexiune.NrNopti(Convert.ToInt32(ddlCam.SelectedValue), "receptie", Calendar1.SelectedDate, Calendar2.SelectedDate);
lblRez.Text = "Numar rezervari: " + "<table><tr><td>anulate: </td><td>" + Conexiune.NrRezervari(Convert.ToInt32(ddlCam.SelectedValue), "anulata", Calendar1.SelectedDate, Calendar2.SelectedDate).ToString() + "</td></tr>"
+ "<tr><td>onorate: </td><td>" + Conexiune.NrRezervari(Convert.ToInt32(ddlCam.SelectedValue), "onorata", Calendar1.SelectedDate, Calendar2.SelectedDate).ToString() + "</td></tr>"
+ "<tr><td>receptie: </td><td>" + Conexiune.NrRezervari(Convert.ToInt32(ddlCam.SelectedValue), "receptie", Calendar1.SelectedDate, Calendar2.SelectedDate).ToString() + "</td></tr>"
+ "<tr><td>despagubiri: </td><td>" + Conexiune.NrRezervari(Convert.ToInt32(ddlCam.SelectedValue), "despagubire", Calendar1.SelectedDate, Calendar2.SelectedDate).ToString() + "</td></tr>"
+ "<tr><td>rezervari: </td><td>" + Conexiune.NrRezervari(Convert.ToInt32(ddlCam.SelectedValue), "rezervare", Calendar1.SelectedDate, Calendar2.SelectedDate).ToString() + "</td></tr></table>";
LblNopti.Text = "Numar nopti: " + "<table><tr><td>anulate: </td><td>" + na.ToString() + "</td></tr>"
+ "<tr><td>onorate: </td><td>" + no.ToString() + "</td></tr>"
+ "<tr><td>receptie: </td><td>" + nr.ToString() + "</td></tr>"
+ "<tr><td>despagubiri: </td><td>" + Conexiune.NrNopti(Convert.ToInt32(ddlCam.SelectedValue), "despagubirq", Calendar1.SelectedDate, Calendar2.SelectedDate).ToString() + "</td></tr>"
+ "<tr><td>rezervari: </td><td>" + Conexiune.NrNopti(Convert.ToInt32(ddlCam.SelectedValue), "rezervare", Calendar1.SelectedDate, Calendar2.SelectedDate).ToString() + "</td></tr></table>";
/* PieChart1.PieChartValues.Add(new AjaxControlToolkit.PieChartValue { Category = "anulate", Data = na });
* PieChart1.PieChartValues.Add(new AjaxControlToolkit.PieChartValue { Category = "onorate", Data = no });
* PieChart1.PieChartValues.Add(new AjaxControlToolkit.PieChartValue { Category = "receptie", Data = nr });
* PieChart1.PieChartValues.Add(new AjaxControlToolkit.PieChartValue { Category = "libere", Data = (int)(Calendar2.SelectedDate-Calendar1.SelectedDate).TotalDays - na-no-nr});*/
}
}
protected void btnRez_Click(object sender, EventArgs e)
{
Camera camera = (Camera)Session["Camera"];
Rezervare rez = new Rezervare(camera.Id, Convert.ToDateTime(Session["Data1"]), Convert.ToDateTime(Session["Data2"]), txtNume.Text, txtCNP.Text, txtBuletin.Text, txtAdr.Text, txtTel.Text, txtMail.Text, "cerere");
Session["mail"] = txtMail.Text;
lblRes.Text = Conexiune.Rezerva(rez);
}
protected void Button1_Click(object sender, EventArgs e)
{
AdImg.SaveAs(@"C:\Users\Maria\Documents\GitHub\TW\Hotel1\Imagini\" + AdImg.FileName);
Camera camera = new Camera(txtTip.Text, txtDetalii.Text, txtFacilitati.Text, txtVedere.Text, "../Imagini/" + AdImg.FileName, (int)Convert.ToInt32(txtPret.Text), (int)Convert.ToInt32(txtNr.Text), (int)Convert.ToInt32(txtNrO.Text));
Conexiune.AdaugaCamera(camera);
}
protected void btnLogin_Click(object sender, EventArgs e)
{
Utilizator utliz = Conexiune.Logare(txtLogare.Text, txtParola.Text);
if (utliz != null)
{
Session["login"] = utliz.Nume;
Session["type"] = utliz.Tip;
Response.Redirect("~/Pages/Home.aspx");
}
else
{
lblEr.Text = "Login failed";
}
}
protected void btnInreg_Click(object sender, EventArgs e)
{
Utilizator utiliz = new Utilizator(txtNume.Text, txtParola.Text, txtEmail.Text, "user");
lblRez.Text = Conexiune.Inregistrare(utiliz);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Calendar1.SelectedDate = DateTime.Now;
Calendar2.SelectedDate = DateTime.Now;
}
txtData1.Text = Calendar1.SelectedDate.ToShortDateString();
txtData2.Text = Calendar2.SelectedDate.ToShortDateString();
ArrayList camere = Conexiune.CautaCamera(ddlCam.SelectedValue, Calendar1.SelectedDate, Calendar1.SelectedDate, ddlPret.SelectedValue);
int nr = -1;
foreach (Camera camera in camere)
{
nr++;
string[] Img = camera.Imagini.Split('|');
Panel CamPanel = new Panel();
Image image = new Image
{
ImageUrl = Img[1],
CssClass = "CImg"
};
Literal literal = new Literal()
{
Text = "<div>"
};
Literal literal1 = new Literal()
{
Text = "</div>"
};
Literal literal2 = new Literal()
{
Text = "<br />"
};
Literal literal3 = new Literal()
{
Text = "<br />"
};
Literal literal4 = new Literal()
{
Text = "<br />"
};
Literal literal5 = new Literal()
{
Text = "<br />"
};
Literal literal6 = new Literal()
{
Text = "<br />"
};
Label lblTip = new Label
{
Text = "Camera " + camera.Tip,
CssClass = "CTip"
};
Label lblDetalii = new Label
{
Text = camera.Detalii,
CssClass = "CDescr"
};
Label lblVedere = new Label
{
Text = camera.Vedere,
CssClass = "CDescr"
};
Label lblPret = new Label
{
Text = string.Format("{0:0.00}", camera.Pret + " RON <br />"),
CssClass = "CPret"
};
Button Rezerva = new Button
{
ID = nr.ToString(),
Text = "Rezerva",
CssClass = "CBtn"
};
Rezerva.Click += delegate(object ss, EventArgs ee)
{
int x = Convert.ToInt32(Rezerva.ID);
Session["Camera"] = (Camera)camere[x];
Session["Data1"] = Calendar1.SelectedDate;
Session["Data2"] = Calendar2.SelectedDate;
Camera c = (Camera)camere[x];
Session["Img"] = c.Imagini;
if (Session["Camera"] != null)
{
Response.Redirect("~/Pages/Formular.aspx");
}
};
//Rezerva.PostBackUrl = "~/Pages/Formular.aspx";
CamPanel.Controls.Add(literal);
CamPanel.Controls.Add(literal5);
CamPanel.Controls.Add(image);
CamPanel.Controls.Add(lblTip);
CamPanel.Controls.Add(literal2);
CamPanel.Controls.Add(lblDetalii);
CamPanel.Controls.Add(literal3);
CamPanel.Controls.Add(lblVedere);
CamPanel.Controls.Add(literal4);
CamPanel.Controls.Add(lblPret);
CamPanel.Controls.Add(literal5);
CamPanel.Controls.Add(Rezerva);
CamPanel.Controls.Add(literal1);
Panel1.Controls.Add(CamPanel);
}
}
protected void Button3_Click(object sender, EventArgs e)
{
Conexiune.RespingeCerere(GridView3.SelectedRow.Cells[1].Text, GridView3.SelectedRow.Cells[10].Text);
}
