/// <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)); }