public IEnumerable <Common.Entities.NoteHeader> GetNotes()
{
var ctx = new SirCoPOS.DataAccess.SirCoPOSDataContext();
var q = ctx.Notas.Where(i => i.Venta == null).OrderBy(i => i.Date);
var items = q.Select(i => new Common.Entities.NoteHeader
{
Id = i.Id,
Date = i.Date,
Sucursal = i.Sucursal,
CajeroId = i.CajeroId,
Total = i.Items.Sum(k => k.Amount)
});
return(items);
}
public IEnumerable <Common.Entities.NoteDetalle> GetNoteDetails(int id)
{
var pctx = new SirCoPOS.DataAccess.SirCoPOSDataContext();
var ctx = new SirCoPOS.DataAccess.SirCoDataContext();
var q = pctx.NotasDetalle.Where(i => i.NotaId == id);
var res = q.Select(i => new Common.Entities.NoteDetalle
{
Serie = i.Serie,
Amount = i.Amount,
Comments = i.Coments
}).ToArray();
foreach (var item in res)
{
var sitem = ctx.Series.Where(i => i.serie == item.Serie).Single();
var corrida = ctx.GetCorrida(sitem);
item.AmountOriginal = corrida.precio.Value;
}
return(res);
}
