public async Task <List <string> > GetCompanyAllNameDataSqlAsync()
{
try
{
List <string> workers = new List <string>();
ReadDb db = new ReadDb();
string QueryString = "select Company.NameCompany from Company";
using (SqlConnection connection = new SqlConnection(connectionString))
{
await connection.OpenAsync();
SqlCommand command = new SqlCommand(QueryString, connection);
using (SqlDataReader sdr = command.ExecuteReader())
{
while (sdr.Read())
{
workers.Add(sdr["NameCompany"].ToString());
}
}
return(workers);
}
}
catch (Exception ex)
{
return(new List <string>());
}
}
public async Task <List <ItemWorker> > GetWorlerDataSqlAsync(string id = "%")
{
try
{
List <ItemWorker> workers = new List <ItemWorker>();
ReadDb db = new ReadDb();
string QueryString = "select Worker.IdTable, Worker.Surname, Worker._Name, Worker.Patronymic, Worker.EmploymentDate, Position._Name as '_NamePos', Company.NameCompany" +
" from Worker" +
" join Position on Worker.PositionId = Position.IdTable" +
" join Company on Worker.CompanyId = Company.IdTable" +
" where Worker.IdTable like '" + id + "'";
using (SqlConnection connection = new SqlConnection(connectionString))
{
await connection.OpenAsync();
SqlCommand command = new SqlCommand(QueryString, connection);
using (SqlDataReader sdr = command.ExecuteReader())
{
while (sdr.Read())
{
ItemWorker worker = new ItemWorker();
worker.IdTable = Convert.ToInt32(sdr["IdTable"]);
worker.Surname = sdr["Surname"].ToString();
worker._Name = sdr["_Name"].ToString();
worker.Patronymic = sdr["Patronymic"].ToString();
worker.EmploymentDate = DateTime.Parse(sdr["EmploymentDate"].ToString());
worker.Position = sdr["_NamePos"].ToString();
worker.Company = sdr["NameCompany"].ToString();
workers.Add(worker);
}
}
return(workers);
}
}
catch (Exception ex)
{
return(new List <ItemWorker>());
}
}
public async Task <List <ItemCompany> > GetCompanyDataSqlAsync()
{
try
{
List <ItemCompany> workers = new List <ItemCompany>();
ReadDb db = new ReadDb();
string QueryString = "select Company.IdTable, Company.NameCompany, CompanySize._Name as 'CompanySize', FormOfIncorporation._Name as 'FormOfIncorporation'" +
" from Company" +
" join FormOfIncorporation on Company.FormOfIncorporationId = FormOfIncorporation.IdTable" +
" join CompanySize on Company.CompanySizeId = CompanySize.IdTable";
using (SqlConnection connection = new SqlConnection(connectionString))
{
await connection.OpenAsync();
SqlCommand command = new SqlCommand(QueryString, connection);
using (SqlDataReader sdr = command.ExecuteReader())
{
while (sdr.Read())
{
ItemCompany worker = new ItemCompany();
worker.IdTable = Convert.ToInt32(sdr["IdTable"]);
worker.NameCompany = sdr["NameCompany"].ToString();
worker.CompanySize = sdr["CompanySize"].ToString();
worker.FormOfIncorporation = sdr["FormOfIncorporation"].ToString();
workers.Add(worker);
}
}
return(workers);
}
}
catch (Exception ex)
{
return(new List <ItemCompany>());
}
}