예제 #1
0
        //Show All appointment based on userID
        public void DisplayWorkDay()
        {
            List <Schedule> listSchedule = db.GetAllAppointment();

            lvShowWorkDay.Items.Clear();

            List <DateTime> dates = new List <DateTime>();

            foreach (Schedule c in listSchedule)
            {
                lvShowWorkDay.Items.Add(c);
                dates.Add(c.ScheduleDate);
            }
            AppointmentDayConverter.LoadAppointments(dates);
        }
예제 #2
0
        private void btnSave_Click(object sender, RoutedEventArgs e)
        {
            Schedule schedule = new Schedule();

            schedule.Note         = tbNote.Text;
            schedule.ScheduleDate = Convert.ToDateTime(dpDate.Text);
            schedule.StartTime    = tpStart.Text;
            schedule.EndTime      = tpEnd.Text;
            schedule.Subject      = tbSubject.Text;
            schedule.SalesRepId   = Convert.ToInt32(Application.Current.Resources["UserName"]);
            schedule.CustomerID   = Convert.ToInt32(lblCustomerID.Content);
            ComboBoxItem comboType = (ComboBoxItem)dpType.SelectedItem;

            schedule.Type = comboType.Content.ToString();


            schedule.Status      = cmbState.SelectedIndex;
            schedule.Schedule_id = Convert.ToInt32(lblScheduleID.Content.ToString());
            try
            {
                db = new Database();
                db.UpdateAppointment(schedule);
            }
            catch (SqlException ex)
            {
                MessageBox.Show(ex.Message);
                return;
            }

            this.Close();

            //refresh the list
            var             calendar     = new Calendar();
            List <Schedule> scheduleList = db.GetAllAppointment();
            List <DateTime> dates        = new List <DateTime>();

            calendar.lvShowWorkDay.Items.Clear();
            foreach (Schedule s in scheduleList)
            {
                calendar.lvShowWorkDay.Items.Add(s);
                dates.Add(s.ScheduleDate);
            }
            var mainWin = Application.Current.Windows.Cast <Window>().FirstOrDefault(window => window is MainWindow) as MainWindow;

            AppointmentDayConverter.LoadAppointments(dates);
            mainWin.frTest.Refresh();
        }