private static void Init(DemoDbContext ctx)
{
int customerCount = ctx.Customers.Count();
if (customerCount == 0)
{
ctx.Customers.Add(new Customer
{
Name = "Kalle",
});
ctx.SaveChanges();
}
int productCount = ctx.Products.Count();
if (productCount == 0)
{
ctx.Products.Add(new Product
{
Name = "Ferarri",
});
ctx.SaveChanges();
}
}
public bool Add(Country country)
{
_logger.LogDebug("In CoiuntryDAL Add()");
_dbContext.Country.Add(country);
return(_dbContext.SaveChanges() > 0);
}
public IActionResult AddGoodsCollection(string openid, int goodsinfocode)
{
if (openid == null || goodsinfocode.ToString() == null)
{
return(NotFound());
}
string Openid = GetOpenid(openid);
var result = from a in _context.UserApp
where a.UserAppOpenid == Openid
select a;
int Code = 0;
foreach (var item in result)
{
Code = item.UserAppCode;
}
try
{
var GoodsCollection = new UserGoodsCollection
{
UserAppCode = Code,
GoodsInfoCode = goodsinfocode
};
_context.UserGoodsCollection.Add(GoodsCollection);
_context.SaveChanges();
return(Content("addsucess"));
}
catch (DbException)
{
return(Content("addfail"));
}
}
public T Add(T entity)
{
_dbContext.Set <T>().Add(entity);
_dbContext.SaveChanges();
return(entity);
}
public ActionResult Create(Customer customer)
{
if (ModelState.IsValid)
{
customer.CreatedDate = DateTime.Now;
customer.CreatedBy = Session["userEmail"].ToString();;
try
{
customer.category = Session["ACategory"].ToString();
db.customers.Add(customer);
String Operation = "Customer Created Sucessfully";
db.ActivityLogs.Add(new ActivityLog
{
Operation = Operation,
CreatedBy = Session["userEmail"].ToString(),
CreatedDate = DateTime.Now,
category = Session["ACategory"].ToString()
});
db.SaveChanges();
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
return(View(customer));
}
public override List <object> Operate(JObject data, DemoDbContext db)
{
UserAccount ua = new UserAccount()
{
Email = data[IVN.Email].ToString(),
Password = data[IVN.Password].ToString()
};
db.UserAccounts.Add(ua);
db.SaveChanges();
string email = data[IVN.Email].ToString();
ua = db.UserAccounts.Where(b => b.Email == email).FirstOrDefault();
UserInfo ui = new UserInfo()
{
UserAccountID = ua.ID,
Name = email,
Sex = "外星人",
Hp = 5,
Mp = 5,
Exp = 0,
Img = "mr.jpg"
};
db.UserInfos.Add(ui);
db.SaveChanges();
return(new List <object> {
true
});
}
private void CreateHostRoleAndUsers()
{
//Admin role for host
var adminRoleForHost = _context.Roles.FirstOrDefault(r => r.TenantId == null && r.Name == StaticRoleNames.Host.Admin);
if (adminRoleForHost == null)
{
adminRoleForHost = _context.Roles.Add(new Role {
Name = StaticRoleNames.Host.Admin, DisplayName = StaticRoleNames.Host.Admin, IsStatic = true
});
_context.SaveChanges();
//Grant all tenant permissions
var permissions = PermissionFinder
.GetAllPermissions(new DemoAuthorizationProvider())
.Where(p => p.MultiTenancySides.HasFlag(MultiTenancySides.Host))
.ToList();
foreach (var permission in permissions)
{
if (!permission.IsGrantedByDefault)
{
_context.Permissions.Add(
new RolePermissionSetting
{
Name = permission.Name,
IsGranted = true,
RoleId = adminRoleForHost.Id
});
}
}
_context.SaveChanges();
}
//Admin user for tenancy host
var adminUserForHost = _context.Users.FirstOrDefault(u => u.TenantId == null && u.UserName == User.AdminUserName);
if (adminUserForHost == null)
{
adminUserForHost = _context.Users.Add(
new User
{
UserName = User.AdminUserName,
Name = "System",
Surname = "Administrator",
EmailAddress = "*****@*****.**",
IsEmailConfirmed = true,
Password = new PasswordHasher().HashPassword(User.DefaultPassword)
});
_context.SaveChanges();
_context.UserRoles.Add(new UserRole(null, adminUserForHost.Id, adminRoleForHost.Id));
_context.SaveChanges();
}
}
private void CreateRolesAndUsers()
{
//Admin role
var adminRole = _context.Roles.FirstOrDefault(r => r.TenantId == _tenantId && r.Name == StaticRoleNames.Tenants.Admin);
if (adminRole == null)
{
adminRole = _context.Roles.Add(new Role(_tenantId, StaticRoleNames.Tenants.Admin, StaticRoleNames.Tenants.Admin)
{
IsStatic = true
});
_context.SaveChanges();
//Grant all permissions to admin role
var permissions = PermissionFinder
.GetAllPermissions(new DemoAuthorizationProvider())
.Where(p => p.MultiTenancySides.HasFlag(MultiTenancySides.Tenant))
.ToList();
foreach (var permission in permissions)
{
if (!permission.IsGrantedByDefault)
{
_context.Permissions.Add(
new RolePermissionSetting
{
TenantId = _tenantId,
Name = permission.Name,
IsGranted = true,
RoleId = adminRole.Id
});
}
}
_context.SaveChanges();
}
//admin user
var adminUser = _context.Users.FirstOrDefault(u => u.TenantId == _tenantId && u.UserName == User.AdminUserName);
if (adminUser == null)
{
adminUser = User.CreateTenantAdminUser(_tenantId, "*****@*****.**", "123qwe");
adminUser.IsEmailConfirmed = true;
adminUser.IsActive = true;
_context.Users.Add(adminUser);
_context.SaveChanges();
//Assign Admin role to admin user
_context.UserRoles.Add(new UserRole(_tenantId, adminUser.Id, adminRole.Id));
_context.SaveChanges();
}
}
public ActionResult Create([Bind(Include = "CCCD,FullName")] Person person)
{
if (ModelState.IsValid)
{
db.Persons.Add(person);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(person));
}
public ActionResult <bool> Delete(int id)
{
var item = _context.Users.FirstOrDefault(s => s.Id.Equals(id));
if (item == null)
{
return(NotFound());
}
_context.Users.Remove(item);
return(_context.SaveChanges() > 0);
}
public ActionResult Create([Bind(Include = "TenDV,MaDV,Gia")] DichVu dichVu)
{
if (ModelState.IsValid)
{
db.DichVus.Add(dichVu);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(dichVu));
}
public ActionResult Create([Bind(Include = "UserName,Password")] Account account)
{
if (ModelState.IsValid)
{
db.Accounts.Add(account);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(account));
}
public ActionResult Create([Bind(Include = "DTNgay,DTThang,DTNam")] BaoCao baoCao)
{
if (ModelState.IsValid)
{
db.BaoCaos.Add(baoCao);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(baoCao));
}
public ActionResult Create([Bind(Include = "MaHD,TenHD,NgayTT,ThanhTien,MaKH")] HoaDon hoaDon)
{
if (ModelState.IsValid)
{
db.HoaDons.Add(hoaDon);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(hoaDon));
}
public ActionResult Create([Bind(Include = "TenKh,MaKh,HoKh,SoCMT,SoDT")] KhachHang khachHang)
{
if (ModelState.IsValid)
{
db.KhachHangs.Add(khachHang);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(khachHang));
}
public ActionResult Create([Bind(Include = "StudentID,StudentName,Age")] Student student)
{
if (ModelState.IsValid)
{
db.Students.Add(student);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(student));
}
public ActionResult Create([Bind(Include = "NameItem,IDIteam,PriceItem,AmountItem")] Item item)
{
if (ModelState.IsValid)
{
db.Items.Add(item);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(item));
}
public ActionResult Create([Bind(Include = "IDPet,TenPet,LoaiPet,TuoiCuaPet")] ShopPet shopPet)
{
if (ModelState.IsValid)
{
db.ShopPets.Add(shopPet);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(shopPet));
}
public ActionResult Create([Bind(Include = "CCCD,Address,University,FullName")] Student1 student1)
{
if (ModelState.IsValid)
{
db.Student1.Add(student1);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(student1));
}
public ActionResult Create([Bind(Include = "NhatKySo,NoiDung")] NotDay notDay)
{
if (ModelState.IsValid)
{
db.NotDays.Add(notDay);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(notDay));
}
public ActionResult Create([Bind(Include = "MaSach,TenSach,MaLoaiSach,SoLuong")] QuanLyThuVien quanLyThuVien)
{
if (ModelState.IsValid)
{
db.QuanLyThuViens.Add(quanLyThuVien);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(quanLyThuVien));
}
public ActionResult Create([Bind(Include = "TenKh,MaKh,HoKh,SoCMT,NgayDen,NgayDi,SoDT")] Customer customer)
{
if (ModelState.IsValid)
{
db.Customers.Add(customer);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(customer));
}
public ActionResult Create([Bind(Include = "TenPhong,ViTri,Loai,TinhTrang,Gia")] ThuePhong thuePhong)
{
if (ModelState.IsValid)
{
db.ThuePhongs.Add(thuePhong);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(thuePhong));
}
public ActionResult Create([Bind(Include = "NameHuman,PositionHuman,IDhuman,PhoneNumber")] Human human)
{
if (ModelState.IsValid)
{
db.Humans.Add(human);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(human));
}
public ActionResult Create([Bind(Include = "CCCD,NhanvienID,Vitri,FullName")] Nhanvien nhanvien)
{
if (ModelState.IsValid)
{
db.Nhanviens.Add(nhanvien);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(nhanvien));
}
public ActionResult Create([Bind(Include = "TenDDH,GiaTriDDH,TinhTrang")] DonDatHang donDatHang)
{
if (ModelState.IsValid)
{
db.DonDatHangs.Add(donDatHang);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(donDatHang));
}
public ActionResult Create([Bind(Include = "NameDescribe,ContentDescribe")] Describe describe)
{
if (ModelState.IsValid)
{
db.Describes.Add(describe);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(describe));
}
public ActionResult Create([Bind(Include = "MaNV,HoNV,TenNV,ChucVu,SoCMT,DiaChi")] NhanVien nhanVien)
{
if (ModelState.IsValid)
{
db.NhanViens.Add(nhanVien);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(nhanVien));
}
public ActionResult Create([Bind(Include = "ktdn")] Encrytion encrytion)
{
if (ModelState.IsValid)
{
db.Encrytions.Add(encrytion);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(encrytion));
}
//修改
public IActionResult CheckGoodsInfos(int?ClassCode, string GoodsInfoName, string GoodsInfoPrice, string GoodsInfoImageUrl, int?Code)
{
var Aid = HttpContext.Session.GetString("Aid");
if (Aid == null)
{
return(RedirectToAction("Login", "Login"));
}
if (ClassCode == null || GoodsInfoName == null || GoodsInfoPrice == null || GoodsInfoImageUrl == null)
{
return(Content("404"));
}
if (_context.GoodsInfo.Where(a => a.GoodsInfoName == GoodsInfoName).Count() == 0 || _context.GoodsInfo.Where(a => a.GoodsInfoImageUrl == GoodsInfoImageUrl).Count() == 0)
{
try
{
var UpdateGoodsInfos = _context.GoodsInfo.Where(a => a.GoodsInfoCode == Code).FirstOrDefault();
UpdateGoodsInfos.GoodsInfoName = GoodsInfoName;
UpdateGoodsInfos.GoodsInfoPrice = GoodsInfoPrice;
UpdateGoodsInfos.GoodsInfoImageUrl = GoodsInfoImageUrl;
UpdateGoodsInfos.GoodsClassificationCode = Convert.ToInt32(ClassCode);
_context.SaveChanges();
return(Content("200"));
}
catch (DbUpdateConcurrencyException)
{
return(Content("500"));
}
}
else
{
return(Content("201"));
}
}
