public bool UpdatePayment(long WBranchTransferID, decimal PaidAmount, WBranchTransferPaymentStatus paymentStatus)
{
try
{
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
string SQL = "UPDATE tblWBranchTransfer SET " +
"PaidAmount = PaidAmount + @PaidAmount, " +
"UnpaidAmount = UnpaidAmount - @PaidAmount, " +
"PaymentStatus = @PaymentStatus " +
"WHERE WBranchTransferID = @WBranchTransferID;";
cmd.Parameters.AddWithValue("@PaidAmount", PaidAmount);
cmd.Parameters.AddWithValue("@PaymentStatus", paymentStatus.ToString("d"));
cmd.Parameters.AddWithValue("@WBranchTransferID", WBranchTransferID);
cmd.CommandText = SQL;
base.ExecuteNonQuery(cmd);
return(true);
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
/**********************************
* Lemuel E. Aceron
* July 30, 2008 17:21
* Added for Payment
**********************************/
public bool UpdatePaymentStatus(WBranchTransferPaymentStatus paymentStatus, string IDs)
{
try
{
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
string SQL = "UPDATE tblWBranchTransfer SET PaymentStatus = @PaymentStatus WHERE WBranchTransferID IN (" + IDs + ");";
cmd.Parameters.AddWithValue("@PaymentStatus", paymentStatus.ToString("d"));
cmd.CommandText = SQL;
base.ExecuteNonQuery(cmd);
return(true);
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public bool UpdatePayment(long WBranchTransferID, decimal PaidAmount, WBranchTransferPaymentStatus paymentStatus)
{
try
{
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
string SQL = "UPDATE tblWBranchTransfer SET " +
"PaidAmount = PaidAmount + @PaidAmount, " +
"UnpaidAmount = UnpaidAmount - @PaidAmount, " +
"PaymentStatus = @PaymentStatus " +
"WHERE WBranchTransferID = @WBranchTransferID;";
cmd.Parameters.AddWithValue("@PaidAmount", PaidAmount);
cmd.Parameters.AddWithValue("@PaymentStatus", paymentStatus.ToString("d"));
cmd.Parameters.AddWithValue("@WBranchTransferID", WBranchTransferID);
cmd.CommandText = SQL;
base.ExecuteNonQuery(cmd);
return true;
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
/**********************************
* Lemuel E. Aceron
* July 30, 2008 17:21
* Added for Payment
**********************************/
public bool UpdatePaymentStatus(WBranchTransferPaymentStatus paymentStatus, string IDs)
{
try
{
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
string SQL = "UPDATE tblWBranchTransfer SET PaymentStatus = @PaymentStatus WHERE WBranchTransferID IN (" + IDs + ");";
cmd.Parameters.AddWithValue("@PaymentStatus", paymentStatus.ToString("d"));
cmd.CommandText = SQL;
base.ExecuteNonQuery(cmd);
return true;
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}