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);
}
