public static async Task <HttpResponseMessage> CompetitorReadAsync(
[HttpTrigger(AuthorizationLevel.Function, "get", Route = "competitor/read")] HttpRequest req,
ILogger log)
{
log.LogInformation("CompetitorReadAsync request");
var ret = new CompetitorResponse();
try
{
var res = await StellaRepository.CompetitorReadAsync();
ret.code = 1;
ret.data = new Competitor()
{
luna_email = res.luna_email,
reg_dt = res.reg_dt,
content = res.content
};
}
catch (MySqlException ex)
{
ret.code = 2;
ret.message = ex.Message;
}
catch (Exception ex)
{
ret.code = 3;
ret.message = ex.Message;
}
return(ret.ObjectToHttpMessage());
}
public CompetitorResponse InsertUpdateCompetitorMaster
(CompetitorMaster competitorMaster)
{
try
{
Log.Info("Started call to InsertUpdateCompetitorMaster");
Log.Info("parameter values"
+ JsonConvert.SerializeObject(competitorMaster));
Command.CommandText = "SP_COMPETITOR_MANAGER";
Command.CommandType = CommandType.StoredProcedure;
Command.Parameters.Clear();
Command.Parameters.AddWithValue("@COMPETITOR_XML"
, GetXMLFromObject(competitorMaster));
if (competitorMaster.AddedBy.HasValue)
{
Command.Parameters.AddWithValue("@USER_ID", competitorMaster.AddedBy.Value);
}
else if (competitorMaster.ModifiedBy.HasValue)
{
Command.Parameters.AddWithValue("@USER_ID", competitorMaster.ModifiedBy.Value);
}
Connection.Open();
SqlDataReader reader = Command.ExecuteReader();
CompetitorResponse result = new CompetitorResponse();
if (reader.HasRows)
{
while (reader.Read())
{
result = new CompetitorResponse
{
Id = Convert.ToInt32(reader["Id"].ToString()),
Message = reader["ReturnMessage"] != DBNull.Value ? reader["ReturnMessage"].ToString() : null,
IsSuccess = Convert.ToBoolean(reader["Result"].ToString())
};
}
}
Log.Info("End call to InsertUpdateCompetitorMaster. Result:"
+ JsonConvert.SerializeObject(result));
return(result);
}
catch (Exception ex)
{
Log.Error("Error in InsertUpdateCompetitorMaster. Error:"
+ JsonConvert.SerializeObject(ex));
LogError(ex);
throw;
}
finally
{
Connection.Close();
}
}
