public override IEnumerable <ChamadoFilaViewModel> Bind(int?index, int pageSize = 50, params object[] param)
{
int _ChamadoID = param != null && param.Count() > 0 && param[0] != null ? (int)param[0] : 0;
if (_ChamadoID > 0)
{
return((from chf in db.ChamadoFilas
join fil in db.FilaAtendimentos on chf.FilaAtendimentoID equals fil.FilaAtendimentoID into FIL
from fil in FIL.DefaultIfEmpty()
where chf.ChamadoID == _ChamadoID
orderby chf.Data
select new ChamadoFilaViewModel
{
empresaId = SessaoLocal.empresaId,
ChamadoID = chf.ChamadoID,
Data = chf.Data,
FilaAtendimentoID = chf.FilaAtendimentoID,
DescricaoFilaAtendimento = fil != null ? fil.Descricao : "",
UsuarioID = chf.UsuarioID,
Nome = chf.Nome,
Login = chf.Login,
PageSize = pageSize,
TotalCount = ((from chf1 in db.ChamadoFilas
join fil1 in db.FilaAtendimentos on chf1.FilaAtendimentoID equals fil1.FilaAtendimentoID into FIL1
from fil1 in FIL1.DefaultIfEmpty()
where chf1.ChamadoID == _ChamadoID
orderby chf1.Data
select chf1).Count())
}).Skip((index ?? 0) * pageSize).Take(pageSize).ToList());
}
else
{
return(new List <ChamadoFilaViewModel>());
}
}
public static EIL Select(int id)
{
if (id > 0)
{
return(FIL.Select(id));
}
else
{
return(null);
}
}
internal static extern UInt32 GetFilePosition(FIL* fil);
internal static extern FRESULT f_truncate(FIL* fp);
internal static extern FRESULT f_write(FIL* fp, byte* buff, UInt32 btw, UInt32* bw);
internal static extern FRESULT f_read(FIL* fp, void* buff, UInt32 btr, UInt32* br);
internal static extern FRESULT f_sync(FIL* fp);
internal static extern FRESULT f_open(FIL* fp, byte* path, byte mode);
internal static extern FRESULT f_lseek(FIL* fp, UInt32 ofs);
internal static extern FRESULT f_close(FIL* fp);
internal static extern void FILFree(FIL* fil);
internal static extern UInt32 GetFileSize(FIL* fil);
