private void cboSelectWarehouse_SelectionChanged(object sender, SelectionChangedEventArgs e) { int intSelectedIndex; int intWarehouseID; DateTime datStartDate = DateTime.Now; DateTime datEndDate = DateTime.Now; DateTime datTodaysDate = DateTime.Now; int intCounter; int intNumberOfRecords; int intRecordsReturned; int intPartID; int intLoop; string strPartNumber; double douAverage; double douSTDev; int intCount; bool blnDoNotCopy; PleaseWait PleaseWait = new PleaseWait(); PleaseWait.Show(); try { intSelectedIndex = cboSelectWarehouse.SelectedIndex - 1; if (intSelectedIndex > -1) { TheCalculatedInventoryStatsDataSet.inventorystats.Rows.Clear(); TheFinalCalculatedInventoryStatsDataSet.inventorystats.Rows.Clear(); intWarehouseID = TheFindPartsWarehouseDataSet.FindPartsWarehouses[intSelectedIndex].EmployeeID; TheFindWarehouseInventoryDataSet = TheInventoryClass.FindWarehouseInventory(intWarehouseID); intNumberOfRecords = TheFindWarehouseInventoryDataSet.FindWarehouseInventory.Rows.Count - 1; datTodaysDate = TheDateSearchClass.RemoveTime(datTodaysDate); for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++) { datStartDate = TheDateSearchClass.SubtractingDays(datTodaysDate, 90); datEndDate = TheDateSearchClass.AddingDays(datStartDate, 30); intLoop = 1; strPartNumber = TheFindWarehouseInventoryDataSet.FindWarehouseInventory[intCounter].PartNumber; TheFindPartByPartNumberDataSet = ThePartNumberClass.FindPartByPartNumber(strPartNumber); intPartID = TheFindPartByPartNumberDataSet.FindPartByPartNumber[0].PartID; CalculatedInventoryStatsDataSet.inventorystatsRow NewInventoryRow = TheCalculatedInventoryStatsDataSet.inventorystats.NewinventorystatsRow(); NewInventoryRow.PartID = intPartID; NewInventoryRow.JDEPartNumber = TheFindWarehouseInventoryDataSet.FindWarehouseInventory[intCounter].JDEPartNumber; NewInventoryRow.PartDescription = TheFindWarehouseInventoryDataSet.FindWarehouseInventory[intCounter].PartDescription; NewInventoryRow.PartNumber = strPartNumber; while (datStartDate < datTodaysDate) { TheFindInventoryIssueStatsDataSet = TheInventoryStatsClass.FindInventoryIssueStats(intPartID, intWarehouseID, datStartDate, datEndDate); intRecordsReturned = TheFindInventoryIssueStatsDataSet.FindInventoryIssueStats.Rows.Count; if (intRecordsReturned == 0) { douAverage = 0; douSTDev = 0; intCount = 0; } else { if (TheFindInventoryIssueStatsDataSet.FindInventoryIssueStats[0].IsAverageIssuedNull() == true) { douAverage = 0; } else { douAverage = TheFindInventoryIssueStatsDataSet.FindInventoryIssueStats[0].AverageIssued; } if (TheFindInventoryIssueStatsDataSet.FindInventoryIssueStats[0].IsIssuedSTDEVNull() == true) { douSTDev = 0; } else { douSTDev = TheFindInventoryIssueStatsDataSet.FindInventoryIssueStats[0].IssuedSTDEV; } intCount = TheFindInventoryIssueStatsDataSet.FindInventoryIssueStats[0].TotalIssued; } if (intLoop == 1) { NewInventoryRow.PeriodOneAvg = douAverage; NewInventoryRow.PeriodOneCount = intCount; NewInventoryRow.PeriodOneSD = douSTDev; NewInventoryRow.PeriodOneStarDate = datStartDate; } else if (intLoop == 2) { NewInventoryRow.PeriodTwoAvg = douAverage; NewInventoryRow.PeriodTwoCount = intCount; NewInventoryRow.PeriodTwoSD = douSTDev; NewInventoryRow.PeriodTwoStartDate = datStartDate; } else if (intLoop == 3) { NewInventoryRow.PeriodThreeAvg = douAverage; NewInventoryRow.PeriodThreeCount = intCount; NewInventoryRow.PeriodThreeSD = douSTDev; NewInventoryRow.PeriodThreeStartDate = datStartDate; } datStartDate = datEndDate; datEndDate = TheDateSearchClass.AddingDays(datEndDate, 30); intLoop++; } TheCalculatedInventoryStatsDataSet.inventorystats.Rows.Add(NewInventoryRow); } intNumberOfRecords = TheCalculatedInventoryStatsDataSet.inventorystats.Rows.Count - 1; for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++) { blnDoNotCopy = false; if (TheCalculatedInventoryStatsDataSet.inventorystats[intCounter].PeriodOneAvg == 0) { if (TheCalculatedInventoryStatsDataSet.inventorystats[intCounter].PeriodTwoAvg == 0) { if (TheCalculatedInventoryStatsDataSet.inventorystats[intCounter].PeriodThreeAvg == 0) { blnDoNotCopy = true; } } } if (blnDoNotCopy == false) { CalculatedInventoryStatsDataSet.inventorystatsRow NewStatsRow = TheFinalCalculatedInventoryStatsDataSet.inventorystats.NewinventorystatsRow(); NewStatsRow.JDEPartNumber = TheCalculatedInventoryStatsDataSet.inventorystats[intCounter].JDEPartNumber; NewStatsRow.PartDescription = TheCalculatedInventoryStatsDataSet.inventorystats[intCounter].PartDescription; NewStatsRow.PartID = TheCalculatedInventoryStatsDataSet.inventorystats[intCounter].PartID; NewStatsRow.PartNumber = TheCalculatedInventoryStatsDataSet.inventorystats[intCounter].PartNumber; NewStatsRow.PeriodOneAvg = TheCalculatedInventoryStatsDataSet.inventorystats[intCounter].PeriodOneAvg; NewStatsRow.PeriodOneCount = TheCalculatedInventoryStatsDataSet.inventorystats[intCounter].PeriodOneCount; NewStatsRow.PeriodOneSD = TheCalculatedInventoryStatsDataSet.inventorystats[intCounter].PeriodOneSD; NewStatsRow.PeriodThreeAvg = TheCalculatedInventoryStatsDataSet.inventorystats[intCounter].PeriodThreeAvg; NewStatsRow.PeriodThreeCount = TheCalculatedInventoryStatsDataSet.inventorystats[intCounter].PeriodThreeCount; NewStatsRow.PeriodThreeSD = TheCalculatedInventoryStatsDataSet.inventorystats[intCounter].PeriodThreeSD; NewStatsRow.PeriodTwoAvg = TheCalculatedInventoryStatsDataSet.inventorystats[intCounter].PeriodTwoAvg; NewStatsRow.PeriodTwoCount = TheCalculatedInventoryStatsDataSet.inventorystats[intCounter].PeriodTwoCount; NewStatsRow.PeriodTwoSD = TheCalculatedInventoryStatsDataSet.inventorystats[intCounter].PeriodTwoSD; NewStatsRow.PeriodOneStarDate = TheCalculatedInventoryStatsDataSet.inventorystats[intCounter].PeriodOneStarDate; NewStatsRow.PeriodThreeStartDate = TheCalculatedInventoryStatsDataSet.inventorystats[intCounter].PeriodThreeStartDate; NewStatsRow.PeriodTwoStartDate = TheCalculatedInventoryStatsDataSet.inventorystats[intCounter].PeriodTwoStartDate; TheFinalCalculatedInventoryStatsDataSet.inventorystats.Rows.Add(NewStatsRow); } } dgrResults.ItemsSource = TheFinalCalculatedInventoryStatsDataSet.inventorystats; } } catch (Exception Ex) { TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Inventory Stats // Main Window // Combo Box Changed " + Ex.Message); TheMessagesClass.ErrorMessage(Ex.ToString()); } PleaseWait.Close(); }
private void cboSelectWarehouse_SelectionChanged(object sender, SelectionChangedEventArgs e) { int intCounter; int intNumberOfRecords; int intWarehouseID; int intPartID; string strPartNumber; string strOldPartNumber = ""; string strJDEPartNumber; string strPartDescription; int intQuantity; int intSelectedIndex; int intRecordsReturned; string strCurrentCount = ""; decimal decPartCost; decimal decTotalCost; try { intSelectedIndex = cboSelectWarehouse.SelectedIndex - 1; TheWarehouseCountDataSet.warehousecount.Rows.Clear(); if (intSelectedIndex > -1) { intWarehouseID = TheFindPartsWarehouseDataSet.FindPartsWarehouses[intSelectedIndex].EmployeeID; TheFindWarehouseInventoryDataSet = TheInventoryClass.FindWarehouseInventory(intWarehouseID); intNumberOfRecords = TheFindWarehouseInventoryDataSet.FindWarehouseInventory.Rows.Count; for (intCounter = 0; intCounter < intNumberOfRecords; intCounter++) { intPartID = TheFindWarehouseInventoryDataSet.FindWarehouseInventory[intCounter].PartID; strPartNumber = TheFindWarehouseInventoryDataSet.FindWarehouseInventory[intCounter].PartNumber; strJDEPartNumber = TheFindWarehouseInventoryDataSet.FindWarehouseInventory[intCounter].JDEPartNumber; strPartDescription = TheFindWarehouseInventoryDataSet.FindWarehouseInventory[intCounter].PartDescription; intQuantity = TheFindWarehouseInventoryDataSet.FindWarehouseInventory[intCounter].Quantity; TheFindPartByPartIDDataSet = ThePartNumberClass.FindPartByPartID(intPartID); decPartCost = Convert.ToDecimal(TheFindPartByPartIDDataSet.FindPartByPartID[0].Price); decPartCost = Math.Round(decPartCost, 2); decTotalCost = decPartCost * intQuantity; decTotalCost = Math.Round(decTotalCost, 2); TheFindMasterPartListPartByPartIDDataSet = ThePartNumberClass.FindMasterPartByPartID(intPartID); intRecordsReturned = TheFindMasterPartListPartByPartIDDataSet.FindMasterPartListPartByPartID.Rows.Count; if (intRecordsReturned > 0) { strOldPartNumber = TheFindMasterPartListPartByPartIDDataSet.FindMasterPartListPartByPartID[0].PartNumber; } else if (intRecordsReturned < 1) { strOldPartNumber = "NO PART FOUND"; } WarehouseCountDataSet.warehousecountRow NewPartRow = TheWarehouseCountDataSet.warehousecount.NewwarehousecountRow(); NewPartRow.Quantity = intQuantity; NewPartRow.JDEPartNumber = strJDEPartNumber; NewPartRow.OldPartNumber = strOldPartNumber; NewPartRow.PartDescription = strPartDescription; NewPartRow.PartID = intPartID; NewPartRow.PartNumber = strPartNumber; NewPartRow.CurrentQuantity = strCurrentCount; NewPartRow.PartCost = decPartCost; NewPartRow.TotalValue = decTotalCost; TheWarehouseCountDataSet.warehousecount.Rows.Add(NewPartRow); } dgrResult.ItemsSource = TheWarehouseCountDataSet.warehousecount; } } catch (Exception Ex) { TheEventLogClass.InsertEventLogEntry(DateTime.Now, "New Blue Jay ERP // Warehouse Inventory Report // Select Warehouse Combo Box " + Ex.Message); TheMessagesClass.ErrorMessage(Ex.ToString()); } }
private void mitPrintCycleCountTickets_Click(object sender, RoutedEventArgs e) { int intCounter; int intRandomNumber = 0; int intNumberOfRecords; int intArrayCounter; bool blnDublicateNumber; bool blnItemFound; try { for (intArrayCounter = 0; intArrayCounter <= 10; intArrayCounter++) { gintNumberUsed[intArrayCounter] = -1; } gintArrayCounter = 0; TheCycleCountTicketsDataSet.tickets.Rows.Clear(); TheFindWarehouseInventoryDataSet = TheInventoryClass.FindWarehouseInventory(MainWindow.gintWarehouseID); intNumberOfRecords = TheFindWarehouseInventoryDataSet.FindWarehouseInventory.Rows.Count; for (intCounter = 0; intCounter < 10; intCounter++) { blnDublicateNumber = true; while (blnDublicateNumber == true) { blnItemFound = false; intRandomNumber = myRandomNumber.Next(0, intNumberOfRecords); for (intArrayCounter = 0; intArrayCounter <= 10; intArrayCounter++) { if (intRandomNumber == gintNumberUsed[intArrayCounter]) { blnItemFound = true; } } if (blnItemFound == false) { blnDublicateNumber = false; } } gintNumberUsed[gintArrayCounter] = intRandomNumber; gintArrayCounter++; CycleCountTicketsDataSet.ticketsRow NewPartRow = TheCycleCountTicketsDataSet.tickets.NewticketsRow(); NewPartRow.Description = TheFindWarehouseInventoryDataSet.FindWarehouseInventory[intRandomNumber].PartDescription; NewPartRow.JDEPartNumber = ""; TheFindPartByPartNumberDataSet = ThePartNumberClass.FindPartByPartNumber(TheFindWarehouseInventoryDataSet.FindWarehouseInventory[intRandomNumber].PartNumber); NewPartRow.PartID = TheFindPartByPartNumberDataSet.FindPartByPartNumber[0].PartID; NewPartRow.PartNumber = TheFindWarehouseInventoryDataSet.FindWarehouseInventory[intRandomNumber].PartNumber; NewPartRow.Quantity = ""; TheCycleCountTicketsDataSet.tickets.Rows.Add(NewPartRow); } PrintTickets(); } catch (Exception Ex) { TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Blue Jay ERP // Cycle Count // Print Cycle Count Tickets " + Ex.Message); TheMessagesClass.ErrorMessage(Ex.ToString()); } }
private void CompareParts() { //setting local variables int intFirstCounter; int intSecondCounter; int intFirstNumberOfRecords; int intSecondNumberOfRecords; bool blnItemFound; int intPartID; int intWarehouseID = 0; bool blnFatalError = false; try { TheItemsNotFoundDataSet.itemsnotfound.Rows.Clear(); TheFindWarehouseInventoryDataSet = TheInventoryClass.FindWarehouseInventory(gintWarehouseID); intFirstNumberOfRecords = TheFindWarehouseInventoryDataSet.FindWarehouseInventory.Rows.Count - 1; intSecondNumberOfRecords = TheImportInventoryDataSet.importinventory.Rows.Count - 1; for (intFirstCounter = 0; intFirstCounter <= intFirstNumberOfRecords; intFirstCounter++) { blnItemFound = false; intPartID = TheFindWarehouseInventoryDataSet.FindWarehouseInventory[intFirstCounter].PartID; for (intSecondCounter = 0; intSecondCounter <= intSecondNumberOfRecords; intSecondCounter++) { if (intPartID == TheImportInventoryDataSet.importinventory[intSecondCounter].PartID) { blnItemFound = true; } } if (blnItemFound == false) { ItemsNotFoundDataSet.itemsnotfoundRow PartNotFound = TheItemsNotFoundDataSet.itemsnotfound.NewitemsnotfoundRow(); PartNotFound.PartID = intPartID; PartNotFound.PartNumber = TheFindWarehouseInventoryDataSet.FindWarehouseInventory[intFirstCounter].PartNumber; PartNotFound.PartDescription = TheFindWarehouseInventoryDataSet.FindWarehouseInventory[intFirstCounter].PartDescription; PartNotFound.JDEPartNumber = TheFindWarehouseInventoryDataSet.FindWarehouseInventory[intFirstCounter].JDEPartNumber; PartNotFound.Quantity = TheFindWarehouseInventoryDataSet.FindWarehouseInventory[intFirstCounter].Quantity; TheItemsNotFoundDataSet.itemsnotfound.Rows.Add(PartNotFound); } } intFirstNumberOfRecords = TheFindPartsWarehousesDataSet.FindPartsWarehouses.Rows.Count - 1; for (intFirstCounter = 0; intFirstCounter <= intFirstNumberOfRecords; intFirstCounter++) { if (TheFindPartsWarehousesDataSet.FindPartsWarehouses[intFirstCounter].FirstName == "MASPRO-HOLDING") { intWarehouseID = TheFindPartsWarehousesDataSet.FindPartsWarehouses[intFirstCounter].EmployeeID; } } intFirstNumberOfRecords = TheItemsNotFoundDataSet.itemsnotfound.Rows.Count - 1; if (intFirstNumberOfRecords > -1) { for (intFirstCounter = 0; intFirstCounter <= intFirstNumberOfRecords; intFirstCounter++) { intPartID = TheItemsNotFoundDataSet.itemsnotfound[intFirstCounter].PartID; blnFatalError = TheInventoryClass.MovePartToNewWarehouse(gintWarehouseID, intWarehouseID, intPartID); if (blnFatalError == true) { throw new Exception(); } } } } catch (Exception Ex) { TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Import Mass Pro Inventory // Compare Parts " + Ex.Message); TheMessagesClass.ErrorMessage(Ex.ToString()); } }