public LogAgentDataUpdate FindById(int id)
{
SqlConnectionStringBuilder builder = ConnectionStringBuilder.GetConnectionStringBuilder();
try
{
//sql connection object
using (SqlConnection connection = new SqlConnection(builder.ConnectionString))
{
string query = @"SELECT e.IDAGENT, e.REQUESTDATA, e.RESPONSEDATA, e.CREATEDDATE
FROM LOG_AGENTDATAUPDATE e
WHERE e.IDAGENT = @p_id ;";
SqlCommand cmd = new SqlCommand(query, connection);
var pid = new SqlParameter("p_id", SqlDbType.Int);
pid.Value = id;
cmd.Parameters.Add(pid);
connection.Open();
SqlDataReader dr = cmd.ExecuteReader();
var result = new List <LogAgentDataUpdate>();
if (dr.HasRows)
{
while (dr.Read())
{
var data = new LogAgentDataUpdate();
data.IDAGENT = dr.GetInt32(0);
data.REQUESTDATA = SafeGetString(dr, 1);
data.RESPONSEDATA = SafeGetString(dr, 2);
data.CREATEDDATE = SafeGetDatetime(dr, 3);
result.Add(data);
}
}
dr.Close();
connection.Close();
if (result.Count > 0)
{
return(result.FirstOrDefault());
}
}
}
catch (Exception ex)
{
Console.WriteLine("Exception: " + ex.Message);
}
return(null);
}
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(LogAgentDataUpdate entity)
{
SqlConnectionStringBuilder builder = ConnectionStringBuilder.GetConnectionStringBuilder();
using (SqlConnection connection = new SqlConnection(builder.ConnectionString))
{
string sql = "INSERT INTO LOG_AGENTDATAUPDATE(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.Parameters.Add("@p_createddate", SqlDbType.DateTime).Value = DateTime.Now;
cmd.CommandType = CommandType.Text;
cmd.ExecuteNonQuery();
connection.Close();
}
}
