public IActionPlanDto GetActionPlan(int actionPlanID) { string command = "SELECT * FROM actionplan WHERE ActionPlanID='{0}';"; IActionPlanDto actionPlan = new ActionPlanDto(); using (MySqlConnection conn = Connection.GetConnection()) { conn.Open(); MySqlCommand cmd = new MySqlCommand(string.Format(command, actionPlanID.ToString()), conn); using MySqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { actionPlan = new ActionPlanDto() { ActionPlanID = Convert.ToInt32(reader["ActionPlanID"]), AccountID = Convert.ToInt32(reader["AccountID"]), PlanTitle = reader["PlanTitle"].ToString(), PlanMessage = reader["PlanMessage"].ToString(), PlanCategory = reader["PlanCategory"].ToString(), PlanDateCreated = Convert.ToDateTime(reader["PlanDateCreated"]) }; } } return(actionPlan); }
public async Task <ActionPlanDto> GetActionPlanAsync(Guid id, CancellationToken ct) { ActionPlan ActionPlanEntity = await _uow.ActionPlan.GetActionPlanAsync(id, ct); ActionPlanDto ActionPlanDto = _mapper.Mapper.Map <ActionPlanDto>(ActionPlanEntity); return(ActionPlanDto); }