public bool UpdatePayment(PaymentUpdate model)
{
connection();
SqlCommand cmd = new SqlCommand("Update Payments SET Amount=@amount, Balance=@balance,PaymentDate=@paymentDate,DateUpdated=@update WHERE Id = @id", _conn);
//assigning values to placeholders
cmd.Parameters.AddWithValue("@id", model.Id);
cmd.Parameters.AddWithValue("@amount", model.Amount);
cmd.Parameters.AddWithValue("@balance", model.Balance);
cmd.Parameters.AddWithValue("@paymentDate", model.PaymentDate);
cmd.Parameters.AddWithValue("@update", DateTime.Now);
_conn.Open();
//execute query and insert form values into database
int i = cmd.ExecuteNonQuery();
_conn.Close();
if (i >= 1)
{
return(true);
}
else
{
return(false);
}
}
protected async Task UpdatePayment(SalesOrder obj, PaymentUpdate _data)
{
if (_data == null)
{
currentErrors.AddValidationError(Messages.PaymentRequired, obj.SalesOrderId);
return;
}
obj.DueDate = _data.DueDate;
obj.ShipMethodObject = await ctx.FindEntityAsync <ShipMethod>(currentErrors, _data.ShipMethodId);
obj.CreditCardApprovalCode = _data.CreditCard?.CreditCardApprovalCode;
obj.CreditCardObject = _data.CreditCard == null ? null :
await ctx.FindEntityAsync <CreditCard>(currentErrors, _data.CreditCard.CreditCardId);
}
protected void UpdatePayment(SalesOrder obj, PaymentUpdate _data)
{
if (_data == null)
{
currentErrors.AddValidationError(Messages.PaymentRequired, obj.SalesOrderId);
return;
}
obj.DueDate = _data.DueDate;
obj.ShipMethodObject = ctx.FindEntity <ShipMethod>(currentErrors, _data.ShipMethodId);
if (_data.CreditCard != null)
{
obj.CreditCardApprovalCode = _data.CreditCard.CreditCardApprovalCode;
obj.CreditCardObject = ctx.FindEntity <CreditCard>(currentErrors, _data.CreditCard.CreditCardId);
}
}
public bool UpdatePaymentType([FromBody] PaymentUpdate model)
{
var payment = _context.Payment.Where(m => m.Lite_Merchant_Trace == model.Lite_Merchant_Trace).FirstOrDefault();
if (payment != null)
{
payment.PaymentType = model.PaymentType;
_context.Payment.Attach(payment);
var result = _context.SaveChanges();
return(true);
}
else
{
return(false);
}
}
public ActionResult EditPayment(PaymentUpdate model)
{
if (ModelState.IsValid)
{
if (pym.UpdatePayment(model))
{
ModelState.Clear();
return(RedirectToAction("Index"));
}
}
else
{
ViewBag.Message = "UnSuccessfully";
}
return(View(model));
}
protected void UpdatePayment(AdventureWorksEntities ctx, SalesOrder obj, PaymentUpdate _data)
{
obj.DueDate = _data.DueDate;
obj.CreditCardApprovalCode = _data.CreditCard.CreditCardApprovalCode;
obj.ShipMethodIdObject = ctx.ShipMethod.Find(_data.ShipMethodId);
if (obj.ShipMethodIdObject == null)
{
ErrorList.Current.AddError("Cannot find ShipMethod with ID {0}.", _data.ShipMethodId);
}
if (_data.CreditCard != null)
{
obj.CreditCardIdObject = ctx.CreditCard.Find(_data.CreditCard.CreditCardId);
if (obj.CreditCardIdObject == null)
{
ErrorList.Current.AddError("Cannot find CreditCard with ID {0}.",
_data.CreditCard.CreditCardId);
}
}
}
public async Task<PaymentUpdate.response> PaymentUpdate(PaymentUpdate.request request, CancellationToken? token = null)
{
return await SendAsync<PaymentUpdate.response>(request.ToXmlString(), token.GetValueOrDefault(CancellationToken.None));
}
