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