public MomoTransaction GetMomoTransactionByRefNo(string ref_number) { using (var command = new SqlCommand()) { command.CommandText = "usp_Get_Momo_Transaction_RefNo"; command.Parameters.AddWithValue("@refNo", ref_number); var dt = GetData(command); if (dt != null && dt.Rows.Count > 0) { var r = dt.Rows[0]; var transaction = new MomoTransaction { EntryID = (int)r["EntryID"], RefNo = r["RefNo"].ToString(), Amount = Convert.ToDecimal(r["Amount"]), MomoNumber = r["MomoNumber"].ToString(), MNO = r["MNO"].ToString(), LastUpdated = r["LastUpdated"].ToString() }; return(transaction); } return(null); } }
//Add or Post Transactions public string PostMomoTransaction(MomoTransaction transaction) { string msg = ""; try { var last_accessed = DateTime.Now; using (var command = new SqlCommand()) { command.CommandText = "[usp_Momo_LoanRepayment]"; command.Parameters.AddWithValue("@RefNo ", transaction.RefNo); command.Parameters.AddWithValue("@MomoNumber ", transaction.MomoNumber); command.Parameters.AddWithValue("@MNO ", transaction.MNO); command.Parameters.AddWithValue("@Amount", transaction.Amount); command.Parameters.AddWithValue("@TransactionID", transaction.TransactionID); var result = Save(command); msg = result; } } catch (Exception ex) { msg = ex.Message; } return(msg); }
internal void LogTransaction(MomoTransaction transaction, string message = "") { string msg = ""; try { var last_accessed = DateTime.Now; using (var command = new SqlCommand()) { command.CommandText = "[usp_SaveTransactionLog]"; command.Parameters.AddWithValue("@RefNo ", transaction.RefNo); command.Parameters.AddWithValue("@MomoNumber ", transaction.MomoNumber); command.Parameters.AddWithValue("@MNO ", transaction.MNO); command.Parameters.AddWithValue("@Amount", transaction.Amount); command.Parameters.AddWithValue("@TransactionID", transaction.TransactionID); command.Parameters.AddWithValue("@ResponseMsg", message); var result = Save(command); msg = result; } } catch (Exception ex) { msg = ex.Message; } }