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