public Inst_EditViewModel(int id, int client_id, int employee_id, string programm, string train_type, string date_created)
{
// инициализация для автозаполнения контролов и последующего неоходимого изменения
trainRoutine_field = new TrainRoutine()
{
Id = id, Client_Id = client_id, Employee_Id = employee_id, Programm = programm, Train_Type = train_type, Date_Created = date_created
};
}
public InstructorViewModel()
{
// Вкладка Расписание
string query = "";
query = string.Format(@"SELECT s.time_visit, s.date_visit, s.visit_type, s.client_id_list::TEXT FROM schedule s, employee e
WHERE s.employee_id = {0} AND e.id = {0};", Employee_Id);
NpgsqlCommand command = new NpgsqlCommand(query, DataBase.connect);
DataBase.connect.Open();
try
{
command.ExecuteNonQuery();
NpgsqlDataReader reader = command.ExecuteReader();
Schedules = new ObservableCollection <Schedule>();
while (reader.Read())
{
Schedules.Add(
new Schedule()
{
Date_Visit = reader["date_visit"].ToString(),
Time_Visit = reader["time_visit"].ToString(),
Visit_Type = reader["visit_type"].ToString(),
Client_Id_List = reader["client_id_list"].ToString().Replace("{", "").Replace("}", "").ToString()
}
);
}
reader.Close();
}
catch (Exception ex) { MessageBox.Show(ex.Message.ToString()); }
finally { DataBase.connect.Close(); }
// ##
Employee employeeModel = new Employee();
employees = new ObservableCollection <Employee>();
employees = employeeModel.GetEmployee(employee_id, employees);
trainRoutines = new ObservableCollection <TrainRoutine>();
TrainRoutine trModel = new TrainRoutine();
trainRoutines = trModel.GetTrainRoutines(employee_id, trainRoutines);
_date_created = DateTime.Now.Year.ToString() + "-" + DateTime.Now.Month.ToString() + "-" + DateTime.Now.Day.ToString();
}
