/********************************** * Lemuel E. Aceron * July 30, 2008 17:21 * Added for Payment **********************************/ public bool UpdatePaymentStatus(TransferOutPaymentStatus paymentStatus, string IDs) { try { string SQL = "UPDATE tblTransferOut SET PaymentStatus = @PaymentStatus WHERE TransferOutID IN (" + IDs + ");"; MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = SQL; MySqlParameter prmPaymentStatus = new MySqlParameter("@PaymentStatus",MySqlDbType.Int16); prmPaymentStatus.Value = paymentStatus.ToString("d"); cmd.Parameters.Add(prmPaymentStatus); base.ExecuteNonQuery(cmd); return true; } catch (Exception ex) { throw base.ThrowException(ex); } }
public bool UpdatePayment(long TransferOutID, decimal PaidAmount, TransferOutPaymentStatus paymentStatus) { try { string SQL = "UPDATE tblTransferOut SET " + "PaidAmount = PaidAmount + @PaidAmount, " + "UnpaidAmount = UnpaidAmount - @PaidAmount, " + "PaymentStatus = @PaymentStatus " + "WHERE TransferOutID = @TransferOutID;"; MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = SQL; MySqlParameter prmPaidAmount = new MySqlParameter("@PaidAmount",MySqlDbType.Decimal); prmPaidAmount.Value = PaidAmount; cmd.Parameters.Add(prmPaidAmount); MySqlParameter prmPaymentStatus = new MySqlParameter("@PaymentStatus",MySqlDbType.Int16); prmPaymentStatus.Value = paymentStatus.ToString("d"); cmd.Parameters.Add(prmPaymentStatus); MySqlParameter prmTransferOutID = new MySqlParameter("@TransferOutID",MySqlDbType.Int64); prmTransferOutID.Value = TransferOutID; cmd.Parameters.Add(prmTransferOutID); base.ExecuteNonQuery(cmd); return true; } catch (Exception ex) { throw base.ThrowException(ex); } }