protected void Page_Load(object sender, EventArgs e) { CheckAccount(); App_Code.Base db = new App_Code.Base(WebConfigurationManager.ConnectionStrings["DefaultConnection"].ToString()); _workers = db.GetWorkers(); _hollidaysType = db.GetWorkTypes(); if (!IsPostBack) { SaveOrClear.DataSource = _soc; SaveOrClear.DataBind(); SaveOrClear.SelectedIndex = 0; HollidaysType.DataSource = _hollidaysType; HollidaysType.DataBind(); HollidaysType.SelectedIndex = 0; Base.UserInfo ui = db.GetUserInfo(_workers[0].UserName); From.Text = ui.HourBeg.ToString(); To.Text = ui.HourEnd.ToString(); Lunch.Text = ui.Lunch.ToString(); DataTable data = db.GetWorkTime(); List <Data> ls = new List <Data>(); foreach (DataRow dr in data.Rows) { ls.Add(new Data() { Name = dr["Family"].ToString() + " " + dr["IO"].ToString(), From = dr["HourBeg"].ToString(), To = dr["HourEnd"].ToString(), Lunch = dr["Lunch"].ToString() }); } Graf.DataSource = ls; Graf.DataBind(); WorkerName.DataSource = _workers; WorkerName.DataBind(); WorkerName.SelectedIndex = 0; List <string> s = db.GetIdU(); IdU.DataSource = s; IdU.DataBind(); if (s.Count > 0) { IdU.SelectedIndex = 0; } IdU_SelectedIndexChanged(sender, e); //Beg.SelectedDate = DateTime.Now.Date; //End.SelectedDate = DateTime.Now.Date.AddMonths(1); Calendar1.SelectedDate = DateTime.Now.Date; Calendar2.SelectedDate = DateTime.Now.Date.AddMonths(1); Calendar3.SelectedDate = DateTime.Now.Date; DHStart.SelectedDate = DateTime.Now.Date; DHEnd.SelectedDate = DateTime.Now.Date.AddMonths(1); Base.PersonData pd = _workers.Find(delegate(Base.PersonData i) { return(i.Title == WorkerName.SelectedValue); }); List <Base.UserLift> ul = db.GetUserLift(pd.Id); AllList.DataSource = ul; AllList.DataBind(); } }