/// <summary> /// Method to create new selling price /// </summary> /// <param name="productDelivery">club member model</param> /// <returns>true or false</returns> public bool AddProductDelivery(ProductDeliveryDataModel productDelivery) { using (OleDbCommand oleDbCommand = new OleDbCommand()) { // Set the command object properties oleDbCommand.Connection = new OleDbConnection(this.ConnectionString); oleDbCommand.CommandType = CommandType.Text; oleDbCommand.CommandText = ProductDeliveryScripts.sqlInsertProductDelivery; // Add the input parameters to the parameter collection oleDbCommand.Parameters.AddWithValue("@DateOfPurchase", productDelivery.DateOfPurchase == null ? (object)DBNull.Value : productDelivery.DateOfPurchase.Value.ToOADate()); oleDbCommand.Parameters.AddWithValue("@LandOfOrigin", productDelivery.LandOfOrigin ?? (object)DBNull.Value); oleDbCommand.Parameters.AddWithValue("@CurrentLocation", productDelivery.CurrentLocation ?? (object)DBNull.Value); oleDbCommand.Parameters.AddWithValue("@DateOfSale", productDelivery.DateOfSale == null ? (object)DBNull.Value : productDelivery.DateOfSale.Value.ToOADate()); oleDbCommand.Parameters.AddWithValue("@LandOfDestination", productDelivery.LandOfDestination ?? (object)DBNull.Value); oleDbCommand.Parameters.AddWithValue("@ProductStatus", productDelivery.ProductStatus ?? (object)DBNull.Value); oleDbCommand.Parameters.AddWithValue("@Seller", productDelivery.Seller ?? (object)DBNull.Value); oleDbCommand.Parameters.AddWithValue("@Buyer", productDelivery.Buyer ?? (object)DBNull.Value); oleDbCommand.Parameters.AddWithValue("@ProductWebsite", productDelivery.ProductWebsite ?? (object)DBNull.Value); oleDbCommand.Parameters.AddWithValue("@ProductAttachment", productDelivery.ProductAttachment ?? (object)DBNull.Value); // Open the connection, execute the query and close the connection oleDbCommand.Connection.Open(); var rowsAffected = oleDbCommand.ExecuteNonQuery(); oleDbCommand.Connection.Close(); return(rowsAffected > 0); } }
/// <summary> /// Updates the data models /// </summary> private void UpdateDataModels() { _paymentDataModel = _salesManagementService.PaymentDataModel; _productDataModel = _salesManagementService.ProductDataModel; _productDeliveryDataModel = _salesManagementService.ProductDeliveryDataModel; _purchasePriceDataModel = _salesManagementService.PurchasePriceDataModel; _sellingPriceDataModel = _salesManagementService.SellingPriceDataModel; _paymentUnitsTable = _salesManagementService.PaymentUnitsTable; }
/// <summary> /// Converts a Data row from the database table to selling price model /// </summary> /// <param name="productDeliveryRow"></param> /// <returns></returns> public ProductDeliveryDataModel ConvertToDataModel(DataRow productDeliveryRow) { var result = new ProductDeliveryDataModel(); result.ProductDeliveryID = productDeliveryRow.Field <int>("ProductDeliveryID"); result.DateOfPurchase = productDeliveryRow.Field <DateTime?>("DateOfPurchase"); result.LandOfOrigin = productDeliveryRow.Field <string>("LandOfOrigin"); result.CurrentLocation = productDeliveryRow.Field <string>("CurrentLocation"); result.DateOfSale = productDeliveryRow.Field <DateTime?>("DateOfSale"); result.LandOfDestination = productDeliveryRow.Field <string>("LandOfDestination"); result.ProductStatus = productDeliveryRow.Field <bool?>("ProductStatus"); result.Seller = productDeliveryRow.Field <string>("Seller"); result.Buyer = productDeliveryRow.Field <string>("Buyer"); result.ProductWebsite = productDeliveryRow.Field <string>("ProductWebsite"); result.ProductAttachment = productDeliveryRow.Field <string>("ProductAttachment"); return(result); }
/// <summary> /// Method to update selling price details /// </summary> /// <param name="productDelivery">Selling Price</param> /// <returns></returns> public bool UpdateProductDelivery(ProductDeliveryDataModel productDelivery) { return(productDeliveryAccess.UpdateProductDelivery(productDelivery)); }
/// <summary> /// Method to create new selling price /// </summary> /// <param name="productDelivery">club member model</param> /// <returns>true or false</returns> public bool AddProductDelivery(ProductDeliveryDataModel productDelivery) { return(productDeliveryAccess.AddProductDelivery(productDelivery)); }