using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.OleDb;

/// <summary>
/// Summary description for FileIsUnique
/// </summary>
public class FileIsUnique
{

    public int CheckFileIsUnique(string file_name)
    {
        string connString = DALUtilities.getConnectionString();
        OleDbCommand command1, command2, command3, command4, command5, command6, command7, command8, command9;
        string query1, query2, query3, query4, query5, query6, query7, query8, query9;
        int i, i1, i2, i3, i4, i5, i6, i7, i8, i9;
        query1 = "SELECT COUNT(ID) FROM casestudies WHERE img1='" + file_name + "' OR img2='" + file_name + "' OR en_path='" + file_name + "' OR ar_path='" + file_name + "';";
        query2 = "SELECT COUNT(ID) FROM press WHERE img='" + file_name + "' OR en_path='" + file_name + "' OR ar_path='" + file_name + "';";
        query3 = "SELECT COUNT(ID) FROM publications WHERE img='" + file_name + "' OR en_path='" + file_name + "' OR ar_path='" + file_name + "';";
        query4 = "SELECT COUNT(ID) FROM clients WHERE logo='" + file_name + "';";
        query5 = "SELECT COUNT(ID) FROM ecopartners WHERE logo='" + file_name + "';";
        query6 = "SELECT COUNT(ID) FROM news WHERE img='" + file_name + "';";
        query7 = "SELECT COUNT(ID) FROM publishers WHERE logo='" + file_name + "';";
        query8 = "SELECT COUNT(ID) FROM usefullinks WHERE img='" + file_name + "';";
        query9 = "SELECT COUNT(ID) FROM events WHERE img='" + file_name + "' OR big_image='" + file_name + "';";
        OleDbConnection connection = new OleDbConnection(connString);
        command1 = new OleDbCommand(query1, connection);
        command2 = new OleDbCommand(query2, connection);
        command3 = new OleDbCommand(query3, connection);
        command4 = new OleDbCommand(query4, connection);
        command5 = new OleDbCommand(query5, connection);
        command6 = new OleDbCommand(query6, connection);
        command7 = new OleDbCommand(query7, connection);
        command8 = new OleDbCommand(query8, connection);
        command9 = new OleDbCommand(query9, connection);
        connection.Open();
        i1 = (int)command1.ExecuteScalar();
        i2 = (int)command2.ExecuteScalar();
        i3 = (int)command3.ExecuteScalar();
        i4 = (int)command4.ExecuteScalar();
        i5 = (int)command5.ExecuteScalar();
        i6 = (int)command6.ExecuteScalar();
        i7 = (int)command7.ExecuteScalar();
        i8 = (int)command8.ExecuteScalar();
        i9 = (int)command9.ExecuteScalar();
        connection.Close();
        i = i1 + i2 + i3 + i4 + i5 + i6 + i7 + i8 + i9;
        return i;
    }
}