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