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