Пример #1
0
 public static void AddProjectToDB(string aStorage, string aPlaceName, string aProjectName, string aPathToProject, string aLocalPath)
 {
     using (ProjectsDB _db = new ProjectsDB())
     {
         _db.ExecuteNonQuery("INSERT INTO PROJECTS VALUES(" +
                             "`" + aStorage + "`," +
                             "`" + aPlaceName + "`," +
                             "`" + aProjectName + "`," +
                             "`" + aPathToProject + "`," +
                             "`" + aLocalPath + "`, ``, ``, 0, 0)");
     }
 }
Пример #2
0
        /// <summary>
        /// Get Storage name and Process and Site if map is in cloud storage
        /// </summary>
        /// <returns>
        /// true:  map is in cloud storage; get refs
        /// false: otherwise
        /// </returns>
        public static void GetMapData(string mapGuid, ref string aStorage, ref string aProcess,
                                      ref string aSite, ref string aPath, ref string aPlaceName, ref string aProjectName, ref string aProjectPath)
        {
            using (MapsDB _db = new MapsDB())
            {
                DataTable _dt = _db.ExecuteQuery("select * from MAPS where MAPGUID=`" + mapGuid + "`");
                if (_dt.Rows.Count != 0)
                {
                    aStorage     = _dt.Rows[0]["STORAGE"].ToString();
                    aPath        = _dt.Rows[0]["PATHTOPLACE"].ToString();
                    aPlaceName   = _dt.Rows[0]["PLACENAME"].ToString();
                    aProjectName = _dt.Rows[0]["PROJECTNAME"].ToString();
                }
            }

            if (aProjectName != "")
            {
                using (ProjectsDB _db = new ProjectsDB())
                {
                    DataTable _dt = _db.ExecuteQuery("select * from PROJECTS where PROJECTNAME=`" + aProjectName + "`");
                    aProjectPath = _dt.Rows[0]["PROJECTPATH"].ToString();
                }
            }

            if (aStorage == "ND")
            {
                return;
            }

            using (StoragesDB _db = new StoragesDB())
            {
                DataTable _dt = _db.ExecuteQuery("select * from STORAGES where STORAGENAME=`" + aStorage + "`");
                if (_dt.Rows.Count != 0)
                {
                    aProcess = _dt.Rows[0]["PROCESS"].ToString();
                    aSite    = _dt.Rows[0]["SITE"].ToString();
                }
            }
        }