private static string CreateRandomUsername()
{
var randomUsername = RandomSecureString();
return(DataContext.Get(dataContext => dataContext.SysUsers.Any(user => user.Username.Equals(randomUsername)))
? CreateRandomUsername()
: randomUsername);
}
public IQueryable <CatDepartmentModel> QueryData(CatDepartmentCriteria criteria)
{
var dept = DataContext.Get();
var query = from d in dept
join off in sysOfficeRepo.Get() on d.BranchId equals off.Id into off2
from off in off2.DefaultIfEmpty()
select new CatDepartmentModel
{
Id = d.Id,
Code = d.Code,
DeptName = d.DeptName,
DeptNameEn = d.DeptNameEn,
DeptNameAbbr = d.DeptNameAbbr,
Description = d.Description,
BranchId = d.BranchId,
OfficeName = off.BranchNameEn,
DeptType = d.DeptType,
UserCreated = d.UserCreated,
DatetimeCreated = d.DatetimeCreated,
UserModified = d.UserModified,
DatetimeModified = d.DatetimeModified,
Active = d.Active,
InactiveOn = d.InactiveOn
};
if (criteria.Type == "All" || string.IsNullOrEmpty(criteria.Type))
{
if (!string.IsNullOrEmpty(criteria.Keyword))
{
//Search gần đúng
query = query.Where(x =>
x.Code.IndexOf(criteria.Keyword ?? "", StringComparison.OrdinalIgnoreCase) >= 0 ||
x.DeptName.IndexOf(criteria.Keyword ?? "", StringComparison.OrdinalIgnoreCase) >= 0 ||
x.DeptNameEn.IndexOf(criteria.Keyword ?? "", StringComparison.OrdinalIgnoreCase) >= 0 ||
x.DeptNameAbbr.IndexOf(criteria.Keyword ?? "", StringComparison.OrdinalIgnoreCase) >= 0 ||
x.OfficeName.IndexOf(criteria.Keyword ?? "", StringComparison.OrdinalIgnoreCase) >= 0
);
}
}
else
{
if (!string.IsNullOrEmpty(criteria.Keyword))
{
//Search gần đúng
query = query.Where(x =>
criteria.Type == "Code" ? x.Code.IndexOf(criteria.Keyword ?? "", StringComparison.OrdinalIgnoreCase) >= 0 : true &&
criteria.Type == "DeptName" ? x.DeptName.IndexOf(criteria.Keyword ?? "", StringComparison.OrdinalIgnoreCase) >= 0 : true &&
criteria.Type == "DeptNameEn" ? x.DeptNameEn.IndexOf(criteria.Keyword ?? "", StringComparison.OrdinalIgnoreCase) >= 0 : true &&
criteria.Type == "DeptNameAbbr" ? x.DeptNameAbbr.IndexOf(criteria.Keyword ?? "", StringComparison.OrdinalIgnoreCase) >= 0 : true &&
criteria.Type == "OfficeName" ? x.OfficeName.IndexOf(criteria.Keyword ?? "", StringComparison.OrdinalIgnoreCase) >= 0 : true
);
}
}
var result = query.OrderByDescending(x => x.DatetimeModified);
return(result);
}
public static List <Tag> GetAll()
{
if (allTags == null)
{
var context = DataContext.Get();
allTags = context.Tag.ToList();
}
return(allTags);
}
private void CreateAdmin()
{
var context = DataContext.Get();
//goldenbr0wn
var account = Admin.Create("sativa", "*****@*****.**", "123123123", 1);
context.AddObject(account);
context.SaveChanges();
}
public static void EnsureId(IPrincipal requestUser, Guid guid, string messageIfNotFulfilled)
{
var databaseGuid = DataContext.Get(GetConcreteIdForUser(requestUser));
if (!databaseGuid.Equals(guid))
{
throw GetResponseException(HttpStatusCode.Unauthorized, messageIfNotFulfilled);
}
}
public IQueryable <SysGroupModel> Query(SysGroupCriteria criteria)
{
IQueryable <SysGroup> groups = null;
IQueryable <CatDepartment> departments = null;
if (criteria.All == null)
{
groups = DataContext.Get(x => (x.Code ?? "").IndexOf(criteria.Code ?? "", StringComparison.OrdinalIgnoreCase) > -1 &&
(x.NameEn ?? "").IndexOf(criteria.NameEN ?? "", StringComparison.OrdinalIgnoreCase) > -1 &&
(x.NameVn ?? "").IndexOf(criteria.NameVN ?? "", StringComparison.OrdinalIgnoreCase) > -1 &&
(x.ShortName ?? "").IndexOf(criteria.ShortName ?? "", StringComparison.OrdinalIgnoreCase) > -1 &&
(x.DepartmentId == criteria.DepartmentId || criteria.DepartmentId == 0) &&
(x.Id == criteria.Id || criteria.Id == 0)
);
departments = departmentRepository.Get(x => (x.DeptNameEn ?? "").IndexOf(criteria.DepartmentName ?? "", StringComparison.OrdinalIgnoreCase) > -1);
}
else
{
groups = DataContext.Get(x => (x.Code ?? "").IndexOf(criteria.All ?? "", StringComparison.OrdinalIgnoreCase) > -1 ||
(x.NameEn ?? "").IndexOf(criteria.All ?? "", StringComparison.OrdinalIgnoreCase) > -1 ||
(x.NameVn ?? "").IndexOf(criteria.All ?? "", StringComparison.OrdinalIgnoreCase) > -1 ||
(x.ShortName ?? "").IndexOf(criteria.All ?? "", StringComparison.OrdinalIgnoreCase) > -1
//|| (x.DepartmentId == criteria.DepartmentId || criteria.DepartmentId == 0)
//|| (x.Id == criteria.Id || criteria.Id == 0)
);
departments = departmentRepository.Get(x => (x.DeptNameEn ?? "").IndexOf(criteria.All ?? "", StringComparison.OrdinalIgnoreCase) > -1);
if (departments.Count() == 0)
{
departments = departmentRepository.Get();
}
}
if (groups == null)
{
return(null);
}
groups = groups.Where(x => x.IsSpecial == false || x.IsSpecial == null);
var results = groups.Join(departments, x => x.DepartmentId, y => y.Id, (x, y) => new SysGroupModel
{
Id = x.Id,
Code = x.Code,
NameEn = x.NameEn,
NameVn = x.NameVn,
ShortName = x.ShortName,
DepartmentId = x.DepartmentId,
ParentId = x.ParentId,
ManagerId = x.ManagerId,
UserCreated = x.UserCreated,
UserModified = x.UserModified,
DatetimeCreated = x.DatetimeCreated,
DatetimeModified = x.DatetimeModified,
Active = x.Active,
InactiveOn = x.InactiveOn,
DepartmentName = y.DeptNameEn
}).OrderByDescending(x => x.DatetimeModified);
return(results);
}
public IQueryable <CatPlaceModel> GetByModeOfTran()
{
IQueryable <CatPlace> data = null;
data = DataContext.Get();
var results = data?.Select(x => mapper.Map <CatPlaceModel>(x));
results = results.Where(x => ((x.ModeOfTransport ?? "").IndexOf("INLAND - SEA", StringComparison.OrdinalIgnoreCase) > -1));
return(results);
}
public IQueryable <CatChargeModel> GetBy(string type)
{
var data = DataContext.Get(x => x.Type == type);
if (data == null)
{
return(null);
}
return(data.ProjectTo <CatChargeModel>(mapper.ConfigurationProvider));
}
public CatUnitModel GetDetail(short id)
{
var data = DataContext.Get(x => x.Id == id).FirstOrDefault();
if (data == null)
{
return(null);
}
return(mapper.Map <CatUnitModel>(data));
}
public static SysUser CreateNewSysUser(UserRole userRole)
{
return(new SysUser
{
Username = CreateRandomUsername(),
Password = CreateRandomPassword(),
CreationDate = DateTime.Now,
RoleId = DataContext.Get(dataContext =>
dataContext.SysUserRoles.First(role => role.Name.Equals(userRole.ToString())).Guid)
});
}
public vw_catCurrencyExchangeNewest ConvertRate(DateTime date, string localCurrency, string fromCurrency)
{
DateTime dateString = date.Date;
var data = DataContext.Get(x => x.CurrencyFromId == fromCurrency &&
x.CurrencyToId == localCurrency &&
x.DatetimeCreated.Value.Month == date.Month &&
x.DatetimeCreated.Value.Year == date.Year &&
x.DatetimeCreated.Value.Day == date.Day &&
x.DatetimeModified.Value.Month == date.Month &&
x.DatetimeModified.Value.Year == date.Year &&
x.DatetimeModified.Value.Day == date.Day
).OrderBy(x => x.DatetimeCreated).ThenBy(x => x.DatetimeModified).LastOrDefault();
if (data == null)
{
var newestExchanges = ((eFMSDataContext)DataContext.DC).GetViewData <vw_catCurrencyExchangeNewest>();
var newList = new List <CatCurrencyExchange>();
foreach (var item in newestExchanges)
{
if (item.DatetimeCreated.Value.Date < DateTime.Now.Date)
{
var exchange = new CatCurrencyExchange
{
CurrencyFromId = item.CurrencyFromID,
DatetimeCreated = new DateTime(date.Year, date.Month, date.Day),
DatetimeModified = new DateTime(date.Year, date.Month, date.Day),
UserCreated = "system",
UserModified = "system",
Rate = item.Rate,
Active = true,
CurrencyToId = item.CurrencyToID
};
newList.Add(exchange);
}
}
if (newList.Count > 0)
{
var hs = DataContext.Add(newList);
if (hs.Success == false)
{
return(null);
}
data = newList.Where(x => x.CurrencyFromId == fromCurrency &&
x.CurrencyToId == localCurrency
).OrderBy(x => x.DatetimeCreated).ThenBy(x => x.DatetimeModified).LastOrDefault();
}
}
return(new vw_catCurrencyExchangeNewest
{
CurrencyFromID = data.CurrencyFromId,
Rate = data.Rate,
DatetimeCreated = data.DatetimeModified ?? data.DatetimeCreated
});
}
public List <SetTariffModel> GetAllTariff()
{
//var clearanceCaching = RedisCacheHelper.GetObject<List<SetTariffModel>>(cache, Templates.CustomDeclaration.NameCaching.ListName);
List <SetTariffModel> setTariffModels = null;
//get from view data
var list = DataContext.Get();
setTariffModels = mapper.Map <List <SetTariffModel> >(list);
//RedisCacheHelper.SetObject(cache, Templates.CustomDeclaration.NameCaching.ListName, customClearances);
return(setTariffModels);
}
public SysAuthorizationModel GetAuthorizationById(int id)
{
var data = new SysAuthorizationModel();
var authoriza = DataContext.Get(x => x.Id == id).FirstOrDefault();
if (authoriza != null)
{
data = mapper.Map <SysAuthorizationModel>(authoriza);
data.ServicesName = GetServiceNameOfAuthorization(data.Services);
}
return(data);
}
public IQueryable <CatStageModel> GetAll()
{
var data = DataContext.Get();
if (data == null)
{
return(null);
}
var results = data.ProjectTo <CatStageModel>(mapper.ConfigurationProvider);
return(results);
}
public List <SysPermissionSampleSpecialViewModel> GetBy(Guid?permissionId)
{
var actionDefaults = specialActionRepository.Get().ToList();
var modules = actionDefaults.GroupBy(x => x.ModuleId);
if (modules == null)
{
return(null);
}
var specialPermissions = DataContext.Get(x => x.PermissionId == permissionId);
var menus = menuRepository.Get().ToList();
List <SysPermissionSampleSpecialViewModel> results = new List <SysPermissionSampleSpecialViewModel>();
foreach (var item in modules)
{
var specialP = new SysPermissionSampleSpecialViewModel();
var module = menus.FirstOrDefault(x => x.Id == item.Key);
specialP.ModuleName = module?.NameEn;
specialP.ModuleID = module?.Id;
specialP.PermissionID = permissionId == null ? Guid.Empty : (Guid)permissionId;
List <SysPermissionSpecialViewModel> sampleSpecials = new List <SysPermissionSpecialViewModel>();
var actions = actionDefaults.Where(x => x.ModuleId == item.Key);
var actionsInMenu = actions.GroupBy(x => x.MenuId);
foreach (var actionInMenu in actionsInMenu)
{
var menu = menus.FirstOrDefault(x => x.Id == actionInMenu.Key);
var perSpecial = new SysPermissionSpecialViewModel
{
MenuId = menu?.Id,
MenuName = menu?.NameEn,
PermissionId = permissionId == null ? Guid.Empty : (Guid)permissionId,
ModuleId = item.Key
};
perSpecial.PermissionSpecialActions = actions.Where(x => x.MenuId == actionInMenu.Key)
.Select(x => new PermissionSpecialAction
{
Id = (short)(specialPermissions.FirstOrDefault(s => s.MenuId == x.MenuId && s.ActionName == x.ActionName) != null ? (short)specialPermissions.FirstOrDefault(s => s.MenuId == x.MenuId && s.ActionName == x.ActionName).Id : 0),
ModuleId = x.ModuleId,
MenuId = x.MenuId,
NameEn = x.NameEn,
NameVn = x.NameVn,
ActionName = x.ActionName,
IsAllow = specialPermissions.FirstOrDefault(s => s.MenuId == x.MenuId && s.ActionName == x.ActionName) != null? specialPermissions.FirstOrDefault(s => s.MenuId == x.MenuId && s.ActionName == x.ActionName).IsAllow: false,
PermissionId = permissionId == null ? Guid.Empty : (Guid)permissionId
}).ToList();
sampleSpecials.Add(perSpecial);
}
specialP.SysPermissionSpecials = sampleSpecials;
results.Add(specialP);
}
return(results);
}
public List <OpsStageAssignedModel> GetByJob(Guid jobId)
{
List <OpsStageAssignedModel> results = null;
var data = DataContext.Get(x => x.JobId == jobId);
if (data == null)
{
return(null);
}
results = MapListToModel(data);
return(results);
}
public List <CatCurrencyExchangeHistory> Paging(CatCurrencyExchangeCriteria criteria, int page, int size, out int rowsCount)
{
var users = userRepository.Get();
var exchanges = DataContext.Get(x => (x.CurrencyToId ?? "").IndexOf(criteria.LocalCurrencyId ?? "", StringComparison.OrdinalIgnoreCase) >= 0 &&
(x.DatetimeCreated >= criteria.FromDate || criteria.FromDate == null) &&
(x.DatetimeCreated <= criteria.ToDate || criteria.ToDate == null) &&
(x.Active == criteria.Active || criteria.Active == null));
var data = (from ex in exchanges
join u in users on ex.UserCreated equals u.Id into grpUsers
from user in grpUsers.DefaultIfEmpty()
select new { ex, user }).OrderByDescending(x => x.ex.DatetimeCreated);
var dateCreateds = data.GroupBy(x => x.ex.DatetimeCreated.Value.Date)
.Select(x => x);
rowsCount = dateCreateds.Count();
if (rowsCount == 0)
{
return(null);
}
if (size > 1)
{
if (page < 1)
{
page = 1;
}
dateCreateds = dateCreateds.Skip((page - 1) * size).Take(size);
}
List <CatCurrencyExchangeHistory> results = new List <CatCurrencyExchangeHistory>();
foreach (var item in dateCreateds)
{
var date = data.Where(x => x.ex.DatetimeCreated.Value.Date == item.Key)
.OrderBy(x => x.ex.DatetimeCreated == item.Key).First();
var userName = "******";
if (date.ex.UserModified != null)
{
if (date.ex.UserModified != "system")
{
userName = date.user?.Username;
}
}
var rate = new CatCurrencyExchangeHistory
{
DatetimeCreated = item.Key,
UserModifield = userName,
LocalCurrency = date.ex.CurrencyToId,
DatetimeUpdated = date.ex.DatetimeModified ?? date.ex.DatetimeCreated
};
results.Add(rate);
}
return(results);
}
public void DeleteTest()
{
DataContext context = this.DataContextWithData();
context.Delete <Customer>(context.Get <Customer>("3"));
Assert.AreEqual(4, context.List <Customer>().Count());
Assert.IsNull(context.List <Customer>().Where <Customer>(customer => customer.CustomerId == "3").FirstOrDefault());
Assert.AreEqual(1, context.List <Order>().Single().OrderId);
Assert.AreEqual(2, context.List <Product>().Count());
Assert.AreEqual(3, context.List <SessionInfo>().Count());
}
public void GetPosts_ReturnsEmptyCollection(string databaseName)
{
// Given
var sut = new DataContext(databaseName);
// When
var result = sut.Get<Post>();
// Then
Assert.Empty(result);
sut.Database.Delete();
sut.Dispose();
}
public void GetPosts_DoesNotReturnNull(string databaseName)
{
// Given
var sut = new DataContext(databaseName);
// When
var result = sut.Get<Post>();
// Then
Assert.NotNull(result);
sut.Database.Delete();
sut.Dispose();
}
public decimal CurrencyExchangeRateConvert(decimal?finalExchangeRate, DateTime?exchangeDate, string currencyFrom, string currencyTo)
{
var exchargeDateSurcharge = exchangeDate == null ? DateTime.Now.Date : exchangeDate.Value.Date;
List <CatCurrencyExchange> currencyExchange = DataContext.Get(x => x.DatetimeCreated.Value.Date == exchargeDateSurcharge).ToList();
decimal _exchangeRateCurrencyTo = GetRateCurrencyExchange(currencyExchange, currencyTo, AccountingConstants.CURRENCY_LOCAL); //Lấy currency Local là m gốc để quy đỗi
decimal _exchangeRateCurrencyFrom = GetRateCurrencyExchange(currencyExchange, currencyFrom, AccountingConstants.CURRENCY_LOCAL); //Lấy currency Local là m gốc để quy đỗi
decimal _exchangeRate = 0;
if (finalExchangeRate != null)
{
if (currencyFrom == currencyTo)
{
_exchangeRate = 1;
}
else if (currencyFrom == AccountingConstants.CURRENCY_LOCAL && currencyTo != AccountingConstants.CURRENCY_LOCAL)
{
_exchangeRate = (finalExchangeRate.Value != 0) ? (1 / finalExchangeRate.Value) : 0;
}
else if (currencyFrom != AccountingConstants.CURRENCY_LOCAL && currencyTo == AccountingConstants.CURRENCY_LOCAL)
{
_exchangeRate = finalExchangeRate.Value;
}
else
{
_exchangeRate = (_exchangeRateCurrencyTo != 0) ? (finalExchangeRate.Value / _exchangeRateCurrencyTo) : 0;
}
}
else
{
if (currencyFrom == currencyTo)
{
_exchangeRate = 1;
}
else if (currencyFrom == AccountingConstants.CURRENCY_LOCAL && currencyTo != AccountingConstants.CURRENCY_LOCAL)
{
_exchangeRate = (_exchangeRateCurrencyTo != 0) ? (1 / _exchangeRateCurrencyTo) : 0;
}
else if (currencyFrom != AccountingConstants.CURRENCY_LOCAL && currencyTo == AccountingConstants.CURRENCY_LOCAL)
{
_exchangeRate = GetRateCurrencyExchange(currencyExchange, currencyFrom, AccountingConstants.CURRENCY_LOCAL);
}
else
{
_exchangeRate = (_exchangeRateCurrencyTo != 0) ? (_exchangeRateCurrencyFrom / _exchangeRateCurrencyTo) : 0;
}
}
return(_exchangeRate);
}
public override HandleState Add(SysGroupModel entity)
{
var item = mapper.Map <SysGroup>(entity);
item.UserCreated = item.UserModified = currentUser.UserID;
item.DatetimeCreated = item.DatetimeModified = DateTime.Now;
var hs = DataContext.Add(item, true);
if (hs.Success)
{
entity.Id = (short)DataContext.Get(x => x.Code == entity.Code)?.FirstOrDefault()?.Id;
}
DataContext.SubmitChanges();
return(hs);
}
public static void RegisterServices(IServiceCollection services)
{
// Service
services.AddScoped <IEquipeService, EquipeService>();
services.AddScoped <ICopaService, CopaService>();
// Repository
services.AddScoped <IEquipeRepository, EquipeRepository>();
//Context
services.AddSingleton(typeof(IContext), new Context());
//UnitOfWork
services.AddSingleton(typeof(IUnitOfWork), new UnitOfWork(DataContext.Get()));
}
public SysPermissionSampleModel GetBy(Guid?id)
{
var data = DataContext.Get(x => x.Id == id).FirstOrDefault();
var result = new SysPermissionSampleModel();
if (data != null)
{
result = mapper.Map <SysPermissionSampleModel>(data);
}
result.SysPermissionSampleGenerals = permissionSampleGeneralService.GetBy(id);
result.SysPermissionSampleSpecials = permissionSampleSpecialService.GetBy(id);
result.NameUserCreated = userRepository.Get(x => x.Id == result.UserCreated).FirstOrDefault()?.Username;
result.NameUserModified = userRepository.Get(x => x.Id == result.UserModified).FirstOrDefault()?.Username;
return(result);
}
public void DeleteCustomer()
{
DataContext context = this.GetDataContext();
Customer c = new Customer {
CustomerId = "XX1",
CompanyName = "Company1",
ContactName = "Contact1",
City = "Seattle",
Country = "USA",
Phone = string.Empty
};
context.Insert <Customer>(c);
c = context.Get <Customer>(c.CustomerId);
Assert.IsNotNull(c);
Assert.AreEqual(92, context.List <Customer>().ToList().Count());
context.Delete <Customer>(c);
c = context.Get <Customer>(c.CustomerId);
Assert.IsNull(c);
Assert.AreEqual(91, context.List <Customer>().ToList().Count());
}
public SysUserViewModel GetUserById(string Id)
{
var user = DataContext.Get(x => x.Id == Id).FirstOrDefault();
if (user == null)
{
return(null);
}
var employee = employeeRepository.Get(x => x.Id == user.EmployeeId).FirstOrDefault();
var result = mapper.Map <SysUserViewModel>(user);
result.EmployeeNameEn = employee?.EmployeeNameEn;
result.EmployeeNameVn = employee?.EmployeeNameVn;
return(result);
}
public async Task <HandleState> DeleteFile(Guid id)
{
var item = DataContext.Get(x => x.Id == id).FirstOrDefault();
if (item == null)
{
return(new HandleState("Not found data"));
}
var result = DataContext.Delete(x => x.Id == id);
if (result.Success)
{
var hs = await ImageHelper.DeleteFile(item.Name, item.ObjectId);
}
return(result);
}
public List <object> ListContOfHB(Guid JobId)
{
var houseBills = detailRepository.Get(x => x.JobId == JobId).ToList();
List <object> returnList = new List <object>();
foreach (var item in houseBills)
{
var conts = DataContext.Get(x => x.Hblid == item.Id).ToList();
foreach (var c in conts)
{
var obj = new { c.ContainerTypeId, c.Quantity, hblid = item.Id };
returnList.Add(obj);
}
}
return(returnList);
}
public IQueryable <SysUserViewModel> GetAll()
{
var users = DataContext.Get(x => x.Active == true);
var employees = employeeRepository.Get();
var data = users.Join(employees, x => x.EmployeeId, y => y.Id, (x, y) => new { x, y });
List <SysUserViewModel> results = new List <SysUserViewModel>();
foreach (var item in data)
{
var model = mapper.Map <SysUserViewModel>(item.x);
model.EmployeeNameEn = item.y.EmployeeNameEn;
model.EmployeeNameVn = item.y.EmployeeNameVn;
results.Add(model);
}
return(results?.OrderBy(x => x.Username).AsQueryable());
}
public CsManifestModel GetById(Guid jobId)
{
var manifests = DataContext.Get(x => x.JobId == jobId);
if (manifests.Count() == 0)
{
return(null);
}
var manifest = manifests.First();
var places = placeRepository.Get(x => x.PlaceTypeId.Contains("port"));
var result = mapper.Map <CsManifestModel>(manifest);
result.PolName = places.FirstOrDefault(x => x.Id == manifest.Pol)?.NameEn;
result.PodName = places.FirstOrDefault(x => x.Id == manifest.Pod)?.NameEn;
return(result);
}
public IQueryable <SysUserLevelModel> GetUsersByType(UserLevelCriteria criteria)
{
var userLevels = DataContext.Get(x => x.Active == true);
var users = userRepository.Get();
var employess = employeeRepository.Get();
var results = userLevels.Join(users, x => x.UserId, y => y.Id, (x, y) => new { User = y, UserLevel = x })
.Join(employess, x => x.User.EmployeeId, y => y.Id, (x, y) => new { User = x, Employee = y })
.Select(x => new SysUserLevelModel
{
Id = x.User.UserLevel.Id,
UserId = x.User.UserLevel.UserId,
UserName = x.User.User.Username,
GroupId = x.User.UserLevel.GroupId,
EmployeeName = x.Employee.EmployeeNameVn,
Active = x.User.UserLevel.Active,
CompanyId = x.User.UserLevel.CompanyId,
OfficeId = x.User.UserLevel.OfficeId,
DepartmentId = x.User.UserLevel.DepartmentId,
DatetimeCreated = x.User.UserLevel.DatetimeCreated,
DatetimeModified = x.User.UserLevel.DatetimeModified,
UserCreated = x.User.UserLevel.UserCreated,
UserModified = x.User.UserLevel.UserModified,
Position = x.User.UserLevel.Position
});
if (criteria.Type == "company")
{
results = results.Where(x => x.CompanyId == criteria.CompanyId);
}
else if (criteria.Type == "office")
{
results = results.Where(x => x.CompanyId == criteria.CompanyId && x.OfficeId == criteria.OfficeId);
}
else if (criteria.Type == "department")
{
results = results.Where(x => x.CompanyId == criteria.CompanyId && x.OfficeId == criteria.OfficeId && x.DepartmentId == criteria.DepartmentId);
}
else if (criteria.Type == "group")
{
results = results.Where(x => x.CompanyId == criteria.CompanyId && x.OfficeId == criteria.OfficeId && x.DepartmentId == criteria.DepartmentId && x.GroupId == criteria.GroupId);
}
else if (criteria.Type == "owner")
{
results = results.Where(x => x.CompanyId == criteria.CompanyId && x.OfficeId == criteria.OfficeId && x.DepartmentId == criteria.DepartmentId && x.GroupId == criteria.GroupId && x.UserId == criteria.UserId);
}
return(results);
}
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 GetPosts_WithNewPostAndNonExistentEagerLoadedProperty_Throws(
Post post,
string propertyName,
string databaseName)
{
// Given
var sut = new DataContext(databaseName);
// When
sut.RegisterAdded(post);
sut.SaveChanges();
// Then
Assert.Throws<InvalidOperationException>(() => sut.Get<Post>(propertyName).Any());
sut.Database.Delete();
sut.Dispose();
}
public void GetPosts_WithNewPost_ReturnsCollectionWithOneElement(
Post post,
string databaseName)
{
// Given
var sut = new DataContext(databaseName);
// When
sut.RegisterAdded(post);
sut.SaveChanges();
var result = sut.Get<Post>();
// Then
Assert.Equal(1, result.Count());
sut.Database.Delete();
sut.Dispose();
}
public void RegisterDeleted_WithPost_RemovesPost(
string databaseName,
Post post)
{
// Given
var sut = new DataContext(databaseName);
sut.RegisterAdded(post);
sut.Commit();
// When
sut.RegisterDeleted(post);
sut.Commit();
var result = sut.Get<Post>().Any();
// Then
Assert.False(result);
sut.Database.Delete();
sut.Dispose();
}
public void RegisterModified_WithModifiedPost_PersistsPost(
string databaseName,
Post post,
string modifiedValue)
{
// Given
var sut = new DataContext(databaseName);
sut.RegisterAdded(post);
sut.Commit();
// When
post.Title = modifiedValue;
sut.RegisterModified(post);
sut.Commit();
var result = sut.Get<Post>().FirstOrDefault();
// Then
Assert.Equal(post, result);
sut.Database.Delete();
sut.Dispose();
}
public void GetPosts_WithNewPostAndEagerLoadedTag_ReturnsPostWithTheSameTag(
Post post,
Tag tag,
string databaseName)
{
// Given
post.Tags.Add(tag);
var sut = new DataContext(databaseName);
// When
sut.RegisterAdded(post);
sut.SaveChanges();
var result = sut.Get<Post>("Tags").SingleOrDefault();
// Then
Assert.True(post.Tags.SequenceEqual(result.Tags));
sut.Database.Delete();
sut.Dispose();
}
