public ED_Contact GetContactInfo(int unID) { ED_Contact contact = null; var cmd = new OracleCommand("external_data.pkg_external_data.GET_CONTACT_INFO"); cmd.Parameters.Add("P_UN_ID", OracleDbType.Int32).Value = unID; cmd.Parameters.Add("P_OUT_CURS", OracleDbType.RefCursor).Direction = ParameterDirection.Output; cmd.CommandType = CommandType.StoredProcedure; string error; new OracleDb <PKG_EXTERNAL_DATA>().ProcessEachRow(cmd, out error, delegate(OracleDataReader reader) { contact = new ED_Contact { UN_ID = int.Parse(reader["UN_ID"].ToString()), PHONE = reader["USER_PHONE"].ToString(), EMAIL = reader["USER_EMAIL"].ToString() }; }); if (!string.IsNullOrEmpty(error)) { throw new Exception(); } return(contact); }
//[Route("SaveContact")] public HttpResponseMessage SaveContactInfo([FromBody] ED_Contact contact) { if (contact != null) { DataProviderManager <PKG_EXTERNAL_DATA> .Provider.SaveContactInfo(AuthUser.UnID, contact.PHONE, contact.EMAIL); return(Success("Info Saved")); } return(Success("")); }