public static void Add(OccasionDTO occasion)
{
using (Entities db = new Entities())
{
DAL.Occasion occasionDb = _CastDTO.DTOToOccasion(occasion);
db.Occasions.Add(occasionDb);
var teachers = db.Teachers.Where(t => occasion.Teachers.Contains(t.Num));
foreach (DAL.Teacher teacher in teachers)
{
occasionDb.Teachers.Add(teacher);
}
if (occasion.Classes.Count != 0)
{
//occasion.Classes = Class.GetByLayers(occasion.Classes.ToList()).Select(cls => cls.Num).ToList();
List <DAL.Class> classes = db.Classes.Where(c => occasion.Classes.Contains(c.Num)).ToList();//מיפוי כיתות //Id=>Class
foreach (DAL.Class cls in classes)
{
occasionDb.Classes.Add(cls);
}
}
var rooms = db.Rooms.Where(r => occasion.Rooms.Contains(r.Id));
foreach (DAL.Room room in rooms)
{
occasionDb.Rooms.Add(room);
}
db.SaveChanges();
}
}
public static void Update(OccasionDTO occasion)
{
using (Entities db = new Entities())
{
var occ = db.Occasions.FirstOrDefault(o => o.Id == occasion.Id);
occ.Id = occasion.Id;
occ.OccasionType = occasion.OccasionType;
occ.FromDate = _CastDTO.DTOToDate(occasion.FromDate);
occ.ToDate = _CastDTO.DTOToDate(occasion.ToDate);
db.SaveChanges();
}
}
public IHttpActionResult Update([FromBody] OccasionDTO occasion)
{
try
{
Occasion.Update(occasion);
return(Ok());
}
catch (Exception e)
{
LogManager.LogException(e);
return(InternalServerError(e));
}
}
public static void Add(OccasionDTO occasion)
{
using (Entities db = new Entities())
{
DAL.Occasion occasionDb = _CastDTO.DTOToOccasion(occasion);
db.Occasions.Add(occasionDb);
var teachers = db.Teachers.Where(t => occasion.Teachers.Contains(t.Id));
foreach (DAL.Teacher teacher in teachers)
{
occasionDb.Teachers.Add(teacher);
}
var classes = db.Classes.Where(c => occasion.Classes.Contains(c.Id));
foreach (DAL.Class cls in classes)
{
occasionDb.Classes.Add(cls);
}
var rooms = db.Rooms.Where(r => occasion.Rooms.Contains(r.Id));
foreach (DAL.Room room in rooms)
{
occasionDb.Rooms.Add(room);
}
db.SaveChanges();
}
}
