//Add or Post Transactions public string PostMomoTransaction(MomoTransaction momoTransaction) { string msg = ""; try { var last_accessed = DateTime.Now; using (var command = new SqlCommand()) { command.CommandText = "[usp_Momo_LoanRepayment]"; command.Parameters.AddWithValue("@RefNo ", momoTransaction.CUSTOMERREFERENCEID); command.Parameters.AddWithValue("@MomoNumber ", momoTransaction.MSISDN); command.Parameters.AddWithValue("@Amount", momoTransaction.AMOUNT); command.Parameters.AddWithValue("@TransactionID", momoTransaction.TXNID); command.Parameters.AddWithValue("@Type", momoTransaction.TYPE); command.Parameters.AddWithValue("@CompanyName", momoTransaction.COMPANYNAME); command.Parameters.AddWithValue("@ReferenceID", momoTransaction.RefID); command.Parameters.AddWithValue("@MNO ", momoTransaction.MNO); var result = Save(command); msg = result; } } catch (Exception ex) { msg = ex.Message; } return(msg); }
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"], CUSTOMERREFERENCEID = r["RefNo"].ToString(), AMOUNT = Convert.ToDecimal(r["Amount"]), MSISDN = r["MomoNumber"].ToString(), MNO = r["MNO"].ToString() }; return(transaction); } return(null); } }