public IEnumerable <eFuncionarios> GetFuncionarios()
{
eFuncionarios item;
var func = new List <eFuncionarios>();
string cmmd = "SELECT ...";
var conn = new DAL();
try
{
DataTable dt = DAL.dtaGet(cmmd);
for (int i = 0; i < dt.Rows.Count; i++)
{
item = new eFuncionarios()
{
eIdFunc = Int32.Parse(dt.Rows[i]["IDFUNC"].ToString()),
eNome = dt.Rows[i]["NOME"].ToString(),
eDepto = Int32.Parse(dt.Rows[i]["DEPTO"].ToString()),
eFuncao = dt.Rows[i]["FUNCAO"].ToString(),
eSalario = Double.Parse(dt.Rows[i]["SALARIO"].ToString()),
};
func.Add(item);
}
_funcionarios = func;
return(_funcionarios);
}
catch (SqlException sqlex)
{
throw sqlex;
}
catch (Exception ex)
{
throw ex;
}
finally
{
conn.Close();
}
}
public void UpdateFuncionarios(eFuncionarios func)
{
string cmmd = $"UPDATE ...";
var conn = new DAL();
try
{
conn.Set(cmmd);
}
catch (SqlException sqlex)
{
throw sqlex;
}
catch (Exception ex)
{
throw ex;
}
finally
{
conn.Close();
}
}
public void InsertFuncionarios(eFuncionarios func)
{
string cmmd = $"INSERT INTO ...";
var conn = new DAL();
try
{
conn.Set(cmmd);
}
catch (SqlException sqlex)
{
throw sqlex;
}
catch (Exception ex)
{
throw ex;
}
finally
{
conn.Close();
}
}
void IDisposable.Dispose()
{
objDAL.Close();
GC.SuppressFinalize(this);
}