/// <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); } }