public async Task <List <DTOVikByUnit> > GetViksByUnit(int resoultID, string unitName)
{
var viks = await MyDB.db.v_GetVikByUnit.Where(elem => elem.UnitName == unitName && elem.ResoultID == resoultID).ToListAsync();
List <DTOVikByUnit> dViks = new List <DTOVikByUnit>();
if (viks.Count > 0)
{
foreach (var item in viks)
{
var photo = GetVikPhoto((int)item.ResoultID, item.VikID).Result.photo;
DTOVikByUnit dVik = new DTOVikByUnit()
{
VikID = item.VikID,
Row = item.Row,
Frame = item.Frame,
nLevel = item.nLevel,
StructuralMemberID = item.StructuralMemberID,
DefectID = item.DefectID,
RiskLevelID = item.RiskLevelID,
States = item.States,
cComment = item.cComment,
mX = item.mX,
mY = item.mY,
mRotation = item.mRotation,
ResoultID = item.ResoultID,
UnitName = item.UnitName,
WarhouseID = item.WarhouseID,
ElementID = item.ElementID,
mScale = item.mScale,
EmployeeID = item.EmployeeID,
SpecificationsID = item.SpecificationsID,
UpdateTime = item.UpdateTime,
FrameRange = item.FrameRange,
SpecificationsElementID = item.SpecificationsElementID,
ElementCount = item.ElementCount,
PartialTOID = item.PartialTOID,
ShowMode = item.ShowMode,
Path = item.Path,
ElementOrientation = item.ElementOrientation,
ManufacturedStillage = item.ManufacturedStillage
};
if (photo == null)
{
dVik.DamagePhoto = null;
}
else
{
dVik.DamagePhoto = "";
}
dViks.Add(dVik);
}
return(dViks);
}
return(new List <DTOVikByUnit>());
}
public async Task <List <DTOVikByUnit> > GetViksByPartialTO(int partialTOID)
{
List <Vik> vList = MyDB.db.Vik.Where(elem => elem.PartialToid == partialTOID).ToList();
List <DTOVikByUnit> vdList = new List <DTOVikByUnit>();
foreach (var item in vList)
{
v_GetVikByUnit vik = MyDB.db.v_GetVikByUnit.FirstOrDefault(elem => elem.VikID == item.VikId);
var photo = GetVikPhoto((int)vik.ResoultID, vik.VikID).Result.photo;
DTOVikByUnit dVik = new DTOVikByUnit()
{
VikID = vik.VikID,
Row = vik.Row,
Frame = vik.Frame,
nLevel = vik.nLevel,
StructuralMemberID = vik.StructuralMemberID,
DefectID = vik.DefectID,
RiskLevelID = vik.RiskLevelID,
States = vik.States,
cComment = vik.cComment,
mX = vik.mX,
mY = vik.mY,
mRotation = vik.mRotation,
ResoultID = vik.ResoultID,
UnitName = vik.UnitName,
WarhouseID = vik.WarhouseID,
ElementID = vik.ElementID,
mScale = vik.mScale,
EmployeeID = vik.EmployeeID,
SpecificationsID = vik.SpecificationsID,
UpdateTime = vik.UpdateTime,
FrameRange = vik.FrameRange,
SpecificationsElementID = vik.SpecificationsElementID,
ElementCount = vik.ElementCount,
PartialTOID = vik.PartialTOID,
ShowMode = vik.ShowMode,
Path = vik.Path,
ElementOrientation = vik.ElementOrientation,
ManufacturedStillage = vik.ManufacturedStillage
};
if (photo == null)
{
dVik.DamagePhoto = null;
}
else
{
dVik.DamagePhoto = "";
}
vdList.Add(dVik);
}
return(vdList);
}
