public void Insert(business2field business2field) { //business2field.BusinessFieldID = NextIdValue(); //_business2fields.Add(business2field); _ds.Insert(business2field); }
public List <business2field> Read() { List <business2field> business2fields = new List <business2field>(); using (SqlConnection connection = new SqlConnection(DataSettings.CONNECTION_STRING)) { connection.Open(); StringBuilder sb = new StringBuilder(); sb.Append("SELECT [BusinessFieldID],[Business],[Field]"); sb.Append("FROM [careerfair].[business2field]"); String sql = sb.ToString(); using (SqlCommand command = new SqlCommand(sql, connection)) { using (SqlDataReader reader = command.ExecuteReader()) { while (reader.Read()) { business2field business2field = new business2field(); business2field.BusinessFieldID = DatabaseHelper.CheckNullInt(reader, 0); business2field.Business = DatabaseHelper.CheckNullInt(reader, 1); business2field.Field = DatabaseHelper.CheckNullInt(reader, 2); business2fields.Add(business2field); } } } } return(business2fields); }
public void Update(business2field business2field) { var oldbusiness2field = _business2fields.Where(b => b.BusinessFieldID == business2field.BusinessFieldID).FirstOrDefault(); if (oldbusiness2field != null) { _business2fields.Remove(oldbusiness2field); _business2fields.Add(business2field); _ds.Update(business2field); } }
public void Remove(business2field business2field) { using (SqlConnection connection = new SqlConnection(DataSettings.CONNECTION_STRING)) { connection.Open(); StringBuilder sb = new StringBuilder(); sb.Append("DELETE FROM [careerfair].[business2field]"); sb.Append("WHERE [BusinessFieldID] = " + business2field.BusinessFieldID); String sql = sb.ToString(); using (SqlCommand command = new SqlCommand(sql, connection)) { command.CommandType = System.Data.CommandType.Text; command.ExecuteNonQuery(); } } }
private void Update(List <string> fields, int businessID) { using (TechCareerFair.DAL.Business2FieldDAL.Business2FieldDatabaseDataService ds = new Business2FieldDAL.Business2FieldDatabaseDataService()) { List <business2field> b2fs = ds.Read(); foreach (string name in fields) { business2field b2f = new business2field(); int fieldIndex = DatabaseHelper.GetFieldIndex(name); b2f.Business = businessID; b2f.Field = fieldIndex; ds.Update(b2f); } } }
public void Insert(business2field business2field) { using (SqlConnection connection = new SqlConnection(DataSettings.CONNECTION_STRING)) { connection.Open(); StringBuilder sb = new StringBuilder(); sb.Append("INSERT INTO [careerfair].[business2field]([Business],[Field])"); string values = "VALUES(@param1, @param2)"; sb.Append(values); String sql = sb.ToString(); using (SqlCommand command = new SqlCommand(sql, connection)) { command.Parameters.Add("@param1", SqlDbType.Int).Value = (object)business2field.Business ?? DBNull.Value; command.Parameters.Add("@param2", SqlDbType.Int).Value = (object)business2field.Field ?? DBNull.Value; command.CommandType = System.Data.CommandType.Text; command.ExecuteNonQuery(); } } }
public void Update(business2field business2field) { using (SqlConnection connection = new SqlConnection(DataSettings.CONNECTION_STRING)) { connection.Open(); StringBuilder sb = new StringBuilder(); sb.Append("UPDATE [careerfair].[business2field]"); sb.Append("SET [Business] = @param1, [Field] = @param2 "); sb.Append("WHERE [BusinessFieldID] = " + business2field.BusinessFieldID); String sql = sb.ToString(); using (SqlCommand command = new SqlCommand(sql, connection)) { command.Parameters.Add("@param1", SqlDbType.Int).Value = (object)business2field.Business ?? DBNull.Value; command.Parameters.Add("@param2", SqlDbType.Int).Value = (object)business2field.Field ?? DBNull.Value; command.CommandType = System.Data.CommandType.Text; command.ExecuteNonQuery(); } } }
private void Insert(List <string> fields, int businessID) { //insert field ID and business ID into new record of mapping table business2field using (TechCareerFair.DAL.Business2FieldDAL.Business2FieldDatabaseDataService ds = new Business2FieldDAL.Business2FieldDatabaseDataService()) { List <business2field> b2fs = ds.Read(); foreach (string name in fields) { business2field b2f = new business2field(); int fieldIndex = DatabaseHelper.GetFieldIndex(name); b2f.Business = businessID; b2f.Field = fieldIndex; if (b2fs.Where(b => b.Field == fieldIndex).Where(b => b.Business == businessID).Count() == 0) { ds.Insert(b2f); } } } }
public business2field SelectOne(int id) { business2field selectedbusiness2field = _business2fields.Where(b => b.BusinessFieldID == id).FirstOrDefault(); return(selectedbusiness2field); }