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