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