public ServicoVM GetServico(int?Id)
{
try
{
Open();
var servicoVM = new ServicoVM();
string selectEditServico = @"SELECT* FROM SERVICO WHERE IdServico =" + Id;
SQL = new SqlCommand(selectEditServico, sqlconnection);
Dr = SQL.ExecuteReader();
while (Dr.Read())
{
servicoVM.IdServico = Convert.ToInt32(Dr["IdServico"]);
servicoVM.dsServico = Dr["dsServico"].ToString();
servicoVM.vlServico = Dr["vlServico"] == DBNull.Value ? 0 : Convert.ToDecimal(Dr["vlServico"]);
servicoVM.dtCadastro = Dr["dtCadastro"] == DBNull.Value ? DateTime.Now : Convert.ToDateTime(Dr["dtCadastro"]);
servicoVM.dtUltAlteracao = Dr["dtUltAlteracao"] == DBNull.Value ? DateTime.Now : Convert.ToDateTime(Dr["dtUltAlteracao"]);
}
return(servicoVM);
}
catch (Exception e)
{
throw new Exception("Erro ao selecionar o Serviço: " + e.Message);
}
finally
{
Close();
}
}
private void dataBuscar_ValueChanged(object sender, EventArgs e)
{
gridEscala.DataSource = null;
this.servico = this.repository.Servicos.obterUltimoPor(dataBuscar.Value);
if (!(servico is null))
{
gridEscala.DataSource = servico.Contigentes;
}
}
public Grid(IRepository _repository)
{
InitializeComponent();
this.repository = _repository;
this.servico = this.repository.Servicos.obterUltimoPor(dataBuscar.Value);
if (!(servico is null))
{
gridEscala.DataSource = servico.Contigentes;
}
}
public int ObterSeContigenteApto(ContingenteVM contigente, int tipoServico, DateTime dataAtualServico)
{
int punicao = repository.JusticasOuDisciplinas
.ObterContigente(contigente.Id, Acao.Punição, dataAtualServico).Count;
int justica = repository.JusticasOuDisciplinas
.ObterContigente(contigente.Id, Acao.Elogio, dataAtualServico).Count;
List <ServicoVM> listaServicos = repository.Servicos.obterUltimoPor(contigente.Id, tipoServico);
ServicoVM ultimoServico = listaServicos.Count > 0 ? listaServicos.First() : null;
float prioridade = 0f;
float ultimoDiaSemanaServico = 0f;
float diaAtualSemanaServico = (float)dataAtualServico.DayOfWeek;
if (!(ultimoServico is null))
{
int qtdDias = (int)(dataAtualServico.Date - ultimoServico.Data.Date).TotalDays;
prioridade = (float)(1 / (1 + Math.Exp(qtdDias * (-1))));
ultimoDiaSemanaServico = (float)ultimoServico.Data.DayOfWeek;
}
