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); }
private void ProcessData(AgentDataNew agent) { var requestdata = RequestBody(agent); Console.WriteLine("requestdata :: " + requestdata); if (requestdata == null) { return; } int?idprofile = null; var taspenApi = new TaspenApi(); var responsedata = taspenApi.CreateNewAgent(requestdata); Console.WriteLine("responsedata :: " + responsedata); if (responsedata != null) { var agentDto = JsonConvert.DeserializeObject <AgentDto>(responsedata); if (agentDto?.listAgentProfile != null) { idprofile = agentDto.listAgentProfile.id; } } var payeeid = int.Parse(agent.PayeeID, NumberStyles.AllowLeadingWhite | NumberStyles.AllowTrailingWhite); var data = new LogAgentDataNew() { IDAGENT = payeeid, CREATEDDATE = DateTime.Now, REQUESTDATA = requestdata, RESPONSEDATA = responsedata, IDPROFILE = idprofile }; Console.WriteLine("IDAGENT : " + payeeid); Console.WriteLine("IDPROFILE : " + idprofile); var logDao = new LogAgentDataNewDao(); logDao.Create(data); }
public List <AgentDataNew> GetListAgentDelete() { SqlConnectionStringBuilder builder = ConnectionStringBuilder.GetConnectionStringBuilder(); try { //sql connection object using (SqlConnection connection = new SqlConnection(builder.ConnectionString)) { //retrieve the SQL Server instance version var query = @"SELECT e.PayeeID, e.Name, e.JoinDate, e.Title, e.EmailAddress, e.Address, e.RecruitBy, e.RecruiterName, e.AMCode, e.AMName, e.SAMCode, e.SAMName, e.ADCode, e.ADNAme, e.GAOfficeCode, e.GAOfficeName, e.PERSON_ID, e.LicenseID, e.Phone, e.EmployeeStatus, e.TerminationComments, e.AccountNo, e.BankCode, e.ExpiryDate, e.TerminationDate, e.CreatedDate, e.UpdatedDate, e.DeletedDate FROM AGENTDATANEW e WHERE e.CreatedDate IS NOT NULL AND e.UpdatedDate IS NOT NULL AND e.DeletedDate IS NOT NULL ORDER BY e.DeletedDate DESC ;"; //define the SqlCommand object SqlCommand cmd = new SqlCommand(query, connection); //open connection connection.Open(); //execute the SQLCommand SqlDataReader dr = cmd.ExecuteReader(); //check if there are records List <AgentDataNew> result = new List <AgentDataNew>(); if (dr.HasRows) { while (dr.Read()) { AgentDataNew data = new AgentDataNew(); data.PayeeID = SafeGetString(dr, 0); data.Name = SafeGetString(dr, 1); data.JoinDate = SafeGetDatetime(dr, 2); data.Title = SafeGetString(dr, 3); data.EmailAddress = SafeGetString(dr, 4); data.Address = SafeGetString(dr, 5); data.RecruitBy = SafeGetString(dr, 6); data.RecruiterName = SafeGetString(dr, 7); data.AMCode = SafeGetString(dr, 8); data.AMName = SafeGetString(dr, 9); data.SAMCode = SafeGetString(dr, 10); data.SAMName = SafeGetString(dr, 11); data.ADCode = SafeGetString(dr, 12); data.ADNAme = SafeGetString(dr, 13); data.GAOfficeCode = SafeGetString(dr, 14); data.GAOfficeName = SafeGetString(dr, 15); data.PERSON_ID = SafeGetString(dr, 16); data.LicenseID = SafeGetString(dr, 17); data.Phone = SafeGetString(dr, 18); data.EmployeeStatus = SafeGetString(dr, 19); data.TerminationComments = SafeGetString(dr, 20); data.AccountNo = SafeGetString(dr, 21); data.BankCode = SafeGetString(dr, 22); data.ExpiryDate = SafeGetDatetime(dr, 23); data.TerminationDate = SafeGetDatetime(dr, 24); data.CreatedDate = SafeGetDatetime(dr, 25); data.UpdatedDate = SafeGetDatetime(dr, 26); data.DeletedDate = SafeGetDatetime(dr, 27); result.Add(data); } } //close data reader dr.Close(); //close connection connection.Close(); if (result.Count > 0) { return(result); } } } catch (Exception ex) { //display error message Console.WriteLine("Exception: " + ex.Message); } return(null); }
private string RequestBody(AgentDataNew agent) { var payeeid = int.Parse(agent.PayeeID, NumberStyles.AllowLeadingWhite | NumberStyles.AllowTrailingWhite); var nameAgentPosition = agent.Title; var taspenApi = new TaspenApi(); var resultAgentPosition = taspenApi.SearchAgentPosition(nameAgentPosition); var agentPositionDto = JsonConvert.DeserializeObject <AgentPositionDto>(resultAgentPosition); if (agentPositionDto == null) { return(null); } Console.WriteLine("agentPositionDto - ok :: " + nameAgentPosition); if (agentPositionDto.PositionMetaDto?.PositionMetaPaginationDto == null || agentPositionDto.PositionMetaDto.PositionMetaPaginationDto.Total == 0) { return(null); } Console.WriteLine("PositionMetaPaginationDto - ok"); var positionAgentDto = agentPositionDto.ListAgentPosition.FirstOrDefault(); if (positionAgentDto == null) { return(null); } var licenseExpireAt = agent.ExpiryDate != null ? agent.ExpiryDate.GetValueOrDefault().ToString("yyyy-MM-dd") : "-"; // var licenseExpireAt = agent.ExpiryDate; Console.WriteLine("licenseExpireAt --> " + licenseExpireAt); Console.WriteLine("payeeid --> " + payeeid); var licenseNumber = agent.LicenseID != null && agent.LicenseID.Trim().Length > 0 ? agent.LicenseID : "-"; var licenseStatus = ""; if (agent.EmployeeStatus != null && agent.EmployeeStatus.StartsWith("A") && licenseNumber != null && !"-".Equals(licenseNumber) && !"-".Equals(licenseExpireAt)) { licenseStatus = "valid"; } var dto = new AgentNewPayloadDTO { instanceId = taspenApi.FindByInstanceProfileName("JAKARTA"), code = agent.PayeeID, name = agent.Name, // address = agent.Address, //20 Sept 2021: Address diganti GA Office Name address = agent.GAOfficeName != null && agent.GAOfficeName.Trim().Length > 0 ? agent.GAOfficeName : "", phone = agent.Phone != null && agent.Phone.Trim().Length > 0 ? agent.Phone : "-", email = agent.EmailAddress != null && agent.EmailAddress.Trim().Length > 0 ? agent.EmailAddress : "-", positionId = positionAgentDto.Id, licenseNumber = licenseNumber, licenseDate = "-", licenseExpireAt = licenseExpireAt, licenseStatus = licenseStatus }; var payload = new AgentNewPayload { agentProfile = dto }; var jsonString = JsonConvert.SerializeObject(payload); return(jsonString); }
private string RequestBody(AgentDataNew agent) { var nameAgentPosition = agent.Title; var taspenApi = new TaspenApi(); var resultAgentPosition = taspenApi.SearchAgentPosition(nameAgentPosition); var agentPositionDto = JsonConvert.DeserializeObject <AgentPositionDto>(resultAgentPosition); if (agentPositionDto == null) { return(null); } if (agentPositionDto.PositionMetaDto?.PositionMetaPaginationDto == null || agentPositionDto.PositionMetaDto.PositionMetaPaginationDto.Total == 0) { return(null); } var positionAgentDto = agentPositionDto.ListAgentPosition.FirstOrDefault(); if (positionAgentDto == null) { return(null); } var licenseExpireAt = agent.ExpiryDate != null ? agent.ExpiryDate.GetValueOrDefault().ToString("yyyy-MM-dd") : "-"; // var licenseExpireAt = agent.ExpiryDate; var licenseNumber = agent.LicenseID != null && agent.LicenseID.Trim().Length > 0 ? agent.LicenseID : "-"; var licenseStatus = ""; if (agent.EmployeeStatus != null && agent.EmployeeStatus.StartsWith("A") && licenseNumber != null && !"-".Equals(licenseNumber) && !"-".Equals(licenseExpireAt)) { licenseStatus = "valid"; } var dto = new AgentNewPayloadDTO(); dto.instanceId = 2; //TODO (saat ini di set default = 2) dto.code = agent.PayeeID; dto.name = agent.Name; // dto.address = agent.Address; // address = agent.Address, //20 Sept 2021: Address diganti GA Office Name dto.address = agent.GAOfficeName != null && agent.GAOfficeName.Trim().Length > 0 ? agent.GAOfficeName : ""; dto.phone = agent.Phone != null && agent.Phone.Trim().Length > 0 ? agent.Phone : "-"; dto.email = agent.EmailAddress != null && agent.EmailAddress.Trim().Length > 0 ? agent.EmailAddress : "-"; dto.positionId = positionAgentDto.Id; //TODO dto.licenseNumber = licenseNumber; dto.licenseDate = "-"; dto.licenseExpireAt = licenseExpireAt; dto.licenseStatus = licenseStatus; Console.WriteLine("licenseExpireAt --> " + licenseExpireAt); Console.WriteLine("code --> " + dto.code); var payload = new AgentNewPayload(); payload.agentProfile = dto; var jsonString = JsonConvert.SerializeObject(payload); return(jsonString); }