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