public void UpdateAgent(AgentDataNew agent, int?idprofile)
{
if (idprofile == null)
{
return;
}
var payeeid = int.Parse(agent.PayeeID,
NumberStyles.AllowLeadingWhite | NumberStyles.AllowTrailingWhite); // returns 100
var dao = new LogAgentDataUpdateDao();
var data = dao.FindById(payeeid);
if (data != null)
{
//update
var requestdata = RequestBody(agent);
var taspenApi = new TaspenApi();
var responsedata = taspenApi.UpdateAgent(requestdata, (int)idprofile);
data.REQUESTDATA = requestdata;
data.RESPONSEDATA = responsedata;
data.CREATEDDATE = DateTime.Now;
dao.Update(data);
}
else
{
//create new
var requestdata = RequestBody(agent);
var taspenApi = new TaspenApi();
var responsedata = taspenApi.UpdateAgent(requestdata, (int)idprofile);
data = new LogAgentDataUpdate();
data.IDAGENT = payeeid;
data.REQUESTDATA = requestdata;
data.RESPONSEDATA = responsedata;
data.CREATEDDATE = DateTime.Now;
dao.Create(data);
}
LogAgentDataUpdateHistoryDao historyDao = new LogAgentDataUpdateHistoryDao();
var history = new LogAgentDataUpdateHistory();
history.IDAGENT = data.IDAGENT;
history.REQUESTDATA = data.REQUESTDATA;
history.RESPONSEDATA = data.RESPONSEDATA;
history.CREATEDDATE = DateTime.Now;
historyDao.Create(history);
}
public void Create(LogAgentDataUpdateHistory entity)
{
SqlConnectionStringBuilder builder = ConnectionStringBuilder.GetConnectionStringBuilder();
using (SqlConnection connection = new SqlConnection(builder.ConnectionString))
{
string sql = "INSERT INTO LOG_AGENTDATAUPDATEHISTORY(IDAGENT, REQUESTDATA,RESPONSEDATA) VALUES(@p_idagent, @p_requestdata, @p_responsedata)";
SqlCommand cmd = new SqlCommand(sql, connection);
connection.Open();
cmd.Parameters.Add("@p_idagent", SqlDbType.Int).Value = entity.IDAGENT;
cmd.Parameters.Add("@p_requestdata", SqlDbType.VarChar).Value = entity.REQUESTDATA;
cmd.Parameters.Add("@p_responsedata", SqlDbType.VarChar).Value = entity.RESPONSEDATA;
cmd.CommandType = CommandType.Text;
cmd.ExecuteNonQuery();
connection.Close();
}
}
