/// <summary>
/// 過去預約課程的課程資料
/// </summary>
/// <param name="MemberNo">會員編號</param>
/// <returns></returns>
public IEnumerable <Course> GetPastBooking(int MemberNo)
{
using (GymEntity db = new GymEntity())
{
//會員所有的預約課程
var allData = db.BookingCourse.Where(a => a.Member_No.Equals(MemberNo)).Select(a => a);
var now = DateTime.Now.Ticks;
//找出近一個月已結束的預約課程
var pastdata = from a in allData.AsEnumerable()
from b in db.Course
where a.Course_No.Equals(b.CourseNo) && b.ClassDate < DateTime.Now
let pastDate = b.ClassDate.Ticks
let days = new TimeSpan(now - pastDate).Days
where days <= 31
orderby b.ClassDate, b.StartTime
select b;
//回傳前3筆資料
int cnt = 0;
//var lstData = new List<Course>();
foreach (var item in pastdata)
{
if (cnt < 3)
{
cnt = cnt + 1;
//lstData.Add(item);
yield return(item);
}
}
}
}
public void Add(List <MemberCourse> LstCourse)
{
using (GymEntity db = new GymEntity())
{
foreach (MemberCourse course in LstCourse)
{
db.MemberCourse.Add(course);
bool saveFailed;
do
{
saveFailed = false;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException ex)
{
saveFailed = true;
ex.Entries.Single().Reload();
}
catch (System.Data.Entity.Validation.DbEntityValidationException ex)
{
throw ex;
}
catch (Exception ex)
{
throw ex;
}
} while (saveFailed);
}
}
}
public void Add(PurchaseRecord item)
{
using (GymEntity db = new GymEntity())
{
db.PurchaseRecord.Add(item);
//處理資料庫儲存
bool saveFailed;
do
{
saveFailed = false;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException ex)
{
saveFailed = true;
ex.Entries.Single().Reload();
}
catch (Exception)
{
}
} while (saveFailed);
}
}
public void Update(StoreViewModel obj)
{
using (GymEntity db = new GymEntity())
{
var store = db.Store.Find(obj.StoreNo);
store.Name = obj.Name;
store.Address = obj.Address;
store.Tel = obj.Tel;
store.ServiceInfo = obj.ServiceInfo;
store.ParkingInfo = obj.ParkingInfo;
store.AccessLimit = Convert.ToInt32(obj.AccessLimit);
bool saveFailed;
do
{
saveFailed = false;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException ex)
{
saveFailed = true;
ex.Entries.Single().Reload();
}
catch (Exception)
{
saveFailed = true;
}
} while (saveFailed);
}
}
/// <summary>
/// 根據教練編號回傳資料
/// </summary>
/// <param name="id">教練編號</param>
/// <returns>姓名</returns>
public Teacher Get(string id)
{
using (GymEntity db = new GymEntity())
{
var all = db.Teacher.Find(id);
return(all);
}
}
/// <summary>
/// 取得所有教練資料
/// </summary>
/// <returns></returns>
public IEnumerable <Teacher> Get()
{
using (GymEntity db = new GymEntity())
{
var all = db.Teacher.Select(a => a).ToList();
return(all);
}
}
/// <summary>
/// 根據教練編號回傳姓名
/// </summary>
/// <param name="TeacherNo">教練編號</param>
/// <returns>姓名</returns>
public string GetName(string TeacherNo)
{
using (GymEntity db = new GymEntity())
{
var name = db.Teacher.Find(TeacherNo).Name;
return(name);
}
}
//取得所有會員課程筆數
public int GetCount()
{
using (GymEntity db = new GymEntity())
{
var courseCnt = db.MemberCourse.Select(a => a).Count();
return(courseCnt);
}
}
//取得所有會員課程資料
public IEnumerable <MemberCourse> Get()
{
using (GymEntity db = new GymEntity())
{
var course = db.MemberCourse.Select(a => a).ToList();
return(course);
}
}
//根據會員編號取得課程資料
public IEnumerable <MemberCourse> Get(int memberNo)
{
using (GymEntity db = new GymEntity())
{
var course = db.MemberCourse.Where(a => a.Member_No.Equals(memberNo)).Select(a => a).ToList();
return(course);
}
}
/// <summary>
/// 根據課程類型編號取得該資料
/// </summary>
/// <param name="courseTypeNo"></param>
/// <returns></returns>
public CourseType Get(string courseTypeNo)
{
using (GymEntity db = new GymEntity())
{
var course = db.CourseType.Find(courseTypeNo);
return(course);
}
}
/// <summary>
/// 根據館別id與教室編號取得教室資料
/// </summary>
/// <param name="no">館別編號</param>
/// <param name="key">教室編號</param>
/// <returns></returns>
public Classroom GetInfo(string no, string key)
{
using (GymEntity db = new GymEntity())
{
var data = db.Classroom.Where(c => c.ClassroomNo.Equals(key) && c.Store_No.Equals(no)).ToList();
return(data[0]);
}
}
//根據會員編號取得方案購買紀錄
public IEnumerable <PurchaseRecord> Get(int id)
{
using (GymEntity db = new GymEntity())
{
var rec = db.PurchaseRecord.Where(a => a.Member_No == id).Select(a => a).ToList();
return(rec);
}
}
/// <summary>
/// 根據場館id找到該館資料
/// </summary>
/// <param name="storeNo">場館id</param>
/// <returns></returns>
public Store GetInfo(string storeNo)
{
using (GymEntity db = new GymEntity())
{
var store = db.Store.Find(storeNo);
return(store);
}
}
/// <summary>
/// 根據場館id找到名稱
/// </summary>
/// <param name="storeNo">場館id</param>
/// <returns></returns>
public string GetName(string storeNo)
{
using (GymEntity db = new GymEntity())
{
var name = db.Store.Where(a => a.StoreNo.Equals(storeNo)).Select(a => a.Name).ToList();
return(name[0]);
}
}
/// <summary>
/// 根據教室編號回傳教室資料
/// </summary>
/// <param name="classroomNo"></param>
/// <returns></returns>
public Classroom Get(string classroomNo)
{
using (GymEntity db = new GymEntity())
{
var data = db.Classroom.Find(classroomNo);
return(data);
}
}
//根據課程方案No取得課程方案內容
public IEnumerable <CourseSeriesDetail> Get(string SeriesNo)
{
using (GymEntity db = new GymEntity())
{
var DetailCourse = db.CourseSeriesDetail.Where(a => a.CourseSeries_No == SeriesNo).Select(a => a).ToList();
return(DetailCourse);
}
}
/// <summary>
/// 無差別取得所有教室資料
/// </summary>
/// <returns></returns>
public IEnumerable <Classroom> Get()
{
using (GymEntity db = new GymEntity())
{
var allClassroom = from x in db.Classroom select x;
var ClassroomList = allClassroom.ToList();
return(ClassroomList);
}
}
/// <summary>
/// 根據id取得該筆方案資料
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public CourseSeries Get(string id)
{
using (GymEntity db = new GymEntity())
{
//回傳未過期及可銷售狀態的方案
var Series = db.CourseSeries.Find(id);
return(Series);
}
}
public IEnumerable <Role> Get()
{
using (GymEntity db = new GymEntity())
{
var Role = from c in db.Role select c;
var allRole = Role.ToList();
return(allRole);
}
}
/// <summary>
/// 取得所有場館資料
/// </summary>
/// <returns></returns>
public IEnumerable <Store> Get()
{
using (GymEntity db = new GymEntity())
{
var allStore = from x in db.Store select x;
var StoreList = allStore.ToList();
return(StoreList);
}
}
/// <summary>
/// 無差別取得所有課程資料
/// </summary>
/// <returns></returns>
public IEnumerable <Course> Get()
{
using (GymEntity db = new GymEntity())
{
var allCourseItem = from x in db.Course select x;
var CourseItemList = allCourseItem.ToList();
return(CourseItemList);
}
}
public IEnumerable <CourseType> Get()
{
using (GymEntity db = new GymEntity())
{
var AllCourse = from c in db.CourseType
select c;
var LstCourse = AllCourse.ToList();
return(LstCourse);
}
}
/// <summary>
/// 取得所有方案資料
/// </summary>
/// <returns></returns>
public IEnumerable <CourseSeries> Get()
{
using (GymEntity db = new GymEntity())
{
//回傳未過期及可銷售狀態的方案
var AllSeries = db.CourseSeries.Where(c => c.DeadLine >= DateTime.Now && c.SaleEnable == true)
.Select(c => c).ToList();
return(AllSeries);
}
}
/// <summary>
/// 根據指定館別取得教室資料
/// </summary>
/// <param name="store">館別</param>
/// <returns></returns>
public IEnumerable <Classroom> Get(Store store)
{
using (GymEntity db = new GymEntity())
{
var allClassroom = from x in db.Classroom
where x.Store_No.Equals(store.StoreNo)
select x;
var ClassroomList = allClassroom.ToList();
return(ClassroomList);
}
}
/// <summary>
/// 根據指定教室取得課程項目
/// </summary>
/// <param name="room">教室</param>
/// <returns></returns>
public IEnumerable <Course> Get(Classroom room)
{
using (GymEntity db = new GymEntity())
{
var allCourseItem = from x in db.Course
where x.Classroom_No.Equals(room.ClassroomNo)
select x;
var CourseItemList = allCourseItem.ToList();
return(CourseItemList);
}
}
/// <summary>
/// 新增教練
/// </summary>
/// <param name="item">新增之教練資料</param>
public string Add(TeacherViewModel item)
{
using (GymEntity db = new GymEntity())
{
var msg = "";
var cnt = db.Teacher.Where(c => c.TeacherNo.Equals(item.TeacherNo) || c.Email.Equals(item.EMail)).Select(c => c);
if (cnt.Count() > 0)
{
msg = "新增的教練資料已存在!";
return(msg);
}
else
{
Teacher teacher = new Teacher();
teacher.TeacherNo = item.TeacherNo;
teacher.Name = item.Name;
teacher.Email = item.EMail;
teacher.Birthday = DateTime.ParseExact(item.BirDate, "yyyy-MM-dd", null, System.Globalization.DateTimeStyles.AllowWhiteSpaces);
teacher.CreateTime = DateTime.Now;
if (item.Status.Equals("True")) //POST回傳值為字串 要完全一樣的字
{
teacher.Status = true;
}
else
{
teacher.Status = false;
}
db.Teacher.Add(teacher);
bool saveFailed;
do
{
saveFailed = false;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException ex)
{
saveFailed = true;
ex.Entries.Single().Reload();
}
catch (Exception)
{
}
} while (saveFailed);
msg = "新增成功";
return(msg);
}
}
}
/// <summary>
/// 新增館別資料
/// </summary>
/// <param name="obj"></param>
/// <returns></returns>
public string Add(StoreViewModel obj)
{
using (GymEntity db = new GymEntity())
{
string msg = "";
var cnt = db.Store.Where(c => c.StoreNo.Equals(obj.StoreNo) || c.Name.Equals(obj.Name)).Select(c => c);
if (cnt.Count() > 0)
{
msg = "新增的館別資料已存在!";
return(msg);
}
else
{
Store store = new Store()
{
StoreNo = obj.StoreNo,
Name = obj.Name,
Tel = obj.Tel,
ServiceInfo = obj.ServiceInfo,
ParkingInfo = obj.ParkingInfo,
MemberInCnt = 0,
AccessLimit = Convert.ToInt32(obj.AccessLimit),
Address = obj.Address
};
db.Store.Add(store);
bool saveFailed;
do
{
saveFailed = false;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException ex)
{
ex.Entries.Single().Reload();
}
catch (DbEntityValidationException ex)
{
}
catch (Exception ex)
{
}
} while (saveFailed);
msg = "新增成功";
return(msg);
}
}
}
/// <summary>
/// 預約課程的課程資料
/// </summary>
/// <param name="MemberNo">會員編號</param>
/// <returns></returns>
public IEnumerable <Course> GetBooking(int MemberNo)
{
using (GymEntity db = new GymEntity())
{
//會員所有的預約課程
var allData = db.BookingCourse.Where(a => a.Member_No.Equals(MemberNo)).Select(a => a);
//找出尚未結束的預約課程
var data = from a in allData
from b in db.Course
where a.Course_No.Equals(b.CourseNo) && b.ClassDate >= DateTime.Now
orderby b.ClassDate, b.StartTime
select b;
var lstData = data.ToList();
return(lstData);
}
}
/// <summary>
/// 根據教室 取得所有課程項目
/// </summary>
/// <param name="RoomLst">所有教室</param>
/// <returns></returns>
public List <List <Course> > Get(List <Classroom> RoomLst)
{
using (GymEntity db = new GymEntity())
{
List <Course> tmpCourseItem = new List <Course>();
List <List <Course> > LstCourseItem = new List <List <Course> >();
foreach (Classroom item in RoomLst)
{
var tmpCourse = from x in db.Course
where x.Classroom_No.Equals(item.ClassroomNo)
select x;
tmpCourseItem = tmpCourse.ToList();
LstCourseItem.Add(tmpCourseItem);
}
return(LstCourseItem);
}
}