private bool ResetClevelandDesignInvoice()
{
int intCounter;
int intNumberOfRecords;
bool blnFatalError = false;
try
{
TheFindSortedWOVTasksByOfficeIDDataSet = TheWOVInvoicingClass.FindSortedWOVTasksByOfficeID(100000);
gintReportNumberOfRecords = 0;
gintReportCounter = 0;
intNumberOfRecords = TheFindSortedWOVTasksByOfficeIDDataSet.FindSortedWOVTasksByOfficeID.Rows.Count - 1;
MainWindow.TheClevelandDesignProjectInvoicingDataSet.clevelanddesigninvoice.Rows.Clear();
ClevelandDesignProjectInvoicingDataSet.clevelanddesigninvoiceRow NewBillingRow = MainWindow.TheClevelandDesignProjectInvoicingDataSet.clevelanddesigninvoice.NewclevelanddesigninvoiceRow();
NewBillingRow.BusinessAddress = "PRICING";
NewBillingRow.BusinessName = "";
NewBillingRow.Date = DateTime.Now;
NewBillingRow.DockID = "";
NewBillingRow.TotalProjectCharge = 0;
for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++)
{
if (TheFindSortedWOVTasksByOfficeIDDataSet.FindSortedWOVTasksByOfficeID[intCounter].WOVTaskDescription == "WOV1")
{
NewBillingRow.WOV1 = TheFindSortedWOVTasksByOfficeIDDataSet.FindSortedWOVTasksByOfficeID[intCounter].Price;
}
else if (TheFindSortedWOVTasksByOfficeIDDataSet.FindSortedWOVTasksByOfficeID[intCounter].WOVTaskDescription == "WOV2")
{
NewBillingRow.WOV2 = TheFindSortedWOVTasksByOfficeIDDataSet.FindSortedWOVTasksByOfficeID[intCounter].Price;
}
else if (TheFindSortedWOVTasksByOfficeIDDataSet.FindSortedWOVTasksByOfficeID[intCounter].WOVTaskDescription == "WOV3")
{
NewBillingRow.WOV3 = TheFindSortedWOVTasksByOfficeIDDataSet.FindSortedWOVTasksByOfficeID[intCounter].Price;
}
else 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;
}
NewBillingRow.PermitCost = 0;
NewBillingRow.PermitQuantity = 0;
NewBillingRow.PermitType = "";
}
MainWindow.TheClevelandDesignProjectInvoicingDataSet.clevelanddesigninvoice.Rows.Add(NewBillingRow);
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Blue Jay ERP // Design Project Invoicing // Reset Cleveland Design Invoice " + Ex.Message);
TheMessagesClass.ErrorMessage(Ex.ToString());
blnFatalError = true;
}
return(blnFatalError);
}
private bool LoadClevelandInvoice(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
{
ResetClevelandDesignInvoice();
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.TheClevelandDesignProjectInvoicingDataSet.clevelanddesigninvoice[intReportCounter].DockID)
{
blnItemFound = true;
if (TheFindProjectTechPayItemsTotalsByProjectIDDataSet.FindProjectTechPayItemsTotalsByProjectID[intPayCounter].TechPayCode == "WOV1")
{
MainWindow.TheClevelandDesignProjectInvoicingDataSet.clevelanddesigninvoice[intReportCounter].WOV1 += Convert.ToDecimal(intTotalQuantity);
MainWindow.TheClevelandDesignProjectInvoicingDataSet.clevelanddesigninvoice[intReportCounter].TotalProjectCharge += decTotalPrice;
}
else if (TheFindProjectTechPayItemsTotalsByProjectIDDataSet.FindProjectTechPayItemsTotalsByProjectID[intPayCounter].TechPayCode == "WOV2")
{
MainWindow.TheClevelandDesignProjectInvoicingDataSet.clevelanddesigninvoice[intReportCounter].WOV2 += Convert.ToDecimal(intTotalQuantity);
MainWindow.TheClevelandDesignProjectInvoicingDataSet.clevelanddesigninvoice[intReportCounter].TotalProjectCharge += decTotalPrice;
}
else if (TheFindProjectTechPayItemsTotalsByProjectIDDataSet.FindProjectTechPayItemsTotalsByProjectID[intPayCounter].TechPayCode == "WOV3")
{
MainWindow.TheClevelandDesignProjectInvoicingDataSet.clevelanddesigninvoice[intReportCounter].WOV3 += Convert.ToDecimal(intTotalQuantity);
MainWindow.TheClevelandDesignProjectInvoicingDataSet.clevelanddesigninvoice[intReportCounter].TotalProjectCharge += decTotalPrice;
}
else if (TheFindProjectTechPayItemsTotalsByProjectIDDataSet.FindProjectTechPayItemsTotalsByProjectID[intPayCounter].TechPayCode == "PP1")
{
MainWindow.TheClevelandDesignProjectInvoicingDataSet.clevelanddesigninvoice[intReportCounter].PP1 += Convert.ToDecimal(intTotalQuantity);
MainWindow.TheClevelandDesignProjectInvoicingDataSet.clevelanddesigninvoice[intReportCounter].TotalProjectCharge += decTotalPrice;
}
else if (TheFindProjectTechPayItemsTotalsByProjectIDDataSet.FindProjectTechPayItemsTotalsByProjectID[intPayCounter].TechPayCode == "PP2")
{
MainWindow.TheClevelandDesignProjectInvoicingDataSet.clevelanddesigninvoice[intReportCounter].PP2 += Convert.ToDecimal(intTotalQuantity);
MainWindow.TheClevelandDesignProjectInvoicingDataSet.clevelanddesigninvoice[intReportCounter].TotalProjectCharge += decTotalPrice;
}
}
}
}
if (blnItemFound == false)
{
ClevelandDesignProjectInvoicingDataSet.clevelanddesigninvoiceRow NewProjectRow = MainWindow.TheClevelandDesignProjectInvoicingDataSet.clevelanddesigninvoice.NewclevelanddesigninvoiceRow();
NewProjectRow.BusinessAddress = strProjectAddress;
NewProjectRow.BusinessName = strProjectName;
NewProjectRow.DockID = MainWindow.gstrAssignedProjectID;
//getting the last update date
datClosingDate = FindClosingDate(MainWindow.gintProjectID);
NewProjectRow.Date = datClosingDate;
NewProjectRow.TotalProjectCharge = decTotalPrice;
if (TheFindProjectTechPayItemsTotalsByProjectIDDataSet.FindProjectTechPayItemsTotalsByProjectID[intPayCounter].TechPayCode == "WOV1")
{
NewProjectRow.WOV1 = Convert.ToDecimal(intTotalQuantity);
NewProjectRow.WOV2 = 0;
NewProjectRow.WOV3 = 0;
NewProjectRow.PP1 = 0;
NewProjectRow.PP2 = 0;
}
else if (TheFindProjectTechPayItemsTotalsByProjectIDDataSet.FindProjectTechPayItemsTotalsByProjectID[intPayCounter].TechPayCode == "WOV2")
{
NewProjectRow.WOV1 = 0;
NewProjectRow.WOV2 = Convert.ToDecimal(intTotalQuantity);
NewProjectRow.WOV3 = 0;
NewProjectRow.PP1 = 0;
NewProjectRow.PP2 = 0;
}
else if (TheFindProjectTechPayItemsTotalsByProjectIDDataSet.FindProjectTechPayItemsTotalsByProjectID[intPayCounter].TechPayCode == "WOV3")
{
NewProjectRow.WOV1 = 0;
NewProjectRow.WOV2 = 0;
NewProjectRow.WOV3 = Convert.ToDecimal(intTotalQuantity);
NewProjectRow.PP1 = 0;
NewProjectRow.PP2 = 0;
}
else if (TheFindProjectTechPayItemsTotalsByProjectIDDataSet.FindProjectTechPayItemsTotalsByProjectID[intPayCounter].TechPayCode == "PP1")
{
NewProjectRow.WOV1 = 0;
NewProjectRow.WOV2 = 0;
NewProjectRow.WOV3 = 0;
NewProjectRow.PP1 = Convert.ToDecimal(intTotalQuantity);
NewProjectRow.PP2 = 0;
}
else if (TheFindProjectTechPayItemsTotalsByProjectIDDataSet.FindProjectTechPayItemsTotalsByProjectID[intPayCounter].TechPayCode == "PP2")
{
NewProjectRow.WOV1 = 0;
NewProjectRow.WOV2 = 0;
NewProjectRow.WOV3 = 0;
NewProjectRow.PP1 = 0;
NewProjectRow.PP2 = Convert.ToDecimal(intTotalQuantity);
}
MainWindow.TheClevelandDesignProjectInvoicingDataSet.clevelanddesigninvoice.Rows.Add(NewProjectRow);
gintReportNumberOfRecords = gintReportCounter + 1;
gintReportCounter++;
}
}
}
}
}
}
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Blue Jay ERP // Design Project Invoicing // Load Cleveland Invoice " + Ex.Message);
TheMessagesClass.ErrorMessage(Ex.ToString());
blnFatalError = true;
}
return(blnFatalError);
}
