/// <summary>
/// Thêm mới quyền cho nhân viên
/// </summary>
/// <param name="lstMember"></param>
/// <returns></returns>
public bool Insert(List <MemberModel> lstMember, int userID)
{
try
{
db = new THN_WebApplicationEntities();
if (lstMember != null && lstMember.Count > 0)
{
foreach (var item in lstMember)
{
Member model = new Member();
model.UserID = item.UserID;
model.FuncID = item.FuncID;
model.CreateBy = ConfigHelper.User.Username;
model.CreateDate = DateTime.Now;
db.Members.Add(model);
}
if (db.SaveChanges() > 0)
{
return(true);
}
}
return(false);
}catch (Exception ex)
{
WriteLogs.WriteToLogFile(ex);
return(false);
}
}
/// <summary>
/// Login Website
/// </summary>
/// <param name="username">username or email</param>
/// <param name="password">password login</param>
/// <param name="login">AccountModel</param>
/// <returns></returns>
public bool Login(string username, string password, out AccountModel login)
{
try
{
User user = new User();
db = new THN_WebApplicationEntities();
AccountModel model = new AccountModel();
if (EmailHelper.IsEmail(username))
{
user = db.Users.Where(u => u.Email == username).FirstOrDefault();
}
else
{
user = db.Users.Where(u => u.Username.Contains(username)).FirstOrDefault();
}
if (user == null)
{
login = model;
return(false);
}
else
{
string seretKey = user.SeretKey;
string pssword = Securities.EncryptPassword(password + seretKey);
if (user.UPassword.Contains(pssword))
{
user.IPAddress = Utility.GetClientIP();
user.LastLogin = DateTime.Now;
db.SaveChanges();
model.ID = (int)user.ID;
model.Username = user.Username;
model.Email = user.Email;
model.Name = user.Name;
model.Address = user.Addrress;
model.Phone = user.Mobile;
model.IPAdress = user.IPAddress;
model.LastDateLogin = (DateTime)user.LastLogin;
}
login = model;
}
if (login != null && !string.IsNullOrEmpty(login.Username) && login.ID > 0)
{
return(true);
}
return(false);
}
catch (Exception ex)
{
WriteLog(ex);
login = new AccountModel();
return(false);
}
}
/// <summary>
/// Get all User
/// </summary>
/// <returns></returns>
public List <User> GetAll()
{
try
{
db = new THN_WebApplicationEntities();
return(db.Users.ToList());
}catch (Exception ex)
{
WriteLog(ex);
return(null);
}
}
public List <Member> GetList(int userID)
{
try
{
db = new THN_WebApplicationEntities();
var lst = db.Members.Where(m => m.UserID == userID).ToList();
return(lst != null ? lst : null);
}catch (Exception ex)
{
WriteLogs.WriteToLogFile(ex);
return(null);
}
}
//public List<Function>
/// <summary>
/// Get Fucntion by ID
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public Function GetByID(int id)
{
try
{
db = new THN_WebApplicationEntities();
var fucntion = db.Functions.Find(id);
return(fucntion);
}catch (Exception ex)
{
WriteLog(ex);
return(null);
}
}
/// <summary>
/// Get Product by ID
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public Product GetByID(int id)
{
try
{
db = new THN_WebApplicationEntities();
return(db.Products.Find(id));
}
catch (Exception ex)
{
WriteLogs.WriteToLogFile(ex);
return(null);
}
}
/// <summary>
/// Get list Fuction by parent
/// </summary>
/// <param name="parent"></param>
/// <returns></returns>
public List <Function> GetByParent(int parent)
{
try
{
db = new THN_WebApplicationEntities();
var lstParent = db.Functions.Where(f => f.Parent == parent).ToList();
return(lstParent);
}catch (Exception ex)
{
WriteLog(ex);
return(null);
}
}
public static AppSetting GetSingle()
{
try
{
THN_WebApplicationEntities db = new THN_WebApplicationEntities();
var model = db.AppSettings.Take(1).FirstOrDefault();
return(model);
}catch (Exception ex)
{
WriteLogs.WriteToLogFile(ex);
return(null);
}
}
/// <summary>
/// Get Product by product name
/// </summary>
/// <param name="name"></param>
/// <returns></returns>
public List <Product> GetByName(string name)
{
try
{
db = new THN_WebApplicationEntities();
return(db.Products.Where(p => p.Name.Contains(name)).OrderBy(p => p.OrderBy).ToList());
}
catch (Exception ex)
{
WriteLogs.WriteToLogFile(ex);
return(null);
}
}
/// <summary>
/// Get Product by category id
/// </summary>
/// <param name="categoryId"></param>
/// <returns></returns>
public List <Product> GetByCategoryID(int categoryId)
{
try
{
db = new THN_WebApplicationEntities();
return(db.Products.Where(p => p.CategoryID == categoryId).OrderBy(p => p.OrderBy).ToList());
}
catch (Exception ex)
{
WriteLogs.WriteToLogFile(ex);
return(null);
}
}
/// <summary>
/// Get All Product
/// </summary>
/// <returns></returns>
public List <Product> GetAll()
{
try
{
db = new THN_WebApplicationEntities();
var lst = db.Products.OrderBy(p => p.OrderBy).ToList();
return(lst);
}
catch (Exception ex)
{
WriteLogs.WriteToLogFile(ex);
}
return(null);
}
/// <summary>
/// Get All Data
/// </summary>
/// <returns></returns>
public List <Function> GetAll()
{
List <Function> lst = new List <Function>();
try
{
db = new THN_WebApplicationEntities();
lst = db.Functions.ToList();
}catch (Exception ex)
{
WriteLog(ex);
}
return(lst);
}
public static AppSetting GetData()
{
try
{
THN_WebApplicationEntities db = new THN_WebApplicationEntities();
db.Database.Connection.Open();
var appsettings = db.AppSettings.Take(1).FirstOrDefault();
return(appsettings);
}catch (Exception ex)
{
Libraries.Utility.WriteLogs.WriteToLogFile(ex);
return(null);
}
}
/// <summary>
/// Get User by ID
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public User GetByID(int id)
{
try
{
db = new THN_WebApplicationEntities();
User model = new User();
model = db.Users.Find(id);
return(model);
}
catch (Exception ex)
{
WriteLog(ex);
return(null);
}
}
/// <summary>
/// Lấy SeretKey for Username
/// </summary>
/// <param name="usernameoremail"></param>
/// <returns></returns>
public string GetSeretKey(string usernameoremail)
{
User model = new User();
db = new THN_WebApplicationEntities();
if (EmailHelper.IsEmail(usernameoremail) == true)
{
model = db.Users.Where(u => u.Email.Contains(usernameoremail)).FirstOrDefault();
}
else
{
model = db.Users.Where(u => u.Username.Contains(usernameoremail)).FirstOrDefault();
}
return(model.SeretKey);
}
/// <summary>
/// Add new Fucntion
/// </summary>
/// <param name="add"></param>
/// <returns></returns>
public bool Insert(Function add)
{
try
{
db = new THN_WebApplicationEntities();
db.Functions.Add(add);
if (db.SaveChanges() > 0)
{
return(true);
}
return(false);
}catch (Exception ex)
{
WriteLog(ex);
return(false);
}
}
public List <FunctionViewModel> GetMenu()
{
try
{
List <FunctionViewModel> lst = new List <FunctionViewModel>();
db = new THN_WebApplicationEntities();
//Lấy danh sách menu gốc parent = 0
//var lstParent = db.Functions.Where(f => f.Parent == 0 && f.Level == 1 && f.IsMenu == false).ToList();
var lstFunction = (from m in db.Members
join f in db.Functions on m.FuncID equals f.ID
where m.UserID == ConfigHelper.User.ID // && f.Parent == 0 && f.Level == 1 && f.IsMenu == false
select f).ToList();
List <int> lstFuncID = lstFunction.Select(f => (int)f.Parent).Distinct().ToList();
List <Function> lstRoot = db.Functions.Where(f => lstFuncID.Contains(f.ID)).ToList();
var functionRoot = lstRoot.Where(f => f.Parent == 0 && f.Level == 1 && f.IsMenu == false).ToList();
//Lấy menu con level 1
foreach (var item in functionRoot)
{
FunctionViewModel model = new FunctionViewModel();
model.Id = item.ID;
model.Name = item.Name;
model.Icon = item.Icon;
model.Controller = item.ControllerName;
model.Action = item.ActionName;
model.Parent = (int)item.Parent;
model.IsMenu = (bool)item.IsMenu;
model.Level = (int)item.Level;
model.ListChild = lstFunction.Where(f => f.Parent == item.ID && f.Level == 2).Select(f => new FunctionViewModel
{
Id = f.ID, Name = f.Name, Icon = f.Icon, Controller = f.ControllerName,
IsMenu = (bool)f.IsMenu, Level = (int)f.Level,
Action = f.ActionName, Parent = (int)f.Parent
}).Distinct().ToList();
//lstFunction.Remove(item);
lst.Add(model);
}
return(lst);
}catch (Exception ex)
{
WriteLog(ex);
return(null);
}
}
/// <summary>
/// Edit product by ID
/// </summary>
/// <param name="update"></param>
/// <returns></returns>
public int Update(ProductModel update)
{
try
{
db = new THN_WebApplicationEntities();
Product model = db.Products.Find(update.Id);
model.Name = update.Name;
model.Slug = !string.IsNullOrEmpty(update.Slug) ? update.Slug : Utility.GetAlias(update.Name);
model.ShortDescription = update.ShortDescription;
model.Detail = update.Detail;
model.Visibled = update.Visibled == true ? 1 : 0;
model.IsNew = update.IsNew;
model.IsHome = update.IsHome;
model.IsHot = update.IsHot;
model.OrderBy = update.OrderBy;
model.CategoryID = update.CategoryID;
model.MenufactureID = 1;
model.MetaTitle = update.MetaTitle;
model.MetaKeyword = update.MetaKeyword;
model.MetaDescription = update.MetaDescription;
model.PriceOld = update.PriceOld;
model.PricceNew = update.PriceNew;
model.UpdatedDate = DateTime.Now;
model.UpdatedBy = AccountLogin.User.Username;
if (db.SaveChanges() > 0)
{
if (HttpContext.Current.Request.Files.Count > 0)
{
string oldImage = model.Picture;
DateTime timeSave = (DateTime)model.CreatedDate;
string folderSave = "~/Images/product/" + timeSave.ToString("MMyyyy");
model.Picture = FileHelper.UploadImage(folderSave, model.Slug);
FileHelper.delete(folderSave, oldImage);
}
return(1);
}
return(0);
}
catch (Exception ex)
{
WriteLogs.WriteToLogFile(ex);
return(-1);
}
}
public bool Update(List <MemberModel> update, int UserID)
{
try
{
db = new THN_WebApplicationEntities();
var lst = db.Members.Where(m => m.UserID == UserID).ToList();
db.Members.RemoveRange(lst);
if (db.SaveChanges() > 0)
{
bool rs = this.Insert(update, UserID);
return(rs);
}
return(false);
}catch (Exception ex)
{
WriteLogs.WriteToLogFile(ex);
return(false);
}
}
public int UploadImages(int ProductID, string[] listImageTitle, string[] listImageAlt, string[] lstOrderBy)
{
try
{
db = new THN_WebApplicationEntities();
var product = GetByID(ProductID);
if (product == null || product.ID <= 0)
{
return(0);
}
string folder = "~/Images/product/" + "P" + product.ID;
List <string> lstImages = FileHelper.UploadImages(folder, product.Slug);
ProductImage pm;
if (lstImages.Count > 0)
{
var i = 0;
foreach (var str in lstImages)
{
pm = new ProductImage();
pm.Title = !string.IsNullOrEmpty(listImageTitle[i]) ? listImageTitle[i] : product.Name;
pm.AltImages = !string.IsNullOrEmpty(listImageAlt[i]) ? listImageAlt[i] : product.MetaTitle;
pm.OrderBy = !string.IsNullOrEmpty(lstOrderBy[i]) ? int.Parse(lstOrderBy[i]) : (i + 1);
pm.FileSave = str;
pm.ProductID = product.ID;
db.ProductImages.Add(pm);
i = i + 1;
}
}
if (db.SaveChanges() > 0)
{
return(1);
}
return(0);
}
catch (Exception ex)
{
WriteLogs.WriteToLogFile(ex);
return(-1);
}
}
/// <summary>
/// Get User By Username or Email
/// </summary>
/// <param name="uInput"></param>
/// <returns></returns>
public User GetByUsernameOrEmail(string uInput)
{
try
{
db = new THN_WebApplicationEntities();
User model = new User();
if (EmailHelper.IsEmail(uInput))
{
model = db.Users.Where(u => u.Email.Contains(uInput)).FirstOrDefault();
}
else
{
model = db.Users.Where(u => u.Username.Contains(uInput)).FirstOrDefault();
}
return(model);
}
catch (Exception ex)
{
WriteLog(ex);
return(null);
}
}
/// <summary>
/// Add new Product
/// </summary>
/// <param name="add"></param>
/// <returns></returns>
public int Insert(ProductModel add)
{
try
{
db = new THN_WebApplicationEntities();
Product model = new Product();
model.Name = add.Name;
model.Slug = !string.IsNullOrEmpty(add.Slug) ? add.Slug : Utility.GetAlias(add.Name);
model.ShortDescription = add.ShortDescription;
model.Detail = add.Detail;
model.Visibled = add.Visibled == true ? 1 : 0;
model.IsNew = add.IsNew;
model.IsHome = add.IsHome;
model.IsHot = add.IsHot;
model.OrderBy = add.OrderBy;
model.CategoryID = add.CategoryID;
model.MenufactureID = 1;
model.MetaTitle = add.MetaTitle;
model.MetaKeyword = add.MetaKeyword;
model.MetaDescription = add.MetaDescription;
model.CreatedDate = DateTime.Now;
model.CreatedBy = AccountLogin.User.Username;
model.PriceOld = add.PriceOld;
model.PricceNew = add.PriceNew;
string folderSave = "~/Images/product/" + DateTime.Now.ToString("MMyyyy");
model.Picture = FileHelper.UploadImages(folderSave, model.Slug)[0].ToString();
db.Products.Add(model);
if (db.SaveChanges() > 0)
{
return(1);
}
return(0);
}
catch (Exception ex)
{
WriteLogs.WriteToLogFile(ex);
return(-1);
}
}
/// <summary>
/// Kiểm tra quyền truy cập User
/// </summary>
/// <param name="controller"></param>
/// <param name="action"></param>
/// <returns></returns>
public bool GetAccess(string controller, string action, int userID)
{
try
{
db = new THN_WebApplicationEntities();
//var function = db.Functions.Where(f => f.ControllerName == controller && f.ActionName == action).ToList();
var lst = (from m in db.Members
join f in db.Functions on m.FuncID equals f.ID
where m.UserID == userID && f.ControllerName == controller && f.ActionName == action
select f).ToList();
if (lst != null && lst.Count > 0)
{
return(true);
}
return(false);
}catch (Exception ex)
{
WriteLog(ex);
return(false);
}
}
/// <summary>
/// Update the function in database
/// </summary>
/// <param name="update"></param>
/// <returns></returns>
public bool Update(Function update)
{
try
{
db = new THN_WebApplicationEntities();
var model = db.Functions.Find(update.ID);
if (model == null)
{
return(false);
}
if (db.SaveChanges() > 0)
{
return(true);
}
return(false);
}
catch (Exception ex)
{
WriteLog(ex);
return(false);
}
}
/// <summary>
/// xoá nhân viên
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public int Delete(int id)
{
try
{
db = new THN_WebApplicationEntities();
var model = db.Users.Find(id);
if (model == null)
{
return(-1);
}
db.Users.Remove(model);
if (db.SaveChanges() > 0)
{
return(1);
}
return(0);
}
catch (Exception ex)
{
WriteLog(ex);
return(-1);
}
}
/// <summary>
/// Change display
/// </summary>
/// <param name="pId"></param>
/// <param name="visibled"></param>
/// <returns></returns>
public int ChangeVisibled(int pId, int visibled)
{
try
{
db = new THN_WebApplicationEntities();
var product = db.Products.Find(pId);
if (product == null || product.ID <= 0)
{
return(0);
}
product.Visibled = visibled;
if (db.SaveChanges() > 0)
{
return(1);
}
return(0);
}
catch (Exception ex)
{
WriteLogs.WriteToLogFile(ex);
return(-1);
}
}
/// <summary>
/// Delete a Function
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public bool Delete(int id)
{
try
{
db = new THN_WebApplicationEntities();
var model = db.Functions.Find(id);
if (model == null)
{
return(false);
}
if (db.SaveChanges() > 0)
{
return(true);
}
return(false);
}catch (Exception ex)
{
WriteLog(ex);
return(false);
}
//throw new NotImplementedException();
}
/// <summary>
/// Change status home
/// </summary>
/// <param name="pId"></param>
/// <param name="status"></param>
/// <returns></returns>
public int ChangeIsHome(int pId, int status)
{
try
{
db = new THN_WebApplicationEntities();
var product = db.Products.Find(pId);
if (product == null || product.ID <= 0)
{
return(0);
}
product.IsHome = status == 1 ? true : false;
if (db.SaveChanges() > 0)
{
return(1);
}
return(0);
}
catch (Exception ex)
{
WriteLogs.WriteToLogFile(ex);
return(-1);
}
}
/// <summary>
/// Delete a Product
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public int Delete(int id)
{
try
{
db = new THN_WebApplicationEntities();
var produdct = db.Products.Find(id);
if (produdct == null || produdct.ID <= 0)
{
return(0);
}
var lstImages = db.ProductImages.Where(p => p.ProductID == produdct.ID).ToList();
if (lstImages.Count > 0)
{
string folder = "P" + id;
db.ProductImages.RemoveRange(lstImages);
foreach (var img in lstImages)
{
string path = "~/Images/product/" + folder + "/" + img.FileSave;
FileHelper.delete(path);
}
}
db.Products.Remove(produdct);
if (db.SaveChanges() > 0)
{
FileHelper.delete("~/Images/product/thump/" + produdct.Picture);
return(1);
}
return(0);
}
catch (Exception ex)
{
WriteLogs.WriteToLogFile(ex);
return(-1);
}
}
/// <summary>
/// Insert new User
/// </summary>
/// <param name="add"></param>
/// <returns></returns>
public int Insert(User add)
{
//1 : true; 0: false; -1: Exception; 2: Đã tồn tại
try
{
db = new THN_WebApplicationEntities();
var check = db.Users.Where(u => u.Username == add.Username || u.Email == add.Email).ToList();
if (check.Count > 0)
{
return(2);
}
db.Users.Add(add);
if (db.SaveChanges() > 0)
{
return(1);
}
return(0);
}
catch (Exception ex)
{
WriteLog(ex);
return(-1);
}
}
