Example #1
0
        /// <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);
            }
        }
Example #2
0
        /// <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);
            }
        }
Example #3
0
 /// <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);
     }
 }
Example #4
0
        /// <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);
            }
        }
Example #5
0
        /// <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);
            }
        }
Example #6
0
        /// <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);
            }
        }
Example #7
0
        /// <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);
            }
        }
Example #8
0
        /// <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);
            }
        }
Example #9
0
        /// <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);
            }
        }
Example #10
0
        /// <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);
            }
        }
Example #11
0
        /// <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);
            }
        }
Example #12
0
        /// <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);
            }
        }
Example #13
0
        /// <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);
            }
        }
Example #14
0
        /// <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);
            }
        }
Example #15
0
        /// <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);
            }
        }
Example #16
0
        /// <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);
            }
        }
Example #17
0
        /// <summary>
        /// Finds an image that matches a semantic query
        /// </summary>
        /// <param name="query">The semantic query</param>
        /// <param name="DBC">The controller through which the search will be done</param>
        public List <string[]> SearchBySemantic(string Query, databaseController DBC)
        {
            List <string[]> res = new List <string[]>();

            return(res);
        }
Example #18
0
        /// <summary>
        /// Finds an image that matches the example image
        /// </summary>
        /// <param name="ExampleImagePath">The path of the example image</param>
        /// <param name="DBC">The controller through which the search will be done</param>
        public List <string[]> SearchByExample(string ExampleImagePath, databaseController DBC, double Max, double Min)
        {
            try
            {
                List <string[]> res = new List <string[]>();

                //Get the features of the example image
                featureExtractor fe = new featureExtractor(ExampleImagePath);
                List <Feature>   fv = fe.AllFeatures();

                double area    = fv[fv.Count - 1].FeatureValue * fv[fv.Count - 2].FeatureValue;
                double MaxArea = area * Max;
                double MinArea = area * Min;

                fv.RemoveAt(fv.Count - 1);
                fv.RemoveAt(fv.Count - 1);
                fv.RemoveAt(fv.Count - 1);
                fv.RemoveAt(fv.Count - 1);

                //Example color features
                double[] exCF = new double[4];
                for (int i = 0; i < 4; i++)
                {
                    exCF[i] = fv[i].FeatureValue;
                }

                //Example shape features
                double[] exSF = new double[7];
                for (int i = 4; i < 11; i++)
                {
                    exSF[i - 4] = fv[i].FeatureValue;
                }

                //Example texture features
                double[] exTF = new double[24];
                for (int i = 11; i < 35; i++)
                {
                    exTF[i - 11] = fv[i].FeatureValue;
                }

                //Example edge features
                double[] exEF = new double[37];
                for (int i = 35; i < 72; i++)
                {
                    exEF[i - 35] = fv[i].FeatureValue;
                }

                //Calculate similarities between example image and images in the database
                FeatureExtractorclass fec = new FeatureExtractorclass();
                MWArray mwXCF             = new MWNumericArray(exCF.Length, 1, exCF);
                MWArray mwXSF             = new MWNumericArray(exSF.Length, 1, exSF);
                MWArray mwXTF             = new MWNumericArray(exTF.Length, 1, exTF);
                MWArray mwXEF             = new MWNumericArray(exEF.Length, 1, exEF);

                DBC.CommandText = "SELECT * FROM FeaturesVector where (CropH*CropW >=" + MinArea.ToString() + ") AND (CropH*CropW <=" + MaxArea.ToString() + ");";
                DataSet ds = DBC.ExecuteQuery();
                if (ds.Tables[0].Rows.Count < 1)
                {
                    throw new Exception("The database is empty or there are no matches!");
                }

                //Calculate similiraties for each group of feature . . .
                List <Result> ColorSimilarties   = new List <Result>();
                List <Result> ShapeSimilarties   = new List <Result>();
                List <Result> TextureSimilarties = new List <Result>();
                List <Result> EdgeSimilarties    = new List <Result>();

                double[] Cfrow;
                double[] Sfrow;
                double[] Tfrow;
                double[] Efrow;

                MWArray mwRes = new MWNumericArray(1);
                MWArray mwCC;   //Color features for current image
                MWArray mwCS;   //Shape features for current image
                MWArray mwCT;   //Texture features for current image
                MWArray mwCE;   //Edge features for current image

                for (int j = 0; j < ds.Tables[0].Rows.Count; j++)
                {
                    int ID = int.Parse(ds.Tables[0].Rows[j].ItemArray[0].ToString());

                    //Current image color features
                    Cfrow = new double[4];
                    for (int i = 1; i < 5; i++)
                    {
                        Cfrow[i - 1] = double.Parse(ds.Tables[0].Rows[j].ItemArray[i].ToString());
                    }
                    mwCC  = new MWNumericArray(Cfrow.Length, 1, Cfrow);
                    mwRes = fec.minkowski(mwXCF, mwCC, 4);

                    double Distance = double.Parse(mwRes.ToString());
                    Result sim      = new Result(ID, Distance);
                    ColorSimilarties.Add(sim);

                    //Current image shape features
                    Sfrow = new double[7];
                    for (int i = 5; i < 12; i++)
                    {
                        Sfrow[i - 5] = double.Parse(ds.Tables[0].Rows[j].ItemArray[i].ToString());
                    }
                    mwCS  = new MWNumericArray(Sfrow.Length, 1, Sfrow);
                    mwRes = fec.minkowski(mwXSF, mwCS, 4);

                    Distance = double.Parse(mwRes.ToString());
                    sim      = new Result(ID, Distance);
                    ShapeSimilarties.Add(sim);

                    //Current image texture features
                    Tfrow = new double[24];
                    for (int i = 12; i < 36; i++)
                    {
                        Tfrow[i - 12] = double.Parse(ds.Tables[0].Rows[j].ItemArray[i].ToString());
                    }
                    mwCT  = new MWNumericArray(Tfrow.Length, 1, Tfrow);
                    mwRes = fec.minkowski(mwXTF, mwCT, 4);

                    Distance = double.Parse(mwRes.ToString());
                    sim      = new Result(ID, Distance);
                    TextureSimilarties.Add(sim);

                    //Current image edge features
                    Efrow = new double[37];
                    for (int i = 36; i < 73; i++)
                    {
                        Efrow[i - 36] = double.Parse(ds.Tables[0].Rows[j].ItemArray[i].ToString());
                    }
                    mwCE  = new MWNumericArray(Efrow.Length, 1, Efrow);
                    mwRes = fec.minkowski(mwXEF, mwCE, 4);

                    Distance = double.Parse(mwRes.ToString());
                    sim      = new Result(ID, Distance);
                    EdgeSimilarties.Add(sim);
                }

                ShapeSimilarties = sortList(ShapeSimilarties);

                double resAvg = ListAverag(ShapeSimilarties);
                while (ShapeSimilarties[ShapeSimilarties.Count - 1].Distance > resAvg)
                {
                    Result R = ShapeSimilarties[ShapeSimilarties.Count - 1];
                    ShapeSimilarties.RemoveAt(ShapeSimilarties.Count - 1);
                    for (int r = 0; r < EdgeSimilarties.Count; r++)
                    {
                        if (EdgeSimilarties[r].ID == R.ID)
                        {
                            EdgeSimilarties.RemoveAt(r);
                            TextureSimilarties.RemoveAt(r);
                            ColorSimilarties.RemoveAt(r);
                            break;
                        }
                    }
                }

                EdgeSimilarties = sortList(EdgeSimilarties);

                resAvg = ListAverag(EdgeSimilarties);
                while (EdgeSimilarties[EdgeSimilarties.Count - 1].Distance > resAvg)
                {
                    Result R = EdgeSimilarties[EdgeSimilarties.Count - 1];
                    EdgeSimilarties.RemoveAt(EdgeSimilarties.Count - 1);
                    for (int r = 0; r < TextureSimilarties.Count; r++)
                    {
                        if (TextureSimilarties[r].ID == R.ID)
                        {
                            TextureSimilarties.RemoveAt(r);
                            ColorSimilarties.RemoveAt(r);
                            break;
                        }
                    }
                }

                TextureSimilarties = sortList(TextureSimilarties);

                resAvg = ListAverag(TextureSimilarties);
                while (TextureSimilarties[TextureSimilarties.Count - 1].Distance > resAvg)
                {
                    Result R = TextureSimilarties[TextureSimilarties.Count - 1];
                    TextureSimilarties.RemoveAt(TextureSimilarties.Count - 1);
                    for (int r = 0; r < ColorSimilarties.Count; r++)
                    {
                        if (ColorSimilarties[r].ID == R.ID)
                        {
                            ColorSimilarties.RemoveAt(r);
                            break;
                        }
                    }
                }

                ColorSimilarties = sortList(ColorSimilarties);

                resAvg = ListAverag(ColorSimilarties);
                while (ColorSimilarties[ColorSimilarties.Count - 1].Distance > resAvg)
                {
                    ColorSimilarties.RemoveAt(ColorSimilarties.Count - 1);
                }

                List <Result> similarties = ColorSimilarties;

                //Ranking :
                double   farestImg = (double)similarties[similarties.Count - 1].Distance; //The worst match.
                double   rank      = 0;
                string[] resStr;

                for (int i = 0; i < similarties.Count; i++)
                {
                    resStr = new string[4];
                    int x = similarties[i].ID;

                    DBC.CommandText  = "SELECT I.FileName, S.FolderPath ";
                    DBC.CommandText += "FROM Image AS I INNER JOIN Series AS S ON FLOOR(I.ImageID / 100) = S.SID ";
                    DBC.CommandText += "WHERE (I.ImageID = " + x + ")";

                    ds        = DBC.ExecuteQuery();
                    rank      = (1 - ((double)similarties[i].Distance / farestImg)) * 100;
                    rank      = Math.Round(rank, 5);
                    resStr[0] = ds.Tables[0].Rows[0].ItemArray[0].ToString();
                    resStr[1] = ds.Tables[0].Rows[0].ItemArray[1].ToString();
                    resStr[2] = " - " + rank.ToString() + "%";
                    resStr[3] = x.ToString();
                    res.Add(resStr);
                    resStr = null;
                }
                return(res);
            }
            catch (Exception ex)
            {
                return(null);
            }
        }