/// <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>
/// 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>
/// 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>
/// 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>
/// Đă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>
/// 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>
/// 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>
/// 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>
/// 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>
/// Xét tiêu đề
/// </summary>
/// <param name="ID"></param>
/// <param name="_title"></param>
/// <returns></returns>
public static Boolean setTitle(int ID, string _title)
{
LTDHDataContext DB = new LTDHDataContext(@strPathDB);
using (TransactionScope ts = new TransactionScope())
{
var record = DB.tblInformatics.Single(TB => TB.ID == ID);
record.Title = _title;
DB.SubmitChanges();
ts.Complete();
}
return true;
}
/// <summary>
/// Cập nhật tin tức
/// </summary>
/// <param name="recordUpdate"></param>
/// <returns></returns>
public static Boolean updateNews(int newsID, tblNew recordUpdate)
{
LTDHDataContext DB = new LTDHDataContext(@strPathDB);
try
{
using (TransactionScope ts = new TransactionScope())
{
var news = DB.tblNews.Single(n => n.ID == newsID);
news.Title = recordUpdate.Title;
news.Chapaeu = recordUpdate.Chapaeu;
news.Contents = recordUpdate.Contents;
news.Posted = recordUpdate.Posted;
news.Author = recordUpdate.Author;
DB.SubmitChanges();
ts.Complete();
}
}
catch (Exception e)
{
return false;
}
return true;
}
/// <summary>
/// Xét nội dung tin tức
/// </summary>
/// <param name="newsID"></param>
/// <param name="strContent"></param>
/// <returns></returns>
public static Boolean setContent(int newsID, string strContent)
{
LTDHDataContext DB = new LTDHDataContext(@strPathDB);
using (TransactionScope ts = new TransactionScope())
{
var record = DB.tblNews.Single(TB => TB.ID == newsID);
record.Contents = strContent;
DB.SubmitChanges();
ts.Complete();
}
return true;
}
