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