public static void EnsureSeedData(this A1ServicesAppDbContext ctx)
{
var jobMaterialLinks = ProcessServiceMaterialsLinkFile("D:\\Projects\\A1ServicesApp\\A1ServicesApp\\Features\\JobServiceMaterialLinks\\ServiceMaterialsLinks.csv");
var servicesList = ProcessServicesFile("D:\\Projects\\A1ServicesApp\\A1ServicesApp\\Features\\JobServiceMaterialLinks\\ServicesBook.csv");
var materialsList = ProcessMaterialsFile("D:\\Projects\\A1ServicesApp\\A1ServicesApp\\Features\\JobServiceMaterialLinks\\MaterialsBook.csv");
var jobServiceMaterialLinks = new List <JobServiceMaterialLink>();
if (ctx.JobServiceMaterialLinks.Any())
{
return;
}
ctx.JobMaterials.AddRange(materialsList);
ctx.JobServices.AddRange(servicesList);
ctx.SaveChanges();
var jobMaterialLinksGroups = jobMaterialLinks.GroupBy(j => j.ServiceId).ToList();
foreach (var link in jobMaterialLinksGroups)
{
var service = ctx.JobServices.Where(s => s.ServiceId == link.Key).FirstOrDefault();
var newJobServiceMaterialLink = new JobServiceMaterialLink()
{
ServiceId = service.ServiceId,
ServiceCode = service.Code,
Active = 1,
MaterialLists = new List <MaterialList>()
};
foreach (var matList in link)
{
var newMaterialList = new MaterialList()
{
Type = "All",
Name = matList.MaterialCode + " - " + link.Key + " - " + "Links"
};
var material = ctx.JobMaterials.Where(j => j.MaterialId == matList.MaterialId).FirstOrDefault();
var materialListItem = new MaterialListItem()
{
JobMaterialId = material.Id,
JobMaterial = material,
MaterialId = material.MaterialId
};
newMaterialList.MaterialListItems.Add(materialListItem);
newJobServiceMaterialLink.MaterialLists.Add(newMaterialList);
}
jobServiceMaterialLinks.Add(newJobServiceMaterialLink);
}
ctx.JobServiceMaterialLinks.AddRange(jobServiceMaterialLinks);
ctx.SaveChanges();
}
public Task <JobServiceMaterialLinkDto> Handle(CreateNewJobServiceMaterialLinkCommand request, CancellationToken cancellationToken)
{
var jobService = _ctx.JobServices.Where(s => s.ServiceId == request.ServiceId).FirstOrDefault();
var materialLists = request.MaterialLists.ToList();
var jobMaterials = new List <JobMaterial>();
var newMaterialLists = new List <MaterialList>();
foreach (var list in request.MaterialLists)
{
var allMaterialListItems = new List <MaterialListItem>();
foreach (var m in list.MaterialListItems)
{
var material = _ctx.JobMaterials.Where(jm => jm.MaterialId == m.MaterialId).FirstOrDefault();
var newMaterialListItem = new MaterialListItem()
{
MaterialId = material.MaterialId,
JobMaterialId = material.Id
};
allMaterialListItems.Add(newMaterialListItem);
}
list.MaterialListItems = allMaterialListItems;
newMaterialLists.Add(list);
}
var newJobServiceMaterialLink = new JobServiceMaterialLink()
{
Active = request.Active,
Name = request.Name,
ServiceId = request.ServiceId,
ServiceCode = jobService.Code,
MaterialLists = newMaterialLists
};
_ctx.JobServiceMaterialLinks.Add(newJobServiceMaterialLink);
_ctx.SaveChanges();
return(Task.FromResult <JobServiceMaterialLinkDto>(_mapper.Map <JobServiceMaterialLinkDto>(newJobServiceMaterialLink)));
}
public void PopulateList()
{
foreach (Object terrainMaterial in terrainTiles)
{
GameObject newTileItem = gameobjectItem;
MaterialListItem listItemScript = newTileItem.GetComponent <MaterialListItem>();
if (terrainMaterial.GetType() == typeof(Texture2D) || terrainMaterial.GetType() == typeof(Texture))
{
listItemScript.ObjectThumbnail.sprite = Sprite.Create((Texture2D)terrainMaterial, new Rect(0.0f, 0.0f, ((Texture)terrainMaterial).width, ((Texture)terrainMaterial).height), new Vector2(), 100.0f);
}
else if (terrainMaterial.GetType() == typeof(Sprite))
{
listItemScript.ObjectThumbnail.sprite = (Sprite)terrainMaterial;
}
listItemScript.ObjectName.text = terrainMaterial.name;
newTileItem = Instantiate(newTileItem) as GameObject;
newTileItem.transform.SetParent(contentPanel);
newTileItem.SetActive(true);
}
}
public void SetMaterial(MaterialListItem materialContainer)
{
ObjectTexture = materialContainer.ObjectThumbnail.mainTexture;
ghostObject.GetComponent <Renderer>().materials[0].mainTexture = ObjectTexture;
}
