public FindTrailerCategoryByCategoryDataSet FindTrailerCategoryByCategory(string strTrailerCategory)
{
try
{
aFindTrailerCategoryByCategoryDataSet = new FindTrailerCategoryByCategoryDataSet();
aFindTrailerCategoryByCategoryTableAdapter = new FindTrailerCategoryByCategoryDataSetTableAdapters.FindTrailerCategoryByCategoryTableAdapter();
aFindTrailerCategoryByCategoryTableAdapter.Fill(aFindTrailerCategoryByCategoryDataSet.FindTrailerCategoryByCategory, strTrailerCategory);
}
catch (Exception Ex)
{
TheEventLogclass.InsertEventLogEntry(DateTime.Now, "Trailer Category Class // Find Trailer Category By Category " + Ex.Message);
}
return(aFindTrailerCategoryByCategoryDataSet);
}
private void mitSave_Click(object sender, RoutedEventArgs e)
{
//setting local variables
int intRecordsReturned;
string strCategory;
bool blnFatalError = false;
try
{
strCategory = txtCategory.Text;
if (strCategory == "")
{
TheMessagesClass.ErrorMessage("Trailer Category was not Entered");
return;
}
TheFindTrailerCategoryByCategoryDataSet = TheTrailerCategoryClass.FindTrailerCategoryByCategory(strCategory);
intRecordsReturned = TheFindTrailerCategoryByCategoryDataSet.FindTrailerCategoryByCategory.Rows.Count;
if (intRecordsReturned > 0)
{
TheMessagesClass.ErrorMessage("The Trailer Category Exists");
return;
}
blnFatalError = TheTrailerCategoryClass.InsertTrailerCategory(strCategory);
if (blnFatalError == true)
{
throw new Exception();
}
TheMessagesClass.InformationMessage("Trailer Category Has Been Added");
txtCategory.Text = "";
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Blue Jay ERP // Add Trailer Category // Save Menu Item " + Ex.Message);
TheMessagesClass.ErrorMessage(Ex.ToString());
}
}
private void mitImportExcel_Click(object sender, RoutedEventArgs e)
{
Excel.Application xlDropOrder;
Excel.Workbook xlDropBook;
Excel.Worksheet xlDropSheet;
Excel.Range range;
int intColumnRange = 0;
int intCounter;
int intNumberOfRecords;
int intRecordsReturned;
try
{
TheNewTrailerDataSet.newtrailers.Rows.Clear();
Microsoft.Win32.OpenFileDialog dlg = new Microsoft.Win32.OpenFileDialog();
dlg.FileName = "Document"; // Default file name
dlg.DefaultExt = ".xlsx"; // Default file extension
dlg.Filter = "Excel (.xlsx)|*.xlsx"; // Filter files by extension
// Show open file dialog box
Nullable <bool> result = dlg.ShowDialog();
// Process open file dialog box results
if (result == true)
{
// Open document
string filename = dlg.FileName;
}
PleaseWait PleaseWait = new PleaseWait();
PleaseWait.Show();
xlDropOrder = new Excel.Application();
xlDropBook = xlDropOrder.Workbooks.Open(dlg.FileName, 0, true, 5, "", "", true, Microsoft.Office.Interop.Excel.XlPlatform.xlWindows, "\t", false, false, 0, true, 1, 0);
xlDropSheet = (Excel.Worksheet)xlDropOrder.Worksheets.get_Item(1);
range = xlDropSheet.UsedRange;
intNumberOfRecords = range.Rows.Count;
intColumnRange = range.Columns.Count;
for (intCounter = 2; intCounter <= intNumberOfRecords; intCounter++)
{
gstrTrailerNumber = Convert.ToString((range.Cells[intCounter, 2] as Excel.Range).Value2);
gstrTrailerNumber = gstrTrailerNumber.Substring(4);
TheFindActiveTrailerByTrailerNumberDataSet = TheTrailersClass.FindActiveTrailerByTrailerNumber(gstrTrailerNumber);
intRecordsReturned = TheFindActiveTrailerByTrailerNumberDataSet.FindActiveTrailerByTrailerNumber.Rows.Count;
if (intRecordsReturned == 0)
{
gstrAssignedOffice = Convert.ToString((range.Cells[intCounter, 1] as Excel.Range).Value2).ToUpper();
gstrTrailerDescription = Convert.ToString((range.Cells[intCounter, 3] as Excel.Range).Value2).ToUpper();
gstrTrailerCategory = Convert.ToString((range.Cells[intCounter, 4] as Excel.Range).Value2).ToUpper();
gstrLicensePlate = Convert.ToString((range.Cells[intCounter, 5] as Excel.Range).Value2).ToUpper();
gstrVINNumber = Convert.ToString((range.Cells[intCounter, 6] as Excel.Range).Value2).ToUpper();
gintLocationID = FindLocationID(gstrAssignedOffice);
TheFindTrailerCategoryByCategoryDataSet = TheTrailerCategoryClass.FindTrailerCategoryByCategory(gstrTrailerCategory);
gintCategoryID = TheFindTrailerCategoryByCategoryDataSet.FindTrailerCategoryByCategory[0].CategoryID;
NewTrailerDataSet.newtrailersRow NewTrailerRow = TheNewTrailerDataSet.newtrailers.NewnewtrailersRow();
NewTrailerRow.CategoryID = gintCategoryID;
NewTrailerRow.LicensePlate = gstrLicensePlate;
NewTrailerRow.Location = gstrAssignedOffice;
NewTrailerRow.LocationID = gintLocationID;
NewTrailerRow.TrailerCategory = gstrTrailerCategory;
NewTrailerRow.TrailerDescription = gstrTrailerDescription;
NewTrailerRow.TrailerNumber = gstrTrailerNumber;
NewTrailerRow.VINNumber = gstrVINNumber;
TheNewTrailerDataSet.newtrailers.Rows.Add(NewTrailerRow);
}
}
PleaseWait.Close();
dgrTrailers.ItemsSource = TheNewTrailerDataSet.newtrailers;
mitSave.IsEnabled = true;
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Blue Jay ERP // Import Trailers // Import Excel Menu Item " + Ex.Message);
TheMessagesClass.ErrorMessage(Ex.ToString());
}
}
