public ModelCourseDetails(OnlineCourse item, List <OnlineCourse> relatedItems) : base(item)
{
intro = item.intro;
if (relatedItems != null)
{
relatedCourses = relatedItems.Select(x => new ModelCourse(x)).ToList();
}
}
public ModelCourse(OnlineCourse item)
{
id = item.id;
title = item.name;
simpleIntro = item.simpleIntro;
price = item.price.HasValue ? item.price.Value : 0;
teacher = item.lecturer;
imgUrl = WebFunctions.ToAbsoluteResourceUrl(item.img);
}
private void AddCourse(string catA, string catB, int count, PeContext context)
{
for (int i = 1; i <= count; i++)
{
OnlineCourse oc = new OnlineCourse()
{
name = "孩子的SEL社会情感课" + i.ToString("00"),
simpleIntro = "认识到人与人之间是不同的，学会在困扰之下冷静思考，并作出对自己和他人负责任的决定。",
intro = "认识到人与人之间是不同的，学会在困扰之下冷静思考，并作出对自己和他人负责任的决定认识到人与人之间是不同的，学会在困扰之下冷静思考，并作出对自己和他人负责任的决定认识到人与人之间是不同的，学会在困扰之下冷静思考，并作出对自己和他人负责任的决定\r\n\r\n认识到人与人之间是不同的，学会在困扰之下冷静思考，并作出对自己和他人负责任的决定认识到人与人之间是不同的，学会在困扰之下冷静思考，并作出对自己和他人负责任的决定\r\n\r\n认识到人与人之间是不同的，学会在困扰之下冷静思考，并作出对自己和他人负责任的决定",
lecturer = "简·尼尔森 & 琳·洛特",
fromAge = 8,
toAge = 12,
price = 5800,
img = "/Images/temp/kc_img.jpg",
categoryA = catA,
categoryB = catB,
createdTime = DateTime.Now,
updatedTime = DateTime.Now,
publishedTime = DateTime.Now,
viewCount = 10,
};
oc.OnlineCourseData = new List <OnlineCourseData>();
for (int j = 1; j <= 3; j++)
{
OnlineCourseData item = new OnlineCourseData()
{
name = oc.name + "_在线课程" + j.ToString("00"),
dataLink = "http://7xk2h9.com1.z0.glb.clouddn.com/no1.mp4",
dataType = ConstValue.CourseDataType.Video,
sort = j,
};
oc.OnlineCourseData.Add(item);
}
OnlineCourseData tryItem = new OnlineCourseData()
{
name = oc.name + "_在线试看",
dataLink = "http://7xlvto.media1.z0.glb.clouddn.com/PDC%E8%AE%A4%E8%AF%81%E8%AF%95%E7%9C%8B1.mp4",
dataType = ConstValue.CourseDataType.TryVideo,
sort = 1,
};
oc.OnlineCourseData.Add(tryItem);
context.OnlineCourse.Add(oc);
}
context.SaveChanges();
}
public void GetOnlineCourseData()
{
// Initialize
string query = @"SELECT TOP 1 * FROM OnlineCourse";
// Execute
SqlDataReader reader = _dbHelper.QueryDB(query);
reader.Read();
OnlineCourse retrieved = _dbHelper.GetOnlineCourseData(reader);
// Validate
Assert.IsTrue(reader.HasRows);
Assert.NotNull(retrieved);
}
/// <summary>
/// Converts row data retrieved from the DB into OnlineCourse
/// </summary>
/// <param name="row">DB row data</param>
/// <returns>OnlineCourse data; null if conversion not possible</returns>
public OnlineCourse GetOnlineCourseData(SqlDataReader row)
{
OnlineCourse retrieved = null;
try
{
retrieved = new OnlineCourse
{
CourseID = row.GetInt32(0),
URL = row.GetString(1)
};
}
catch
{
retrieved = null;
}
return(retrieved);
}
static void AddNewDepartmentAndCourses(int departmentID, int courseID)
{
using (var service = new Service1Client())
{
Department newDepartment = new Department()
{
DepartmentID = departmentID,
Budget = 13000.000m,
Name = "New Department",
StartDate = DateTime.Now
};
OnlineCourse newCourse = new OnlineCourse()
{
CourseID = courseID,
DepartmentID = departmentID,
URL = "http://www.fineartschool.net/Trigonometry",
Title = "New Onsite Course",
Credits = 4
};
// Add the course to the department.
newDepartment.Courses.Add(newCourse);
// The newly create objects are marked as added, the service will insert these into the store.
service.UpdateDepartment(newDepartment);
// Let’s make few more changes to the saved object.
// Since the previous changes have now been persisted, call AcceptChanges to
// reset the ChangeTracker on the objects and mark the state as ObjectState.Unchanged.
// Note, AcceptChanges sets the tracking on, so you do not need to call StartTracking
// explicitly.
newDepartment.AcceptChanges();
newCourse.AcceptChanges();
// Because the change tracking is enabled
// the following change will set newCourse.ChangeTracker.State to ObjectState.Modified.
newCourse.Credits = 6;
service.UpdateDepartment(newDepartment);
}
}
public string GetOnlineCourseDetail(string pRequest)
{
var rd = new APIResponse <GetOnlineCourseDetailRD>();
var rdData = new GetOnlineCourseDetailRD();
OnlineCourse course = new OnlineCourse
{
OnlineCourseId = "1",
Topic = "大数据的得与失",
Icon = "icon",
AccessCount = 10,
AverageStar = 66,
CourseType = 1,
KeepType = "1"
};
List <CourseWare> list = new List <CourseWare>();
CourseWare ware = new CourseWare
{
ContentId = "1",
CourseWareId = "1",
CourseWareFile = "大数据的得与失.doc",
Downloadable = 1,
ExtName = ".doc",
Icon = "icon",
OriginalName = "",
Size = "2.3M"
};
list.Add(ware);
CourseDetail detail = new CourseDetail
{
OnlineCourse = course,
CourseWareList = list
};
rdData.CourseDetail = detail;
rd.Data = rdData;
rd.ResultCode = 0;
return(rd.ToJSON());
}
public string SearchCourse(string pRequest)
{
var rd = new APIResponse <SearchCourseRD>();
var rdData = new SearchCourseRD();
List <OnlineCourse> list = new List <OnlineCourse>();
OnlineCourse category = new OnlineCourse
{
OnlineCourseId = "1",
Topic = "大数据的得与失",
Icon = "icon",
AccessCount = 10,
AverageStar = 66,
CourseType = 1,
KeepType = "0"
};
list.Add(category);
rdData.CourseList = list;
rd.Data = rdData;
rd.ResultCode = 0;
return(rd.ToJSON());
}
public string GetFavorite(string pRequest)
{
var rd = new APIResponse <GetFavoriteRD>();
var rdData = new GetFavoriteRD();
List <OnlineCourse> list = new List <OnlineCourse>();
OnlineCourse favorite = new OnlineCourse
{
OnlineCourseId = "1",
Topic = "大数据的得与失",
Icon = "icon",
AccessCount = 10,
AverageStar = 66,
CourseType = 1,
KeepType = "1"
};
list.Add(favorite);
rdData.FavoriteList = list;
rd.Data = rdData;
rd.ResultCode = 0;
return(rd.ToJSON());
}
/// <summary>
/// Create a new OnlineCourse object.
/// </summary>
/// <param name="courseID">Initial value of CourseID.</param>
/// <param name="uRL">Initial value of URL.</param>
public static OnlineCourse CreateOnlineCourse(int courseID, string uRL)
{
OnlineCourse onlineCourse = new OnlineCourse();
onlineCourse.CourseID = courseID;
onlineCourse.URL = uRL;
return onlineCourse;
}
/// <summary>
/// There are no comments for OnlineCourse in the schema.
/// </summary>
public void AddToOnlineCourse(OnlineCourse onlineCourse)
{
base.AddObject("OnlineCourse", onlineCourse);
}
public ModelCourseDetails(OnlineCourse item) : base(item)
{
intro = item.intro;
}
