/// <summary>
/// Updates an existing series
/// </summary>
/// <param name="DBC">The controller through which series update will be done</param>
public bool UpdateSeries(databaseController DBC)
{
string sqlstr;
try
{
sqlstr = "UPDATE Series SET ";
sqlstr = sqlstr + "PID = " + this.pid + " ,";
sqlstr = sqlstr + "FolderPath = '" + this.path + "' ";
sqlstr = sqlstr + "WHERE SID =" + this.id + " ;";
if (DBC.IsConnected)
{
DBC.CommandText = sqlstr;
if (DBC.ExecuteNonQuery() > 0)
{
DBC.CommandText = "DELETE FROM Series_Notes WHERE SID = " + this.id + " ;";
DBC.ExecuteNonQuery();
if (InsertNotes(DBC))
{
DBC.CommandText = "DELETE FROM Series_Cats WHERE SID = " + this.id + " ;";
DBC.ExecuteNonQuery();
if (InsertCats(DBC))
{
return(true);
}
else
{
throw new Exception("Failed to modify categories of series !");
}
}
else
{
throw new Exception("Failed to modify notes of series !");
}
}
else
{
throw new Exception("Failed to modify series !");
}
}
else
{
throw new Exception("The database is not connected!");
}
}
catch (Exception e)
{
return(false);
}
}
/// <summary>
/// Updates image's features in the database
/// </summary>
/// <param name="DBC">The controller through which features update will be done</param>
private bool UpdateImageFeatures(databaseController DBC)
{
//Declarations
string sqlstr;
try
{
sqlstr = "UPDATE FeaturesVector SET ";
foreach (Feature f in featureVector)
{
sqlstr = sqlstr + f.FeatureName + " = " + f.FeatureValue.ToString() + " ,";
}
//sqlstr = sqlstr + "Tags ='" + this.tags + "' ,";
//sqlstr = sqlstr + "ImagePath ='" + this.url + "',";
//sqlstr = sqlstr + "Category = " + this.cat.ID + " ,";
//sqlstr = sqlstr + "Size = " + this.imageInfo[0] + " ,";
//sqlstr = sqlstr + "Dimensions = '" + this.imageInfo[1] + "' ,";
sqlstr = sqlstr.Trim(',');
sqlstr = sqlstr + " WHERE ImageID =" + this.id + " ;";
if (DBC.IsConnected)
{
DBC.CommandText = sqlstr;
return(DBC.ExecuteNonQuery() > 0);
}
else
{
throw new Exception("The database is not connected!");
}
}
catch (Exception e)
{
return(false);
}
}
/// <summary>
/// Inserts image's features into the database
/// </summary>
/// <param name="DBC">The controller through which features insertion will be done</param>
private bool InsertImageFeatures(databaseController DBC)
{
try
{
string f_insert = "INSERT INTO FeaturesVector VALUES ( " + this.id;
foreach (Feature f in featureVector)
{
f_insert += "," + f.FeatureValue;
}
f_insert += " );";
f_insert = f_insert.ToLower().Replace("nan", "0");
if (DBC.IsConnected)
{
DBC.CommandText = f_insert;
return(DBC.ExecuteNonQuery() > 0);
}
else
{
throw new Exception("The database is not connected!");
}
}
catch (Exception ex)
{
return(false);
}
}
/// <summary>
/// Deletes the categories of the series
/// </summary>
/// <param name="DBC">The controller through which categories deletion will be done</param>
private bool DeleteCats(databaseController DBC)
{
string sqlstr;
if (catList.Count < 1)
{
return(true);
}
try
{
sqlstr = "DELETE FROM Series_Cats WHERE (SID = " + this.id + " ) ;";
if (DBC.IsConnected)
{
DBC.CommandText = sqlstr;
return(DBC.ExecuteNonQuery() > 0);
}
else
{
throw new Exception("The database is not connected!");
}
}
catch (Exception e)
{
return(false);
}
}
/// <summary>
/// Inserts the notes of this series
/// </summary>
/// <param name="DBC">The controller through which notes insertion will be done</param>
private bool InsertNotes(databaseController DBC)
{
string sqlstr = "";
if (this.notes == "")
{
return(true);
}
try
{
sqlstr = "INSERT INTO Series_Notes VALUES ( " + this.id;
sqlstr += " , '" + this.notes;
sqlstr += "' );";
if (DBC.IsConnected)
{
DBC.CommandText = sqlstr;
return(DBC.ExecuteNonQuery() > 0);
}
else
{
throw new Exception("The database is not connected!");
}
}
catch (Exception ex)
{
return(false);
}
}
/// <summary>
/// Updates an existing patiant
/// </summary>
/// <param name="DBC">The controller through which patiant update will be done</param>
public bool UpdatePatiant(databaseController DBC)
{
//Declarations
string sqlstr;
try
{
sqlstr = "UPDATE Patiant SET ";
sqlstr = sqlstr + "Name ='" + this.name + "',";
sqlstr = sqlstr + "Age = " + this.age + " ,";
sqlstr = sqlstr + "Info = '" + this.info + "' ";
sqlstr = sqlstr + "WHERE PID =" + this.id + " ;";
if (DBC.IsConnected)
{
DBC.CommandText = sqlstr;
return(DBC.ExecuteNonQuery() > 0);
}
else
{
throw new Exception("The database is not connected!");
}
}
catch (Exception e)
{
return(false);
}
}
/// <summary>
/// Inserts new series to the system
/// </summary>
/// <param name="DBC">The controller through which series insertion will be done</param>
public bool InsertSeries(databaseController DBC)
{
string sqlstr;
try
{
sqlstr = "INSERT INTO Series VALUES ( " +
this.id + " , " + this.pid + " , '" + this.Path + "' );";
if (DBC.IsConnected)
{
DBC.CommandText = sqlstr;
if (DBC.ExecuteNonQuery() > 0)
{
if (InsertCats(DBC))
{
if (InsertNotes(DBC))
{
return(true);
}
else
{
throw new Exception("Failed to insert the note of series !");
}
}
else
{
throw new Exception("Failed to insert the categories of series !");
}
}
else
{
throw new Exception("Failed to insert the series !");
}
}
else
{
throw new Exception("The database is not connected!");
}
}
catch (Exception e)
{
return(false);
}
}
/// <summary>
/// Deletes an existing series
/// </summary>
/// <param name="DBC">The controller through which series deletion will be done</param>
public bool DeleteSeries(databaseController DBC)
{
string sqlstr;
try
{
if (DeleteCats(DBC))
{
if (DeleteNotes(DBC))
{
if (DBC.IsConnected)
{
sqlstr = "DELETE FROM Series WHERE SID = " + this.id + " ;";
DBC.CommandText = sqlstr;
if (DBC.ExecuteNonQuery() > 0)
{
return(true);
}
else
{
throw new Exception("Failed to delete the series !");
}
}
else
{
throw new Exception("The database is not connected!");
}
}
else
{
throw new Exception("Failed to delete the notes of series !");
}
}
else
{
throw new Exception("Failed to delete the categories of series !");
}
}
catch (Exception e)
{
return(false);
}
}
/// <summary>
/// Modifies an image in the database
/// </summary>
/// <param name="DBC">The controller through which the modification will be done</param>
public bool ModifyImage(databaseController DBC)
{
//Declarations
string sqlstr;
try
{
sqlstr = "UPDATE Image SET ";
sqlstr = sqlstr + "FileName ='" + this.fileName + "',";
sqlstr = sqlstr + "Size = " + this.imageInfo[0] + " ,";
sqlstr = sqlstr + "Dimensions = '" + this.imageInfo[1] + "' ";
sqlstr = sqlstr + "WHERE ImageID =" + this.id + " ;";
if (DBC.IsConnected)
{
DBC.CommandText = sqlstr;
if (DBC.ExecuteNonQuery() > 0)
{
if (UpdateImageFeatures(DBC))
{
return(true);
}
else
{
throw new Exception("Failed to modify the image !");
}
}
else
{
throw new Exception("Failed to modify the image !");
}
}
else
{
throw new Exception("The database is not connected!");
}
}
catch (Exception e)
{
return(false);
}
}
/// <summary>
/// Inserts an image into the database
/// </summary>
/// <param name="DBC">The controller through which the insertion will be done</param>
public bool InsertImage(databaseController DBC)
{
//Declarations
string sqlstr;
try
{
sqlstr = "INSERT INTO Image VALUES ( " +
this.id + " , '" + this.fileName + "' , " + this.imageInfo[0]
+ " , '" + this.imageInfo[1] + "' );";
if (DBC.IsConnected)
{
DBC.CommandText = sqlstr;
if (DBC.ExecuteNonQuery() > 0)
{
if (InsertImageFeatures(DBC))
{
return(true);
}
else
{
throw new Exception("Failed to insert the features of image !");
}
}
else
{
throw new Exception("Failed to insert the image !");
}
}
else
{
throw new Exception("The database is not connected!");
}
}
catch (Exception e)
{
return(false);
}
}
/// <summary>
/// Deletes an existing patiant from the database
/// </summary>
/// <param name="DBC">The controller through which patiant deletion will be done</param>
public bool DeletePatiant(databaseController DBC)
{
string sqlstr;
try
{
if (DBC.IsConnected)
{
sqlstr = "DELETE FROM Patiant WHERE PID= " + this.id + " ;";
DBC.CommandText = sqlstr;
return(DBC.ExecuteNonQuery() > 0);
}
else
{
throw new Exception("The database is not connected!");
}
}
catch (Exception e)
{
return(false);
}
}
/// <summary>
/// Deletes image's features from the database
/// </summary>
/// <param name="DBC">The controller through which features deletion will be done</param>
private bool DeleteImageFeatures(databaseController DBC)
{
//Declarations
string sqlstr;
try
{
sqlstr = "DELETE FROM FeaturesVector WHERE ImageID= " + this.id + " ;";
if (DBC.IsConnected)
{
DBC.CommandText = sqlstr;
return(DBC.ExecuteNonQuery() > 0);
}
else
{
throw new Exception("The database is not connected!");
}
}
catch (Exception e)
{
return(false);
}
}
/// <summary>
/// Deletes an image category from the database
/// </summary>
/// <param name="dbc">The controller through which the insertion will be done</param>
/// <param name="DBC">The controller through which the deletion will be done</param>
public bool DeleteCategory(databaseController DBC)
{
//Declarations
string sqlstr;
try
{
sqlstr = "DELETE FROM Category WHERE CatID= " + this.id + " ;";
if (DBC.IsConnected)
{
DBC.CommandText = sqlstr;
return(DBC.ExecuteNonQuery() > 0);
}
else
{
throw new Exception("The database is not connected!");
}
}
catch (Exception e)
{
return(false);
}
}
/// <summary>
/// Deletes an image from the database.
/// </summary>
/// <param name="DBC">The controller through which the deletion will be done</param>
public bool DeleteImage(databaseController DBC)
{
//Declarations
string sqlstr;
try
{
if (DeleteImageFeatures(DBC))
{
if (DBC.IsConnected)
{
sqlstr = "DELETE FROM Image WHERE ImageID= " + this.id + " ;";
DBC.CommandText = sqlstr;
if (DBC.ExecuteNonQuery() > 0)
{
return(true);
}
else
{
throw new Exception("Failed to delete the image !");
}
}
else
{
throw new Exception("The database is not connected!");
}
}
else
{
throw new Exception("Failed to delete the image !");
}
}
catch (Exception e)
{
return(false);
}
}
/// <summary>
/// Inserts the categories of this series
/// </summary>
/// <param name="DBC">The controller through which categories insertion will be done</param>
private bool InsertCats(databaseController DBC)
{
string sqlstr = "";
if (catList.Count < 1)
{
return(true);
}
int inserted_cats = 0;
try
{
if (DBC.IsConnected)
{
foreach (category c in catList)
{
sqlstr = "INSERT INTO Series_Cats VALUES ( " + this.id;
sqlstr += " , " + c.ID;
sqlstr += " );";
DBC.CommandText = sqlstr;
if (DBC.ExecuteNonQuery() > 0)
{
inserted_cats++;
}
}
return(inserted_cats == catList.Count);
}
else
{
throw new Exception("The database is not connected!");
}
}
catch (Exception ex)
{
return(false);
}
}
/// <summary>
/// Inserts new patiant into the database
/// </summary>
/// <param name="DBC">The controller through which patiant insertion will be done</param>
public bool InsertPatiant(databaseController DBC)
{
string sqlstr;
try
{
sqlstr = "INSERT INTO Patiant VALUES ( " +
this.id + " , '" + this.name + "' , " + this.age + " , '" + this.info + "' );";
if (DBC.IsConnected)
{
DBC.CommandText = sqlstr;
return(DBC.ExecuteNonQuery() > 0);
}
else
{
throw new Exception("The database is not connected!");
}
}
catch (Exception e)
{
return(false);
}
}