public Models.Lookup.CourseModel GetCourseByID(int CourseID)
{
BusinessLogic.Lookup.CourseManager CourseManager = new BusinessLogic.Lookup.CourseManager();
BusinessEntity.Lookup.CourseEntity Course = CourseManager.GetCourseByID(CourseID);
return(new Models.Lookup.CourseModel(Course));
}
public BusinessEntity.Result DeleteCourse(BusinessEntity.Lookup.CourseEntity Course)
{
BusinessEntity.Result result = new BusinessEntity.Result();
try
{
SchoolInformationManagementSystemDBEntities e = new SchoolInformationManagementSystemDBEntities();
var original = e.tblCourses.Find(Course.ID);
if (original != null)
{
e.tblCourses.Remove(e.tblCourses.Where(x => x.ID == Course.ID).First());
e.SaveChanges();
result.Message = "Deleted Successfully.";
result.Status = true;
return(result);
}
else
{
result.Message = "Failed to delete";
result.Status = false;
return(result);
}
}
catch (Exception)
{
result.Message = "Failed to delete";
result.Status = false;
return(result);
}
}
public BusinessEntity.Result UpdateCourse(BusinessEntity.Lookup.CourseEntity Course)
{
BusinessEntity.Result result = new BusinessEntity.Result();
try
{
SchoolInformationManagementSystemDBEntities e = new SchoolInformationManagementSystemDBEntities();
var original = e.tblCourses.Find(Course.ID);
if (original != null)
{
e.Entry(original).CurrentValues.SetValues(Course);
e.SaveChanges();
result.Message = "Updated Successfully.";
result.Status = true;
return(result);
}
else
{
result.Message = "Failed to update";
result.Status = false;
return(result);
}
}
catch (Exception)
{
result.Message = "Failed to update";
result.Status = false;
return(result);
}
}
public CourseModel(BusinessEntity.Lookup.CourseEntity course)
{
this.ID = course.ID;
this.Name = course.Name;
this.Description = course.Description;
this.CreatedBy = course.CreatedBy;
this.CreatedDate = course.CreatedDate;
}
public T MapToEntity <T>() where T : class
{
BusinessEntity.Lookup.CourseEntity course = new BusinessEntity.Lookup.CourseEntity();
course.ID = this.ID;
course.Name = this.Name;
course.Description = this.Description;
course.CreatedBy = this.CreatedBy;
course.CreatedDate = this.CreatedDate;
return(course as T);
}
public BusinessEntity.Result SaveCourse(BusinessEntity.Lookup.CourseEntity Course)
{
BusinessEntity.Result result = new BusinessEntity.Result();
try
{
SchoolInformationManagementSystemDBEntities e = new SchoolInformationManagementSystemDBEntities();
e.tblCourses.Add(Course.MapToModel <DataAccessLogic.tblCourse>());
e.SaveChanges();
result.Message = "Saved Successfully.";
result.Status = true;
return(result);
}
catch (Exception)
{
result.Message = "Failed to save";
result.Status = false;
return(result);
}
}