private void But_SumPNCRevision_Click(object sender, EventArgs e)
{
Cursor.Current = Cursors.WaitCursor;
var Option = MainProgram.Self.adminTableView.optionsView;
var Table = MainProgram.Self.adminTableView.ReturnDataGridView();
Table.DataSource = SumRevisionController.LoadByYear(Convert.ToInt32(Option.GetYear()));
Cursor.Current = Cursors.Default;
}
public GroupPNCRevision(int Year, string Revision)
{
IEnumerable <PNCRevisionDB> AllQuantity = PNCRevisionQuantity.LoadByYear_Revision(Year, Revision);
IEnumerable <SumRevisionQuantityDB> SumQuantity = SumRevisionController.LoadByRervision(Year, Revision);
List <SumRevisionQuantityDB> SumToAdd = new List <SumRevisionQuantityDB>();
if (AllQuantity.Count() == 0)
{
MessageBox.Show("No Data To Sum!");
return;
}
if (SumQuantity.Count() != 0)
{
SumRevisionController.RemoveData(SumQuantity);
}
for (int Month = StartMonth(Revision); Month <= 12; Month++)
{
double DMD_FS = 0;
double DMD_FI = 0;
double DMD_BI = 0;
double DMD_FSBU = 0;
double D45_FS = 0;
double D45_FI = 0;
double D45_BI = 0;
double D45_FSBU = 0;
IEnumerable <PNCRevisionDB> AllQuantityMonth = AllQuantity.Where(u => u.Month == Month).ToList();
foreach (PNCRevisionDB PNC in AllQuantityMonth)
{
if (PNC.PNC.Remove(0, 3).Remove(1, 5) == "5")
{
switch (PNC.PNC.Remove(0, 4).Remove(1, 4))
{
case "1":
DMD_FS += PNC.Value;
break;
case "2":
DMD_BI += PNC.Value;
break;
case "3":
DMD_FI += PNC.Value;
break;
case "4":
DMD_FSBU += PNC.Value;
break;
default:
break;
}
}
else if (PNC.PNC.Remove(0, 3).Remove(1, 5) == "0")
{
switch (PNC.PNC.Remove(0, 4).Remove(1, 4))
{
case "5":
D45_FS += PNC.Value;
break;
case "6":
D45_BI += PNC.Value;
break;
case "7":
D45_FI += PNC.Value;
break;
case "8":
D45_FSBU += PNC.Value;
break;
default:
break;
}
}
}
var DMDFS = new SumRevisionQuantityDB
{
Platform = "DMD",
Installation = "FS",
Revision = Revision,
Year = Year,
Month = Month,
Value = DMD_FS,
};
var DMDFI = new SumRevisionQuantityDB
{
Platform = "DMD",
Installation = "FI",
Revision = Revision,
Year = Year,
Month = Month,
Value = DMD_FI,
};
var DMDBI = new SumRevisionQuantityDB
{
Platform = "DMD",
Installation = "BI",
Revision = Revision,
Year = Year,
Month = Month,
Value = DMD_BI,
};
var DMDFSBU = new SumRevisionQuantityDB
{
Platform = "DMD",
Installation = "FSBU",
Revision = Revision,
Year = Year,
Month = Month,
Value = DMD_FSBU,
};
var D45FS = new SumRevisionQuantityDB
{
Platform = "D45",
Installation = "FS",
Revision = Revision,
Year = Year,
Month = Month,
Value = D45_FS,
};
var D45FI = new SumRevisionQuantityDB
{
Platform = "D45",
Installation = "FI",
Revision = Revision,
Year = Year,
Month = Month,
Value = D45_FI,
};
var D45BI = new SumRevisionQuantityDB
{
Platform = "D45",
Installation = "BI",
Revision = Revision,
Year = Year,
Month = Month,
Value = D45_BI,
};
var D45FSBU = new SumRevisionQuantityDB
{
Platform = "D45",
Installation = "FSBU",
Revision = Revision,
Year = Year,
Month = Month,
Value = D45_FSBU,
};
SumToAdd.Add(DMDFS);
SumToAdd.Add(DMDFI);
SumToAdd.Add(DMDBI);
SumToAdd.Add(DMDFSBU);
SumToAdd.Add(D45FS);
SumToAdd.Add(D45FI);
SumToAdd.Add(D45BI);
SumToAdd.Add(D45FSBU);
}
if (SumToAdd.Count() != 0)
{
SumRevisionController.AddData(SumToAdd);
}
}
