/// <summary>
/// Update a row in the sales management table
/// </summary>
/// <param name="salesManagement"></param>
/// <returns></returns>
public bool UpdateSalesManagement(SalesManagementDataModel salesManagement)
{
using (OleDbCommand oleDbCommand = new OleDbCommand())
{
// Set the command object properties
oleDbCommand.Connection = new OleDbConnection(this.ConnectionString);
oleDbCommand.CommandType = CommandType.Text;
oleDbCommand.CommandText = SalesManagementScripts.sqlUpdateSalesManagement;
// Add the input parameters to the parameter collection
oleDbCommand.Parameters.AddWithValue("@ProductID", salesManagement.PaymentID);
oleDbCommand.Parameters.AddWithValue("@ProductDeliveryID", salesManagement.ProductDeliveryID);
oleDbCommand.Parameters.AddWithValue("@SellingPriceID", salesManagement.SellingPriceID);
oleDbCommand.Parameters.AddWithValue("@PaymentID", salesManagement.PaymentID);
oleDbCommand.Parameters.AddWithValue("@PurchasePriceID", salesManagement.PurchasePriceID);
oleDbCommand.Parameters.AddWithValue("@SalesManagementID", salesManagement.SalesManagementID);
// Open the connection, execute the query and close the connection
oleDbCommand.Connection.Open();
var rowsAffected = oleDbCommand.ExecuteNonQuery();
oleDbCommand.Connection.Close();
return(rowsAffected > 0);
}
}
/// <summary>
/// Event handler for new button click
/// </summary>
private void btnNew_Click(object sender, System.EventArgs e)
{
_salesManagementDataModel = _salesManagementService.AddEmptySalesManagement();
UpdateDataModels();
UpdateSalesManagementForm(DataState.WriteToUI);
_parentForm.UpdateDataGridView();
}
/// <summary>
/// Instantiate an instance of the class
/// </summary>
public SalesManagementService()
{
_salesManagementAccess = new SalesManagementAccess();
SalesManagementDataModel = new SalesManagementDataModel();
_paymentService = new PaymentService();
_paymentUnitService = new PaymentUnitService();
_productService = new ProductService();
_productDeliveryService = new ProductDeliveryService();
_purchasePriceService = new PurchasePriceService();
_sellingPriceService = new SellingPriceService();
}
/// <summary>
/// Converts a Data row from the database table to sales management model
/// </summary>
/// <param name="salesManagementRow"></param>
/// <returns></returns>
public SalesManagementDataModel ConvertToDataModel(DataRow salesManagementRow)
{
var result = new SalesManagementDataModel();
result.SalesManagementID = salesManagementRow.Field <int>("SalesManagementID");
result.ProductID = salesManagementRow.Field <int>("ProductID");
result.ProductDeliveryID = salesManagementRow.Field <int>("ProductDeliveryID");
result.SellingPriceID = salesManagementRow.Field <int>("SellingPriceID");
result.PaymentID = salesManagementRow.Field <int>("PaymentID");
result.PurchasePriceID = salesManagementRow.Field <int>("PurchasePriceID");
return(result);
}
/// <summary>
/// Update an entry in the sales management table
/// </summary>
/// <param name="salesManagement"></param>
/// <returns></returns>
public bool UpdateSalesManagement(SalesManagementDataModel salesManagement)
{
var success = true;
success = _paymentService.UpdatePayment(PaymentDataModel) && success;
success = _productDeliveryService.UpdateProductDelivery(ProductDeliveryDataModel) && success;
success = _productService.UpdateProduct(ProductDataModel) && success;
success = _purchasePriceService.UpdatePurchasePrice(PurchasePriceDataModel) && success;
success = _sellingPriceService.UpdateSellingPrice(SellingPriceDataModel) && success;
success = _paymentUnitService.UpdatePaymentUnitDataTable(PaymentUnitsTable) && success;
//success = _salesManagementAccess.UpdateSalesManagement(SalesManagementDataModel) && success;
return(success);
}
/// <summary>
/// Constructor
/// </summary>
/// <param name="parentForm"> A reference to the parent form</param>
/// <param name="salesManagementDataModel">A reference to the sales management data model</param>
/// <param name="selectedTabIndex">Index of the tab to initialize the form with</param>
public frmSalesManagement(
frmProductsOverview parentForm, SalesManagementDataModel salesManagementDataModel, int selectedTabIndex)
{
InitializeComponent();
_parentForm = parentForm;
_salesManagementDataModel = salesManagementDataModel;
_salesManagementService = new SalesManagementService(salesManagementDataModel);
_paymentService = new PaymentService();
_paymentUnitService = new PaymentUnitService();
_productService = new ProductService();
_productDeliveryService = new ProductDeliveryService();
_purchasePriceService = new PurchasePriceService();
_sellingPriceService = new SellingPriceService();
UpdateDataModels();
UpdateSalesManagementForm(DataState.WriteToUI);
saleManagementTabControl.SelectedIndex = selectedTabIndex;
}
/// <summary>
/// Add a sales management row into the table
/// </summary>
/// <param name="salesManagement"></param>
/// <returns></returns>
public int AddSalesManagement(SalesManagementDataModel salesManagement)
{
var result = -1;
using (OleDbCommand oleDbCommand = new OleDbCommand())
{
// Set the command object properties
oleDbCommand.Connection = new OleDbConnection(this.ConnectionString);
oleDbCommand.CommandType = CommandType.Text;
oleDbCommand.CommandText = SalesManagementScripts.sqlInsertSalesManagement;
// Add the input parameters to the parameter collection
oleDbCommand.Parameters.AddWithValue("@ProductID", salesManagement.ProductID);
oleDbCommand.Parameters.AddWithValue("@ProductDeliveryID", salesManagement.ProductDeliveryID);
oleDbCommand.Parameters.AddWithValue("@SellingPriceID", salesManagement.SellingPriceID);
oleDbCommand.Parameters.AddWithValue("@PaymentID", salesManagement.PaymentID);
oleDbCommand.Parameters.AddWithValue("@PurchasePriceID", salesManagement.PurchasePriceID);
// Open the connection, execute the query and close the connection
oleDbCommand.Connection.Open();
var rowsAffected = oleDbCommand.ExecuteNonQuery();
if (rowsAffected == 0)
{
result = -1;
}
else
{
oleDbCommand.CommandText = GeneralScripts.sqlGetIdentityOfInsertedRow;
result = (int)oleDbCommand.ExecuteScalar();
}
oleDbCommand.Connection.Close();
return(result);
}
}
/// <summary>
/// Add a sales management instance to the table
/// </summary>
/// <param name="salesManagement"></param>
/// <returns></returns>
public int AddSalesManagement(SalesManagementDataModel salesManagement)
{
//TODO:implement necessary logic
return(_salesManagementAccess.AddSalesManagement(salesManagement));
}
