public static void AddNewApplication(string name, string city, string state,
string skills, string education, string reason, int jID)
{
ApplicationModels am = new ApplicationModels();
ModelList.Add(am);
am.City = city;
am.education = education;
am.jobID = jID;
am.Name = name;
am.reason = reason;
am.skills = skills;
am.State = state;
SqlConnection connect = new SqlConnection(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=|DataDirectory|/Database1.mdf;Integrated Security=True");
connect.Open();
string commandStr = "INSERT INTO App (AName, ACity, AState, ASkills, AEducation, Areason, JobID)\n";
commandStr += " VALUES ('" + am.Name + "','" + am.City + "','" + am.State + "','" + am.skills + "','" + am.education + "','" + am.reason + "'," + am.jobID + ");\n";
SqlCommand comm = new SqlCommand(commandStr, connect);
comm.ExecuteNonQuery();
connect.Close();
}
public static void prepFromDatabase()
{
if (ModelList == null)
{
ModelList = new List <ApplicationModels>();
}
else
{
return;
}
SqlConnection connect = new SqlConnection(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=|DataDirectory|/Database1.mdf;Integrated Security=True");
connect.Open();
SqlCommand comm = new SqlCommand("SELECT COUNT(*) from App;");
SqlDataReader reader = comm.ExecuteReader();
while (reader.Read())
{
ApplicationModels newMod = new ApplicationModels();
ModelList.Add(newMod);
}
connect.Close();
foreach (ApplicationModels am in ModelList)
{
am.loadFromTable();
}
}