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