//Return all corporations public List <CorporationModel> index() { CorporationModel corporation; List <CorporationModel> corporations = new List <CorporationModel>(); connection.Connect(); SqlCommand sqlCommand = new SqlCommand("select * from corporation", connection.getConnection()); SqlDataReader reader = sqlCommand.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { corporation = new CorporationModel(); corporation.id = Convert.ToInt32(reader["id"]); corporation.name = reader["name"].ToString(); corporation.address = reader["address"].ToString(); corporation.zip = reader["zip"].ToString(); corporation.email = reader["email"].ToString(); corporations.Add(corporation); } } connection.disConnect(); return(corporations); }
// Return a corporation public CorporationModel find(int id) { CorporationModel corporation = new CorporationModel(); connection.Connect(); SqlCommand sqlCommand = new SqlCommand("select id, email, name, address, zip from corporation where id = @id", connection.getConnection()); sqlCommand.Parameters.AddWithValue("@id", id); SqlDataReader reader = sqlCommand.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { corporation.id = Convert.ToInt32(reader["id"]); corporation.email = reader["email"].ToString(); corporation.name = reader["name"].ToString(); corporation.address = reader["address"].ToString(); corporation.zip = reader["zip"].ToString(); } } connection.disConnect(); return(corporation); }
//Update a corporation public void update(CorporationModel corporation) { connection.Connect(); SqlCommand sqlCommand = new SqlCommand("update corporation set email = @email, name = @name, address = @address, zip = @zip where id = @id", connection.getConnection()); sqlCommand.Parameters.AddWithValue("@email", corporation.email); sqlCommand.Parameters.AddWithValue("@name", corporation.name); sqlCommand.Parameters.AddWithValue("@address", corporation.address); sqlCommand.Parameters.AddWithValue("@zip", corporation.zip); sqlCommand.Parameters.AddWithValue("@id", corporation.id); sqlCommand.ExecuteNonQuery(); connection.disConnect(); }
//Store a corporation and trigger stored procedure so software is automatically stored public int store(CorporationModel corporation) { SqlCommand sqlCommand; sqlCommand = new SqlCommand("insert into corporation (email, name, address, zip) VALUES (@email, @name, @address, @zip) select scope_identity()", connection.getConnection()); connection.Connect(); sqlCommand.Parameters.AddWithValue("@email", corporation.email); sqlCommand.Parameters.AddWithValue("@name", corporation.name); sqlCommand.Parameters.AddWithValue("@address", corporation.address); sqlCommand.Parameters.AddWithValue("@zip", corporation.zip); sqlCommand.Connection = connection.getConnection(); int id = (int)(decimal)sqlCommand.ExecuteScalar(); sqlCommand = new SqlCommand("createSoftware", connection.getConnection()); sqlCommand.CommandType = CommandType.StoredProcedure; sqlCommand.Parameters.AddWithValue("@corporation_id", id); sqlCommand.ExecuteNonQuery(); connection.disConnect(); return(id); }