public void Remove(FuelCorrectionObject fuelCorrection) { try { CheckTransaction(); new FuelCorrectionDataService(Transaction).Remove(fuelCorrection); if (IsOwner) { Transaction.Commit(); } } catch (Exception exception1) { if (IsOwner) { Transaction.Rollback(); } Exception innerException = exception1; throw new Exception(MethodBase.GetCurrentMethod().Name, innerException); } finally { if (IsOwner) { Connection.Close(); } } }
public void Save(FuelCorrectionObject fuelCorrection) { SqlCommand cmd = null; try { ExecuteNonQuery(out cmd, false, "FuelCorrection_SAVE", CreateParameter("@fuelcorID", SqlDbType.UniqueIdentifier, fuelCorrection.FuelCorID, ParameterDirection.InputOutput), CreateParameter("@DateFrom", SqlDbType.VarChar, fuelCorrection.DateFrom), CreateParameter("@DateTo", SqlDbType.VarChar, fuelCorrection.DateTo), CreateParameter("@Quantity", SqlDbType.Decimal, fuelCorrection.Quantity), CreateParameter("@MaxQuantity", SqlDbType.Decimal, fuelCorrection.MaxQuantity), CreateParameter("@VehiclesNotIncluded", SqlDbType.VarChar, fuelCorrection.VehiclesNotIncluded), CreateParameter("@SuppliersIncluded", SqlDbType.VarChar, fuelCorrection.SuppliersIncluded) ); fuelCorrection.FuelCorID = (Guid)cmd.Parameters["@fuelcorID"].Value; } catch (Exception exception1) { Exception innerException = exception1; throw new Exception(MethodBase.GetCurrentMethod().Name, innerException); } finally { if (cmd != null) { cmd.Dispose(); } cmd = null; } }
public bool Remove(FuelCorrectionObject fuelCorrection) { SqlCommand cmd = null; try { ExecuteNonQuery(out cmd, false, "FuelCorrection_DELETE", CreateParameter("@fuelcorID", SqlDbType.UniqueIdentifier, fuelCorrection.FuelCorID, ParameterDirection.Input) ); return(true); } catch (Exception exception1) { Exception innerException = exception1; throw new Exception(MethodBase.GetCurrentMethod().Name, innerException); } finally { if (cmd != null) { cmd.Dispose(); } cmd = null; } }
private void gdvFuelCorrection_DoubleClick(object sender, EventArgs e) { try { GridView view = (GridView)sender; _fuelCorrection = (FuelCorrectionObject)view.GetRow(view.FocusedRowHandle); FillFuelCorrectionControls(); _saveEnable = false; btnSaveCorrection.Enabled = false; btnCancelCorrection.Enabled = false; btnCalculateCorrection.Enabled = true; } catch (System.Exception excepion1) { System.Exception thisException = excepion1; Management.ShowException(thisException); } }
public Fuel() { try { InitializeComponent(); _fuelCorrection = new FuelCorrectionObject(); _fuelCorrectionRows = new FuelObjectCollection(); _saveEnable = true; FillControls(); FillControlsCorrection(); FillControlsDelivery(); FillControlsFuelReport(); SetPermissions(); } catch (System.Exception exception1) { System.Exception innerException = exception1; throw new System.Exception(MethodBase.GetCurrentMethod().Name, innerException); } }
private void bbiRemoveFuelCorrection_Click(object sender, EventArgs e) { try { if (DevExpress.XtraEditors.XtraMessageBox.Show(this.LookAndFeel, "Ben je zeker dat je de brandstof correctie wilt verwijderen?", "Delete?", MessageBoxButtons.YesNoCancel, MessageBoxIcon.Question, MessageBoxDefaultButton.Button3) == DialogResult.Yes) { //******************** // GetFuels //******************** FuelCorrectionObject fuel = (FuelCorrectionObject)this.gdvFuelCorrection.GetRow(this.gdvFuelCorrection.FocusedRowHandle); FuelObjectCollection fuels; BL.Internal.Fuel fuelBL = new BL.Internal.Fuel(); fuels = fuelBL.GetFilter(PROF_IT.Common.Convert.DateFunctions.DBDateToDate(fuel.DateFrom), PROF_IT.Common.Convert.DateFunctions.DBDateToDate(fuel.DateTo), fuel.VehiclesNotIncluded, fuel.SuppliersIncluded); if (fuels != null) { foreach (FuelObject fuelObj in fuels) { fuelObj.QuantityCorrection = fuelObj.Quantity; new BL.Internal.Fuel().Save(fuelObj); } } new BL.Internal.FuelCorrection().Remove(fuel); FillControlsCorrection(); } } catch (System.Exception exception1) { System.Exception thisException = exception1; Management.ShowException(thisException); } }
private void ClearFuelCorrectionControls() { try { this.ccbxSuppliersIncluded.Properties.Items.Clear(); string[] suppliers = new BL.Internal.Fuel().GetSuppliers(); foreach (string supplier in suppliers) { this.ccbxSuppliersIncluded.Properties.Items.Add(supplier); } this.ccbxVehiclesNotIncluded.Properties.Items.Clear(); string[] vehicles = new BL.Internal.Fuel().GetVehicles(); foreach (string vehicle in vehicles) { this.ccbxVehiclesNotIncluded.Properties.Items.Add(vehicle); } dteDateFromCorrection.Text = ""; dteDateToCorrection.Text = ""; _fuelCorrection = new FuelCorrectionObject(); this.gdcFuelCorrectionCalc.DataSource = null; _saveEnable = true; btnSaveCorrection.Enabled = false; btnCancelCorrection.Enabled = false; } catch (System.Exception exception1) { System.Exception innerException = exception1; throw new System.Exception(MethodBase.GetCurrentMethod().Name, innerException); } spinMaxQuantity.Value = 0; spinQuantityCorrection.Value = 0; }