public async Task <AgendaSalaModel> Insert(AgendaSalaModel agendaSala)
{
try
{
using (SqlConnection conn = new SqlConnection(Configuration.Conn()))
{
conn.Open();
var queryParameters = new DynamicParameters();
queryParameters.Add("@SalaId", agendaSala.SalaId);
queryParameters.Add("@AgendamentoInicial", agendaSala.AgendamentoInicial);
queryParameters.Add("@AgendamentoFinal", agendaSala.AgendamentoFinal);
queryParameters.Add("@AgendamentoStatus", true);
agendaSala.SalaId = await conn.ExecuteScalarAsync <int>("AddAgendamentoSala", param : queryParameters,
commandType : CommandType.StoredProcedure);
return(agendaSala);
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public async Task <bool> GetVerificaAgendamento(AgendaSalaModel agendaSalaModel)
{
try
{
bool agendado = (await _agendaSalaProvider.GetVerificaAgendamento(agendaSalaModel));
return(agendado);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public async Task <bool> GetVerificaAgendamento(AgendaSalaModel agendaSalaModel)
{
var response = await _agendaSalaProvider.GetVerificaAgendamento(agendaSalaModel);
var jsonResponse = await response.Content.ReadAsStringAsync();
if (!response.IsSuccessStatusCode || jsonResponse.Contains("false"))
{
return(false);
}
return(true);
}
public async Task <AgendaSalaModel> Insert(AgendaSalaModel agendaSala)
{
try
{
var agendasalaManager = await _agendaSalaProvider.Insert(agendaSala);
return(agendasalaManager);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public async Task <AgendaSalaModel> Insert(AgendaSalaModel agendaSala)
{
var response = await _agendaSalaProvider.Post(agendaSala);
if (!response.IsSuccessStatusCode)
{
await ErrorResponse(response, "Post");
}
var json = await response.Content.ReadAsStringAsync();
JObject jsonParse = JObject.Parse(json);
var objectCliente = JsonConvert.DeserializeObject(jsonParse.ToString());
var _sala = await Task.Factory.StartNew(() => JsonConvert.DeserializeObject <AgendaSalaModel>(objectCliente.ToString()));
return(_sala);
}
public async Task <bool> GetVerificaAgendamento(AgendaSalaModel agendaSalaModel)
{
bool agendado = false;
var parameters = new DynamicParameters();
parameters.Add("@salaId", agendaSalaModel.SalaId);
parameters.Add("@DataInicial", agendaSalaModel.AgendamentoInicial);
parameters.Add("@DataFinal", agendaSalaModel.AgendamentoFinal);
try
{
using (SqlConnection conn = new SqlConnection(Configuration.Conn()))
{
conn.Open();
agendado = (await conn.ExecuteScalarAsync <bool>("VerificaAgendamentoSala", parameters, commandType: CommandType.StoredProcedure));
return(agendado);
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public async Task <HttpResponseMessage> Post(AgendaSalaModel agendasala) => await new HttpClientHelper(_client) .SetEndpoint($"Post") .WithContentSerialized(agendasala) .PostAsync();
public async Task <HttpResponseMessage> GetVerificaAgendamento(AgendaSalaModel agendaSalaModel) => await new HttpClientHelper(_client) .SetEndpoint($"GetSalaAgendada") .WithContentSerialized(agendaSalaModel) .PostAsync();
