public M.Case[] Get()
{
var query = from C in BD.Cases
where (true)
select new { C.Id, C.Name, C.DescriptionCase, C.PostedDate, C.User.Username };
var lista = query.ToArray();
M.Case[] arrayCase = new M.Case[lista.Length];
for (int i = 0; i < lista.Length; i++)
{
M.Case temp = new M.Case
{
Id = lista[i].Id,
Name = lista[i].Name,
DescriptionCase = lista[i].DescriptionCase,
PostedDate = lista[i].PostedDate,
Username = lista[i].Username
};
arrayCase[i] = temp;
}
return(arrayCase);
}
/* Obtiene los casos de un Usuario */
/* Agrega un Caso */
public bool Post(M.Case caso)
{
O.Case BDCaso = new O.Case
{
Name = caso.Name,
DescriptionCase = caso.DescriptionCase,
PostedDate = System.DateTime.Now.ToString("g"),
PostedHourZone = System.TimeZoneInfo.Local.ToString(),
IdUser = caso.IdUser
};
BD.Cases.Add(BDCaso);
BD.SaveChanges();
return(true);
}
/* Obtiene los casos de un Usuario */
public M.Case[] Get(long idUser)
{
var query = from C in BD.Cases
where (C.IdUser.Equals(idUser))
select new { C.Id, C.Name, C.DescriptionCase, C.PostedDate, C.PostedHourZone };
M.Case[] arrayCase = new M.Case[query.Count()];
int i = 0;
foreach (var item in query)
{
M.Case temp = new M.Case
{
Id = item.Id,
Name = item.Name,
DescriptionCase = item.DescriptionCase,
PostedDate = item.PostedDate,
PostedHourZone = item.PostedHourZone
};
arrayCase[i] = temp;
i++;
}
return(arrayCase);
}
