public int InsertSale(SaleInsert saleInsert) { int affectedRows; using (SqlConnection cn = new SqlConnection()) { cn.ConnectionString = connection; cn.Open(); var cmdText = "INSERT INTO sale(order_id, customer_id, product_id, sales, quantity, discount, profit) " + "VALUES (@order_id, @customer_id, @product_id, @sales, @quantity, @discount, @profit)"; using (SqlCommand cmd = new SqlCommand(cmdText, cn)) { cmd.Parameters.Add("@order_id", SqlDbType.Char, 14); cmd.Parameters["@order_id"].Value = saleInsert.OrderId; cmd.Parameters.Add("@customer_id", SqlDbType.Char, 8); cmd.Parameters["@customer_id"].Value = saleInsert.CustomerId; cmd.Parameters.Add("@product_id", SqlDbType.Char, 15); cmd.Parameters["@product_id"].Value = saleInsert.ProductId; cmd.Parameters.Add("@sales", SqlDbType.Decimal); cmd.Parameters["@sales"].Value = saleInsert.Sales; cmd.Parameters.Add("@quantity", SqlDbType.Int); cmd.Parameters["@quantity"].Value = saleInsert.Quantity; cmd.Parameters.Add("@discount", SqlDbType.Decimal); cmd.Parameters["@discount"].Value = saleInsert.Discount; cmd.Parameters.Add("@profit", SqlDbType.Decimal); cmd.Parameters["@profit"].Value = saleInsert.Profit; affectedRows = cmd.ExecuteNonQuery(); } cn.Close(); } return(affectedRows); }
public int InsertSale(SaleInsert saleInsert) { using (SqlConnection sqlConnection = new SqlConnection(connection)) { var selection = "INSERT INTO sale(order_id, customer_id, product_id, sales, quantity, discount, profit) " + "VALUES (@order_id, @customer_id, @product_id, @sales, @quantity, @discount, @profit)"; var count = sqlConnection.Execute(selection, new { order_id = saleInsert.OrderId, customer_id = saleInsert.CustomerId, product_id = saleInsert.ProductId, sales = saleInsert.Sales, quantity = saleInsert.Quantity, discount = saleInsert.Discount, profit = saleInsert.Profit }); return(count); } }
public int InsertSale(SaleInsert saleInsert) { return(_employeeRepository.InsertSale(saleInsert)); }