public FindDesignProjectsByJobStatusDataSet FindDesignProjectsByJobStatus(string strJobStatus)
{
try
{
aFindDesignProjectsByJobStatusDataSet = new FindDesignProjectsByJobStatusDataSet();
aFindDesignProjectsByJobStatusTableAdapter = new FindDesignProjectsByJobStatusDataSetTableAdapters.FindDesignProjectsByJobStatusTableAdapter();
aFindDesignProjectsByJobStatusTableAdapter.Fill(aFindDesignProjectsByJobStatusDataSet.FindDesignProjectsByJobStatus, strJobStatus);
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Design Projects Class // Find Design Projects By Job Status " + Ex.Message);
}
return(aFindDesignProjectsByJobStatusDataSet);
}
private void ResetControls()
{
//setting local variables
int intCounter;
int intNumberOfRecords;
int intSecondCounter;
int intProjectID;
bool blnItemFound;
string strAssignedProjectID;
try
{
//filling data set
TheFindDesignProjectsByJobStatusDataSet = TheDesignProjectsClass.FindDesignProjectsByJobStatus("INVOICED");
//getting ready for the loop
intNumberOfRecords = TheFindDesignProjectsByJobStatusDataSet.FindDesignProjectsByJobStatus.Rows.Count - 1;
TheDesignProjectsNeedingInvoiceDataSet.designprojects.Rows.Clear();
gintCounter = 0;
gintNumberOfRecords = 0;
if (intNumberOfRecords > -1)
{
for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++)
{
blnItemFound = false;
strAssignedProjectID = TheFindDesignProjectsByJobStatusDataSet.FindDesignProjectsByJobStatus[intCounter].AssignedProjectID;
TheFindDesignProjectsByAssignedProjectIDDataSet = TheDesignProjectsClass.FindDesignProjectsByAssignedProjectID(strAssignedProjectID);
intProjectID = TheFindDesignProjectsByAssignedProjectIDDataSet.FindDesignProjectsByAssignedProjectID[0].ProjectID;
if (gintCounter > 0)
{
for (intSecondCounter = 0; intSecondCounter <= gintNumberOfRecords; intSecondCounter++)
{
if (intProjectID == TheDesignProjectsNeedingInvoiceDataSet.designprojects[intSecondCounter].ProjectID)
{
blnItemFound = true;
}
}
}
if (blnItemFound == false)
{
DesignProjectsNeedingInvoiceDataSet.designprojectsRow NewProjectRow = TheDesignProjectsNeedingInvoiceDataSet.designprojects.NewdesignprojectsRow();
NewProjectRow.AssignedOffice = TheFindDesignProjectsByJobStatusDataSet.FindDesignProjectsByJobStatus[intCounter].FirstName;
NewProjectRow.AssignedProjectID = TheFindDesignProjectsByJobStatusDataSet.FindDesignProjectsByJobStatus[intCounter].AssignedProjectID;
NewProjectRow.ProjectID = intProjectID;
NewProjectRow.ProjectName = TheFindDesignProjectsByJobStatusDataSet.FindDesignProjectsByJobStatus[intCounter].ProjectName;
NewProjectRow.ProcessProject = false;
NewProjectRow.DateReceived = TheFindDesignProjectsByJobStatusDataSet.FindDesignProjectsByJobStatus[intCounter].DateReceived;
TheDesignProjectsNeedingInvoiceDataSet.designprojects.Rows.Add(NewProjectRow);
gintNumberOfRecords = gintCounter;
gintCounter++;
}
}
}
dgrResults.ItemsSource = TheDesignProjectsNeedingInvoiceDataSet.designprojects;
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Blue Jay ERP // Design Project Invoicing // Reset Controls " + Ex.Message);
TheMessagesClass.ErrorMessage(Ex.ToString());
}
}
