public FrmManEmpleadoPeriodo(ObservableListSource <PeriodoLaboral> viewModelList) { InitializeComponent(); ViewModel = new PeriodoLaboral(); ViewModelList = viewModelList; // categoriaBindingSource.DataSource = ApplicationDbContext.Categorias(); finPeriodoBindingSource.DataSource = ApplicationDbContext.FinPeriodos(); periodoLaboralBindingSource.DataSource = ViewModel; }
public static ObservableListSource <PeriodoLaboral> PeriodoLaborals(int idEmpleado) { ObservableListSource <PeriodoLaboral> _PeriodoLaborals = new ObservableListSource <PeriodoLaboral>(); using (MySqlConnection connection = new MySqlConnection( ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString)) { using (MySqlCommand command = new MySqlCommand()) { command.Connection = connection; command.CommandText = Properties.Resources.q_pla_periodolaboral_get; command.Parameters.Add(new MySqlParameter("@n_idempleado", idEmpleado)); connection.Open(); using (MySqlDataReader reader = command.ExecuteReader()) { while (reader.Read()) { PeriodoLaboral periodoLaboral = new PeriodoLaboral { n_idperiodolaboral = reader.GetString("n_idperiodolaboral"), n_idempleado = reader.GetInt32("n_idempleado"), n_idcategoria = reader.GetInt32("n_idcategoria"), n_idfinperiodo = reader.GetInt32("n_idfinperiodo"), n_corr = reader.GetInt32("n_corr"), d_fchini = reader.GetDateTime("d_fchini"), d_fchfin = reader.GetDateTime("d_fchfin"), categoria = reader.GetString("categoria"), finperiodo = reader.GetString("finperiodo") }; periodoLaboral.IsNew = false; _PeriodoLaborals.Add(periodoLaboral); } } } } return(_PeriodoLaborals); }