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