public void UpdateVehicleExceptionEmailDB(VehicleExceptionEmailDataSet aVehicleExceptionEmailDataSet) { try { aVehicleExceptionEmailTableAdapter = new VehicleExceptionEmailDataSetTableAdapters.vehicleexceptionemailTableAdapter(); aVehicleExceptionEmailTableAdapter.Update(aVehicleExceptionEmailDataSet.vehicleexceptionemail); } catch (Exception Ex) { TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Vehicle Exception Email Class // Update Vehicle Exception Email DB " + Ex.Message); } }
public VehicleExceptionEmailDataSet GetVehicleExceptionEmailInfo() { try { aVehicleExceptionEmailDataSet = new VehicleExceptionEmailDataSet(); aVehicleExceptionEmailTableAdapter = new VehicleExceptionEmailDataSetTableAdapters.vehicleexceptionemailTableAdapter(); aVehicleExceptionEmailTableAdapter.Fill(aVehicleExceptionEmailDataSet.vehicleexceptionemail); } catch (Exception Ex) { TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Vehicle Exception Email Class // Get Vehicle Exception Email Info " + Ex.Message); } return(aVehicleExceptionEmailDataSet); }
private void SendVehicleReports() { DateTime datTodaysDate = DateTime.Now; DateTime datTransactionDate; DateTime datStartDate; DateTime datEndDate; try { TheVehicleExceptionEmailDataSet = TheVehicleExceptionEmailClass.GetVehicleExceptionEmailInfo(); TheWeeklyVehicleReportsDateDataSet = TheVehicleExceptionEmailClass.GetWeeklyVehicleReportsDateInfo(); datTransactionDate = TheVehicleExceptionEmailDataSet.vehicleexceptionemail[0].TransactionDate; datTransactionDate = TheDateSearchClass.AddingDays(datTransactionDate, 1); datStartDate = TheDateSearchClass.SubtractingDays(datTodaysDate, 1); datStartDate = TheDateSearchClass.RemoveTime(datStartDate); if (datTodaysDate > datTransactionDate) { if (datTransactionDate.DayOfWeek == DayOfWeek.Saturday) { TheVehicleExceptionEmailDataSet.vehicleexceptionemail[0].TransactionDate = datTransactionDate; TheVehicleExceptionEmailClass.UpdateVehicleExceptionEmailDB(TheVehicleExceptionEmailDataSet); } else if (datTransactionDate.DayOfWeek == DayOfWeek.Sunday) { TheVehicleExceptionEmailDataSet.vehicleexceptionemail[0].TransactionDate = datTransactionDate; TheVehicleExceptionEmailClass.UpdateVehicleExceptionEmailDB(TheVehicleExceptionEmailDataSet); } else { //ChangeVehicleInYardToWarehouse(); datTodaysDate = TheDateSearchClass.RemoveTime(datTodaysDate); datEndDate = TheDateSearchClass.AddingDays(datTodaysDate, 1); TheVehicleExceptionEmailDataSet.vehicleexceptionemail[0].TransactionDate = datTransactionDate; TheAutomatedVehicleReportsClass.RunAutomatedReports(datTodaysDate); TheVehicleExceptionEmailClass.UpdateVehicleExceptionEmailDB(TheVehicleExceptionEmailDataSet); //TheUpdatingWorkTaskStatsClass.UpdateWorkTaskStatsTable(); DataEntryReports(datStartDate, datEndDate); SendOverdueProjectReport(); //SendVehicleAfterHourActivity(); if (datTodaysDate.DayOfWeek == DayOfWeek.Tuesday) { TheRunPunchedVSProductionClass.RunPunchedVSProductionReport(); TheRunPunchedVSProductionClass.CreateOverTimeReport(); TheRunPunchedVSProductionClass.CreateEmployeeMiscReport(); } } } if(datTodaysDate.DayOfWeek == DayOfWeek.Monday) { datTodaysDate = TheDateSearchClass.RemoveTime(datTodaysDate); if(datTodaysDate > TheWeeklyVehicleReportsDateDataSet.weeklyvehiclereportsdate[0].LastWeeklyReport) { //TheAutomatedVehicleReportsClass.RunWeeklyVehicleInspectionReport(); // TheAutomatedVehicleReportsClass.RunWeeklyVehiclesInYardReport(); TheWeeklyVehicleReportsDateDataSet.weeklyvehiclereportsdate[0].LastWeeklyReport = datTodaysDate; TheVehicleExceptionEmailClass.UpdateWeeklyVehicleReportsDB(TheWeeklyVehicleReportsDateDataSet); TheAutomatedProductioinReportsClass.RunAutomatedProductionReports(); } } } catch (Exception Ex) { TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Blue Jay ERP // Main Window // Begin The Process " + Ex.Message); TheMessagesClass.ErrorMessage(Ex.ToString()); } }