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