public static string getGuid(string elementId, CourseTypes elementType)
{
string key = Database.Instance.GetKey(elementId, elementType);
if (String.IsNullOrEmpty(key))
{
key = getNewGuid();
Database.Instance.AddKey(elementId, key, elementType);
Program.Log.Info(String.Format("New Key generated elementType: {0}; element_id: {1}; generatedKey: {2}", elementType.ToString(), elementId, key));
}
if (_generatedGuids.ContainsKey(key))
{
var existing = _generatedGuids[key];
Program.Log.Warn(
String.Format(
"DUPLICATE ID DETECTED >>GeneratedId = '{0}' ; existingReferenceId = {1} existingType = {2}; newRefrenceId = {3} newType = {4} ",
key, existing.ElementId, existing.elementType, elementId, elementType));
}
else
{
_generatedGuids[key] = new guidRequest
{
ElementId = elementId,
elementType = elementType
};
}
return(key);
}
// TODO additional constructor for setting coursetype as well
public Course(String nameOnly, CourseTypes typeOfCourse, InstituteEquipment necessaryEquipment)
{
CompatibleRooms = new List <LectureRoom>();
SpecificSchedule = new Schedule();
Name = nameOnly;
TypeOfCourse = typeOfCourse;
NecessaryEquipment = necessaryEquipment;
}
public static List <Course> GetCoursesList(CourseTypes courseType, bool onlyPublished)
{
string where = " WHERE Type=" + (int)courseType;
if (onlyPublished)
{
where += " AND Published=1 ";
}
return(GetCoursesList(where, onlyPublished));
}
public SectionCourseTypeRemovedEvent(
Guid sectionId,
CourseTypes courseTypeRemoved,
IEnumerable<CourseTypes> currentCourseTypes)
{
SectionId = sectionId;
CourseTypeRemoved = courseTypeRemoved;
CurrentCourseTypes = currentCourseTypes;
}
public void AddKey(string element_id, string generatedId, CourseTypes elementType)
{
if (String.IsNullOrEmpty(element_id) || String.IsNullOrEmpty(generatedId))
{
return;
}
string sql = String.Format(@"INSERT INTO GeneratedIds(element_id, type, generated_id) VALUES('{0}', '{1}', '{2}')", element_id, elementType.ToString(), generatedId);
var command = new SQLiteCommand(sql, conn);
command.ExecuteNonQuery();
}
public void AddKeyIfDoesntExists(string element_id, string generatedId, CourseTypes elementType)
{
if (String.IsNullOrEmpty(element_id) || String.IsNullOrEmpty(generatedId))
{
return;
}
if (GetKey(element_id, elementType) == null)
{
Program.Log.Info(String.Format("Key added elementType: {0}; element_id: {1}; generatedKey: {2}", elementType.ToString(), element_id, generatedId));
AddKey(element_id, generatedId, elementType);
}
}
public string GetKey(string element_id, CourseTypes type)
{
if (String.IsNullOrEmpty(element_id))
{
return(null);
}
string sql = String.Format(@"SELECT generated_id FROM GeneratedIds WHERE element_id = '{0}' AND type = '{1}'", element_id, type.ToString());
var command = new SQLiteCommand(sql, conn);
using (var dr = command.ExecuteReader()) {
if (dr.Read() && !dr.IsDBNull(0))
{
return(dr.GetString(0));
}
}
return(null);
}
private async void OnPageLoad(object o)
{
Instructors = await _employeeProxy.GetEmployees(string.Empty);
OnPropertyChanged("Instructors");
CourseTypes = await _serviceTypeProxy.GetServiceTypes(new ServiceTypeFilter { IsCourse = true });
OnPropertyChanged("CourseTypes");
if (IsEditing && CourseId != null)
{
Course = await _servicesProxy.GetCourse(CourseId.Value);
SelectedCourse = CourseTypes.First(c => c.Id == Course.ServiceTypeId);
SelectedInstructor = Instructors.First(i => i.Id == Course.InstructorId);
OnPropertyChanged("Course");
OnPropertyChanged("SelectedCourse");
OnPropertyChanged("SelectedInstructor");
}
OnPropertyChanged("IsEditing");
OnPropertyChanged("IsAdding");
}
public CourseTypeAddedToCourseEvent(Guid courseId, CourseTypes typeAdded, IEnumerable<CourseTypes> currentTypes)
{
CourseId = courseId;
TypeAdded = typeAdded;
CurrentTypes = currentTypes;
}
public static List<Course> GetCoursesList(CourseTypes courseType, bool onlyPublished)
{
string where = " WHERE Type=" + (int)courseType;
if (onlyPublished)
{
where += " AND Published=1 ";
}
return GetCoursesList(where, onlyPublished);
}
public CourseTypeRemovedFromCourseEvent(Guid courseId, CourseTypes typeRemoved, IEnumerable<CourseTypes> currentTypes)
{
CourseId = courseId;
TypeRemoved = typeRemoved;
CurrentTypes = currentTypes;
}
public CourseTypesController()
{
uow = new UnitOfWork();
repo = new CourseTypes(uow);
}
public void FilterByCourseType(ref List <Announcement> announcements, CourseTypes courseType)
{
announcements = announcements.Where(an => an.Course != null && an.Course.CourseType.Type == courseType).ToList();
}
