public IActionResult Post([FromBody] Lesson item)
{
var result = _context.Lessons.Add(item);
_context.SaveChanges();
return(Ok(result.Entity));
}
private void InitialiseDatabase()
{
var systemAccount = new Account
{
AccountId = Guid.Parse("35c38df0-a959-4232-aadd-40db2260f557"),
AddedByAccountId = null,
AddedOnUtc = DateTime.UtcNow,
ModifiedByAccountId = null,
ModifiedOnUtc = DateTime.UtcNow
};
var otherAccounts = new List <Account>
{
new Account
{
AccountId = Guid.Parse("015b76fc-2833-45d9-85a7-ab1c389c1c11"),
AddedByAccountId = Guid.Parse("35c38df0-a959-4232-aadd-40db2260f557"),
AddedOnUtc = DateTime.UtcNow,
ModifiedByAccountId = Guid.Parse("35c38df0-a959-4232-aadd-40db2260f557"),
ModifiedOnUtc = DateTime.UtcNow
},
new Account
{
AccountId = Guid.Parse("538ee0dd-531a-41c6-8414-0769ec5990d8"),
AddedByAccountId = Guid.Parse("35c38df0-a959-4232-aadd-40db2260f557"),
AddedOnUtc = DateTime.UtcNow,
ModifiedByAccountId = Guid.Parse("35c38df0-a959-4232-aadd-40db2260f557"),
ModifiedOnUtc = DateTime.UtcNow
},
new Account
{
AccountId = Guid.Parse("8288d9ac-fbce-417e-89ef-82266b284b78"),
AddedByAccountId = Guid.Parse("35c38df0-a959-4232-aadd-40db2260f557"),
AddedOnUtc = DateTime.UtcNow,
ModifiedByAccountId = Guid.Parse("35c38df0-a959-4232-aadd-40db2260f557"),
ModifiedOnUtc = DateTime.UtcNow
},
new Account
{
AccountId = Guid.Parse("4bcfe9f8-e4a5-49f0-b6ee-44871632a903"),
AddedByAccountId = Guid.Parse("35c38df0-a959-4232-aadd-40db2260f557"),
AddedOnUtc = DateTime.UtcNow,
ModifiedByAccountId = Guid.Parse("35c38df0-a959-4232-aadd-40db2260f557"),
ModifiedOnUtc = DateTime.UtcNow
}
};
_dbContext.Add(systemAccount);
_dbContext.AddRange(otherAccounts);
try
{
_dbContext.SaveChanges();
}
catch (Exception ex)
{
// Just checking to see if anything was being raised.
}
}
public void InserMany <T>(IEnumerable <T> entities)
where T : class
{
using (var context = new EntityFrameworkDbContext()) {
context.Set <T>().AddRange(entities);
context.SaveChanges();
}
}
public TEntity Add(TEntity entity)
{
entity.Created = DateTime.UtcNow;
TEntity addedEntity = DbSet.Add(entity);
EntityFrameworkDbContext.SaveChanges();
return(addedEntity);
}
public void InsertOne <T>(T entity)
where T : class
{
using (var context = new EntityFrameworkDbContext()) {
context.Set <T>().Add(entity);
context.SaveChanges();
}
}
public virtual void Update(TEntity entity, bool save = true)
{
DbSet.Attach(entity);
EntityFrameworkDbContext.Entry(entity).State = EntityState.Modified;
if (save)
{
EntityFrameworkDbContext.SaveChanges();
}
}
private static void CreateFtpUsers(int count, string login)
{
using var context = new EntityFrameworkDbContext();
context.FtpUsers.AddRange(Enumerable.Range(0, count).Select(_ => new FtpUser
{
Login = login,
BoxId = Guid.NewGuid().ToString(),
Id = Guid.NewGuid(),
}));
context.SaveChanges();
}
private static UsersTable[] GenerateRandomUsersAndAssertCount(int count)
{
var scopeId = Guid.NewGuid().ToString();
var users = Enumerable.Range(0, count).Select(_ => GetRandomUser(scopeId, $"{Guid.NewGuid()}@gmail.com")).ToArray();
using var context = new EntityFrameworkDbContext();
context.Users.AddRange(users);
context.SaveChanges();
Assert.That(() => GetUserObjectsCount(scopeId, count), Is.EqualTo(count).After(180000, 1000));
return(users);
}
public IActionResult Delete(string date, string time, string lecturer, string status,
int id = 0)
{
if (status == "Add")
{
var lesson = _context.Lessons.Find(id);
if (lesson != null)
{
_context.Lessons.Remove(lesson);
_context.SaveChanges();
return(RedirectToAction("Index"));
}
return(RedirectToAction("Index"));
}
_context.Lessons.Add(new Lesson
{
Date = date,
BeginLesson = time,
Lecturer = lecturer,
Status = "Delete"
});
_context.SaveChanges();
return(RedirectToAction("Index"));
}
public UserInfoResponseModel UserRegister(UserInfoRequestModel request)
{
UserInfoResponseModel response = new UserInfoResponseModel();
UserInfoResponseModel userData = new UserInfoResponseModel()
{
UserName = request.UserName, UserNO = request.UserNO, PassWord = request.PassWord
};
db.UserInfo.Add(userData);
int result = db.SaveChanges();
if (result == 1)
{
response.UserNO = request.UserNO;
}
return(response);
}
private FtpUser CreateFtpUser()
{
using var context = new EntityFrameworkDbContext();
var userId = Guid.NewGuid();
var ftpUser = new FtpUser
{
Login = Guid.NewGuid().ToString(),
BoxId = Guid.NewGuid().ToString(),
Id = userId,
};
context.FtpUsers.Add(ftpUser);
context.SaveChanges();
Assert.That(GetFtpUser(userId), Is.Not.Null, "Failed to create ftp user");
return(ftpUser);
}
public void TestAllowSort()
{
using (var context = new EntityFrameworkDbContext())
{
var serializer = new Serializer(new AllPropertiesExtractor());
var customer = new Customer {
Age = 1, Name = "13"
};
context.Tests.Add(new TestTable
{
Id = 1,
CompositeKey = Guid.NewGuid().ToString(),
String = "123",
Customer = customer,
CustomerSerialized = serializer.Serialize(customer),
});
context.Users.Add(new UsersTable
{
Email = "123",
Id = Guid.NewGuid(),
Patronymic = "1",
Surname = "2",
FirstName = "3",
ScopeId = "scopeId",
});
context.SaveChanges();
}
using var browser = new BrowserForTests();
var usersPage = browser.LoginAsSuperUser().SwitchTo <BusinessObjectTablePage>("UsersTable");
usersPage = browser.RefreshUntil(usersPage, x => x.BusinessObjectItems.IsPresent.Get());
usersPage.TableHeader.WaitPresence();
usersPage.TableHeader.SortByColumn("Header_Id");
var largeObjectPage = browser.SwitchTo <BusinessObjectTablePage>("TestTable");
largeObjectPage = browser.RefreshUntil(largeObjectPage, x => x.BusinessObjectItems.IsPresent.Get());
largeObjectPage.TableHeader.WaitPresence();
largeObjectPage.TableHeader.WaitNotSortable("Header_Index");
largeObjectPage.TableHeader.WaitNotSortable("Header_String");
largeObjectPage.TableHeader.WaitNotSortable("Header_DateTime");
}
private static void CreateUsers(int count, string scopeId, Guid?id = null)
{
if (count > 1 && id != null)
{
throw new InvalidOperationException();
}
using var context = new EntityFrameworkDbContext();
context.Users.AddRange(Enumerable.Range(0, count).Select(_ => new UsersTable
{
Id = id ?? Guid.NewGuid(),
ScopeId = scopeId,
Email = "*****@*****.**",
FirstName = "1",
Surname = "2",
Patronymic = "3",
}));
context.SaveChanges();
}
public int UpdatePricesInMainCurrency()
{
Currency mainCurrency = EntityFrameworkDbContext.Currencies.SingleOrDefault(x => !x.IsDeleted && x.IsMain);
if (mainCurrency == null)
{
throw new ArgumentNullException("There is no main currency in the system!");
}
var productsWithCurrencyRate = from product in DbSet
join cr in
(from currencyRate in EntityFrameworkDbContext.CurrencyRates
where currencyRate.DateOfRate ==
(from currencyRate1 in EntityFrameworkDbContext.CurrencyRates select currencyRate1).Max(currencyRate1 => currencyRate1.DateOfRate)
select currencyRate) on product.CurrencyIdOfThePrice equals cr.CurrencyId
select new { Product = product, CurrencyRate = cr };
productsWithCurrencyRate.ToList().ForEach(x =>
{
x.Product.PriceInTheMainCurrency = x.Product.Price * x.CurrencyRate.Rate;
Update(x.Product, false);
});
return(EntityFrameworkDbContext.SaveChanges());
}
public int UserInfoUpdate(UserInfoRequestModel request)
{
EntityFrameworkDbContext _db = new EntityFrameworkDbContext();
//修改需要对主键赋值，注意：这里需要对所有字段赋值，没有赋值的字段会用NULL更新到数据库
var user = new UserInfoResponseModel
{
UID = request.UID,
UserNO = request.UserNO,
UserName = request.UserName,
UserEmail = request.UserEmail,
PassWord = request.NewPassWord
};
//将实体附加到对象管理器中
_db.UserInfo.Attach(user);
//获取到状态实体，可以修改其状态
var setEntry = ((IObjectContextAdapter)_db).ObjectContext.ObjectStateManager.GetObjectStateEntry(user);
//只修改实体属性
setEntry.SetModifiedProperty("PassWord");
return(_db.SaveChanges());
}
public virtual void Delete(params TEntity[] entities)
{
DbSet.RemoveRange(entities);
EntityFrameworkDbContext.SaveChanges();
}
private static void CreateSqlDocument(DocumentModel documentModel)
{
using var context = new EntityFrameworkDbContext();
context.Documents.Add(documentModel.ToSqlDocument());
context.SaveChanges();
}
public void SaveChanges()
{
_dbContext.SaveChanges();
}
public int SaveChanges(bool acceptAllChangesOnSuccess = true)
{
return(_context.SaveChanges(acceptAllChangesOnSuccess));
}
