protected void SortDDL_SelectedIndexChanged(object sender, EventArgs e)
{
DataSet ds;
VacationService vs = new VacationService();
string whereclout = " WHERE DoctorId=VacationDoctorId and ManagerId=VacationManagerId";
int x = SortDDL.SelectedIndex;
switch (x)
{
case 1:
{
whereclout += " ORDER BY VacationDoctorId";
break;
}
case 2:
{
whereclout += " ORDER BY VacationManagerId";
break;
}
case 3:
{
whereclout += " ORDER BY VacationStartDate";
break;
}
}
ds = vs.SortVacation(whereclout);
if (ds.Tables[0].Rows.Count != 0)
{
CloseVac.Visible = true;
ShowVac.Visible = true;
ShowVac.DataSource = ds;
ShowVac.DataBind();
}
else
{
Response.Write("<script>alert('לא נמצאו חופשות')</script>");
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
Manager m = (Manager)Session["manager"];
HelloLabel.Text = m.CManagerName;
GetAllData.VacationsForDoctor();
VacationService vs = new VacationService();
string whereclout = " WHERE DoctorId=VacationDoctorId and ManagerId=VacationManagerId";
DataSet ds = vs.SortVacation(whereclout);
ShowVac.Visible = false;
if (ds.Tables[0].Rows.Count != 0)
{
CloseVac.Visible = true;
ShowVac.Visible = true;
ShowVac.DataSource = ds;
ShowVac.DataBind();
}
else
{
Response.Write("<script>alert('לא נמצאו חופשות')</script>");
}
}
}
