public void SavePurchase(SalesReciepts sale) { using (var cn = new SqlConnection(Settings.GetConnectionString())) { SqlCommand cmd = new SqlCommand("SavePurchase", cn); cmd.CommandType = CommandType.StoredProcedure; SqlParameter param = new SqlParameter("@SalesReceiptId", SqlDbType.Int); param.Direction = ParameterDirection.Output; cmd.Parameters.Add(param); cmd.Parameters.AddWithValue("@VehicleId", sale.VehicleId); cmd.Parameters.AddWithValue("@CustomerId", sale.CustomerId); cmd.Parameters.AddWithValue("@EmployeeId", sale.EmployeeId); cmd.Parameters.AddWithValue("@PaymentMethodId", sale.PaymentMethodId); cmd.Parameters.AddWithValue("@Total", sale.Total); cmd.Parameters.AddWithValue("@Date", sale.Date); cn.Open(); cmd.ExecuteNonQuery(); sale.SalesRecieptsId = (int)param.Value; } }
public void CanAddReciept() { var repo = new PurchaseRepositoryADO(); var reciept = new SalesReciepts(); reciept.CustomerId = 1; reciept.Date = DateTime.Now; reciept.EmployeeId = 1; reciept.PaymentMethodId = 1; reciept.Total = 30000; reciept.VehicleId = 1; repo.SavePurchase(reciept); Assert.AreEqual(1, 1); }