public IActionResult Add(ViewModel assign)
{
Assignment assignment = assign.Assignment;
if (assign.SelectedTags != null)
{
int id = assign.SelectedTags.ElementAt(0);
for (int i = 0; i < assign.SelectedTags.Count(); i++)
{
AssignmentTag assignmentTag = new AssignmentTag {
Assignment = assignment,
AssignmentId = assign.Assignment.Id,
Tag = _context.Tags.Single(n => n.Id == assign.SelectedTags.ElementAt(i)),
TagId = assign.SelectedTags.ElementAt(i)
};
_context.AssignmentTags.Add(assignmentTag);
}
}
_context.Add(assignment);
_context.SaveChanges();
return(RedirectToAction("Index"));
}
public async Task <IActionResult> Create(AssignmentItem model)
{
if (ModelState.IsValid)
{
_db.Add(model);
_db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(model));
}
public ActionResult Create([Bind(Include = "Id,Name,Address")] Manufacturer manufacturer)
{
if (ModelState.IsValid)
{
db.Manufacturers.Add(manufacturer);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(manufacturer));
}
private void CreateEditions()
{
var defaultEdition = _context.Editions.IgnoreQueryFilters().FirstOrDefault(e => e.Name == EditionManager.DefaultEditionName);
if (defaultEdition == null)
{
defaultEdition = new Edition {
Name = EditionManager.DefaultEditionName, DisplayName = EditionManager.DefaultEditionName
};
_context.Editions.Add(defaultEdition);
_context.SaveChanges();
/* Add desired features to the standard edition, if wanted... */
}
}
public static void MockCustomer(AssignmentDbContext assignmentDbContext)
{
var customer1 = new Customer()
{
Name = "Customer1",
Email = "*****@*****.**",
Phone = 71234568,
CreateDate = DateTime.Now,
UpdateDate = DateTime.Now
};
var customer2 = new Customer()
{
Name = "Customer2",
Email = "*****@*****.**",
Phone = 234567189,
CreateDate = DateTime.Now,
UpdateDate = DateTime.Now
};
var customer3 = new Customer()
{
Name = "Customer3",
Email = "*****@*****.**",
Phone = 1239874,
CreateDate = DateTime.Now,
UpdateDate = DateTime.Now
};
assignmentDbContext.Add(customer1);
assignmentDbContext.Add(customer2);
assignmentDbContext.Add(customer3);
assignmentDbContext.SaveChanges();
}
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();
}
public ActionResult Create(FormCollection formCollection)
{
var name = formCollection.Get("Name");
var quantity = int.Parse(formCollection.Get("Quantity"));
var price = float.Parse(formCollection.Get("Price"));
var year = int.Parse(formCollection.Get("Year"));
var newProduct = new Product
{
Name = name,
Quantity = quantity,
Price = price,
Year = year
};
dbContext.Products.Add(newProduct);
dbContext.SaveChanges();
return(RedirectToAction("Index"));
}
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 Create()
{
new DefaultEditionCreator(_context).Create();
new DefaultLanguagesCreator(_context).Create();
new HostRoleAndUserCreator(_context).Create();
new DefaultSettingsCreator(_context).Create();
new DefaultCowsSensorsCreator(_context).Create();
_context.SaveChanges();
}
private void CreateCows()
{
var cows = _context.Cows.Count();
Random rnd = new Random();
var farms = new string[] { "A", "B", "C" };
var states = new string[] { "Open", "Inseminated", "Pregnant", "Dry" };
if (cows <= 0)
{
for (int i = 0; i < 100; i++)
{
_context.Cows.Add(new Cows.Cow
{
FarmId = farms[rnd.Next(farms.Length)],
State = states[rnd.Next(states.Length)]
});
}
_context.SaveChanges();
}
}
public ActionResult Create(MarkupPlan model)
{
if (string.IsNullOrWhiteSpace(model.Name))
{
ModelState.AddModelError("", "Name Required");
return(View(model));
}
try
{
_context.MarkupPlan.Add(model);
_context.SaveChanges();
return(RedirectToAction(nameof(Index)));
}
catch (Exception e)
{
ModelState.AddModelError("", e.Message);
return(View(model));
}
}
private void CreateDefaultTenant()
{
// Default tenant
var defaultTenant = _context.Tenants.IgnoreQueryFilters().FirstOrDefault(t => t.TenancyName == AbpTenantBase.DefaultTenantName);
if (defaultTenant == null)
{
defaultTenant = new Tenant(AbpTenantBase.DefaultTenantName, AbpTenantBase.DefaultTenantName);
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 void CreateHostRoleAndUsers()
{
// Admin role for host
var adminRoleForHost = _context.Roles.IgnoreQueryFilters().FirstOrDefault(r => r.TenantId == null && r.Name == StaticRoleNames.Host.Admin);
if (adminRoleForHost == null)
{
adminRoleForHost = _context.Roles.Add(new Role(null, StaticRoleNames.Host.Admin, StaticRoleNames.Host.Admin)
{
IsStatic = true, IsDefault = true
}).Entity;
_context.SaveChanges();
}
// Grant all permissions to admin role for host
var grantedPermissions = _context.Permissions.IgnoreQueryFilters()
.OfType <RolePermissionSetting>()
.Where(p => p.TenantId == null && p.RoleId == adminRoleForHost.Id)
.Select(p => p.Name)
.ToList();
var permissions = PermissionFinder
.GetAllPermissions(new AssignmentAuthorizationProvider())
.Where(p => p.MultiTenancySides.HasFlag(MultiTenancySides.Host) &&
!grantedPermissions.Contains(p.Name))
.ToList();
if (permissions.Any())
{
_context.Permissions.AddRange(
permissions.Select(permission => new RolePermissionSetting
{
TenantId = null,
Name = permission.Name,
IsGranted = true,
RoleId = adminRoleForHost.Id
})
);
_context.SaveChanges();
}
// Admin user for host
var adminUserForHost = _context.Users.IgnoreQueryFilters().FirstOrDefault(u => u.TenantId == null && u.UserName == AbpUserBase.AdminUserName);
if (adminUserForHost == null)
{
var user = new User
{
TenantId = null,
UserName = AbpUserBase.AdminUserName,
Name = "admin",
Surname = "admin",
EmailAddress = "*****@*****.**",
IsEmailConfirmed = true,
IsActive = true
};
user.Password = new PasswordHasher <User>(new OptionsWrapper <PasswordHasherOptions>(new PasswordHasherOptions())).HashPassword(user, "123qwe");
user.SetNormalizedNames();
adminUserForHost = _context.Users.Add(user).Entity;
_context.SaveChanges();
// Assign Admin role to admin user
_context.UserRoles.Add(new UserRole(null, adminUserForHost.Id, adminRoleForHost.Id));
_context.SaveChanges();
_context.SaveChanges();
}
}
private void CreateRolesAndUsers()
{
// Admin role
var adminRole = _context.Roles.IgnoreQueryFilters().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
}).Entity;
_context.SaveChanges();
}
// Grant all permissions to admin role
var grantedPermissions = _context.Permissions.IgnoreQueryFilters()
.OfType <RolePermissionSetting>()
.Where(p => p.TenantId == _tenantId && p.RoleId == adminRole.Id)
.Select(p => p.Name)
.ToList();
var permissions = PermissionFinder
.GetAllPermissions(new AssignmentAuthorizationProvider())
.Where(p => p.MultiTenancySides.HasFlag(MultiTenancySides.Tenant) &&
!grantedPermissions.Contains(p.Name))
.ToList();
if (permissions.Any())
{
_context.Permissions.AddRange(
permissions.Select(permission => new RolePermissionSetting
{
TenantId = _tenantId,
Name = permission.Name,
IsGranted = true,
RoleId = adminRole.Id
})
);
_context.SaveChanges();
}
// Admin user
var adminUser = _context.Users.IgnoreQueryFilters().FirstOrDefault(u => u.TenantId == _tenantId && u.UserName == AbpUserBase.AdminUserName);
if (adminUser == null)
{
adminUser = User.CreateTenantAdminUser(_tenantId, "*****@*****.**");
adminUser.Password = new PasswordHasher <User>(new OptionsWrapper <PasswordHasherOptions>(new PasswordHasherOptions())).HashPassword(adminUser, "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 static void MockTransaction(AssignmentDbContext assignmentDbContext)
{
var customer = assignmentDbContext.Customers.Select(c => c);
var transaction1OfCustomer1 = new Transaction()
{
Currency = "USD",
Amount = (decimal)39.75,
Status = StatusTransaction.Success,
CustomerId = customer.First().Id,
CreateDate = DateTime.Now,
UpdateDate = DateTime.Now,
Date = DateTime.Now
};
var transaction2OfCustomer1 = new Transaction()
{
Currency = "EUR",
Amount = (decimal)40.17,
Status = StatusTransaction.Canceled,
CustomerId = customer.First().Id,
CreateDate = DateTime.Now,
UpdateDate = DateTime.Now,
Date = DateTime.Now
};
var transaction3OfCustomer1 = new Transaction()
{
Currency = "THB",
Amount = (decimal)150.15,
Status = StatusTransaction.Failed,
CustomerId = customer.First().Id,
CreateDate = DateTime.Now,
UpdateDate = DateTime.Now,
Date = DateTime.Now
};
var transaction1OfCustomer2 = new Transaction()
{
Currency = "JYP",
Amount = (decimal)60,
Status = StatusTransaction.Success,
CustomerId = customer.Last().Id,
CreateDate = DateTime.Now,
UpdateDate = DateTime.Now,
Date = DateTime.Now
};
var transaction2OfCustomer2 = new Transaction()
{
Currency = "GBP",
Amount = (decimal)48.95,
Status = StatusTransaction.Canceled,
CustomerId = customer.Last().Id,
CreateDate = DateTime.Now,
UpdateDate = DateTime.Now,
Date = DateTime.Now
};
var transaction3OfCustomer2 = new Transaction()
{
Currency = "CNY",
Amount = (decimal)7985.07,
Status = StatusTransaction.Failed,
CustomerId = customer.Last().Id,
CreateDate = DateTime.Now,
UpdateDate = DateTime.Now,
Date = DateTime.Now
};
assignmentDbContext.Add(transaction1OfCustomer1);
assignmentDbContext.Add(transaction2OfCustomer1);
assignmentDbContext.Add(transaction3OfCustomer1);
assignmentDbContext.Add(transaction1OfCustomer2);
assignmentDbContext.Add(transaction2OfCustomer2);
assignmentDbContext.Add(transaction3OfCustomer2);
assignmentDbContext.SaveChanges();
}
