public bool HaveEmpty(string courseId)
{
//获取课程已报名人数
var sql = @"
SELECT
COUNT(Id)
FROM dbo.CoachCourseJoin
WHERE CourseId = @CourseId
";
var cmdVal = CommandHelper.CreateText <ClubUser>(FetchType.Scalar, sql);
cmdVal.Params.Add("@CourseId", courseId);
var result = DbContext.GetInstance().Execute(cmdVal);
int fillCount = 0;
if (result.Tag != null)
{
fillCount = (int)result.Tag;
}
//获取课程类型
var courseType = CoachHelper.Instance.GetCoacherCourse(courseId).Type;
//计算剩余空位数
var emptyPosition = CoachHelper.CountEmptyPosition(fillCount, courseType);
if (emptyPosition > 0)
{
return(true);
}
else
{
return(false);
}
}
public Response Execute(User currentUser, string request)
{
var req = JsonConvert.DeserializeObject <Request <CoachStudentMoneyNotPay> >(request);
var obj = req.FirstEntity();
if (CoachHelper.Instance.IsCoach(currentUser.Id))
{
return(ResultHelper.Fail("对不起, 你是教练, 不能购买其他教练的课程"));
}
List <EntityBase> entites = new List <EntityBase>();
entites.Add(obj);
if (obj.RowState == RowState.Added)
{
obj.CourseTypeName = CoachDic.CoacherCourse[obj.CourseTypeId];
obj.ThenTotalAmount = obj.Amount;
obj.Deadline = CoachHelper.GetDeadline(obj.CourseTypeId, obj.ThenTotalAmount / 10);
obj.IsPay = false;
obj.CoachBootcampId = "";
obj.TrySetNewEntity();
}
var result = DbContext.GetInstance().Execute(CommandHelper.CreateSave(entites));
if (result.IsSuccess)
{
//生成 待支付订单
result = SaveWaitPay(obj, currentUser);
}
return(result);
}
public Response Execute(User currentUser, string request)
{
var req = JsonConvert.DeserializeObject <Request <GetCoachRelatedFilter> >(request);
var courseId = req.Filter.CourseId;
//获取要取消报名的学员列表
var studentList = CoachHelper.GetStudentList(courseId);
List <CoachCourseJoin> listNotJoin = new List <CoachCourseJoin>();
foreach (var student in studentList)
{
CoachCourseJoin c = new CoachCourseJoin();
c.CourseId = courseId;
c.CoachId = student.CoachId;
c.StudentId = student.UserId;
listNotJoin.Add(c);
}
//取消学员课程报名
Response result = new Response();
if (listNotJoin.Count > 0)
{
result = CoachHelper.Instance.CourseNotJoin(listNotJoin);
}
//删除课程前先备份记录(因为这里会反算学员次数 , 备份哈记录避免后面扯皮找不到记录)
result = BackupCourseRow(courseId);
//删除课程
var sql = @"DELETE CoachCourse WHERE Id=@CourseId ";
var cmd = CommandHelper.CreateText <ClubUser>(FetchType.Execute, sql);
cmd.Params.Add("@CourseId", courseId);
result = DbContext.GetInstance().Execute(cmd);
//删除课程的说说
result = DeleteCourseNote(courseId);
return(result);
}
public Response Execute(User currentUser, string request)
{
var req = JsonConvert.DeserializeObject <Request <GetCoachRelatedFilter> >(request);
Response rsp = new Response();
var userRole = CoachHelper.GetUserRole(req.Filter.CurrentUserId);
var isTeachingPointManager = CoachHelper.Instance.IsTeachingPointManager(req.Filter.CurrentUserId);
if (isTeachingPointManager) //如果是教学点课程管理员
{
//获取既是教学点课程管理员的
rsp = GetRelatedTechingPoint(req.Filter.CurrentUserId);
}
else if (userRole.IsCoach)
{
//获取教练的
rsp = GetCoachSyllabusTechingPoint(req.Filter.CurrentUserId);
}
else
{
//获取学员的
rsp = GetStudentSyllabusTechingPoint(req);
}
return(rsp);
}
public decimal GetCourseTotalMoney(string courseId)
{
var studentList = CoachHelper.GetStudentList(courseId);
decimal totalMoney = 0;
foreach (var item in studentList)
{
totalMoney += item.ThenCourseUnitPrice;
}
return(totalMoney);
}
public Response Execute(User currentUser, string request)
{
var req = JsonConvert.DeserializeObject <Request <GetCoachRelatedFilter> >(request);
var studentList = CoachHelper.GetStudentList(req.Filter.CourseId);
Response rsp = new Response();
rsp.IsSuccess = true;
if (studentList.Count > 0)
{
rsp.Entities = studentList.ToList <CoachStudent, EntityBase>();
}
return(rsp);
}
public Response Execute(User currentUser, string request)
{
var req = JsonConvert.DeserializeObject <Request <GetCoachRelatedFilter> >(request);
var cmd = CommandHelper.CreateProcedure <CoachCourse>(text: "sp_GetCoachTeachingCourseList");
cmd.Params.Add(CommandHelper.CreateParam("@CoachId", req.Filter.CoachId));
cmd.CreateParamPager(req.Filter);
var result = DbContext.GetInstance().Execute(cmd);
result.SetRowCount();
foreach (var item in result.Entities)
{
var obj = item as CoachCourse;
obj.StudentList = CoachHelper.GetStudentList(obj.Id);
}
return(result);
}
public Response Execute(User currentUser, string request)
{
var req = JsonConvert.DeserializeObject <Request <GetCoachRelatedFilter> >(request);
var sql = @"
SELECT
a.*,
d.Id AS CoacherUserId,
d.Sex,
d.CardName AS CoachName,
d.HeadUrl AS CoacherHeadUrl,
b.Name AS TypeName,
c.Address AS VenueAddress,
c.Name AS VenueName,
FillPosition=(SELECT COUNT(*) FROM dbo.CoachCourseJoin WHERE CourseId=@CourseId),
IsJoined=(SELECT COUNT(*) FROM dbo.CoachCourseJoin WHERE CourseId=@CourseId AND StudentId=@StudentUserId),
IsComment=(SELECT COUNT(*) FROM dbo.CoachComment WHERE CourseId=@CourseId AND CommentatorId=@StudentUserId),
e.Name AS CategoryOfTechnologyName,
f.Name AS CityName,
CoachBootcampId=(SELECT CoachBootcampId FROM dbo.CoachBootcampCourse WHERE a.CoachBootcampCourseId=Id)
FROM dbo.CoachCourse a
LEFT JOIN dbo.UserAccount d ON a.CoachId=d.Id
LEFT JOIN dbo.BaseData b ON a.Type=b.Id
LEFT JOIN dbo.Venue c ON a.VenueId=c.Id
LEFT JOIN dbo.SysDic e ON a.CategoryOfTechnologyId=e.Id
LEFT JOIN dbo.City f ON a.CityId=f.Id
WHERE a.Id=@CourseId
";
var cmd = CommandHelper.CreateText <CoachCourse>(FetchType.Fetch, sql);
cmd.Params.Add("@CourseId ", req.Filter.CourseId);
cmd.Params.Add("@StudentUserId ", req.Filter.CurrentUserId);//@StudentUserId 变量仅用于学员 IsJoined ,IsComment 字段的计算
var result = DbContext.GetInstance().Execute(cmd);
var obj = result.FirstEntity <CoachCourse>();
if (obj == null)
{
return(ResultHelper.Fail(ErrorCode.DATA_NOTEXIST, "未找到此课程信息"));
}
obj.TryGetFiles();
//获取课程学员
var studentList = CoachHelper.GetStudentList(req.Filter.CourseId);
if (studentList.Count > 0)
{
obj.StudentList.AddRange(studentList);
}
//计算空位
obj.EmptyPosition = CoachHelper.CountEmptyPosition(obj.FillPosition, obj.Type);
#region 计算课程状态-- 下面的状态界面用
var isCoach = CoachHelper.Instance.IsCoach(req.Filter.CurrentUserId);
if (isCoach == true) //教练 课程状态计算
{
if (obj.CoachId == req.Filter.CurrentUserId) //当前登陆者是此节课的教练,才能进行下面的操作
{
if (obj.State == CoachDic.CourseJoin && obj.FillPosition != 0 &&/*有学员报名*/
obj.EndTime > DateTime.Now /*课程结束时间大于当前时间*/)
{
obj.CourseState = "ConfirmStart";
}
else if (obj.State == CoachDic.CourseStart)
{
obj.CourseState = "ConfirmFinished";
}
else if (obj.State == CoachDic.CourseFinished)
{
obj.CourseState = "CourseFinished";
}
else
{
obj.CourseState = "NotOperate";
}
}
else
{
obj.CourseState = "NotPermission";
}
}
else //学员 课程状态计算
{
if (obj.IsJoined == 0 && obj.State != CoachDic.CourseFinished &&/*课程未结束*/
obj.EndTime > DateTime.Now /*课程结束时间大于当前时间*/)
{
obj.CourseState = "Join"; //课程可以报名
}
if (obj.IsJoined == 0 && obj.State != CoachDic.CourseFinished &&/*课程未结束*/
obj.EndTime <= DateTime.Now /*课程结束时间大于当前时间*/)
{
obj.CourseState = "NotJoin"; //课程不可以报名
}
else if (obj.IsJoined == 1 && obj.State != CoachDic.CourseFinished &&/*课程未结束*/
obj.IsComment == 0 /*没有评论*/)
{
obj.CourseState = "CanNotComment"; //课程还没结束, 不能评价,不显示评价按钮
}
else if (obj.IsJoined == 1 /*已报名*/ && obj.State == CoachDic.CourseFinished &&/*课程已结束*/
obj.IsComment == 0 /*没有评论*/)
{
obj.CourseState = "Comment"; //课程已结束,能评价
}
else if (obj.IsJoined == 1 /*已报名*/ && obj.State == CoachDic.CourseFinished &&/*课程已结束*/
obj.IsComment == 1 /*已评论*/)
{
obj.CourseState = "Commented"; //已评价
}
}
#endregion 计算课程状态-- 下面的状态界面用
//当前登录者是否为场馆的课程管理员
obj.IsCurrentCourseManager = CoachHelper.Instance.IsCurrentVenueCourseManager(req.Filter.CurrentUserId, obj.VenueId);
if (obj.Type == CoachDic.BootcampCourse)
{
if (obj.CreatorId == currentUser.Id)
{
obj.CoachBootcampCourseDetailCanEdit = true; //如果这个课程是当前登陆者创建的, 那么这个用户可以编辑
}
else
{
obj.CoachBootcampCourseDetailCanEdit = false;
}
}
return(result);
}
