public InstructorFitnessClass Delete(InstructorFitnessClass InstructorClass)
{
var result = _context.Remove(InstructorClass);
_context.SaveChanges();
return(result.Entity);
}
public InstructorFitnessClass Create(InstructorFitnessClass InstructorClass)
{
var result = _context.Add <InstructorFitnessClass>(InstructorClass);
_context.SaveChanges();
return(result.Entity);
}
public void Post(FitnessClassDTO value)
{
FitnessClass model = new FitnessClass()
{
Name = value.Name,
Img = value.Img
};
IFitnessClassRepository.Create(model); // am creat o clasa
// trebuie sa introducem si in tabela de intersectie
for (int i = 0; i < value.InstructorId.Count; i++)
{
InstructorFitnessClass InstructorClass = new InstructorFitnessClass()
{
FitnessClassId = model.Id,
InstructorId = value.InstructorId[i]
};
IInstructorClassRepository.Create(InstructorClass);
}
for (int i = 0; i < value.GymClubId.Count; i++)
{
GymClubFitnessClass GymClubClass = new GymClubFitnessClass()
{
FitnessClassId = model.Id,
GymClubId = value.GymClubId[i]
};
IGymClubClassRepository.Create(GymClubClass);
}
}
public InstructorFitnessClass Post(InstructorClassDTO value)
{
InstructorFitnessClass model = new InstructorFitnessClass()
{
InstructorId = value.InstructorId,
FitnessClassId = value.FitnessClassId
};
return(IInstructorClassRepository.Create(model));
}
public void Put(int id, FitnessClassDTO value)
{
FitnessClass model = IFitnessClassRepository.Get(id);
if (value.Name != null)
{
model.Name = value.Name;
}
if (value.Img != null)
{
model.Img = value.Img;
}
IFitnessClassRepository.Update(model);
//trebuie sa putem face update si la lista de instructori si sali de fitness
if (value.InstructorId != null)
{
IEnumerable <InstructorFitnessClass> MyInstructorClasses = IInstructorClassRepository.GetAll().Where(x => x.FitnessClassId == id);
foreach (InstructorFitnessClass MyInstructorClass in MyInstructorClasses)
{
IInstructorClassRepository.Delete(MyInstructorClass);
}
for (int i = 0; i < value.InstructorId.Count; i++)
{
InstructorFitnessClass InstructorClass = new InstructorFitnessClass()
{
FitnessClassId = model.Id,
InstructorId = value.InstructorId[i]
};
IInstructorClassRepository.Create(InstructorClass);
}
}
if (value.GymClubId != null)
{
IEnumerable <GymClubFitnessClass> MyGymClubClasses = IGymClubClassRepository.GetAll().Where(x => x.FitnessClassId == id);
foreach (GymClubFitnessClass MyGymClubClass in MyGymClubClasses)
{
IGymClubClassRepository.Delete(MyGymClubClass);
}
for (int i = 0; i < value.GymClubId.Count; i++)
{
GymClubFitnessClass GymClubClass = new GymClubFitnessClass()
{
FitnessClassId = model.Id,
GymClubId = value.GymClubId[i]
};
IGymClubClassRepository.Create(GymClubClass);
}
}
}
public InstructorFitnessClass Put(int id, InstructorClassDTO value)
{
InstructorFitnessClass model = IInstructorClassRepository.Get(id);
if (value.InstructorId != 0)
{
model.InstructorId = value.InstructorId;
}
if (value.FitnessClassId != 0)
{
model.FitnessClassId = value.FitnessClassId;
}
return(IInstructorClassRepository.Update(model));
}
private static InstructorFitnessClass FillDataRecord(IDataRecord myDataRecord)
{
InstructorFitnessClass myObject = new InstructorFitnessClass();
myObject.InstructorFitnessClassId = myDataRecord.GetInt32(myDataRecord.GetOrdinal("InstructorFitnessClassId"));
if (!myDataRecord.IsDBNull(myDataRecord.GetOrdinal("FitnessClassId")))
{
myObject.FitnessClassId = myDataRecord.GetInt32(myDataRecord.GetOrdinal("FitnessClassId"));
}
if (!myDataRecord.IsDBNull(myDataRecord.GetOrdinal("InstructorId")))
{
myObject.InstructorId = myDataRecord.GetInt32(myDataRecord.GetOrdinal("InstructorId"));
}
if (!myDataRecord.IsDBNull(myDataRecord.GetOrdinal("Description")))
{
myObject.Description = myDataRecord.GetString(myDataRecord.GetOrdinal("Description"));
}
return(myObject);
}
public InstructorFitnessClass Update(InstructorFitnessClass InstructorClass)
{
_context.Entry(InstructorClass).State = Microsoft.EntityFrameworkCore.EntityState.Modified;
_context.SaveChanges();
return(InstructorClass);
}
public InstructorFitnessClass Delete(int id)
{
InstructorFitnessClass model = IInstructorClassRepository.Get(id);
return(IInstructorClassRepository.Delete(model));
}
