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); } }