public static bool RemoveResource(int Id)
{
bool resultOperation = false;
EFRepository <Entities.RESOURCE> repo = new EFRepository <Entities.RESOURCE>();
EFRepository <Entities.SUBSCRIPTION> repoSub = new EFRepository <Entities.SUBSCRIPTION>();
Entities.RESOURCE exists = repo.FindNoTracking(x => x.ID == Id).FirstOrDefault();
List <Entities.SUBSCRIPTION> subCPList = repoSub.FindNoTracking(s => s.ID_CP == Id).ToList();
if (exists != null)
{
try
{
repo.Delete(exists);
//cancello anche le sottoscrizioni confermate dalla risorsa rimossa, se è CP
foreach (Entities.SUBSCRIPTION sub in subCPList)
{
repoSub.Delete(sub);
}
DAL.GlobalUnitOfWork.Commit();
resultOperation = true;
}
catch (Exception ex)
{
//Inserire LOG
resultOperation = false;
}
}
return(resultOperation);
}
public static bool InsertResource(Entities.RESOURCE resourceToInsert)
{
bool resultOperation = false;
EFRepository <Entities.RESOURCE> repo = new EFRepository <Entities.RESOURCE>();
Entities.RESOURCE exists = repo.FindNoTracking(x => x.ID == resourceToInsert.ID).FirstOrDefault();
if (exists == null) //check if already exists
{
try
{
resourceToInsert.UserName = ResourceManager.SetUsername(resourceToInsert.Name, resourceToInsert.Surname);
repo.Add(resourceToInsert);
DAL.GlobalUnitOfWork.Commit();
resultOperation = true;
}
catch (Exception ex)
{
//Inserire LOG
resultOperation = false;
}
}
return(resultOperation);
}
public static bool UpdateResource(Entities.RESOURCE resourceToUpdate)
{
bool resultOperation = false;
EFRepository <Entities.RESOURCE> repo = new EFRepository <Entities.RESOURCE>();
Entities.RESOURCE mod = repo.FindNoTracking(x => x.ID == resourceToUpdate.ID).FirstOrDefault();
if (mod != null)
{
try
{
repo.Update(resourceToUpdate);
DAL.GlobalUnitOfWork.Commit();
resultOperation = true;
}
catch (Exception ex)
{
//Inserire LOG
resultOperation = false;
}
}
return(resultOperation);
}
public static ResourceModel MapModel(Entities.RESOURCE resource)
{
return(new ResourceModel
{
ID = resource.ID,
UserName = resource.UserName,
Name = resource.Name,
Surname = resource.Surname,
IsAvaiable = resource.IsAvaiable,
IsCP = resource.IsCP,
IsTeacher = resource.IsTeacher
});
}
public static TeacherCourseResourceModel MapModel(Entities.TEACHING teaching, Entities.RESOURCE resource, Entities.COURSE course)
{
return(new TeacherCourseResourceModel
{
ID = teaching.ID,
ID_Resource = teaching.ID_Resource,
ID_Course = teaching.ID_Course,
Notes = teaching.Notes,
ResourceModel = ResourceModel.MapModel(resource),
CourseModel = CourseModel.MapModel(course)
});
}
public static SubscriptionCourseResourceModel MapModel(Entities.SUBSCRIPTION sub, Entities.COURSE course, Entities.RESOURCE resource, Entities.RESOURCE cp)
{
SubscriptionCourseResourceModel result = new SubscriptionCourseResourceModel();
//map Subscription
result.ID = sub.ID;
result.ID_Course = sub.ID_Course;
result.ID_CP = sub.ID_CP;
result.ID_Resource = sub.ID_Resource;
result.StartDate = sub.StartDate;
result.MaxEndDate = sub.MaxEndDate;
result.IsAdmitted = sub.IsAdmitted;
result.Notes = sub.Notes;
//map Course
result.CourseModel = CourseModel.MapModel(course);
//map Resources
result.ResourceModel = ResourceModel.MapModel(resource);
//map Cp
result.CpModel = ResourceModel.MapModel(cp);
return(result);
}
