public IActionResult PresentationQuestionnarieIndex(string studentSchoolId)
{
List <ClassPresentationsession> returnList = new List <ClassPresentationsession>();
var studentId = uow.StudentDataAccess
.GetAll()
.Where(i => i.StudentSchoolId == studentSchoolId)
.FirstOrDefault()
.StudentId;
var registeredPresentations = uow.studentPresentationsessionDataAccess
.GetAll()
.Where(i => i.StudentId == studentId)
.ToList();
foreach (var presentation in registeredPresentations)
{
var item = new ClassPresentationsession();
item.PresentationId = presentation.PresentationId;
item.Presentation = uow.PresentationDataAccess
.GetAll()
.Where(i => i.PresentationId == item.PresentationId)
.FirstOrDefault();
item.SessionId = presentation.SessionId;
item.Sessions = uow.SessionsDataAccess
.GetAll()
.Where(i => i.SessionId == item.SessionId)
.FirstOrDefault();
var classInfos = uow.ClassPresentationsession
.GetAll()
.Where(i => i.PresentationId == item.PresentationId &&
i.SessionId == item.SessionId)
.FirstOrDefault();
item.CurrentCapacity = classInfos.CurrentCapacity;
item.Class = uow.ClassDataAccess
.GetAll()
.Where(i => i.ClassId == classInfos.ClassId)
.FirstOrDefault();
returnList.Add(item);
}
return(View(returnList));
}
public string AddPresentation(string className, string sessions, string presentationName)
{
if (presentationName == null || sessions == null || className == null)
{
return("Lütfen tüm bilgileri giriniz");
}
try
{
var presentationNameIsRegistered = uow.PresentationDataAccess
.Find(i => i.PresentationName == presentationName)
.FirstOrDefault();
if (presentationNameIsRegistered == null)
{
uow.PresentationDataAccess.Add(new Presentation()
{
PresentationName = presentationName
});
uow.SaveChanges();
}
var classId = uow.ClassDataAccess
.Find(i => i.ClassName == className)
.FirstOrDefault()
.ClassId;
var presentationId = uow.PresentationDataAccess
.Find(i => i.PresentationName == presentationName)
.FirstOrDefault()
.PresentationId;
string[] session = sessions.Split('-');
var sessionId = uow.SessionsDataAccess
.Find(i => i.StartTime == Convert.ToDateTime(session[0].Trim()) &&
i.EndTime == Convert.ToDateTime(session[1].Trim()))
.FirstOrDefault()
.SessionId;
var presentationsessionvalid = uow.PresentationSession
.GetAll()
.Where(i => i.PresentationID == presentationId && i.SessionId == sessionId)
.FirstOrDefault();
if (presentationsessionvalid == null)
{
uow.PresentationSession
.Add(new PresentationSession()
{
PresentationID = presentationId,
SessionId = sessionId
});
uow.SaveChanges();
}
var isValid = uow.ClassPresentationsession
.GetAll()
.Where(i => i.PresentationId == presentationId && i.SessionId == sessionId && i.ClassId == classId)
.FirstOrDefault();
if (isValid != null)
{
return("Bu sınıf ve saatte böyle bir sunum var");
}
isValid = uow.ClassPresentationsession
.GetAll()
.Where(i => i.SessionId == sessionId && i.ClassId == classId)
.FirstOrDefault();
if (isValid != null)
{
return("Seçilen saatte sınıfta başka bir sunum var");
}
var newPresentation = new ClassPresentationsession()
{
ClassId = classId,
SessionId = sessionId,
PresentationId = presentationId
};
uow.ClassPresentationsession.Add(newPresentation);
uow.SaveChanges();
return("Sunum eklendi");
}
catch (Exception ex)
{
return("Sunum eklenemedi");
}
}
