/// <summary>
/// Cập nhật người dùng
/// </summary>
/// <param name="us">User</param>
/// <returns>bool</returns>
public bool UpdateUser(StudyOnline.Entities.Models.User us)
{
using (StudyOnline.Entities.Models.StudyOnline _db = new StudyOnline.Entities.Models.StudyOnline())
{
try
{
var c = _db.User.Find(us.ID);
c.UserName = us.UserName;
c.Password = us.Password;
c.Name = us.Name;
c.Address = us.Address;
c.Email = us.Email;
c.Phone = us.Phone;
c.Avatar = us.Avatar;
c.Status = us.Status;
c.CreatedDate = us.CreatedDate;
c.CreatedBy = us.CreatedBy;
c.ModifiedDate = us.ModifiedDate;
c.ModifiedBy = us.ModifiedBy;
//c.GroupID = us.GroupID;
//c.PayID = us.PayID;
_db.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
}
public StudyOnline.Entities.Models.User GetById(string userName)
{
using (StudyOnline.Entities.Models.StudyOnline _db = new StudyOnline.Entities.Models.StudyOnline())
{
return(_db.User.SingleOrDefault(x => x.UserName == userName));
}
}
/// <summary>
/// Tạo người dùng
/// </summary>
/// <param name="tq">User</param>
/// <returns>long</returns>
public long CreateUser(StudyOnline.Entities.Models.User tq)
{
using (StudyOnline.Entities.Models.StudyOnline _db = new StudyOnline.Entities.Models.StudyOnline())
{
try
{
//User data = new User();
//data.UserName = tq.UserName;
//data.Name = tq.Name;
//data.Address = tq.Address;
//data.Email = tq.Email;
//data.Phone = tq.Phone;
//data.Avatar = tq.Avatar;
//data.Password = Encryptor.MD5Hash(tq.Password);
//data.Status = false;
_db.User.Add(tq);
_db.SaveChanges();
return(tq.ID);
}
catch (Exception)
{
return(-1);
}
}
}
public bool CheckEmail(string email)
{
using (StudyOnline.Entities.Models.StudyOnline _db = new StudyOnline.Entities.Models.StudyOnline())
{
return(_db.User.Count(x => x.Email == email) > 0);
}
}
//public List<StudyOnline.Entities.Models.User> ListUserName()
//{
// using (StudyOnline.Entities.Models.StudyOnline _db = new StudyOnline.Entities.Models.StudyOnline())
// {
// return _db.User.Where(x=>x.UserName.Equals(.ToList();
// }
//}
/// <summary>
/// Xem chi tiết người dùng
/// </summary>
/// <param name="id">id</param>
/// <returns>User</returns>
public StudyOnline.Entities.Models.User ViewDetail(long id)
{
using (StudyOnline.Entities.Models.StudyOnline _db = new StudyOnline.Entities.Models.StudyOnline())
{
return(_db.User.Find(id));
}
}
/// <summary>
/// Danh sách người dùng
/// </summary>
/// <returns>List</returns>
public List <StudyOnline.Entities.Models.User> ListAllUser()
{
using (StudyOnline.Entities.Models.StudyOnline _db = new StudyOnline.Entities.Models.StudyOnline())
{
return(_db.User.ToList());
}
}
public bool CheckUserName(string userName)
{
using (StudyOnline.Entities.Models.StudyOnline _db = new StudyOnline.Entities.Models.StudyOnline())
{
return(_db.User.Count(x => x.UserName == userName) > 0);
}
}
public int Login(string userName, string password)
{
using (StudyOnline.Entities.Models.StudyOnline _db = new StudyOnline.Entities.Models.StudyOnline())
{
var result = _db.User.SingleOrDefault(x => x.UserName == userName && x.Password == password); //lấy giá trị của User Name
if (result == null) //Nếu bằng null
{
return(0); //Nhập Tài Khoản Và Mật Khẩu
}
else //Khác Null
{
if (result.Status == false) //Trạng Thaí = False
{
return(-1); //Tài Khoản Đang Bị Khóa
}
else //Trạng Thái == true
{
if (result.Password == password) //Nếu Password đúng
{
return(1); //Đăng Nhập Thành Công
}
else
{
return(-2); //Sai tài khoản và mật khẩu
}
}
}
}
}
//Cập nhật khóa học
/// <summary>
/// Cập Nhật Khóa Học
/// </summary>
/// <param name="course">Course</param>
/// <returns>bool</returns>
public bool editCourse(StudyOnline.Entities.Models.Course course)
{
using (StudyOnline.Entities.Models.StudyOnline _db = new StudyOnline.Entities.Models.StudyOnline())
{
try
{
var c = _db.Course.Find(course.ID);
c.CourseName = course.CourseName;
c.Avatar = course.Avatar;
c.VideoIntroduce = course.VideoIntroduce;
c.Description = course.Description;
c.Content = course.Content;
c.PriceSale = course.PriceSale;
c.Price = course.Price;
c.ViewCount = course.ViewCount;
c.CreateDate = course.CreateDate;
c.Tags = course.Tags;
c.Status = course.Status;
c.TopHot = course.TopHot;
c.MetaTitle = course.MetaTitle;
c.CourseCategoryID = course.CourseCategoryID;
_db.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
}
public void Active(int id, bool status)
{
using (StudyOnline.Entities.Models.StudyOnline _db = new StudyOnline.Entities.Models.StudyOnline())
{
var data = _db.User.SingleOrDefault(x => x.ID == id);
data.Status = true;
_db.SaveChanges();
}
}
/// <summary>
/// Lấy danh sách khóa học
/// </summary>
/// <returns>List</returns>
public List <StudyOnline.Entities.Models.Course> getListCourse()
{
using (StudyOnline.Entities.Models.StudyOnline _db = new StudyOnline.Entities.Models.StudyOnline())
{
List <StudyOnline.Entities.Models.Course> lst = new List <Course>();
lst = _db.Course.ToList();
return(_db.Course.ToList());
}
}
public bool Signup(User user)
{
using (StudyOnline.Entities.Models.StudyOnline _db = new StudyOnline.Entities.Models.StudyOnline())
{
if (user != null)
{
var User = _db.User.Add(user);
_db.SaveChanges();
return(true);
}
else
{
return(false);
}
}
}
/// <summary>
/// Tạo 1 khóa học
/// </summary>
/// <param name="course">Course</param>
/// <returns>long</returns>
public long addCourse(StudyOnline.Entities.Models.Course course)
{
using (StudyOnline.Entities.Models.StudyOnline _db = new StudyOnline.Entities.Models.StudyOnline())
{
try
{
_db.Course.Add(course);
_db.SaveChanges();
return(course.ID);
}
catch (Exception)
{
return(-1);
}
}
}
/// <summary>
/// Xóa người dùng
/// </summary>
/// <param name="id">ID</param>
/// <returns>bool</returns>
public bool DeleteUser(long id)
{
using (StudyOnline.Entities.Models.StudyOnline _db = new StudyOnline.Entities.Models.StudyOnline())
{
try
{
var result = _db.User.Find(id);
_db.User.Remove(result);
_db.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
}
