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(""));
}
