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