public static List <SelectListItem> drpCourseLevel()
{
using (IN705_201802_arulr1Entities1 entity = new IN705_201802_arulr1Entities1())
{
var drpData = (from item in entity.CourseLevels
select new SelectListItem
{
Text = item.LevelName.ToString(),
Value = item.CourseLevelID.ToString(),
}).ToList();
drpData.Insert(0, new SelectListItem {
Text = "-- Select Level --", Value = ""
});
return(drpData);
}
}
public static List <SelectListItem> drpTutor()
{
using (IN705_201802_arulr1Entities1 entity = new IN705_201802_arulr1Entities1())
{
var drpData = (from item in entity.Tutors
select new SelectListItem
{
Text = item.User.FirstName.ToString() + " " + item.User.LastName.ToString(),
Value = item.TutorID.ToString(),
}).ToList();
drpData.Insert(0, new SelectListItem {
Text = "-- Select Tutor --", Value = ""
});
return(drpData);
}
}
public static List <SelectListItem> drpStaff()
{
using (IN705_201802_arulr1Entities1 entity = new IN705_201802_arulr1Entities1())
{
var drpData = (from item in entity.Users where item.UserRoleID == 2 || item.UserRoleID == 3
select new SelectListItem
{
Text = item.FirstName.ToString() + " " + item.LastName.ToString(),
Value = item.UserID.ToString(),
}).ToList();
drpData.Insert(0, new SelectListItem {
Text = "-- Select staff --", Value = ""
});
return(drpData);
}
}
public static List <SelectListItem> drpPaymentStatus()
{
using (IN705_201802_arulr1Entities1 entity = new IN705_201802_arulr1Entities1())
{
var drpData = (from item in entity.PaymentStatus
select new SelectListItem
{
Text = item.StatusName.ToString(),
Value = item.PaymentStatus.ToString(),
}).ToList();
drpData.Insert(0, new SelectListItem {
Text = "-- Select Payment status --", Value = ""
});
return(drpData);
}
}
public static List <SelectListItem> drpInstrumentHire()
{
using (IN705_201802_arulr1Entities1 entity = new IN705_201802_arulr1Entities1())
{
var drpData = (from item in entity.InstrumentHires
select new SelectListItem
{
Text = item.Enrolment.Student.User.FirstName.ToString() + " " + item.Enrolment.Student.User.LastName.ToString() + " ( " + item.Enrolment.Lessonbatch.Name.ToString() + " )",
Value = item.InstrumentHireId.ToString(),
}).ToList();
drpData.Insert(0, new SelectListItem {
Text = "-- Select Hire --", Value = ""
});
return(drpData);
}
}
public static List <SelectListItem> drpInstrument()
{
using (IN705_201802_arulr1Entities1 entity = new IN705_201802_arulr1Entities1())
{
var drpData = (from item in entity.Instruments
select new SelectListItem
{
Text = item.Name.ToString(),
Value = item.InstrumentID.ToString(),
}).ToList();
drpData.Insert(0, new SelectListItem {
Text = "-- Select Instrument --", Value = ""
});
return(drpData);
}
}
public static List <SelectListItem> drpUserRole()
{
using (IN705_201802_arulr1Entities1 entity = new IN705_201802_arulr1Entities1())
{
var drpData = (from item in entity.UserRoles
select new SelectListItem
{
Text = item.Role.ToString(),
Value = item.UserRoleID.ToString(),
}).ToList();
drpData.Insert(0, new SelectListItem {
Text = "-- Select Role --", Value = ""
});
return(drpData);
}
}
public static List <SelectListItem> drpLesson()
{
using (IN705_201802_arulr1Entities1 entity = new IN705_201802_arulr1Entities1())
{
var drpData = (from item in entity.Lessons
select new SelectListItem
{
Text = item.Name.ToString() + " ( " + item.Instrument.Name + " - " + item.CourseLevel.LevelName.ToString() + " )",
Value = item.LessonID.ToString(),
}).ToList();
drpData.Insert(0, new SelectListItem {
Text = "-- Select Lesson --", Value = ""
});
return(drpData);
}
}
protected override ValidationResult IsValid(object value, ValidationContext validationContext)
{
ValidationResult validationResult = ValidationResult.Success;
try
{
var otherPropertyInfo = validationContext.ObjectType.GetProperty(this.otherPropertyName);
if (otherPropertyInfo.PropertyType.Equals(new Int32().GetType()))
{
int EnrolmentID = (int)value;
int InstrumentAssertID = (int)otherPropertyInfo.GetValue(validationContext.ObjectInstance, null);
using (IN705_201802_arulr1Entities1 entity = new IN705_201802_arulr1Entities1())
{
Enrolment enrolment = entity.Enrolments.Where(f => f.EnrolmentID == EnrolmentID).FirstOrDefault();
InstrumentAssert instrumentAssert = entity.InstrumentAsserts.Where(f => f.InstrumentAssertID == InstrumentAssertID).FirstOrDefault();
InstrumentHire instrumentHire = entity.InstrumentHires.Where(f => f.EnrolmentID == enrolment.EnrolmentID && f.InstrumentAssertID == instrumentAssert.InstrumentAssertID).FirstOrDefault();
if (enrolment.Lessonbatch.Lesson.InstrumentID == instrumentAssert.InstrumentID && instrumentHire == null)
{
return(ValidationResult.Success);
}
else if (enrolment.Lessonbatch.Lesson.InstrumentID != instrumentAssert.InstrumentID)
{
return(new ValidationResult("Enrolment can't hire this instrument."));
}
else if (instrumentHire != null)
{
return(new ValidationResult("Enrolment currently has an instrument hired."));
}
else
{
return(new ValidationResult("Enrolment can't hire this instrument and currently has an instrument hired."));
}
}
}
else
{
validationResult = new ValidationResult("An error occurred while validating the property.");
}
}
catch (Exception)
{
return(new ValidationResult("Enrolment can't hire this instrument."));
}
return(validationResult);
}
public static List <SelectListItem> drpProgram()
{
using (IN705_201802_arulr1Entities1 entity = new IN705_201802_arulr1Entities1())
{
var drpData = (from item in entity.Performances
select new SelectListItem
{
Text = item.Name.ToString(),
Value = item.PerformanceID.ToString(),
}).ToList();
drpData.Insert(0, new SelectListItem {
Text = "-- Select Program --", Value = ""
});
return(drpData);
}
}
protected override ValidationResult IsValid(object value, ValidationContext validationContext)
{
ValidationResult validationResult = ValidationResult.Success;
try
{
var otherPropertyInfo = validationContext.ObjectType.GetProperty(this.otherPropertyName);
var enrolmentPropertyInfo = validationContext.ObjectType.GetProperty(this.EnrolmentPropertyName);
if (otherPropertyInfo.PropertyType.Equals(new Int32().GetType()))
{
int LessonBatchID = (int)value;
int studentID = (int)otherPropertyInfo.GetValue(validationContext.ObjectInstance, null);
int enromlentD = (int)enrolmentPropertyInfo.GetValue(validationContext.ObjectInstance, null);
using (IN705_201802_arulr1Entities1 entity = new IN705_201802_arulr1Entities1())
{
Enrolment enrolment = entity.Enrolments.Where(f => f.StudentID == studentID && f.LessonBatchID == LessonBatchID).FirstOrDefault();
if (enrolment == null)
{
return(ValidationResult.Success);
}
else if (enrolment.EnrolmentID == enromlentD)
{
return(ValidationResult.Success);
}
else
{
return(new ValidationResult("Student is already enrolled in this lesson."));
}
}
}
else
{
validationResult = new ValidationResult("An error occurred while validating the property.");
}
}
catch (Exception)
{
return(new ValidationResult("Student is already enrolled in this lesson."));
}
return(validationResult);
}
protected override ValidationResult IsValid(object value, ValidationContext validationContext)
{
ValidationResult validationResult = ValidationResult.Success;
try
{
var otherPropertyInfo = validationContext.ObjectType.GetProperty(this.otherPropertyName);
if (otherPropertyInfo.PropertyType.Equals(new Int32().GetType()))
{
string email = (string)value;
int userID = (int)otherPropertyInfo.GetValue(validationContext.ObjectInstance, null);
using (IN705_201802_arulr1Entities1 entity = new IN705_201802_arulr1Entities1())
{
User datasetUser = entity.Users.Where(f => f.Email == email).FirstOrDefault();
if (datasetUser.UserID == userID)
{
return(ValidationResult.Success);
}
else if (datasetUser == null)
{
return(ValidationResult.Success);
}
else
{
return(new ValidationResult("Email address alrady exists."));
}
}
}
else
{
validationResult = new ValidationResult("An error occurred while validating the property.");
}
}
catch (Exception)
{
return(new ValidationResult("Email address alrady exists."));
}
return(validationResult);
}
protected override ValidationResult IsValid(object value, ValidationContext validationContext)
{
ValidationResult validationResult = ValidationResult.Success;
try
{
var otherPropertyInfo = validationContext.ObjectType.GetProperty(this.otherPropertyName);
if (otherPropertyInfo.PropertyType.Equals(new Int32().GetType()))
{
int tutorID = (int)value;
int lessonID = (int)otherPropertyInfo.GetValue(validationContext.ObjectInstance, null);
using (IN705_201802_arulr1Entities1 entity = new IN705_201802_arulr1Entities1())
{
Tutor tutor = entity.Tutors.Where(f => f.TutorID == tutorID).FirstOrDefault();
Lesson lesson = entity.Lessons.Where(f => f.LessonID == lessonID).FirstOrDefault();
var skill = entity.InstumentLevels.Where(f => f.UserID == tutor.UserID && f.CourseLevelID > lesson.CourseLevelID && f.InstrumentID == lesson.InstrumentID).ToList();
if (skill.Count > 0)
{
return(ValidationResult.Success);
}
else
{
return(new ValidationResult("Levels are conflicting with course and tutor."));
}
}
}
else
{
validationResult = new ValidationResult("An error occurred while validating the property.");
}
}
catch (Exception)
{
return(new ValidationResult("Levels are conflicting with course and tutor."));
}
return(validationResult);
}
protected override ValidationResult IsValid(object value, ValidationContext validationContext)
{
try
{
using (IN705_201802_arulr1Entities1 entity = new IN705_201802_arulr1Entities1())
{
var lessonbatch = entity.Lessonbatches.Where(f => f.LessonBatchID == (Int32)value).ToList();
if (lessonbatch.Count < 16)
{
return(ValidationResult.Success);
}
else
{
return(new ValidationResult("Group size has reached the maximum."));
}
}
}
catch
{
return(new ValidationResult("Group size has reached the maximum."));
}
}
protected override ValidationResult IsValid(object value, ValidationContext validationContext)
{
try
{
using (IN705_201802_arulr1Entities1 entity = new IN705_201802_arulr1Entities1())
{
InstumentService instumentService = entity.InstumentServices.Where(f => f.InstrumentHireId == (Int32)value).FirstOrDefault();
if (instumentService == null)
{
return(ValidationResult.Success);
}
else
{
return(new ValidationResult("Instrument is being serviced."));
}
}
}
catch
{
return(new ValidationResult("Instrument is being serviced."));
}
}
public CourseController()
{
entities = new IN705_201802_arulr1Entities1();
}
public MasterController()
{
entities = new IN705_201802_arulr1Entities1();
}
public OrchestraController()
{
entities = new IN705_201802_arulr1Entities1();
}
public AdminController()
{
entities = new IN705_201802_arulr1Entities1();
}
