public void Insert(applicant2field applicant2field)
{
//applicant2field.ApplicantFieldID = NextIdValue();
//_applicant2fields.Add(applicant2field);
_ds.Insert(applicant2field);
}
public List <applicant2field> Read()
{
List <applicant2field> applicant2fields = new List <applicant2field>();
using (SqlConnection connection = new SqlConnection(DataSettings.CONNECTION_STRING))
{
connection.Open();
StringBuilder sb = new StringBuilder();
sb.Append("SELECT [ApplicantFieldID],[Applicant],[Field]");
sb.Append("FROM [careerfair].[applicant2field]");
String sql = sb.ToString();
using (SqlCommand command = new SqlCommand(sql, connection))
{
using (SqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
applicant2field applicant2field = new applicant2field();
applicant2field.ApplicantFieldID = DatabaseHelper.CheckNullInt(reader, 0);
applicant2field.Applicant = DatabaseHelper.CheckNullInt(reader, 1);
applicant2field.Field = DatabaseHelper.CheckNullInt(reader, 2);
applicant2fields.Add(applicant2field);
}
}
}
}
return(applicant2fields);
}
public void Update(applicant2field applicant2field)
{
var oldapplicant2field = _applicant2fields.Where(a => a.ApplicantFieldID == applicant2field.ApplicantFieldID).FirstOrDefault();
if (oldapplicant2field != null)
{
_applicant2fields.Remove(oldapplicant2field);
_applicant2fields.Add(applicant2field);
_ds.Update(applicant2field);
}
}
public void Remove(applicant2field applicant2field)
{
using (SqlConnection connection = new SqlConnection(DataSettings.CONNECTION_STRING))
{
connection.Open();
StringBuilder sb = new StringBuilder();
sb.Append("DELETE FROM [careerfair].[applicant2field]");
sb.Append("WHERE [ApplicantFieldID] = " + applicant2field.ApplicantFieldID);
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 applicantID)
{
using (TechCareerFair.DAL.Applicant2FieldDAL.Applicant2FieldDatabaseDataService ds = new Applicant2FieldDAL.Applicant2FieldDatabaseDataService())
{
List <applicant2field> a2fs = ds.Read();
foreach (string name in fields)
{
applicant2field a2f = new applicant2field();
int fieldIndex = DatabaseHelper.GetFieldIndex(name);
a2f.Applicant = applicantID;
a2f.Field = fieldIndex;
ds.Update(a2f);
}
}
}
public void Insert(applicant2field applicant2field)
{
using (SqlConnection connection = new SqlConnection(DataSettings.CONNECTION_STRING))
{
connection.Open();
StringBuilder sb = new StringBuilder();
sb.Append("INSERT INTO [careerfair].[applicant2field]([Applicant],[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)applicant2field.Applicant ?? DBNull.Value;
command.Parameters.Add("@param2", SqlDbType.Int).Value = (object)applicant2field.Field ?? DBNull.Value;
command.CommandType = System.Data.CommandType.Text;
command.ExecuteNonQuery();
}
}
}
public void Update(applicant2field applicant2field)
{
using (SqlConnection connection = new SqlConnection(DataSettings.CONNECTION_STRING))
{
connection.Open();
StringBuilder sb = new StringBuilder();
sb.Append("UPDATE [careerfair].[applicant2field]");
sb.Append("SET [Applicant] = @param1, [Field] = @param2 ");
sb.Append("WHERE [ApplicantFieldID] = " + applicant2field.ApplicantFieldID);
String sql = sb.ToString();
using (SqlCommand command = new SqlCommand(sql, connection))
{
command.Parameters.Add("@param1", SqlDbType.Int).Value = (object)applicant2field.Applicant ?? DBNull.Value;
command.Parameters.Add("@param2", SqlDbType.Int).Value = (object)applicant2field.Field ?? DBNull.Value;
command.CommandType = System.Data.CommandType.Text;
command.ExecuteNonQuery();
}
}
}
private void Insert(List <string> fields, int applicantID)
{
//insert field ID and applicant ID into new record of mapping table applicant2field
using (TechCareerFair.DAL.Applicant2FieldDAL.Applicant2FieldDatabaseDataService ds = new Applicant2FieldDAL.Applicant2FieldDatabaseDataService())
{
List <applicant2field> a2fs = ds.Read();
foreach (string name in fields)
{
applicant2field a2f = new applicant2field();
int fieldIndex = DatabaseHelper.GetFieldIndex(name);
a2f.Applicant = applicantID;
a2f.Field = fieldIndex;
if (a2fs.Where(a => a.Field == fieldIndex).Where(a => a.Applicant == applicantID).Count() == 0)
{
ds.Insert(a2f);
}
}
}
}
public applicant2field SelectOne(int id)
{
applicant2field selectedapplicant2field = _applicant2fields.Where(a => a.ApplicantFieldID == id).FirstOrDefault();
return(selectedapplicant2field);
}
