public ValidateUserPIN(IDbFacade dbFacade)
: base(dbFacade)
{
}
public GetMachineEventByPlant(IDbFacade dbFacade)
: base(dbFacade)
{
}
public UpdateElectrodeWithDataSheet(IDbFacade dbFacade)
: base(dbFacade)
{
}
public GetAllSubstances(IDbFacade dbFacade)
: base(dbFacade)
{
}
public GetPlantActiveProductionOrders(IDbFacade dbFacade)
: base(dbFacade)
{
}
public GetOperationCard(IDbFacade dbFacade)
: base(dbFacade)
{
}
public GetAllMaterials(IDbFacade dbFacade)
: base(dbFacade)
{
}
public GetUserByPIN(IDbFacade dbFacade)
: base(dbFacade)
{
}
public AddOrUpdateOperationCard(IDbFacade dbFacade)
: base(dbFacade)
{
}
public GetChargeData(IDbFacade dbFacade)
: base(dbFacade)
{
}
public GetIngotByID(IDbFacade dbFacade)
: base(dbFacade)
{
}
public AddUserSignature(IDbFacade dbFacade)
: base(dbFacade)
{
}
public GetAllMotherheats(IDbFacade dbFacade)
: base(dbFacade)
{
}
public GetChargesByMotherheat(IDbFacade dbFacade)
: base(dbFacade)
{
}
public GetProcessVariablesByPlant(IDbFacade dbFacade)
: base(dbFacade)
{
}
private async Task SaveSubstances(OperationCardModel operationCardModel, IDbFacade dbFacade, IDbSession dbSession, OperationCard operationCard)
{
if (operationCardModel.Substances.Operator == null && operationCardModel.Substances.SubstanceList == null)
{
return;
}
if (operationCardModel.Substances.SubstanceList.Count == 0)
{
return;
}
var operationCardLogSubst = new OperationCardLogs()
{
ID = operationCardModel.Substances.LogPKID,
OperationCardID = operationCard.ID,
Type = "Substances",
Content = null,
LoggedError = null,
Date = operationCardModel.Substances != null ? operationCardModel.Substances.Date : new DateTime(),
OperatorID = operationCardModel.Substances != null ? operationCardModel.Substances.Operator.ID : -1
};
// Substance TimeStamp
if (operationCardLogSubst.OperatorID != -1)
{
if (!await dbSession.Set <OperationCardLogs>().AnyAsync(u => u.ID == operationCardLogSubst.ID))
{
dbSession.Set <OperationCardLogs>().Add(operationCardLogSubst);
}
else
{
var logEntry = await dbSession.Set <OperationCardLogs>().FirstOrDefaultAsync(u => u.ID == operationCardLogSubst.ID);
logEntry.Date = operationCardModel.Substances.Date;
logEntry.OperatorID = operationCardModel.Substances.Operator.ID;
}
}
// Substances
if (operationCardModel.Substances?.SubstanceList != null)
{
// Get Instruction Recipe Materials
var instructionRecipeMaterials = new GetAllSubstances(dbFacade).Execute(operationCardModel.HeatNumber);
// Get Instruction
var instruction = dbSession.Set <Instruction>()
.Include(x => x.Materials)
.Where(x => x.ID == operationCard.InstructionID)
.FirstOrDefault();
foreach (var item in operationCardModel.Substances?.SubstanceList.Where(x => x.Weight > 0))
{
// Add or Update to the newest Amounts
if (instruction.Materials.Any(y => y.MaterialID == item.Subst.ID))
{
instruction.Materials.FirstOrDefault(y => y.MaterialID == item.Subst.ID).Amount = item.Weight;
}
else
{
instruction.Materials.Add(new InstructionMaterial()
{
InstructionID = instruction.ID,
MaterialID = item.Subst.ID,
Amount = item.Weight
});
}
}
}
}
public GetGroupedMachineDataByPlant(IDbFacade dbFacade)
: base(dbFacade)
{
}
public GetTabletHeaderData(IDbFacade dbFacade)
: base(dbFacade)
{
}
