public int UpdateApplication(ApplicationItem item)
{
string queryString = "update " + tableApplication + " set "
+ "title=@title, "
+ "job_id=@job_id, "
+ "job_url=@job_url, "
+ "job_type=@job_type, "
+ "status=@status, "
+ "priority=@priority, "
+ "next_action=@next_action, "
+ "next_action_date=@next_action_date, "
+ "organization_id=@organization_id, "
+ "iso2=@iso2, "
+ "city=@city, "
+ "contact_name=@contact_name, "
+ "contact_phone=@contact_phone, "
+ "contact_email=@contact_email, "
+ "description=@description, "
+ "note=@note"
+ " where id=@id";
using (SQLiteConnection connection = new SQLiteConnection(strConnection))
using (SQLiteCommand dbCommand = new SQLiteCommand(queryString, connection))
{
// Set command parameters.
dbCommand.Parameters.AddWithValue("@id", item.Id);
dbCommand.Parameters.AddWithValue("@title", item.Title);
dbCommand.Parameters.AddWithValue("@job_id", item.JobId);
dbCommand.Parameters.AddWithValue("@job_url", item.JobUrl);
dbCommand.Parameters.AddWithValue("@job_type", item.JobType);
dbCommand.Parameters.AddWithValue("@status", item.Status);
dbCommand.Parameters.AddWithValue("@priority", item.Priority);
dbCommand.Parameters.AddWithValue("@next_action", item.NextAction);
dbCommand.Parameters.AddWithValue("@next_action_date", item.NextActionDate);
dbCommand.Parameters.AddWithValue("@organization_id", item.OrganizationId);
dbCommand.Parameters.AddWithValue("@iso2", item.Iso2);
dbCommand.Parameters.AddWithValue("@city", item.City);
dbCommand.Parameters.AddWithValue("@contact_name", item.ContactName);
dbCommand.Parameters.AddWithValue("@contact_phone", item.ContactPhone);
dbCommand.Parameters.AddWithValue("@contact_email", item.ContactEmail);
dbCommand.Parameters.AddWithValue("@description", item.Description);
dbCommand.Parameters.AddWithValue("@note", item.Note);
// Update organization in table.
connection.Open();
int result = dbCommand.ExecuteNonQuery();
// Notify changes.
if (this.ApplicationModified != null)
{
this.ApplicationModified(this, null);
}
// Return the result.
return(result);
}
}
public int AddApplication(ApplicationItem item)
{
string queryString = "insert into " + tableApplication + " values(null, @title, @job_id, @job_url, @job_type, @status, @priority, @next_action, @next_action_date, @organization, "
+ "@iso2, @city, @contact_name, @contact_phone, @contact_email, @description, @note)";
using (SQLiteConnection connection = new SQLiteConnection(strConnection))
using (SQLiteCommand dbCommand = new SQLiteCommand(queryString, connection))
{
// Set command parameters.
dbCommand.Parameters.AddWithValue("@title", item.Title);
dbCommand.Parameters.AddWithValue("@job_id", item.JobId);
dbCommand.Parameters.AddWithValue("@job_url", item.JobUrl);
dbCommand.Parameters.AddWithValue("@job_type", item.JobType);
dbCommand.Parameters.AddWithValue("@status", item.Status);
dbCommand.Parameters.AddWithValue("@priority", item.Priority);
dbCommand.Parameters.AddWithValue("@next_action", item.NextAction);
dbCommand.Parameters.AddWithValue("@next_action_date", item.NextActionDate);
dbCommand.Parameters.AddWithValue("@organization", item.OrganizationId);
dbCommand.Parameters.AddWithValue("@iso2", item.Iso2);
dbCommand.Parameters.AddWithValue("@city", item.City);
dbCommand.Parameters.AddWithValue("@contact_name", item.ContactName);
dbCommand.Parameters.AddWithValue("@contact_phone", item.ContactPhone);
dbCommand.Parameters.AddWithValue("@contact_email", item.ContactEmail);
dbCommand.Parameters.AddWithValue("@description", item.Description);
dbCommand.Parameters.AddWithValue("@note", item.Note);
// Add new organization to table.
connection.Open();
int result = dbCommand.ExecuteNonQuery();
// Notify changes.
if (this.ApplicationModified != null)
{
this.ApplicationModified(this, null);
}
// Return the result.
return(result);
}
}
public int DeleteApplication(ApplicationItem item)
{
string queryString = "delete from " + tableApplication + " where id=@id";
using (SQLiteConnection connection = new SQLiteConnection(strConnection))
using (SQLiteCommand dbCommand = new SQLiteCommand(queryString, connection))
{
// Set command parameters.
dbCommand.Parameters.AddWithValue("@id", item.Id);
// Delete organization from table.
connection.Open();
int result = dbCommand.ExecuteNonQuery();
// Notify changes.
if (this.ApplicationModified != null)
{
this.ApplicationModified(this, null);
}
// Return the result.
return(result);
}
}
