public void Add(Domain.Models.Company company)
{
connection.Open();
string sqlExp = $"Insert into Companies(Title, OrganisationalForm) Values('{company.Title}','{company.OrganisationalForm}')";
SqlCommand command = new SqlCommand(sqlExp, connection);
command.ExecuteNonQuery();
connection.Close();
}
public void Edit(Domain.Models.Company company)
{
connection.Open();
string sqlExp = $"Update Companies SET Title='{company.Title}', OrganisationalForm = '{company.OrganisationalForm}' WHERE Id={company.Id}";
SqlCommand command = new SqlCommand(sqlExp, connection);
command.ExecuteNonQuery();
connection.Close();
}
public IActionResult Add(Domain.Models.Company company)
{
if (ModelState.IsValid)
{
companyDomainService.Add(company);
return(RedirectToAction("Index"));
}
return(View("Edit", company));
}
public Domain.Models.Company Get(int id)
{
connection.Open();
string sqlExp = $"Select * FROM Companies WHERE Id={id}";
SqlCommand command = new SqlCommand(sqlExp, connection);
var reader = command.ExecuteReader();
reader.Read();
var company = new Domain.Models.Company
{
Id = reader.GetInt32(0),
Title = reader.GetString(1),
OrganisationalForm = reader.GetString(2),
};
connection.Close();
return(company);
}
public void EditCompany(Domain.Models.Company company, Guid id)
{
_companyService.EditCompany(company, id);
}
public Guid AddCompany(Domain.Models.Company company)
{
return(_companyService.AddCompany(company));
}
