public void UPdateDesignPermitsDB(DesignPermitsDataSet aDesignPermitsDataSet)
{
try
{
aDesignPermitsTableAdapter = new DesignPermitsDataSetTableAdapters.designpermitsTableAdapter();
aDesignPermitsTableAdapter.Update(aDesignPermitsDataSet.designpermits);
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Design Permits Class // Update Design Permits DB " + Ex.Message);
}
}
public DesignPermitsDataSet GetDesignPermitsInfo()
{
try
{
aDesignPermitsDataSet = new DesignPermitsDataSet();
aDesignPermitsTableAdapter = new DesignPermitsDataSetTableAdapters.designpermitsTableAdapter();
aDesignPermitsTableAdapter.Fill(aDesignPermitsDataSet.designpermits);
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Design Permits Class // Get Design Permits Info " + Ex.Message);
}
return(aDesignPermitsDataSet);
}
private void BtnProcess_Click(object sender, RoutedEventArgs e)
{
//setting local variables
int intCounter;
int intNumberOfRecords;
decimal decPermitCost;
decimal decPermitPrice;
int intTransactionID;
bool blnFatalError = false;
try
{
intNumberOfRecords = TheDesignPermitsDataSet.designpermits.Rows.Count - 1;
for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++)
{
if (TheDesignPermitsDataSet.designpermits[intCounter].IsPermitCostNull() == false)
{
decPermitCost = TheDesignPermitsDataSet.designpermits[intCounter].PermitCost;
intTransactionID = TheDesignPermitsDataSet.designpermits[intCounter].TransactionID;
decPermitPrice = decPermitCost + (decPermitCost * Convert.ToDecimal(.15));
decPermitPrice = Math.Round(decPermitPrice, 2);
blnFatalError = TheDesignPermitsClass.UpdateDesignProjectPermitCost(intTransactionID, decPermitCost, decPermitPrice);
if (blnFatalError == true)
{
throw new Exception();
}
}
}
TheDesignPermitsDataSet = TheDesignPermitsClass.GetDesignPermitsInfo();
dgrResults.ItemsSource = TheDesignPermitsDataSet.designpermits;
TheMessagesClass.InformationMessage("Records Have Been Updated");
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Calculating Permit Pricing // Process Button " + Ex.Message);
TheMessagesClass.ErrorMessage(Ex.ToString());
}
}
private void Window_Loaded(object sender, RoutedEventArgs e)
{
TheDesignPermitsDataSet = TheDesignPermitsClass.GetDesignPermitsInfo();
dgrResults.ItemsSource = TheDesignPermitsDataSet.designpermits;
}