public bool Insert()
{
Command = CommandBuilder(@"insert into Production ( productId, qty, actualQty, expireDate, manufuctureDate, number, formulaId, employeeId)
values( @productId, @qty, @actualQty, @expireDate, @manufuctureDate, @number, @formulaId, @employeeId)");
Command.Parameters.AddWithValue("@productId", ProductId);
Command.Parameters.AddWithValue("@qty", Quentity);
Command.Parameters.AddWithValue("@actualQty", ActualQuentity);
Command.Parameters.AddWithValue("@expireDate", ExpireDate.ToShortDateString());
Command.Parameters.AddWithValue("@manufuctureDate", ManufuctureDate.ToShortDateString());
Command.Parameters.AddWithValue("@number", Number);
Command.Parameters.AddWithValue("@formulaId", FormulaId);
Command.Parameters.AddWithValue("@employeeId", EmployeeId);
return(ExecuteNQ(Command));
}
public override string ToString()
{
var completion = GetObjectiveCompletionPercents();
var subobjecivesString = new StringBuilder();
foreach (var item in Subobjectives)
{
subobjecivesString.Append($"|\n|______Subobjective {Subobjectives.IndexOf(item) + 1}. {item.ToString()}");
}
return($"{Title}. Formulation date: {ObjectiveFormulationDate.ToShortDateString()} Expire date: {ExpireDate.ToShortDateString()} - {completion}%\n" +
$"{subobjecivesString.ToString()}");
}
