public Company GetStudentById(int companyId)
{
SqlConnection connection = new SqlConnection(connectionString);
string query = "SELECT * FROM company WHERE company_id = '" + companyId + "'";
SqlCommand command = new SqlCommand(query, connection);
connection.Open();
SqlDataReader reader = command.ExecuteReader();
Company company = null;
while (reader.Read())
{
if (company == null)
{
company = new Company();
}
company.CompanyId = int.Parse(reader["company_id"].ToString());
company.Name = reader["company_name"].ToString();
company.Address = reader["address"].ToString();
}
reader.Close();
connection.Close();
return company;
}
public void Delete(Company company)
{
SqlConnection connection = new SqlConnection(connectionString);
string query = "Delete from company WHERE company_id =" + company.CompanyId;
SqlCommand command = new SqlCommand(query, connection);
connection.Open();
command.ExecuteNonQuery();
connection.Close();
}
public void Update(Company company)
{
myCompanyGateway.Update(company);
//MessageBox.Show("Update Success");
}
public bool Save(Company company)
{
return myCompanyGateway.Save(company) > 0;
}
public void Delete(Company company)
{
myCompanyGateway.Delete(company);
}
public int Save(Company company)
{
SqlConnection sqlConnection = new SqlConnection(connectionString);
string query = "INSERT INTO company VALUES('" + company.Name + "','" + company.Address + "')";
SqlCommand sqlCommand = new SqlCommand(query, sqlConnection);
sqlConnection.Open();
int rowAffected = sqlCommand.ExecuteNonQuery();
sqlConnection.Close();
return rowAffected;
}
public void Update(Company company)
{
SqlConnection connection = new SqlConnection(connectionString);
string query = "UPDATE company SET company_name = '" + company.Name + "', address= '" + company.Address + "' WHERE company_id =" + company.CompanyId;
SqlCommand command = new SqlCommand(query, connection);
connection.Open();
command.ExecuteNonQuery();
connection.Close();
}
public List<Company> ShowAll()
{
List<Company> companieslList = new List<Company>();
SqlConnection sqlConnection = new SqlConnection(connectionString);
string query = "SELECT * FROM company";
SqlCommand command = new SqlCommand(query, sqlConnection);
sqlConnection.Open();
SqlDataReader myReader = command.ExecuteReader();
while (myReader.Read())
{
Company company = new Company();
company.CompanyId = Convert.ToInt32(myReader["company_id"].ToString());
company.Name = myReader["company_name"].ToString();
company.Address = myReader["address"].ToString();
companieslList.Add(company);
}
return companieslList;
}
