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