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