//Method to update data from our application
public bool Update(InternInfoEntry foo)
{
bool isSuccess = false;
//DB connection
SqlConnection conn = new SqlConnection(myConnString);
try
{
string sql = "UPDATE internship SET Company=@company, Position=@position, date_app=@date_app, date_resp=@date_resp, response=@response, followUp=@followUp, additionalinfo=@additionalInfo, active=@active " +
" WHERE company=@company";
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.AddWithValue("@company", foo.Company);
cmd.Parameters.AddWithValue("@position", foo.PositionProp);
cmd.Parameters.AddWithValue("@date_app", foo.DateForApplication);
cmd.Parameters.AddWithValue("@date_resp", foo.DateForResponse);
cmd.Parameters.AddWithValue("@response", foo.Response);
cmd.Parameters.AddWithValue("@followUp", foo.FollowUp);
cmd.Parameters.AddWithValue("@additionalInfo", foo.AdditionalInfo);
cmd.Parameters.AddWithValue("@active", foo.Active);
conn.Open();
int rows = cmd.ExecuteNonQuery();
if (rows > 0)
{
isSuccess = true;
}
}
catch (Exception e) { Console.Write(e.StackTrace); }
finally { conn.Close(); }
return(isSuccess);
}
//Inserting data => database
public bool Insert(InternInfoEntry foo)
{
//basic return type, default = false
bool isSucces = false;
//DB connection
SqlConnection conn = new SqlConnection(myConnString);
try
{
//Create sql query
string sql = "INSERT INTO internship (company, position, date_app, date_resp, response, followup, additionalInfo, active) " +
"VALUES(@company, @position, @date_app, @date_resp, @response, @followup, @additionalInfo, @active)";
//create sql command using sql and conn
SqlCommand cmd = new SqlCommand(sql, conn);
//Create parameters to add data
cmd.Parameters.AddWithValue("@company", foo.Company);
cmd.Parameters.AddWithValue("@position", foo.PositionProp);
cmd.Parameters.AddWithValue("@date_app ", foo.DateForApplication);
cmd.Parameters.AddWithValue("@date_resp ", foo.DateForResponse);
cmd.Parameters.AddWithValue("@response", foo.Response);
cmd.Parameters.AddWithValue("@followUp", foo.FollowUp);
cmd.Parameters.AddWithValue("@additionalInfo", foo.AdditionalInfo);
cmd.Parameters.AddWithValue("@active", foo.Active);
//Open connection
conn.Open();
int rows = cmd.ExecuteNonQuery();
//check if the query was succesfull
if (rows > 0)
{
isSucces = true;
}
}
catch (Exception e) { Console.WriteLine(e.StackTrace); }
finally { conn.Close(); }
return(isSucces);
}
public bool Delete(InternInfoEntry foo)
{
bool isSuccess = false;
//DB connection
SqlConnection conn = new SqlConnection(myConnString);
try
{
string sql = "DELETE FROM internship WHERE company=@company ";
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.AddWithValue("@company", foo.Company);
conn.Open();
int rows = cmd.ExecuteNonQuery();
if (rows > 0)
{
isSuccess = true;
}
}
catch (Exception e) { }
finally { conn.Close(); }
return(isSuccess);
}