public string EmailFuncionario(Entity.tb_login log)
{
DataBase.Entity.db_a4f62c_oticaEntities db = new DataBase.Entity.db_a4f62c_oticaEntities();
string email = db.tb_login.FirstOrDefault(x => x.id_login == log.id_login).nm_usuario;
return(email);
}
public byte[] ConsultarFotoUsuario(DataBase.Entity.tb_login usuario)
{
DataBase.Entity.db_a4f62c_oticaEntities db = new DataBase.Entity.db_a4f62c_oticaEntities();
byte[] img = (byte[])db.tb_login.FirstOrDefault(a => a.nm_email == usuario.nm_email).ft_usuario;
if (img == null)
{
throw new ArgumentException("Erro tente novamente.");
}
return(img);
}
private void timer1_Tick(object sender, EventArgs e)
{
Telas.FrmLoginOtica tela = new FrmLoginOtica();
tela.Show();
DataBase.Entity.db_a4f62c_oticaEntities db = new DataBase.Entity.db_a4f62c_oticaEntities();
db.tb_login.Where(x => x.id_login > 0);
timer1.Stop();
Hide();
}
public double CalcularHorasExtras(int funcionario, DateTime mes)
{
DataBase.Entity.db_a4f62c_oticaEntities db = new DataBase.Entity.db_a4f62c_oticaEntities();
var pontos =
db.tb_ponto.Where(x => x.id_funcionario == funcionario && x.dt_entrada.Month == mes.Month).ToList();
var horasExtras =
pontos.Select(x => (x.dt_saida.Value.TimeOfDay
-
x.tb_funcionario.tb_jornada.First().hr_saida.Value
).TotalHours)
.Sum();
return(horasExtras);
}
