public void Nuevo()
{
NominaActual = new nominatype();
PrincipalViewModel.EstatusNuevo = true;
NotifyPropertyChanged("NominaActual");
}
public void CargaPorNomina(nominatype nomina)
{
if (nomina != null)
{
nominatype conceptosNom = Datos.Micontexto.nominatype.FirstOrDefault(x => x.idnomina == nomina.idnomina);
this.Concepts = new ObservableCollection <string>(conceptosNom.conceptos.Split(','));
obtenernombres();
}
}
public void Filtro(string id)
{
int esto = Int32.Parse(id);
var bt = bd.nominatype.FirstOrDefault(x => x.idnomina == esto);
bd.Entry(bt).Reload();
NominaActual = bt;
PrincipalViewModel.EstatusNuevo = false;
NotifyPropertyChanged();
}
public static List <DiasAsistA> ProcDias(DateTime desde, DateTime hasta, nominatype nomina)
{
var procDays = new List <DiasAsistB>();
var TrabsDays = new List <DiasAsistA>();
for (DateTime i = desde; i.Date <= hasta.Date; i = i.AddDays(1))
{
procDays.Add(new DiasAsistB()
{
Dia = i,
asist = false
});
}
nominaEntities fortrabs = new nominaEntities();
var trabs = Datos.Micontexto.trabajador.Where(x => x.nominatype.idnomina == nomina.idnomina && x.estatus.idestatus == 1);
foreach (var trab in trabs)
{
int idtrab = trab.idtrabajador;
var trabx = new DiasAsistA();
trabx.Trab = trab;
trabx.Dias = new List <DiasAsistB>();
foreach (var day in procDays)
{
var qry = fortrabs.controlasist.Where(x => x.idtrabajador == idtrab && x.date == day.Dia).ToList();
int asi;
if (day.Dia.DayOfWeek == DayOfWeek.Saturday || day.Dia.DayOfWeek == DayOfWeek.Sunday)
{
asi = 1;
}
else
{
asi = qry.Count();
}
trabx.Dias.Add(new DiasAsistB()
{
Dia = day.Dia,
asist = Convert.ToBoolean(asi)
});
}
trabx.DiasAsis = string.Join(",", trabx.Dias.Where(x => x.asist == true).Select(x => x.Dia.Date.ToShortDateString()));
trabx.DiasInasis = string.Join(",", trabx.Dias.Where(x => x.asist == false).Select(x => x.Dia.Date.ToShortDateString()));
trabx.TotalAsis = trabx.Dias.Where(x => x.asist == true).Count();
trabx.TotalIna = trabx.Dias.Where(x => x.asist == false).Count();
TrabsDays.Add(trabx);
}
return(TrabsDays);
}
public AsigConceptoViewModel()
{
MoveTrabCommand = new RelayCommand(MoveTrab);
MoveBackCommand = new RelayCommand(MoveBack);
AsignarAllCommad = new RelayCommand(AsignarAll);
conceptos = BD.conceptos.ToList();
buscarTrabs(0);
TrabajadoresS = new ObservableCollection <Trabs>();
var noms = BD.nominatype.ToList();
nominatype newtodo = new nominatype {
descripcion = "TODOS", idnomina = 0
};
noms.Add(newtodo);
Nominas = noms.OrderBy(x => x.idnomina).ToList();
}
public void Buscar(string cedulax)
{
var bt = bd.nominatype.FirstOrDefault(x => x.scodigo == cedulax);
if (bt != null)
{
NominaActual = bt;
PrincipalViewModel.EstatusNuevo = false;
}
else
{
NominaActual = new nominatype {
scodigo = cedulax
};
PrincipalViewModel.EstatusNuevo = true;
NotifyPropertyChanged("NominaActual");
}
}
public AsigNominaViewModel()
{
MoveTrabCommand = new RelayCommand(MoveTrab);
MoveBackCommand = new RelayCommand(MoveBack);
AsignarAllCommad = new RelayCommand(AsignarAll);
buscarTrabs(0);
TrabajadoresS = new ObservableCollection <Trabs>();
var noms = Datos.Micontexto.nominatype.Where(x => x.tipo == 1).ToList();
var noms2 = Datos.Micontexto.nominatype.Where(x => x.tipo == 1).ToList();
NominasTo = noms2;
nominatype newtodo = new nominatype {
descripcion = "TODOS", idnomina = 0
};
noms.Add(newtodo);
Nominas = noms.OrderBy(x => x.idnomina).ToList();
}
