private bool ResetMilwaukeeDesignInvoice() { int intCounter; int intNumberOfRecords; bool blnFatalError = false; try { TheFindSortedWOVTasksByOfficeIDDataSet = TheWOVInvoicingClass.FindSortedWOVTasksByOfficeID(1343); gintReportNumberOfRecords = 0; gintReportCounter = 0; intNumberOfRecords = TheFindSortedWOVTasksByOfficeIDDataSet.FindSortedWOVTasksByOfficeID.Rows.Count - 1; MainWindow.TheWisconsinDesignProjectInvoicingDataSet.wisconsindesigninvoice.Rows.Clear(); WisconsinDesignProjectInvoicingDataSet.wisconsindesigninvoiceRow NewBillingRow = MainWindow.TheWisconsinDesignProjectInvoicingDataSet.wisconsindesigninvoice.NewwisconsindesigninvoiceRow(); NewBillingRow.BusinessAddress = "PRICING"; NewBillingRow.BusinessName = ""; NewBillingRow.Date = DateTime.Now; NewBillingRow.DockID = ""; NewBillingRow.ProjectTotal = 0; NewBillingRow.PermitType = ""; NewBillingRow.PermitCost = 0; for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++) { if (TheFindSortedWOVTasksByOfficeIDDataSet.FindSortedWOVTasksByOfficeID[intCounter].WOVTaskDescription == "PP1") { NewBillingRow.PP1 = TheFindSortedWOVTasksByOfficeIDDataSet.FindSortedWOVTasksByOfficeID[intCounter].Price; } else if (TheFindSortedWOVTasksByOfficeIDDataSet.FindSortedWOVTasksByOfficeID[intCounter].WOVTaskDescription == "PP2") { NewBillingRow.PP2 = TheFindSortedWOVTasksByOfficeIDDataSet.FindSortedWOVTasksByOfficeID[intCounter].Price; } else if (TheFindSortedWOVTasksByOfficeIDDataSet.FindSortedWOVTasksByOfficeID[intCounter].WOVTaskDescription == "MC05") { NewBillingRow.MC05 = TheFindSortedWOVTasksByOfficeIDDataSet.FindSortedWOVTasksByOfficeID[intCounter].Price; } } MainWindow.TheWisconsinDesignProjectInvoicingDataSet.wisconsindesigninvoice.Rows.Add(NewBillingRow); } catch (Exception Ex) { TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Blue Jay ERP // Design Project Invoicing // Reset Wisconsin Design Invoice " + Ex.Message); TheMessagesClass.ErrorMessage(Ex.ToString()); blnFatalError = true; } return(blnFatalError); }
private bool LoadWisconsinInvoice(int intOfficeID, int intBillingID) { bool blnFatalError = false; int intProjectCounter; int intProjectNumberOfRecords; int intPayCounter; int intPayNumberOfRecords; bool blnIsSelected; int intReportCounter; bool blnItemFound; string strProjectName; string strProjectAddress; int intTotalQuantity; decimal decPrice; decimal decTotalPrice; string strWOVTaskDescription; DateTime datClosingDate; try { ResetMilwaukeeDesignInvoice(); ThefindDesignProjectsForInvoicingByOfficeBillingCodeDataSet = TheWOVInvoicingClass.FindDesignProjectsForInvoicingByOfficeBillingCode(intOfficeID, intBillingID); intProjectNumberOfRecords = ThefindDesignProjectsForInvoicingByOfficeBillingCodeDataSet.FindDesignProjectsForInvoicingByOfficeBillingCode.Rows.Count - 1; if (intProjectNumberOfRecords > -1) { for (intProjectCounter = 0; intProjectCounter <= intProjectNumberOfRecords; intProjectCounter++) { MainWindow.gintProjectID = ThefindDesignProjectsForInvoicingByOfficeBillingCodeDataSet.FindDesignProjectsForInvoicingByOfficeBillingCode[intProjectCounter].ProjectID; MainWindow.gstrAssignedProjectID = ThefindDesignProjectsForInvoicingByOfficeBillingCodeDataSet.FindDesignProjectsForInvoicingByOfficeBillingCode[intProjectCounter].AssignedProjectID; strProjectAddress = ThefindDesignProjectsForInvoicingByOfficeBillingCodeDataSet.FindDesignProjectsForInvoicingByOfficeBillingCode[intProjectCounter].ProjectAddress; strProjectName = ThefindDesignProjectsForInvoicingByOfficeBillingCodeDataSet.FindDesignProjectsForInvoicingByOfficeBillingCode[intProjectCounter].ProjectName; blnIsSelected = ProjectSelected(MainWindow.gintProjectID); if (blnIsSelected == true) { gblnDisplayInvoice = true; TheFindProjectTechPayItemsTotalsByProjectIDDataSet = TheTechPayClass.FindProjectTechPayItemsTotalsByProjectID(MainWindow.gintProjectID); intPayNumberOfRecords = TheFindProjectTechPayItemsTotalsByProjectIDDataSet.FindProjectTechPayItemsTotalsByProjectID.Rows.Count - 1; if (intPayNumberOfRecords > -1) { for (intPayCounter = 0; intPayCounter <= intPayNumberOfRecords; intPayCounter++) { blnItemFound = false; intTotalQuantity = TheFindProjectTechPayItemsTotalsByProjectIDDataSet.FindProjectTechPayItemsTotalsByProjectID[intPayCounter].TotalQuantity; strWOVTaskDescription = TheFindProjectTechPayItemsTotalsByProjectIDDataSet.FindProjectTechPayItemsTotalsByProjectID[intPayCounter].TechPayCode; TheFindWOVTaskByOfficeIDAndDescriptionDataSet = TheWOVInvoicingClass.FindWOVTaskByOfficeIDAndDescription(MainWindow.gintWarehouseID, strWOVTaskDescription); decPrice = TheFindWOVTaskByOfficeIDAndDescriptionDataSet.FindWOVTaskByOfficeIDAndDescription[0].Price; decTotalPrice = decPrice * Convert.ToDecimal(intTotalQuantity); if (gintReportCounter > 0) { for (intReportCounter = 1; intReportCounter <= gintReportNumberOfRecords; intReportCounter++) { if (MainWindow.gstrAssignedProjectID == MainWindow.TheWisconsinDesignProjectInvoicingDataSet.wisconsindesigninvoice[intReportCounter].DockID) { blnItemFound = true; if (TheFindProjectTechPayItemsTotalsByProjectIDDataSet.FindProjectTechPayItemsTotalsByProjectID[intPayCounter].TechPayCode == "PP1") { MainWindow.TheWisconsinDesignProjectInvoicingDataSet.wisconsindesigninvoice[intReportCounter].PP1 += Convert.ToDecimal(intTotalQuantity); MainWindow.TheWisconsinDesignProjectInvoicingDataSet.wisconsindesigninvoice[intReportCounter].ProjectTotal += decTotalPrice; } else if (TheFindProjectTechPayItemsTotalsByProjectIDDataSet.FindProjectTechPayItemsTotalsByProjectID[intPayCounter].TechPayCode == "PP2") { MainWindow.TheWisconsinDesignProjectInvoicingDataSet.wisconsindesigninvoice[intReportCounter].PP2 += Convert.ToDecimal(intTotalQuantity); MainWindow.TheWisconsinDesignProjectInvoicingDataSet.wisconsindesigninvoice[intReportCounter].ProjectTotal += decTotalPrice; } else if (TheFindProjectTechPayItemsTotalsByProjectIDDataSet.FindProjectTechPayItemsTotalsByProjectID[intPayCounter].TechPayCode == "MC05") { MainWindow.TheWisconsinDesignProjectInvoicingDataSet.wisconsindesigninvoice[intReportCounter].MC05 += Convert.ToDecimal(intTotalQuantity); MainWindow.TheWisconsinDesignProjectInvoicingDataSet.wisconsindesigninvoice[intReportCounter].ProjectTotal += decTotalPrice; } } } } if (blnItemFound == false) { WisconsinDesignProjectInvoicingDataSet.wisconsindesigninvoiceRow NewProjectRow = MainWindow.TheWisconsinDesignProjectInvoicingDataSet.wisconsindesigninvoice.NewwisconsindesigninvoiceRow(); NewProjectRow.BusinessAddress = strProjectAddress; NewProjectRow.BusinessName = strProjectName; NewProjectRow.DockID = MainWindow.gstrAssignedProjectID; //getting the last update date datClosingDate = FindClosingDate(MainWindow.gintProjectID); NewProjectRow.Date = datClosingDate; NewProjectRow.ProjectTotal = decTotalPrice; NewProjectRow.PermitType = ""; NewProjectRow.PermitCost = 0; if (TheFindProjectTechPayItemsTotalsByProjectIDDataSet.FindProjectTechPayItemsTotalsByProjectID[intPayCounter].TechPayCode == "PP1") { NewProjectRow.PP1 = Convert.ToDecimal(intTotalQuantity); NewProjectRow.PP2 = 0; NewProjectRow.MC05 = 0; } else if (TheFindProjectTechPayItemsTotalsByProjectIDDataSet.FindProjectTechPayItemsTotalsByProjectID[intPayCounter].TechPayCode == "PP2") { NewProjectRow.PP1 = 0; NewProjectRow.PP2 = Convert.ToDecimal(intTotalQuantity); NewProjectRow.MC05 = 0; } else if (TheFindProjectTechPayItemsTotalsByProjectIDDataSet.FindProjectTechPayItemsTotalsByProjectID[intPayCounter].TechPayCode == "MC05") { NewProjectRow.PP1 = 0; NewProjectRow.PP2 = 0; NewProjectRow.MC05 = Convert.ToDecimal(intTotalQuantity); } MainWindow.TheWisconsinDesignProjectInvoicingDataSet.wisconsindesigninvoice.Rows.Add(NewProjectRow); gintReportNumberOfRecords = gintReportCounter + 1; gintReportCounter++; } } } } } } } catch (Exception Ex) { TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Blue Jay ERP // Design Project Invoicing // Load Wisconsin Invoice " + Ex.Message); TheMessagesClass.ErrorMessage(Ex.ToString()); blnFatalError = true; } return(blnFatalError); }