/// <summary>
/// 作者：Kylin
/// 时间：2014.04.22
/// 描述：查询平台课堂
/// </summary>
/// <param name="platformType"></param>
/// <param name="systemType"></param>
/// <param name="businessType"></param>
/// <param name="arrangeCourseId"></param>
/// <returns></returns>
public static MeetingRoom GetClassroom(int platformType, int systemType, int businessType, int arrangeCourseId)
{
using (var edb = new EmeMeetingEntities())
{
var query = edb.MeetingRoom.SingleOrDefault(p => p.PlatformType == platformType && p.SystemType == systemType && p.BussinessType == businessType && p.ArrangeCourseId == arrangeCourseId);
return query;
}
}
/// <summary>
/// 作者：Kylin
/// 时间：2014.04.21
/// 描述：创建平台课堂
/// </summary>
public static MeetingRoom CreateClassroom(MeetingRoom model)
{
using (var edb = new EmeMeetingEntities())
{
var createModel = edb.Entry<MeetingRoom>(model).State = EntityState.Added;
edb.SaveChanges();
return model;
}
}
/// <summary>
/// 作者：Primo
/// 时间：2015.09.30
/// 描述：删除课堂，重新建立
/// </summary>
/// <param name="ArrangeCourseId"></param>
/// <returns></returns>
public static bool DeleteClassroom(int ArrangeCourseId)
{
try
{
using (var edb = new EmeMeetingEntities())
{
var model = edb.MeetingRoom.FirstOrDefault(p => p.ArrangeCourseId == ArrangeCourseId);
edb.Entry(model).State = EntityState.Deleted;
var result = edb.SaveChanges() > 0;
return result;
}
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 作者：Kylin
/// 时间：2014.04.22
/// 描述：查询平台课堂
/// </summary>
/// <param name="platformType"></param>
/// <param name="systemType"></param>
/// <param name="businessType"></param>
/// <param name="arrangeCourseId"></param>
/// <returns></returns>
public static bool IsClassroomExisted(int platformType, int systemType, int businessType, int arrangeCourseId)
{
using (var edb = new EmeMeetingEntities())
{
var query = edb.MeetingRoom.Any(p => p.PlatformType == platformType && p.SystemType == systemType && p.BussinessType == businessType && p.ArrangeCourseId == arrangeCourseId);
return query;
}
}
