public ActionResult Create([Bind(Include = "Id,FirstName,LastName,PhoneNumber,AddressStreet,AddressCity,AddressZip,AddressState,Email")] Customer customer) { if (ModelState.IsValid) { db.Customers.Add(customer); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(customer)); }
public ActionResult Create([Bind(Include = "Id,Name")] Category category) { if (ModelState.IsValid) { db.Categories.Add(category); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(category)); }
public ActionResult Create([Bind(Include = "Id,Name")] Vendor vendor) { if (ModelState.IsValid) { db.Vendors.Add(vendor); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(vendor)); }
public ActionResult Create([Bind(Include = "Id,FirstName,LastName,PhoneNumber,AddressStreet,AddressCity,AddressZip,AddressState,Email,Job")] Employee employee) { if (ModelState.IsValid) { db.Employees.Add(employee); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(employee)); }
public ActionResult Create([Bind(Include = "Id,Date,IsOpen,Description")] Incident incident) { if (ModelState.IsValid) { db.Incidents.Add(incident); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(incident)); }
public ActionResult Create([Bind(Include = "Id,UnitPrice,ItemPrice")] SaleItem saleItem) { if (ModelState.IsValid) { db.SaleItems.Add(saleItem); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(saleItem)); }
protected override void DeleteCurrent() { UserMessage msg = new UserMessage(); if (SelectedProduct != null) { int NumSaleLines = NumberOfSaleLines(SelectedProduct.TheEntity.ProductID); int NumGrnLines = NumberOfSaleLines(SelectedProduct.TheEntity.ProductID); if ((NumSaleLines > 0) || (NumGrnLines > 0)) { if (NumSaleLines > 0) { msg.Message = string.Format("Cannot delete - there are {0} Sale Lines for this Product", NumSaleLines); } else if (NumGrnLines > 0) { msg.Message = string.Format("Cannot delete - there are {0} Grn Lines for this Product", NumGrnLines); } } else { db.Products.Remove(SelectedProduct.TheEntity); db.SaveChanges(); Products.Remove(SelectedProduct); RaisePropertyChanged("Products"); msg.Message = "Deleted"; } } else { msg.Message = "No Product selected to delete"; } Messenger.Default.Send <UserMessage>(msg); }
public void Create() { new TestOrganizationUnitsBuilder(_context, _tenantId).Create(); new TestSubscriptionPaymentBuilder(_context, _tenantId).Create(); _context.SaveChanges(); }
public void UpdateProducts() { PosWebService.PosWebServiceClient client = new PosWebService.PosWebServiceClient(); Product[] products = client.GetProducts(); db.Database.ExecuteSqlCommand("delete from Products"); db.Products.AddRange(products); db.SaveChanges(); }
public void UpdateSuppliers() { PosWebService.PosWebServiceClient client = new PosWebService.PosWebServiceClient(); Supplier[] Suppliers = client.GetSuppliers(); db.Database.ExecuteSqlCommand("delete from Suppliers"); db.Suppliers.AddRange(Suppliers); db.SaveChanges(); }
public void UpdateEmployees() { PosWebService.PosWebServiceClient client = new PosWebService.PosWebServiceClient(); Employee[] Employees = client.GetEmployees(); db.Database.ExecuteSqlCommand("delete from Employees"); db.Employees.AddRange(Employees); db.SaveChanges(); }
public void UpdateCustomers() { PosWebService.PosWebServiceClient client = new PosWebService.PosWebServiceClient(); Customer[] Customers = client.GetCustomers(); db.Database.ExecuteSqlCommand("delete from Customers"); db.Customers.AddRange(Customers); db.SaveChanges(); }
public ServiceResponse AddItem(ServiceRequest request) { var itemRequest = request.Request as Item; var result = _dbContext.Items.Add(itemRequest);; _dbContext.SaveChanges(); return(new ServiceResponse(result, true)); }
public void Create() { new DefaultEditionCreator(_context).Create(); new DefaultLanguagesCreator(_context).Create(); new HostRoleAndUserCreator(_context).Create(); new DefaultSettingsCreator(_context).Create(); _context.SaveChanges(); }
private OrganizationUnit CreateOU(string displayName, string code, long?parentId = null) { var ou = _context.OrganizationUnits.Add(new OrganizationUnit(_tenantId, displayName, parentId) { Code = code }).Entity; _context.SaveChanges(); return(ou); }
private void AddSettingIfNotExists(string name, string value, int?tenantId = null) { if (_context.Settings.IgnoreQueryFilters().Any(s => s.Name == name && s.TenantId == tenantId && s.UserId == null)) { return; } _context.Settings.Add(new Setting(tenantId, null, name, value)); _context.SaveChanges(); }
private void Approve_Click(object sender, RoutedEventArgs e) { using (var db = new RetailDbContext()) { db.Pos.Add(ViewModel.PO.TheEntity); db.SaveChanges(); } DataContext = new POEntryViewModel(); }
private void AddLanguageIfNotExists(ApplicationLanguage language) { if (_context.Languages.IgnoreQueryFilters().Any(l => l.TenantId == language.TenantId && l.Name == language.Name)) { return; } _context.Languages.Add(language); _context.SaveChanges(); }
public void SimpleDbTest() { //Add a product var product = new Product() { ProductName = $"Product {Guid.NewGuid()}" }; _dbRetail.Add(product); _dbRetail.SaveChanges(); //Purge all products var products = _dbRetail.Products.ToList(); foreach (var p in products) { _dbRetail.Remove(p); } _dbRetail.SaveChanges(); }
public ActionResult Create(int Category, string Name, string Description, decimal Price, int Vendor) { Product product = new Product(); Category _category = db.Categories.Where(c => c.Id == Category).First(); Vendor _vendor = db.Vendors.Where(v => v.Id == Vendor).First(); product.Category = _category; product.Name = Name; product.Description = Description; product.Price = Price; product.Vendor = _vendor; try { db.Products.Add(product); db.SaveChanges(); } catch (Exception e) { System.Diagnostics.Debugger.Break(); } return(RedirectToAction("Details", new { id = product.Id })); }
public ActionResult Edit([Bind(Include = "Id,Name,TaxRate")] Company company) { if (ModelState.IsValid) { db.Entry(company).State = EntityState.Modified; db.SaveChanges(); CompanyNameActionAttribute.FlushCachedCompanyName(); return(RedirectToAction("Index", "Home")); } return(View(company)); }
public ActionResult Create(int Customer, int Employee, int Product, string Description) { Service service = new Service(); Customer _customer = db.Customers.Find(Customer); Employee _employee = db.Employees.Find(Employee); Product _product = db.Products.Find(Product); service.Date = DateTime.Now; service.Description = Description; service.IsOpen = true; service.Customer = _customer; service.Employee = _employee; service.Product = _product; try { db.Services.Add(service); db.SaveChanges(); } catch (Exception e) { System.Diagnostics.Debugger.Break(); } return(RedirectToAction("Details", new { id = service.Id })); }
private void CreateDefaultTenant() { //默认组织 var defaultOrg = _context.OrganizationUnits.IgnoreQueryFilters().FirstOrDefault(t => t.DisplayName == AbpTenantBase.DefaultTenantName); if (defaultOrg == null) { defaultOrg = new OrganizationUnit(null, AbpTenantBase.DefaultTenantName) { Code = OrganizationUnit.CreateCode(1) }; _context.OrganizationUnits.Add(defaultOrg); _context.SaveChanges(); } //默认租户 var defaultTenant = _context.Tenants.IgnoreQueryFilters().FirstOrDefault(t => t.TenancyName == AbpTenantBase.DefaultTenantName); if (defaultTenant == null) { defaultTenant = new MultiTenancy.Tenant(AbpTenantBase.DefaultTenantName, AbpTenantBase.DefaultTenantName, defaultOrg.Id); var defaultEdition = _context.Editions.IgnoreQueryFilters().FirstOrDefault(e => e.Name == EditionManager.DefaultEditionName); if (defaultEdition != null) { defaultTenant.EditionId = defaultEdition.Id; } _context.Tenants.Add(defaultTenant); _context.SaveChanges(); } }
private SubscriptionPayment CreatePayment(decimal amount, int editionId, int tenantId, int dayCount, string paymentId) { var payment = _context.SubscriptionPayments.Add(new SubscriptionPayment { Amount = amount, EditionId = editionId, TenantId = tenantId, DayCount = dayCount, PaymentId = paymentId }).Entity; _context.SaveChanges(); return(payment); }
public ActionResult Create([Bind(Include = "Id,Name")] ContactList contactList) { if (ModelState.IsValid) { db.ContactLists.Add(contactList); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(contactList)); }
protected override void DeleteCurrent() { UserMessage msg = new UserMessage(); if (SelectedTenderType != null) { db.TenderTypes.Remove(SelectedTenderType.TheEntity); db.SaveChanges(); TenderTypes.Remove(SelectedTenderType); RaisePropertyChanged("TenderTypes"); msg.Message = "Deleted"; } else { msg.Message = "No TenderType selected to delete"; } Messenger.Default.Send <UserMessage>(msg); }
protected override void DeleteCurrent() { UserMessage msg = new UserMessage(); if (SelectedBankAccount != null) { db.BankAccounts.Remove(SelectedBankAccount.TheEntity); db.SaveChanges(); BankAccounts.Remove(SelectedBankAccount); RaisePropertyChanged("BankAccounts"); msg.Message = "Deleted"; } else { msg.Message = "No BankAccount selected to delete"; } Messenger.Default.Send <UserMessage>(msg); }
protected override void DeleteCurrent() { UserMessage msg = new UserMessage(); if (SelectedPrinter != null) { db.Printers.Remove(SelectedPrinter.TheEntity); db.SaveChanges(); Printers.Remove(SelectedPrinter); RaisePropertyChanged("Printers"); msg.Message = "Deleted"; } else { msg.Message = "No Printer selected to delete"; } Messenger.Default.Send <UserMessage>(msg); }
protected override void DeleteCurrent() { UserMessage msg = new UserMessage(); if (SelectedEmployee != null) { db.Addresses.Remove(SelectedEmployee.TheEntity.Address); db.Employees.Remove(SelectedEmployee.TheEntity); db.SaveChanges(); Employees.Remove(SelectedEmployee); RaisePropertyChanged("Employees"); msg.Message = "Deleted"; } else { msg.Message = "No Employee selected to delete"; } Messenger.Default.Send <UserMessage>(msg); }
public ActionResult Create(int Customer, int Employee) { Customer _customer = db.Customers.Where(c => c.Id == Customer).First(); Employee _employee = db.Employees.Where(e => e.Id == Employee).First(); Sale sale = new Sale(); sale.Customer = _customer; sale.Employee = _employee; sale.Date = DateTime.Now; sale.SubTotal = 0.00M; sale.Discount = 0.00M; sale.Tax = 0.00M; sale.Total = 0.00M; db.Sales.Add(sale); db.SaveChanges(); return(RedirectToAction("Edit", new { id = sale.Id })); }