/// <summary> /// Lấy ngày đăng /// </summary> /// <param name="ID"></param> /// <returns></returns> public static DateTime getPosted(int ID) { LTDHDataContext DB = new LTDHDataContext(@strPathDB); var lst = from record in DB.tblEnglishes where record.ID == ID select record; return lst.ElementAt(0).Posted; }
/// <summary> /// Lấy điểm bài viết /// </summary> /// <param name="ID"></param> /// <returns></returns> public static int getPoint(int ID) { LTDHDataContext DB = new LTDHDataContext(@strPathDB); var lst = from record in DB.tblEnglishes where record.ID == ID select record; return (int)lst.ElementAt(0).Point; }
/// <summary> /// Lấy nội dung bài viết /// </summary> /// <param name="ID"></param> /// <returns></returns> public static string getContent(int ID) { LTDHDataContext DB = new LTDHDataContext(@strPathDB); var lst = from record in DB.tblInformatics where record.ID == ID select record; return lst.ElementAt(0).Contents; }
/// <summary> /// Lấy tên tác giả bài viết /// </summary> /// <param name="newsID"></param> /// <returns></returns> public static string getAuthor(int newsID) { LTDHDataContext DB = new LTDHDataContext(@strPathDB); var lst = from author in DB.tblUsers join news in DB.tblNews on author.Username equals news.Author where news.ID == newsID select author; return lst.ElementAt(0).DisplayName; }
/// <summary> /// Lấy tên tác giả /// </summary> /// <param name="ID"></param> /// <returns></returns> public static string getAuthor(int ID) { LTDHDataContext DB = new LTDHDataContext(@strPathDB); var lst = from author in DB.tblUsers join record in DB.tblEnglishes on author.Username equals record.Author where record.ID == ID select author; return lst.ElementAt(0).DisplayName; }
/// <summary> /// Kiểm tra sự tồn tại của 1 tin tức /// </summary> /// <param name="newsID"></param> /// <returns></returns> public static bool checkNewsExists(int newsID) { LTDHDataContext DB = new LTDHDataContext(@strPathDB); IEnumerable<tblNew> lst = from record in DB.tblNews where record.ID == newsID select record; if (lst.Count() > 0) { return true; } return false; }
/// <summary> /// Lấy ra đoạn tóm tắt của tin tức /// </summary> /// <param name="newsID"></param> /// <returns></returns> public static string getChapeau(int newsID) { LTDHDataContext DB = new LTDHDataContext(@strPathDB); IEnumerable<tblNew> lst = from record in DB.tblNews where record.ID == newsID select record; if (lst.Count() > 0) { return lst.ElementAt(0).Chapaeu; } return "Not Exists"; }
/// <summary> /// Kiểm tra xem đã có email này đăng ký hay chưa? /// </summary> /// <param name="_email"></param> /// <returns></returns> public static string existedEmail(string _email) { LTDHDataContext DB = new LTDHDataContext(@strPathDB); //tìm user trong bảng user IEnumerable<tblUser> user = from record in DB.tblUsers where record.Email == _email select record; // nếu tồn tại it nhất 1 user if (user.Count() > 0) { return user.ElementAt(0).Username; } return null; }
/// <summary> /// Kiểm tra xem đã có username này hay chưa? /// </summary> /// <param name="_username"></param> /// <returns></returns> public static Boolean existedUser(string _username) { LTDHDataContext DB = new LTDHDataContext(@strPathDB); //tìm user trong bảng user IEnumerable<tblUser> user = from record in DB.tblUsers where record.Username == _username select record; // nếu tồn tại it nhất 1 user if (user.Count() > 0) { return true; } return false; }
/// <summary> /// Tổng số user /// </summary> /// <returns></returns> public static int numberOfUsers() { LTDHDataContext DB = new LTDHDataContext(@strPathDB); var lst = from record in DB.tblUsers select record; return lst.Count(); }
/// <summary> /// Kiểm tra xem có phải user hay k? /// </summary> /// <param name="_username"></param> /// <param name="_password"></param> /// <returns></returns> public static Boolean isUser(string _username, string _password) { LTDHDataContext DB = new LTDHDataContext(@strPathDB); string pwd = encryptPassword(_password); IEnumerable<tblUser> lst = from record in DB.tblUsers where record.Username == _username && record.Password == pwd select record; if (lst.Count() > 0) { return true; } return false; }
/// <summary> /// Thêm một user mới /// </summary> /// <param name="record"></param> /// <returns></returns> public static Boolean insertUser(tblUser record) { LTDHDataContext DB = new LTDHDataContext(strPathDB); try { using (TransactionScope ts = new TransactionScope()) { DB.tblUsers.InsertOnSubmit(record); DB.SubmitChanges(); ts.Complete(); } } catch (Exception e) { return false; } return true; }
/// <summary> /// Lấy loại thành viên /// - Admin /// - Normal /// </summary> /// <param name="username"></param> /// <returns></returns> public static string getUserType(string username) { LTDHDataContext DB = new LTDHDataContext(@strPathDB); IEnumerable<tblUser> lst = from record in DB.tblUsers where record.Username == username select record; if (lst.ElementAt(0).Type == false) { return "Admin"; } return "Normal"; }
/// <summary> /// Lấy trạng thái của user /// </summary> /// <param name="username"></param> /// <returns></returns> public static string getUserState(string username) { LTDHDataContext DB = new LTDHDataContext(@strPathDB); IEnumerable<tblUser> lst = from record in DB.tblUsers where record.Username == username select record; int type = lst.ElementAt(0).State; string strState = ""; switch (type) { case 0: { strState = "Non-Active"; break; } case 1: { strState = "Active"; break; } case 2: { strState = "Warning"; break; } case 31: { strState = "KIA 3 ngày"; break; } case 32: { strState = "KIA 1 tuần"; break; } case 33: { strState = "KIA 2 tuần"; break; } case 34: { strState = "KIA 3 tuần"; break; } case 35: { strState = "KIA 1 tháng"; break; } default: break; } return strState; }
/// <summary> /// Lấy user /// </summary> /// <param name="_username"></param> /// <param name="_password"></param> /// <returns></returns> public static tblUser getUser(string _username, string _password) { LTDHDataContext DB = new LTDHDataContext(@strPathDB); string pwd = encryptPassword(_password); IEnumerable<tblUser> lst = from record in DB.tblUsers where record.Username == _username && record.Password == pwd select record; if (lst.Count() > 0) { return lst.ElementAt(0); } return null; }
/// <summary> /// Xét loại bài viết /// 0 - Bài giảng /// 1 - Đề thi /// 2 - Bài tập /// </summary> /// <param name="ID"></param> /// <param name="_type"></param> /// <returns></returns> public static Boolean setType(int ID, int _type) { LTDHDataContext DB = new LTDHDataContext(@strPathDB); using (TransactionScope ts = new TransactionScope()) { var record = DB.tblEnglishes.Single(TB => TB.ID == ID); record.Type = _type; DB.SubmitChanges(); ts.Complete(); } return true; }
/// <summary> /// Lấy số bài viết của user. /// </summary> /// <param name="username"></param> /// <returns></returns> public static int getNumberOfArticles(string username) { LTDHDataContext DB = new LTDHDataContext(@strPathDB); IEnumerable<tblUser> lst = from record in DB.tblUsers where record.Username == username select record; return lst.ElementAt(0).NumberOfArticles; }
/// <summary> /// Cập nhật bài viết /// </summary> /// <param name="update"></param> /// <returns></returns> public static Boolean updateInformatic(int _id, tblInformatic update) { LTDHDataContext DB = new LTDHDataContext(@strPathDB); try { using (TransactionScope ts = new TransactionScope()) { var informatic = DB.tblInformatics.Single(info => info.ID == _id); informatic.Title = update.Title; informatic.Type = update.Type; informatic.Chapeau = update.Chapeau; informatic.Contents = update.Contents; informatic.Author = update.Author; informatic.Posted = update.Posted; informatic.State = update.State; informatic.Point = update.Point; informatic.Tag = update.Tag; DB.SubmitChanges(); ts.Complete(); } } catch (Exception e) { return false; } return true; }
/// <summary> /// Cập nhật user /// </summary> /// <param name="_username"></param> /// <param name="update"></param> /// <returns></returns> public static Boolean updateUser(string _username, tblUser update) { LTDHDataContext DB = new LTDHDataContext(@strPathDB); try { using (TransactionScope ts = new TransactionScope()) { var user = DB.tblUsers.Single(u => u.Username == _username); user.Password = update.Password; user.DisplayName = update.DisplayName; user.Email = update.Email; user.Type = update.Type; user.Role = update.Role; user.Permission = update.Permission; user.State = update.State; user.RegisterDate = update.RegisterDate; user.NumberOfArticles = update.NumberOfArticles; user.Note = update.Note; DB.SubmitChanges(); ts.Complete(); } } catch (Exception e) { return false; } return true; }
/// <summary> /// Lấy tiêu đề /// </summary> /// <param name="ID"></param> /// <returns></returns> public static string getTitle(int ID) { LTDHDataContext DB = new LTDHDataContext(@strPathDB); var lst = from record in DB.tblEnglishes where record.ID == ID select record; return lst.ElementAt(0).Title; }
/// <summary> /// Lấy ra loại bài viết /// </summary> /// <param name="ID"></param> /// <returns></returns> public static string getType(int ID) { LTDHDataContext DB = new LTDHDataContext(@strPathDB); var lst = from record in DB.tblEnglishes where record.ID == ID select record; int type = lst.ElementAt(0).Type; string strType = ""; switch (type) { case 0: { strType = "Bài giảng"; break; } case 1: { strType = "Đề thi"; break; } case 2: { strType = "Bài tập"; break; } default: break; } return strType; }
/// <summary> /// Cập nhật bài viết /// </summary> /// <param name="ID"></param> /// <param name="update"></param> /// <returns></returns> public static Boolean updateEnglish(int _id, tblEnglish update) { LTDHDataContext DB = new LTDHDataContext(@strPathDB); try { using (TransactionScope ts = new TransactionScope()) { var english = DB.tblEnglishes.Single(e => e.ID == _id); english.Title = update.Title; english.Type = update.Type; english.Contents = update.Contents; english.Author = update.Author; english.Posted = update.Posted; english.State = update.State; english.Point = update.Point; english.Tag = update.Tag; DB.SubmitChanges(); ts.Complete(); } } catch (Exception e) { return false; } return true; }
/// <summary> /// Đăng ký user mới /// </summary> /// <param name="_username"></param> /// <param name="_displayName"></param> /// <param name="_email"></param> /// <param name="_sex"></param> /// <param name="_password"></param> /// <returns></returns> public static Boolean register(string _username, string _displayName, string _email, Boolean _sex, string _password) { LTDHDataContext DB = new LTDHDataContext(@strPathDB); try { using (TransactionScope ts = new TransactionScope()) { tblUser user = new tblUser(); user.Username = _username; user.DisplayName = _displayName; user.Sex = _sex; user.Email = _email; user.Password = encryptPassword(_password); user.Note = "Password: "******"Normal"; user.RegisterDate = DateTime.Today; user.NumberOfArticles = 0; user.State = 0; DB.tblUsers.InsertOnSubmit(user); DB.SubmitChanges(); ts.Complete(); } } catch (Exception e) { return false; } return true; }
/// <summary> /// lấy tên role của user /// </summary> /// <param name="username"></param> /// <returns></returns> public static string getRole(string username) { LTDHDataContext DB = new LTDHDataContext(@strPathDB); IEnumerable<tblUser> lst = from record in DB.tblUsers where record.Username == username select record; return lst.ElementAt(0).Role; }
/// <summary> /// Lấy trạng thái bài viết /// </summary> /// <param name="ID"></param> /// <returns></returns> public static string getState(int ID) { LTDHDataContext DB = new LTDHDataContext(@strPathDB); var lst = from record in DB.tblEnglishes where record.ID == ID select record; int state = lst.ElementAt(0).State; string strState = ""; switch (state) { case 0: { strState = "Uncheck"; break; } case 1: { strState = "Checked"; break; } case 2: { strState = "Bad"; break; } default: break; } return strState; }
/// <summary> /// Xét ngày đăng tin /// </summary> /// <param name="ID"></param> /// <param name="_posted"></param> /// <returns></returns> public static Boolean setPosted(int ID, DateTime _posted) { LTDHDataContext DB = new LTDHDataContext(@strPathDB); using (TransactionScope ts = new TransactionScope()) { var record = DB.tblEnglishes.Single(TB => TB.ID == ID); record.Posted = _posted; DB.SubmitChanges(); ts.Complete(); } return true; }
/// <summary> /// Xét trạng thái của user /// 0: Non-Active (mới đăng ký thành viên) /// 1: Active (Trạng thái hoạt động bình thường) /// 2: Warning (khi gửi bài bị báo xấu) /// 31: KIA 3 ngày /// 32: KIA 1 tuần /// 33: KIA 2 tuần /// 34: KIA 3 tuần /// 35: KIA 1 tháng /// </summary> /// <param name="username"></param> /// <param name="_state"></param> /// <returns></returns> public static Boolean setUserState(string username, int _state) { LTDHDataContext DB = new LTDHDataContext(@strPathDB); using (TransactionScope ts = new TransactionScope()) { var record = DB.tblUsers.Single(TB => TB.Username == username); record.State = _state; DB.SubmitChanges(); ts.Complete(); } return true; }
/// <summary> /// method of UniversityDAO /// </summary> /// <returns></returns> public static IEnumerable<tblContestForUniversity> getAll() { LTDHDataContext DB = new LTDHDataContext(@strPathDB); IEnumerable<tblContestForUniversity> lst = from p in DB.tblContestForUniversities select p; return lst; }
/// <summary> /// Cập nhật mật khẩu mới /// </summary> /// <param name="_username"></param> /// <param name="_newPassword"></param> public static Boolean updateUserPassword(string _username, string _newPassword) { LTDHDataContext DB = new LTDHDataContext(@strPathDB); try { using (TransactionScope ts = new TransactionScope()) { var user = DB.tblUsers.Single(u => u.Username == _username); user.Note = "New password: " + _newPassword; user.Password = encryptPassword(_newPassword); DB.SubmitChanges(); ts.Complete(); } } catch (Exception e) { return false; } return true; }
/// <summary> /// Lấy ra email của username /// </summary> /// <param name="username"></param> /// <returns></returns> public static string getEmail(string username) { LTDHDataContext DB = new LTDHDataContext(@strPathDB); IEnumerable<tblUser> lst = from record in DB.tblUsers where record.Username == username select record; if (lst.Count() > 0) { return lst.ElementAt(0).Email; } return "Not Exists"; }