public void F_DataContext_Should_Read_Data_With_One_Field_And_Insert_A_Data_With_Some_Parameters_Types()
{
using (var context = new DataContext())
{
var selectParameters = new { Name = "Lotus" };
var manufacturer = context.First <Manufacturer>("SELECT TheId FROM Le_Manufacturer WHERE Name = @Name", selectParameters);
var insertParameters = new Car
{
Name = "Esprit Turbo",
ModelYear = 1981,
Mileage = 318.19850801,
ManufacturerId = manufacturer.TheId,
Category = CarCategory.Sport
};
context.Execute("INSERT INTO Car VALUES (@Name, @ModelYear, @CreatedAt, @Chassis, @Mileage, @Category, @ManufacturerId)", insertParameters);
var car = context.First <Car>("SELECT TOP 1 * FROM Car");
context.Commit();
car.Id.Should().BeGreaterThan(0);
car.Name.Should().Be("Esprit Turbo");
car.ModelYear.Should().Be(1981);
car.Mileage.Should().Be(318.19850801);
car.ManufacturerId.Should().Be(manufacturer.TheId);
car.CreatedAt.Date.Should().Be(DateTime.Today.Date);
car.Category.Should().Be(CarCategory.Sport);
}
}
public void S_DataObject_Should_CRUD_An_Item_With_Shared_Transactional_Data_Context()
{
using (var context = new DataContext())
{
var dodge = new Manufacturer {
Name = "Dodge", BuildYear = 1900
};
manufacturerDataObject.Insert(dodge, context);
dodge.BuildYear = 1915;
manufacturerDataObject.Update(dodge, context);
var updatedDodge = context.First <Manufacturer>("SELECT TOP 1 * FROM Le_Manufacturer WHERE Name = 'Dodge'");
var m4s = new Car {
Name = "M4S", ModelYear = 1984, Category = CarCategory.Prototype, ManufacturerId = dodge.TheId
};
carDataObject.Insert(m4s, context);
var createdM4s = carDataObject.Select.With(context).First("WHERE Name = 'M4S'");
carDataObject.Delete(m4s, context);
var deletedM4s = carDataObject.Select.With(context).First("WHERE Name = 'M4S'");
updatedDodge.BuildYear.Should().Be(1915);
createdM4s.Should().NotBeNull();
deletedM4s.Should().BeNull();
context.Commit();
}
var createdDodgeOutsiteContext = manufacturerDataObject.Select.First("WHERE Name = 'Dodge'");
createdDodgeOutsiteContext.Should().NotBeNull();
}
public HandleState Update(Guid id, SysCompanyAddModel model)
{
var userCurrent = currentUser.UserID;
try
{
var SysCompanyCurrent = DataContext.First(x => x.Id == id);
SysCompanyCurrent.DatetimeCreated = SysCompanyCurrent.DatetimeCreated;
SysCompanyCurrent.UserCreated = SysCompanyCurrent.UserCreated;
if (SysCompanyCurrent.Code != model.CompanyCode && DataContext.Any(item => item.Code == model.CompanyCode))
{
return(new HandleState("Code existed"));
}
SysCompanyCurrent.DatetimeModified = DateTime.Now;
SysCompanyCurrent.UserModified = userCurrent;
SysCompanyCurrent.LogoPath = model.PhotoUrl;
SysCompanyCurrent.Active = model.Status;
SysCompanyCurrent.Code = model.CompanyCode;
SysCompanyCurrent.Website = model.Website;
SysCompanyCurrent.BunameAbbr = model.CompanyNameAbbr;
SysCompanyCurrent.BunameEn = model.CompanyNameEn;
SysCompanyCurrent.BunameVn = model.CompanyNameVn;
DataContext.Update(SysCompanyCurrent, x => x.Id == id);
var hs = new HandleState();
return(hs);
}
catch (Exception ex)
{
var hs = new HandleState(ex.Message);
return(hs);
}
}
public void J_DataContext_Reader_First_Should_Return_A_Null_Object_When_Query_Do_Not_Found_Items()
{
using (var context = new DataContext())
{
var car = context.First <Car>("SELECT * FROM Car WHERE Name = 'Fusca'");
car.Should().BeNull();
}
}
public void H_DataContext_Reader_Should_Translate_DBNull_To_Null_Value()
{
using (var context = new DataContext())
{
context.Execute("UPDATE Car SET Name = NULL WHERE Name = 'Esprit Turbo'");
var car = context.First <Car>("SELECT * FROM Car WHERE Name IS NULL");
car.Name.Should().BeNull();
}
}
public HandleState AddMultipleStage(List <OpsStageAssignedEditModel> models, Guid jobId)
{
var result = new HandleState();
var stagesByJob = DataContext.Get(x => x.JobId == jobId);
var listToDelete = stagesByJob.Where(x => !models.Any(model => model.Id == x.Id));
if (listToDelete.Count() > 0)
{
ChangeTrackerHelper.currentUser = currentUser.UserID;
var list = mapper.Map <List <OpsStageAssigned> >(listToDelete);
foreach (var item in list)
{
DataContext.Delete(x => x.Id == item.Id, false);
}
}
foreach (var item in models)
{
if (item.Id == Guid.Empty)
{
var assignedItem = mapper.Map <OpsStageAssigned>(item);
assignedItem.Id = Guid.NewGuid();
assignedItem.JobId = jobId;
assignedItem.Deadline = item.Deadline ?? null;
assignedItem.Status = OperationConstants.InSchedule;
assignedItem.DatetimeCreated = assignedItem.DatetimeModified = DateTime.Now;
assignedItem.UserCreated = currentUser.UserID;
DataContext.Add(assignedItem, false);
}
else
{
var assignedToUpdate = DataContext.First(x => x.Id == item.Id);
assignedToUpdate.UserModified = currentUser.UserID;
assignedToUpdate.DatetimeModified = DateTime.Now;
assignedToUpdate.OrderNumberProcessed = item.OrderNumberProcessed;
DataContext.Update(assignedToUpdate, x => x.Id == assignedToUpdate.Id, false);
}
}
try
{
DataContext.SubmitChanges();
}
catch (Exception ex)
{
result = new HandleState(ex.Message);
}
return(result);
}
public void C_DataContext_Non_Transitional_Should_Execute_A_Insert_SQL_Command_With_Object_Parameters_And_Read_Created_Data_In_Same_And_Count_Data()
{
using (var context = new DataContext(Transaction.No))
{
var insertParameters = new Manufacturer {
Name = "General Motors", BuildYear = 1908
};
context.Execute("INSERT INTO Le_Manufacturer VALUES (@Name, @BuildYear)", insertParameters);
var manufacturer = context.First <Manufacturer>("SELECT * FROM Le_Manufacturer WHERE BuildYear = 1908");
var manufacturerCount = context.GetValue <int>("SELECT COUNT(TheId) FROM Le_Manufacturer");
manufacturer.TheId.Should().BeGreaterThan(0);
manufacturer.Name.Should().Be("General Motors");
manufacturer.BuildYear.Should().Be(1908);
manufacturerCount.Should().Be(3);
}
}
public CatPlaceModel GetDetail(Guid id)
{
ICurrentUser _user = null;
CatPlace data = DataContext.First(x => x.Id == id);
if (data == null)
{
return(null);
}
CatPlaceModel result = mapper.Map <CatPlaceModel>(data);
if (data.PlaceTypeId == CatPlaceTypeEnum.Warehouse.ToString())
{
_user = PermissionExtention.GetUserMenuPermission(currentUser, Menu.catWarehouse);
}
if (data.PlaceTypeId == CatPlaceTypeEnum.Port.ToString())
{
_user = PermissionExtention.GetUserMenuPermission(currentUser, Menu.catPortindex);
}
if (data.PlaceTypeId == CatPlaceTypeEnum.Province.ToString() ||
data.PlaceTypeId == CatPlaceTypeEnum.District.ToString() ||
data.PlaceTypeId == CatPlaceTypeEnum.Ward.ToString())
{
_user = PermissionExtention.GetUserMenuPermission(currentUser, Menu.catLocation);
}
var permissionRangeWrite = PermissionExtention.GetPermissionRange(currentUser.UserMenuPermission.Write);
BaseUpdateModel baseModel = new BaseUpdateModel
{
UserCreated = result.UserCreated,
CompanyId = result.CompanyId,
DepartmentId = result.DepartmentId,
OfficeId = result.OfficeId,
GroupId = result.GroupId
};
result.Permission = new PermissionAllowBase
{
AllowUpdate = PermissionExtention.GetPermissionDetail(permissionRangeWrite, baseModel, currentUser),
};
return(result);
}
public void M_DataObject_Should_Insert_Item_From_Database_And_Set_Primery_Key()
{
var car = new Car {
Name = "Aventador", ModelYear = 2011, Category = CarCategory.Sport
};
carDataObject.Insert(car);
car.Id.Should().BeGreaterThan(0);
using (var context = new DataContext())
{
var query = "SELECT TOP 1 * FROM Car WHERE Name = 'Aventador'";
var createdManufacturer = context.First <Car>(query);
createdManufacturer.Should().NotBeNull();
}
}
public void E_DataContext_Transitional_Should_Execute_A_SQL_And_Share_Transaction_With_A_Data_Reader()
{
using (var context = new DataContext())
{
var insertParameters = new { Name = "BMW", Year = 1916 };
context.Execute("INSERT INTO Le_Manufacturer VALUES (@Name, @Year)", insertParameters);
var selectParameters = new { Name = "BMW" };
var manufacturer = context.First <Manufacturer>("SELECT * FROM Le_Manufacturer WHERE Name = @Name", selectParameters);
manufacturer.Should().NotBeNull();
}
using (var context = new DataContext())
{
var selectParameters = new { Name = "BMW" };
var manufacturer = context.First <Manufacturer>("SELECT * FROM Le_Manufacturer WHERE Name = @Name", selectParameters);
manufacturer.Should().BeNull();
}
}
public void B_DataContext_Transitional_Should_Execute_A_Insert_SQL_Command_With_Array_Parameters_And_Read_Created_Data_In_Same_And_Count_Data_In_Another_Context()
{
using (var context = new DataContext())
{
context.Execute("INSERT INTO Le_Manufacturer VALUES (@0, @1)", "McLaren", 1963);
var manufacturer = context.First<Manufacturer>("SELECT TOP 1 * FROM Le_Manufacturer WHERE Name = @0", "McLaren");
context.Commit();
manufacturer.TheId.Should().BeGreaterThan(0);
manufacturer.Name.Should().Be("McLaren");
manufacturer.BuildYear.Should().Be(1963);
}
using (var context = new DataContext())
{
var manufacturerCount = context.GetValue<int>("SELECT COUNT(TheId) FROM Le_Manufacturer");
manufacturerCount.Should().Be(2);
}
}
public void B_DataContext_Transitional_Should_Execute_A_Insert_SQL_Command_With_Array_Parameters_And_Read_Created_Data_In_Same_And_Count_Data_In_Another_Context()
{
using (var context = new DataContext())
{
context.Execute("INSERT INTO Le_Manufacturer VALUES (@0, @1)", "McLaren", 1963);
var manufacturer = context.First <Manufacturer>("SELECT TOP 1 * FROM Le_Manufacturer WHERE Name = @0", "McLaren");
context.Commit();
manufacturer.TheId.Should().BeGreaterThan(0);
manufacturer.Name.Should().Be("McLaren");
manufacturer.BuildYear.Should().Be(1963);
}
using (var context = new DataContext())
{
var manufacturerCount = context.GetValue <int>("SELECT COUNT(TheId) FROM Le_Manufacturer");
manufacturerCount.Should().Be(2);
}
}
public void A_DataContext_Transitional_Should_Execute_A_Insert_SQL_Command_With_Anonymous_Object_Parameters_And_Read_Created_Data_In_Same_And_Count_Data_In_Another_Context()
{
using (var context = new DataContext())
{
var insertParameters = new { Name = "Lotus", Year = 1952 };
context.Execute("INSERT INTO Le_Manufacturer VALUES (@Name, @Year)", insertParameters);
var manufacturer = context.First<Manufacturer>("SELECT TOP 1 * FROM Le_Manufacturer");
context.Commit();
manufacturer.TheId.Should().BeGreaterThan(0);
manufacturer.Name.Should().Be("Lotus");
manufacturer.BuildYear.Should().Be(1952);
}
using (var context = new DataContext())
{
var manufacturerCount = context.GetValue<int>("SELECT COUNT(TheId) FROM Le_Manufacturer");
manufacturerCount.Should().Be(1);
}
}
public void A_DataContext_Transitional_Should_Execute_A_Insert_SQL_Command_With_Anonymous_Object_Parameters_And_Read_Created_Data_In_Same_And_Count_Data_In_Another_Context()
{
using (var context = new DataContext())
{
var insertParameters = new { Name = "Lotus", Year = 1952 };
context.Execute("INSERT INTO Le_Manufacturer VALUES (@Name, @Year)", insertParameters);
var manufacturer = context.First <Manufacturer>("SELECT TOP 1 * FROM Le_Manufacturer");
context.Commit();
manufacturer.TheId.Should().BeGreaterThan(0);
manufacturer.Name.Should().Be("Lotus");
manufacturer.BuildYear.Should().Be(1952);
}
using (var context = new DataContext())
{
var manufacturerCount = context.GetValue <int>("SELECT COUNT(TheId) FROM Le_Manufacturer");
manufacturerCount.Should().Be(1);
}
}
public OpsStageAssignedModel GetBy(Guid id)
{
var data = DataContext.First(x => x.Id == id);
if (data == null)
{
return(null);
}
var stages = catStageApi.GetAll().Result;
var departments = catDepartmentApi.GetAll().Result;
var result = mapper.Map <OpsStageAssignedModel>(data);
if (stages != null)
{
var stage = stages?.FirstOrDefault(x => x.Id == result.StageId);
result.StageCode = stages.FirstOrDefault(x => x.Id == result.StageId).Code;
result.StageNameEN = stages.FirstOrDefault(x => x.Id == result.StageId).StageNameEn;
result.DepartmentName = departments?.FirstOrDefault(x => x.Id == stage.DepartmentId)?.DeptName;
result.Description = result.Description != null ? result.Description : stages.FirstOrDefault(x => x.Id == result.StageId).DescriptionEn;
}
return(result);
}
public void C_DataContext_Non_Transitional_Should_Execute_A_Insert_SQL_Command_With_Object_Parameters_And_Read_Created_Data_In_Same_And_Count_Data()
{
using (var context = new DataContext(Transaction.No))
{
var insertParameters = new Manufacturer { Name = "General Motors", BuildYear = 1908 };
context.Execute("INSERT INTO Le_Manufacturer VALUES (@Name, @BuildYear)", insertParameters);
var manufacturer = context.First<Manufacturer>("SELECT * FROM Le_Manufacturer WHERE BuildYear = 1908");
var manufacturerCount = context.GetValue<int>("SELECT COUNT(TheId) FROM Le_Manufacturer");
manufacturer.TheId.Should().BeGreaterThan(0);
manufacturer.Name.Should().Be("General Motors");
manufacturer.BuildYear.Should().Be(1908);
manufacturerCount.Should().Be(3);
}
}
public void S_DataObject_Should_CRUD_An_Item_With_Shared_Transactional_Data_Context()
{
using (var context = new DataContext())
{
var dodge = new Manufacturer { Name = "Dodge", BuildYear = 1900 };
manufacturerDataObject.Insert(dodge, context);
dodge.BuildYear = 1915;
manufacturerDataObject.Update(dodge, context);
var updatedDodge = context.First<Manufacturer>("SELECT TOP 1 * FROM Le_Manufacturer WHERE Name = 'Dodge'");
var m4s = new Car { Name = "M4S", ModelYear = 1984, Category = CarCategory.Prototype, ManufacturerId = dodge.TheId };
carDataObject.Insert(m4s, context);
var createdM4s = carDataObject.Select.With(context).First("WHERE Name = 'M4S'");
carDataObject.Delete(m4s, context);
var deletedM4s = carDataObject.Select.With(context).First("WHERE Name = 'M4S'");
updatedDodge.BuildYear.Should().Be(1915);
createdM4s.Should().NotBeNull();
deletedM4s.Should().BeNull();
context.Commit();
}
var createdDodgeOutsiteContext = manufacturerDataObject.Select.First("WHERE Name = 'Dodge'");
createdDodgeOutsiteContext.Should().NotBeNull();
}
public void M_DataObject_Should_Insert_Item_From_Database_And_Set_Primery_Key()
{
var car = new Car { Name = "Aventador", ModelYear = 2011, Category = CarCategory.Sport };
carDataObject.Insert(car);
car.Id.Should().BeGreaterThan(0);
using (var context = new DataContext())
{
var query = "SELECT TOP 1 * FROM Car WHERE Name = 'Aventador'";
var createdManufacturer = context.First<Car>(query);
createdManufacturer.Should().NotBeNull();
}
}
public void J_DataContext_Reader_First_Should_Return_A_Null_Object_When_Query_Do_Not_Found_Items()
{
using (var context = new DataContext())
{
var car = context.First<Car>("SELECT * FROM Car WHERE Name = 'Fusca'");
car.Should().BeNull();
}
}
public void H_DataContext_Reader_Should_Translate_DBNull_To_Null_Value()
{
using (var context = new DataContext())
{
context.Execute("UPDATE Car SET Name = NULL WHERE Name = 'Esprit Turbo'");
var car = context.First<Car>("SELECT * FROM Car WHERE Name IS NULL");
car.Name.Should().BeNull();
}
}
public void F_DataContext_Should_Read_Data_With_One_Field_And_Insert_A_Data_With_Some_Parameters_Types()
{
using (var context = new DataContext())
{
var selectParameters = new { Name = "Lotus" };
var manufacturer = context.First<Manufacturer>("SELECT TheId FROM Le_Manufacturer WHERE Name = @Name", selectParameters);
var insertParameters = new Car
{
Name = "Esprit Turbo",
ModelYear = 1981,
Mileage = 318.19850801,
ManufacturerId = manufacturer.TheId,
Category = CarCategory.Sport
};
context.Execute("INSERT INTO Car VALUES (@Name, @ModelYear, @CreatedAt, @Chassis, @Mileage, @Category, @ManufacturerId)", insertParameters);
var car = context.First<Car>("SELECT TOP 1 * FROM Car");
context.Commit();
car.Id.Should().BeGreaterThan(0);
car.Name.Should().Be("Esprit Turbo");
car.ModelYear.Should().Be(1981);
car.Mileage.Should().Be(318.19850801);
car.ManufacturerId.Should().Be(manufacturer.TheId);
car.CreatedAt.Date.Should().Be(DateTime.Today.Date);
car.Category.Should().Be(CarCategory.Sport);
}
}
public void E_DataContext_Transitional_Should_Execute_A_SQL_And_Share_Transaction_With_A_Data_Reader()
{
using (var context = new DataContext())
{
var insertParameters = new { Name = "BMW", Year = 1916 };
context.Execute("INSERT INTO Le_Manufacturer VALUES (@Name, @Year)", insertParameters);
var selectParameters = new { Name = "BMW" };
var manufacturer = context.First<Manufacturer>("SELECT * FROM Le_Manufacturer WHERE Name = @Name", selectParameters);
manufacturer.Should().NotBeNull();
}
using (var context = new DataContext())
{
var selectParameters = new { Name = "BMW" };
var manufacturer = context.First<Manufacturer>("SELECT * FROM Le_Manufacturer WHERE Name = @Name", selectParameters);
manufacturer.Should().BeNull();
}
}
