public int UpdatePaymentAndOrderStatus(TblOrderPayment orderPaymentDetails)
{
var ID = new SqlParameter
{
ParameterName = "@ID",
DbType = System.Data.DbType.Int32,
Value = orderPaymentDetails.Id,
Direction = System.Data.ParameterDirection.Input
};
var TransactionID = new SqlParameter
{
ParameterName = "@TransactionID",
DbType = System.Data.DbType.String,
Size = 20,
Value = orderPaymentDetails.TransactionId,
Direction = System.Data.ParameterDirection.Input
};
var tblPaymentStatusID = new SqlParameter
{
ParameterName = "@tblPaymentStatusID",
DbType = System.Data.DbType.Int32,
Value = orderPaymentDetails.TblPaymentStatusId,
Direction = System.Data.ParameterDirection.Input
};
var ReturnValue = new SqlParameter
{
ParameterName = "@ReturnValue",
DbType = System.Data.DbType.Int32,
Direction = System.Data.ParameterDirection.Output
};
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append("exec UpdatePaymentStatus @ID, @TransactionID, ");
stringBuilder.Append("@tblPaymentStatusID, @ReturnValue OUT");
_context.Database.ExecuteSqlCommand(stringBuilder.ToString(),
ID,
TransactionID,
tblPaymentStatusID,
ReturnValue);
_context.SaveChanges();
return((int)ReturnValue.Value);
}
//[Test]
public void Test_Update_Payment_And_Order_Status()
{
TblOrderPayment OrderedFoodDetails = new TblOrderPayment()
{
Id = 1,
TransactionId = "qwerty12345",
TblPaymentStatusId = 3
};
var options = new DbContextOptionsBuilder <OrderManagementContext>()
.UseInMemoryDatabase(databaseName: "OrderManagement")
.Options;
PaymentDbAccess placeOrderDbAccess = new PaymentDbAccess(new OrderManagementContext(options));
int OrderId = placeOrderDbAccess.UpdatePaymentAndOrderStatus(OrderedFoodDetails);
Assert.Greater(OrderId, 0);
}
public void Test_Make_Payment_For_Order()
{
TblOrderPayment OrderedFoodDetails = new TblOrderPayment()
{
TblPaymentTypeId = 1,
Remarks = "test",
TransactionId = "qwerty12345",
TblPaymentStatusId = 3
};
var options = new DbContextOptionsBuilder <OrderManagementContext>()
.UseInMemoryDatabase(databaseName: "OrderManagement")
.Options;
PaymentDbAccess placeOrderDbAccess = new PaymentDbAccess(new OrderManagementContext(options));
int OrderId = placeOrderDbAccess.MakePaymentForOrder(OrderedFoodDetails);
Assert.Greater(OrderId, 0);
}
public int UpdatePaymentAndOrderStatus(TblOrderPayment orderPaymentDetails)
{
var ID = new SqlParameter
{
ParameterName = "@ID",
DbType = System.Data.DbType.Int32,
Value = orderPaymentDetails.Id,
Direction = System.Data.ParameterDirection.Input
};
var TransactionID = new SqlParameter
{
ParameterName = "@TransactionID",
DbType = System.Data.DbType.String,
Size = 20,
Value = orderPaymentDetails.TransactionId,
Direction = System.Data.ParameterDirection.Input
};
var tblPaymentStatusID = new SqlParameter
{
ParameterName = "@tblPaymentStatusID",
DbType = System.Data.DbType.Int32,
Value = orderPaymentDetails.TblPaymentStatusId,
Direction = System.Data.ParameterDirection.Input
};
var ReturnValue = new SqlParameter
{
ParameterName = "@ReturnValue",
DbType = System.Data.DbType.Int32,
Direction = System.Data.ParameterDirection.Output
};
_context.Database.ExecuteSqlInterpolated($"exec UpdatePaymentStatus @ID={ID}, @TransactionID={TransactionID},@tblPaymentStatusID={tblPaymentStatusID}, @ReturnValue OUT={ReturnValue}");
_context.SaveChanges();
return((int)ReturnValue.Value);
}
public int MakePaymentForOrder(TblOrderPayment orderPaymentDetails)
{
_context.TblOrderPayment.Add(orderPaymentDetails);
_context.SaveChanges();
return(orderPaymentDetails.Id);
}
