public override Role GetElement(int id)
{
QLSDDienNuocModel db = new QLSDDienNuocModel();
var result = db.Roles.Where(x => x.isDelete == false && x.ID == id).FirstOrDefault();
return(result);
}
public override User Insert(User obj)
{
QLSDDienNuocModel db = new QLSDDienNuocModel();
obj.isDelete = false;
var result = db.Users.Add(obj);
if (result != null)
{
if (db.SaveChanges() > 0)
{
foreach (var item in new QuyenLDM().GetElements())
{
var mUR = new Users_Roles
{
CreatedByID = obj.CreatedByID,
CreatedDate = DateTime.Now.Date,
isAdd = false,
isDelete = false,
isEdit = false,
isRemove = false,
isView = false,
RoleID = item.ID,
UserID = result.ID
};
new User_RoleLDM().Insert(mUR);
}
return(result);
}
}
return(null);
}
protected override void Seed(LogicDataModels.DataModels.QLSDDienNuocModel context)
{
// This method will be called after migrating to the latest version.
// You can use the DbSet<T>.AddOrUpdate() helper extension method
// to avoid creating duplicate seed data.
QLSDDienNuocModel db = new QLSDDienNuocModel();
if (!db.Users.Any(x => x.UserName == "admin"))
{
db.Users.Add(new User {
UserName = "******", Password = Commons.En_Decrypt.Encrypt("123a@"), isAdmin = 1, isDelete = false, DisplayName = "Administrator"
});
}
List <string> RoleName = new List <string>
{
"Quản lý khách hàng",
"Quản lý nhân viên",
"Quản lý đơn giá",
"Quản lý tiêu thụ"
};
if (!db.Roles.Any())
{
foreach (var item in RoleName)
{
db.Roles.Add(new Role {
RoleName = item, isDelete = false
});
}
}
db.SaveChanges();
}
public override List <Users_Roles> GetElements(int UserID)
{
QLSDDienNuocModel db = new QLSDDienNuocModel();
var result = db.Users_Roles.Where(x => x.UserID == UserID && x.isDelete == false).ToList();
return(result);
}
public List <Customer> SearchElements(string key)
{
List <Customer> result = new List <Customer>();
QLSDDienNuocModel db = new QLSDDienNuocModel();
result = db.Customers.Where(e => e.isDelete == false && e.User.DisplayName.Contains(key)).ToList();
return(result);
}
public override List <Customer> GetElements()
{
List <Customer> result = new List <Customer>();
QLSDDienNuocModel db = new QLSDDienNuocModel();
result = db.Customers.Where(e => e.isDelete == false).ToList();
return(result);
}
public List <Role> SearchElements(string key)
{
List <Role> result = new List <Role>();
QLSDDienNuocModel db = new QLSDDienNuocModel();
result = db.Roles.Where(x => x.isDelete == false && x.RoleName.Contains(key)).ToList();
return(result);
}
public List <Price> SearchElements(string key)
{
List <Price> result = new List <Price>();
QLSDDienNuocModel db = new QLSDDienNuocModel();
result = db.Prices.Where(e => e.isDelete == false && e.PriceName.Contains(key)).ToList();
return(result);
}
public User Login(string UserName, string Password)
{
string pass = En_Decrypt.Encrypt(Password);
QLSDDienNuocModel db = new QLSDDienNuocModel();
User result = db.Users.Where(e => e.UserName == UserName && e.Password == pass && e.isDelete == false).FirstOrDefault();
return(result);
}
public List <Consume> SearchElements(DateTime fromDate, DateTime toDate, int cusID)
{
List <Consume> result = new List <Consume>();
QLSDDienNuocModel db = new QLSDDienNuocModel();
result = db.Consumes.Where(e => e.isDelete == false && e.Time.Value >= fromDate && e.Time.Value <= toDate && e.CustomerID == cusID).ToList();
return(result);
}
public override List <Consume> GetElements(int id)
{
List <Consume> result = new List <Consume>();
QLSDDienNuocModel db = new QLSDDienNuocModel();
result = db.Consumes.Where(e => e.isDelete == false && e.CustomerID == id).ToList();
return(result);
}
public override List <User> GetElements()
{
List <User> result = new List <User>();
QLSDDienNuocModel db = new QLSDDienNuocModel();
result = db.Users.Where(e => e.isDelete == false && e.isAdmin == 2).ToList();
return(result);
}
public override List <Role> GetElements()
{
List <Role> result = new List <Role>();
QLSDDienNuocModel db = new QLSDDienNuocModel();
result = db.Roles.Where(x => x.isDelete == false).ToList();
return(result);
}
public List <User> SearchElements(string key)
{
List <User> result = new List <User>();
QLSDDienNuocModel db = new QLSDDienNuocModel();
result = db.Users.Where(x => x.isDelete == false && x.DisplayName.Contains(key) && x.isAdmin != 1).ToList();
return(result);
}
public bool isDuplicateUserName(string userName)
{
QLSDDienNuocModel db = new QLSDDienNuocModel();
if (db.Users.Where(x => x.isDelete == false && x.UserName == userName).FirstOrDefault() == default(User))
{
return(false);
}
return(true);
}
public bool DoiMatKhau(User obj)
{
QLSDDienNuocModel db = new QLSDDienNuocModel();
var result = db.Users.Where(x => x.ID == obj.ID).FirstOrDefault();
if (result != default(User))
{
result.Password = obj.Password;
if (db.SaveChanges() >= 0)
{
return(true);
}
}
return(false);
}
public bool ThanhToan(Consume obj)
{
QLSDDienNuocModel db = new QLSDDienNuocModel();
var result = db.Consumes.Where(x => x.ID == obj.ID).FirstOrDefault();
if (result != default(Consume))
{
result.isPay = true;
if (db.SaveChanges() > 0)
{
return(true);
}
}
return(false);
}
public bool Delete(int UserID, int RoleID)
{
QLSDDienNuocModel db = new QLSDDienNuocModel();
var result = db.Users_Roles.Where(x => x.UserID == UserID && x.RoleID == RoleID).FirstOrDefault();
if (result != default(Users_Roles))
{
result.isDelete = true;
}
if (db.SaveChanges() <= 0)
{
return(false);
}
return(true);
}
public override bool Delete(int id)
{
QLSDDienNuocModel db = new QLSDDienNuocModel();
var result = db.Users.Where(x => x.ID == id).FirstOrDefault();
if (result != default(User))
{
result.isDelete = true;
}
if (db.SaveChanges() <= 0)
{
return(false);
}
return(true);
}
public override Role Insert(Role obj)
{
QLSDDienNuocModel db = new QLSDDienNuocModel();
obj.isDelete = false;
var result = db.Roles.Add(obj);
if (result != null)
{
if (db.SaveChanges() > 0)
{
return(result);
}
}
return(null);
}
public override bool Update(Role obj)
{
QLSDDienNuocModel db = new QLSDDienNuocModel();
var result = db.Roles.Where(x => x.ID == obj.ID).FirstOrDefault();
if (result != default(Role))
{
result.RoleName = obj.RoleName;
result.Description = obj.Description;
result.ModifiedByID = obj.ModifiedByID;
result.ModifiedDate = DateTime.Now.Date;
if (db.SaveChanges() >= 0)
{
return(true);
}
}
return(false);
}
public override bool Update(Price obj)
{
QLSDDienNuocModel db = new QLSDDienNuocModel();
var result = db.Prices.Where(x => x.ID == obj.ID).First();
if (result != null)
{
result.ModifiedByID = obj.ModifiedByID;
result.ModifiedDate = DateTime.Now.Date;
result.PriceName = obj.PriceName;
result.WaterPrice = obj.WaterPrice;
result.ElectricPrice = obj.ElectricPrice;
if (db.SaveChanges() >= 0)
{
return(true);
}
}
return(false);
}
public override bool Update(Users_Roles obj)
{
QLSDDienNuocModel db = new QLSDDienNuocModel();
var result = db.Users_Roles.Where(x => x.UserID == obj.UserID && x.RoleID == obj.RoleID).FirstOrDefault();
if (result != default(Users_Roles))
{
result.isAdd = obj.isAdd;
result.isEdit = obj.isEdit;
result.isRemove = obj.isRemove;
result.isView = obj.isView;
result.ModifiedByID = obj.ModifiedByID;
result.ModifiedDate = DateTime.Now.Date;
if (db.SaveChanges() >= 0)
{
return(true);
}
}
return(false);
}
public bool isDuplicateRoleName(string roleName, int id)
{
QLSDDienNuocModel db = new QLSDDienNuocModel();
if (id != -1)
{
var CurrentRole = this.GetElement(id);
if (db.Roles.Where(x => x.RoleName == roleName && x.isDelete == false && x.ID != CurrentRole.ID).FirstOrDefault() == default(Role))
{
return(false);
}
}
else
{
if (db.Roles.Where(x => x.RoleName == roleName && x.isDelete == false).FirstOrDefault() == default(Role))
{
return(false);
}
}
return(true);
}
public override bool Update(Consume obj)
{
QLSDDienNuocModel db = new QLSDDienNuocModel();
var result = db.Consumes.Where(x => x.ID == obj.ID).FirstOrDefault();
if (result != default(Consume))
{
result.WaterConsume = obj.WaterConsume;
result.ElectricConsume = obj.ElectricConsume;
result.ModifiedByID = obj.ModifiedByID;
result.ModifiedDate = DateTime.Now.Date;
result.Time = obj.Time.Value.Date;
result.NewWaterIndex = obj.NewWaterIndex;
result.NewElectricIndex = obj.NewElectricIndex;
if (db.SaveChanges() >= 0)
{
return(true);
}
}
return(false);
}
public override bool Update(Customer obj)
{
if (new UserLDM().Update(obj.User))
{
QLSDDienNuocModel db = new QLSDDienNuocModel();
var result = db.Customers.Where(x => x.ID == obj.ID).FirstOrDefault();
if (result != default(Customer))
{
result.PriceID = obj.PriceID;
result.ModifiedByID = obj.ModifiedByID;
result.ModifiedDate = DateTime.Now.Date;
result.PassportID = obj.PassportID;
if (db.SaveChanges() >= 0)
{
return(true);
}
}
}
return(false);
}
public override bool Update(User obj)
{
QLSDDienNuocModel db = new QLSDDienNuocModel();
var result = db.Users.Where(x => x.ID == obj.ID).FirstOrDefault();
if (result != default(User))
{
result.Address = obj.Address;
result.DateOfBirth = obj.DateOfBirth;
result.DisplayName = obj.DisplayName;
result.Email = obj.Email;
result.Gender = obj.Gender;
result.isAdmin = obj.isAdmin;
result.ModifiedByID = obj.ModifiedByID;
result.ModifiedDate = DateTime.Now.Date;
result.Phone = obj.Phone;
result.isPay = obj.isPay;
if (db.SaveChanges() >= 0)
{
return(true);
}
}
return(false);
}
public Customer GetElementByUserID(int id)
{
QLSDDienNuocModel db = new QLSDDienNuocModel();
return(db.Customers.Where(x => x.isDelete == false && x.UserID == id).FirstOrDefault());
}
public override List <Price> GetElements()
{
QLSDDienNuocModel db = new QLSDDienNuocModel();
return(db.Prices.Where(x => x.isDelete == false).ToList());
}
public override User GetElement(int id)
{
QLSDDienNuocModel db = new QLSDDienNuocModel();
return(db.Users.Where(x => x.ID == id && x.isDelete == false).FirstOrDefault());
}
