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)); }