private CsPrestaServico CsPrestaServico_Preencher()
{
try
{
CsPrestaServico csPrestaServico = new CsPrestaServico
{
FkEmpresa = CsEmpresa_Fk_Preencher(),
FkFuncionario = CsFuncionario_Fk_Preencher(),
DataRegistro = Convert.ToDateTime(DtDataRegistro.Text),
Entrada = Convert.ToDateTime(DtEntrada.Value.TimeOfDay.ToString()),
Intervalo = Convert.ToDateTime(DtIntervalo.Value.TimeOfDay.ToString()),
Saida = Convert.ToDateTime(DtSaida.Value.TimeOfDay.ToString()),
HorasTrabalhadas = Convert.ToDateTime(DtTotalHoras.Value.TimeOfDay.ToString()),
HorasExtras = Convert.ToDateTime(DtHoraExtra.Value.TimeOfDay.ToString()),
TotalHoras = Convert.ToDateTime(DtIntervalo.Value.TimeOfDay.ToString())
};
MessageBox.Show("" + Convert.ToDateTime(DtIntervalo.Value.TimeOfDay.ToString()) + " HorasExtras =" + Convert.ToDateTime(DtHoraExtra.Value.TimeOfDay.ToString()));
return(csPrestaServico);
}
catch (Exception exception)
{
MessageBox.Show("Ocorreu um erro, detalhes:" + exception.Message);
}
return(null);
}
public CsCollectionPrestaServico CsPrestaServicoParametroColecao_Returno(CommandType commandType, string oleDbCommand, string where, string name)
{
csPrestaServico = new CsPrestaServico();
csCollectionPrestaServico = new CsCollectionPrestaServico();
csCommand = new CsCommand();
csCommand.ParameterCollection_Clear();
if (!(String.IsNullOrEmpty(name)))
{
csCommand.ParameterCollection_Add("@Name", name);
}
DataTable dataTable = csCommand.ExecuteCommandConsult(commandType, oleDbCommand);
foreach (DataRow linha in dataTable.Rows)
{
csCollectionPrestaServico.Add(csPrestaServico.CsPrestaServicoDataGridView(linha));
}
return(csCollectionPrestaServico);
}
public void CsPrestaServicoParemetroColecao(CommandType commandType, string oleDbCommand, CsPrestaServico csPrestaServico)
{
csCommand = new CsCommand();
csCommand.ParameterCollection_Clear();
csCommand.ParameterCollection_Add("@FkEmpresa", csPrestaServico.FkEmpresa.Id);
csCommand.ParameterCollection_Add("@FkFuncionario", csPrestaServico.FkFuncionario.Id);
csCommand.ParameterCollection_Add("@DataDeRegistro", csPrestaServico.DataRegistro);
csCommand.ParameterCollection_Add("@Entrada", csPrestaServico.Entrada);
csCommand.ParameterCollection_Add("@Intervalo", csPrestaServico.Intervalo);
csCommand.ParameterCollection_Add("@Saida", csPrestaServico.Saida);
csCommand.ParameterCollection_Add("@HorasTrabalhadas", csPrestaServico.HorasTrabalhadas);
csCommand.ParameterCollection_Add("@HorasExtras", csPrestaServico.HorasExtras);
csCommand.ParameterCollection_Add("@TotalHoras", csPrestaServico.TotalHoras);
csCommand.ParameterCollection_Add("@Id", csPrestaServico.Id);
csCommand.ExecuteCommandNonQuery(commandType, oleDbCommand);
}
