public static void UnBlockEmp(int idEmp) { using (RealEstateWebsiteEntities db = new RealEstateWebsiteEntities()) { db.USP_UnBlockBlockEmp(idEmp, DateTime.Now); } }
public static void UnBlockCust(int idCust) { using (RealEstateWebsiteEntities db = new RealEstateWebsiteEntities()) { db.USP_UnBlockBlockCust(idCust, DateTime.Now, DateTime.Now); } }
public static void QuitEmp(int idEmp, string Reason) { using (RealEstateWebsiteEntities db = new RealEstateWebsiteEntities()) { db.USP_InsertQuitEmp(idEmp, Reason, DateTime.Now); } }
public static List <Employee> GetListEmp() { using (RealEstateWebsiteEntities db = new RealEstateWebsiteEntities()) { return(db.Employees.ToList()); } }
public static Employee GetOneEmp(int id) { using (RealEstateWebsiteEntities db = new RealEstateWebsiteEntities()) { return(db.Employees.Where(p => p.Employee_ID == id).SingleOrDefault()); } }
public static void UpdateEmp(Employee model) { using (RealEstateWebsiteEntities db = new RealEstateWebsiteEntities()) { db.Employees.Attach(model); db.Entry(model).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); } }
public static void BlockEmp(int idEmp, string Reason, DateTime?unBlockDate) { using (RealEstateWebsiteEntities db = new RealEstateWebsiteEntities()) { if (unBlockDate == null) { unBlockDate = DateTime.Now.AddMonths(1); } db.USP_InsertBlockEmp(idEmp, unBlockDate, Reason, DateTime.Now); } }
public static Dashboard GetItem() { Dashboard dash = new Dashboard(); RealEstateWebsiteEntities db = new RealEstateWebsiteEntities(); { dash.Count_Employee = db.Employees.Count(); dash.Count_Customer = db.Customers.Count(); dash.Count_Post = db.Posts.Count(); dash.Sum_Sale = db.Posts.Where(p => p.PostTime.Value == DateTime.Now).Count(); } return(dash); }
public PartialViewResult UpdatePassPartial(string passwordM, string passwordC, string passwordL) { RealEstateWebsiteEntities dbs = new RealEstateWebsiteEntities(); Account cst = Session["Account"] as Account; if (HashPwdTool.CheckPassword(passwordC, cst.PasswordHash) && passwordM == passwordL) { dbs.spUpdateAccount(cst.Account_ID, HashPwdTool.GeneratePassword(passwordM)); ViewBag.ThongBao = "Change password successful"; } else { ViewBag.ThongBao = "Current pass incorrect"; } return(PartialView("UpdatePassPartial")); }
public ActionResult SearchResultCustomer(string key) { RealEstateWebsiteEntities db = new RealEstateWebsiteEntities(); List <Customer> list = db.Customers.Where(p => p.Firstname.Contains(key) || p.LastName.Contains(key) || p.Account.UserName.Contains(key)).ToList(); if (list.Count != 0) { ViewBag.ThongBaoSearch = "Found " + list.Count + " results"; } else { ViewBag.ThongBaoSearchNotFound = "No Results Found"; } return(View(list)); }
public BLLAccount() { _dbContext = new RealEstateWebsiteEntities(); }