private void ActivityDetailForm_Load(object sender, EventArgs e) { DataRowView view = this.BindingContext[adaScheduleDataSet1, ACTIVITY_TABLE].Current as DataRowView; ADAScheduleDataSet.ActivityRow activityRow = view.Row as ADAScheduleDataSet.ActivityRow; if (!activityRow.IsSymbolIdNull()) { if (!activityRow.SymbolRow.IsImageNull()) { byte[] image = activityRow.SymbolRow.Image; this.pictureBoxImage.Image = ImageEngine.Resize(ImageEngine.FromArray(image), this.pictureBoxImage.Size); } } ADAScheduleDataSet.Activity_ReminderRow[] activityReminderRows = activityRow.GetActivity_ReminderRows(); foreach (ADAScheduleDataSet.Activity_ReminderRow activityReminderRow in activityReminderRows) { if (!activityReminderRow.IsTimeNull() && activityReminderRow.ReminderId == ADADataAccess.Constants.ALARM_REMINDER_ID) { this.dateTimePickerAlarm.Value = activityReminderRow.Time; _alarmTimeSpan = activityReminderRow.Time - activityRow.EndTime; } } buttonPlaySound.Enabled = (!activityRow.IsSymbolIdNull() && !activityRow.SymbolRow.IsSoundNull()); }
private void buttonOK_Click(object sender, EventArgs e) { this.BindingContext[adaScheduleDataSet1, ACTIVITY_TABLE].EndCurrentEdit(); DataRowView view = this.BindingContext[adaScheduleDataSet1, ACTIVITY_TABLE].Current as DataRowView; ADAScheduleDataSet.ActivityRow activityRow = view.Row as ADAScheduleDataSet.ActivityRow; DataRow[] rows = adaScheduleDataSet1.Activity.Select( "ActivityId <> " + activityRow.ActivityId + " AND ScheduleId = " + activityRow.ScheduleId, "Sequence DESC"); foreach (ADAScheduleDataSet.ActivityRow row in rows) { if (row.Sequence < activityRow.Sequence) { break; } row.Sequence++; } rows = adaScheduleDataSet1.Activity.Select("ScheduleId = " + activityRow.ScheduleId, "Sequence ASC"); int i = 1; foreach (ADAScheduleDataSet.ActivityRow row in rows) { row.Sequence = i++; } ADAScheduleDataSet.Activity_ReminderRow[] activityReminderRows = activityRow.GetActivity_ReminderRows(); foreach (ADAScheduleDataSet.Activity_ReminderRow activityReminderRow in activityReminderRows) { if (!activityReminderRow.IsTimeNull() && activityReminderRow.ReminderId == ADADataAccess.Constants.ALARM_REMINDER_ID) { activityReminderRow.Time = this.dateTimePickerAlarm.Value; } } }
private void copyToAntherUserToolStripMenuItem_Click(object sender, EventArgs e) { System.Data.DataRowView userRowView = this.BindingContext[adaScheduleDataSet1, "User"].Current as System.Data.DataRowView; if (userRowView != null) { ADAScheduleDataSet.UserRow currentUserRow = userRowView.Row as ADAScheduleDataSet.UserRow; SelectUserForm f = new SelectUserForm(); f.ScheduleDataSet.Merge(adaScheduleDataSet1); DataRow[] rows = f.ScheduleDataSet.User.Select("UserId=" + currentUserRow.UserId); if (rows.Length > 0) { rows[0].Delete(); } if (f.ShowDialog(this) == DialogResult.OK) { DataRow[] scheduleRows = adaScheduleDataSet1.Schedule.Select("UserId=" + f.SelectedUser.UserId); ADAScheduleDataSet.ScheduleRow currentScheduleRow = null; foreach (ADAScheduleDataSet.ScheduleRow scheduleRow in scheduleRows) { if (scheduleRow.Type == (int)ScheduleType.Normal) { currentScheduleRow = scheduleRow; break; } } if (currentScheduleRow == null) { currentScheduleRow = adaScheduleDataSet1.Schedule.NewScheduleRow(); currentScheduleRow.UserId = f.SelectedUser.UserId; currentScheduleRow.Type = (int)ScheduleType.Normal; currentScheduleRow.Date = monthCalendar1.SelectionStart; currentScheduleRow.IsActive = true; adaScheduleDataSet1.Schedule.AddScheduleRow(currentScheduleRow); } else { foreach (ADAScheduleDataSet.ActivityRow activityRow in currentScheduleRow.GetActivityRowsByFK_Activity_Schedule()) { ADAScheduleDataSet.Activity_ReminderRow[] remiderRows = activityRow.GetActivity_ReminderRows(); foreach (ADAScheduleDataSet.Activity_ReminderRow reminderRow in remiderRows) { reminderRow.Delete(); } activityRow.Delete(); } } int count = this.BindingContext[adaScheduleDataSet1, "User.FK_Schedule_User.FK_Activity_Schedule"].Count; for (int i = 0; i < count; i++) { this.BindingContext[adaScheduleDataSet1, "User.FK_Schedule_User.FK_Activity_Schedule"].Position = i; DataRowView activityRowView = this.BindingContext[adaScheduleDataSet1, "User.FK_Schedule_User.FK_Activity_Schedule"].Current as DataRowView; ADAScheduleDataSet.ActivityRow currentActivityRow = activityRowView.Row as ADAScheduleDataSet.ActivityRow; ADAScheduleDataSet.ActivityRow newActivityRow = adaScheduleDataSet1.Activity.NewActivityRow(); newActivityRow.ScheduleId = currentScheduleRow.ScheduleId; newActivityRow.Sequence = currentActivityRow.Sequence; newActivityRow.StartTime = currentActivityRow.StartTime; newActivityRow.EndTime = currentActivityRow.EndTime; newActivityRow.Name = currentActivityRow.Name; newActivityRow.SymbolId = currentActivityRow.SymbolId; newActivityRow.Image = currentActivityRow.Image; adaScheduleDataSet1.Activity.AddActivityRow(newActivityRow); ADAScheduleDataSet.Activity_ReminderRow[] remiderRows = currentActivityRow.GetActivity_ReminderRows(); foreach (ADAScheduleDataSet.Activity_ReminderRow reminderRow in remiderRows) { ADAScheduleDataSet.Activity_ReminderRow activityReminderRow = adaScheduleDataSet1.Activity_Reminder.NewActivity_ReminderRow(); activityReminderRow.ActivityId = newActivityRow.ActivityId; activityReminderRow.ReminderId = ADADataAccess.Constants.ALARM_REMINDER_ID; activityReminderRow.Time = reminderRow.Time; adaScheduleDataSet1.Activity_Reminder.AddActivity_ReminderRow(activityReminderRow); } } count = this.BindingContext[adaScheduleDataSet1, "User"].Count; for (int i = 0; i < count; i++) { this.BindingContext[adaScheduleDataSet1, "User"].Position = i; userRowView = this.BindingContext[adaScheduleDataSet1, "User"].Current as System.Data.DataRowView; currentUserRow = userRowView.Row as ADAScheduleDataSet.UserRow; if (currentUserRow.UserId == f.SelectedUser.UserId) { break; } } } } }