// DELETE Sessio public static void DeleteSessio(int id) { Sessio c = dataContext.Sessios.Where(x => x.Id == id).SingleOrDefault(); if (c != null) { dataContext.Sessios.Remove(c); dataContext.SaveChanges(); } }
// POST Sessio public static Sessio InsertSessio(Sessio c) { try { Sessio s = dataContext.Sessios.Where(x => x.Dia_Id == c.Dia_Id && x.Hora_Id == c.Hora_Id && (x.Sale_Id == c.Sale_Id || x.Treballador_Id == c.Treballador_Id)).SingleOrDefault(); if (s == null) { dataContext.Sessios.Add(c); dataContext.SaveChanges(); return(GetSessio(c.Id)); } return(null); } catch (Exception e) { return(null); } }
// PUT Sessio public static Sessio UpdateSessio(Sessio c) { try { Sessio c0 = dataContext.Sessios.Where(x => x.Id == c.Id).SingleOrDefault(); c0.Hora_Id = c.Hora_Id; c0.Dia_Id = c.Dia_Id; c0.Treballador_Id = c.Treballador_Id; c0.ActivitatsDirigide_Id = c.ActivitatsDirigide_Id; c0.Sale_Id = c.Sale_Id; dataContext.SaveChanges(); return(GetSessio(c.Id)); } catch (Exception e) { return(null); } }
// GET Sessio public static Sessio GetSessio(int id) { Sessio c = dataContext.Sessios.Where(x => x.Id == id).SingleOrDefault(); return(c); }