public static void UpdateValue(FrozenDB _UpdateValue)
{
var context = new DataBaseConnectionContext();
context.Update(_UpdateValue);
context.SaveChanges();
}
public static void AddValue(FrozenDB _AddValue)
{
var context = new DataBaseConnectionContext();
context.Add(_AddValue);
context.SaveChanges();
}
public SaveFrozen(int YearToSave, int[] Data)
{
IEnumerable <FrozenDB> Frozen = FrozenController.Load_year(YearToSave);
if (Frozen.Count() == 0)
{
var NewRow = new FrozenDB();
PrepareData(NewRow, Data);
NewRow.Year = YearToSave;
FrozenController.AddValue(NewRow);
}
else
{
PrepareData(Frozen.First(), Data);
FrozenController.UpdateValue(Frozen.First());
}
}
private void PrepareData(FrozenDB Lista, int[] data)
{
Lista.BU = data[0];
Lista.EA1 = data[1];
Lista.EA2 = data[2];
Lista.EA3 = data[3];
Lista.January = data[4];
Lista.February = data[5];
Lista.March = data[6];
Lista.April = data[7];
Lista.May = data[8];
Lista.June = data[9];
Lista.July = data[10];
Lista.August = data[11];
Lista.September = data[12];
Lista.October = data[13];
Lista.November = data[14];
Lista.December = data[15];
Lista.ElectronicApprove = data[16];
Lista.MechanicApprove = data[17];
Lista.NVRApprove = data[18];
}
private bool CheckIfCanCalculate()
{
IEnumerable <FrozenDB> Year = FrozenController.Load_year(Convert.ToInt32(MainProgram.Self.actionView.stateView.GetYear()));
if (Year.Count() == 1)
{
foreach (FrozenDB CalcYear in Year)
{
FrozenYear = CalcYear;
CalcRow = 0;
if (CalcYear.BU == 1)
{
StartCalc = 1;
FinishCalc = 12;
CalcRow = 4;
return(true);
}
if (CalcYear.EA1 == 1)
{
StartCalc = 3;
FinishCalc = 12;
CalcRow = 3;
return(true);
}
if (CalcYear.EA2 == 1)
{
StartCalc = 6;
FinishCalc = 12;
CalcRow = 2;
return(true);
}
if (CalcYear.EA3 == 1)
{
StartCalc = 9;
FinishCalc = 12;
CalcRow = 1;
return(true);
}
if (CalcYear.January == 1)
{
StartCalc = 1;
FinishCalc = 1;
return(true);
}
if (CalcYear.February == 1)
{
StartCalc = 2;
FinishCalc = 2;
return(true);
}
if (CalcYear.March == 1)
{
StartCalc = 3;
FinishCalc = 3;
return(true);
}
if (CalcYear.April == 1)
{
StartCalc = 4;
FinishCalc = 4;
return(true);
}
if (CalcYear.May == 1)
{
StartCalc = 5;
FinishCalc = 5;
return(true);
}
if (CalcYear.June == 1)
{
StartCalc = 6;
FinishCalc = 6;
return(true);
}
if (CalcYear.July == 1)
{
StartCalc = 7;
FinishCalc = 7;
return(true);
}
if (CalcYear.August == 1)
{
StartCalc = 8;
FinishCalc = 8;
return(true);
}
if (CalcYear.September == 1)
{
StartCalc = 9;
FinishCalc = 9;
return(true);
}
if (CalcYear.November == 1)
{
StartCalc = 10;
FinishCalc = 10;
return(true);
}
if (CalcYear.October == 1)
{
StartCalc = 11;
FinishCalc = 11;
return(true);
}
if (CalcYear.December == 1)
{
StartCalc = 12;
FinishCalc = 12;
return(true);
}
}
StartCalc = 0;
FinishCalc = 0;
return(false);
}
else
{
FrozenYear = null;
StartCalc = 0;
FinishCalc = 0;
return(false);
}
}
