public Entities.SaoLuuHeThong[] LayBackUp()
 {
     try
     {
         string        path = duongdanFolder;
         DirectoryInfo DI   = new DirectoryInfo(path);
         if (!DI.Exists)
         {
             return(null);
         }
         FileInfo[] FI = DI.GetFiles("BUSuperMarketDHT*");
         Entities.SaoLuuHeThong[] slht = new Entities.SaoLuuHeThong[FI.Length];
         int j = 0;
         for (int i = FI.Length - 1; i >= 0; i--)
         {
             slht[j] = new Entities.SaoLuuHeThong(FI[i].Name, FI[i].LastWriteTime.ToShortDateString(), FI[i].Length);
             j++;
         }
         return(slht);
     }
     catch
     {
         return(null);
     }
 }
        public bool Restore(Entities.SaoLuuHeThong slht1)
        {
            try
            {
                try
                {
                    SqlConnection.ClearAllPools();
                    string        path     = duongdanFolder;
                    DirectoryInfo FI       = new DirectoryInfo(path);
                    string        fileName = "BUSuperMarketDHT" + slht1.Name;
                    string        sql      = "ALTER DATABASE SupermarketManagementDHT ";
                    sql += "SET SINGLE_USER WITH ROLLBACK IMMEDIATE ";
                    sql += " use master ";
                    //sql += "while((select COUNT(spid) from master..sysprocesses where DBid=DB_ID('SupermarketManagement'))>0)";
                    //sql += "begin ";
                    //sql += "declare @id smallint=(select top(1)spid from master..sysprocesses where DBid=DB_ID('SupermarketManagement')) ";
                    //sql += "declare @sql nvarchar(100)=N'kill @i' ";
                    //sql += "exec sp_executesql @sql,N'@i smallint',@i=@id ";
                    //sql += "end ";
                    sql += "restore DATABASE SupermarketManagementDHT from DISK='" + path + "\\" + slht1.Name + "' with replace";
                    sql += " ALTER DATABASE SupermarketManagementDHT ";
                    sql += "SET MULTI_USER";

                    if (!FI.Exists)
                    {
                        return(false);
                    }
                    conn            = new Connection();
                    cmd             = new SqlCommand();
                    cmd.CommandText = sql;
                    cmd.Connection  = conn.openConnection();

                    cmd.ExecuteNonQuery();

                    cmd.Connection.Dispose();
                    cmd.Connection.Close();
                    cmd.Dispose();
                }
                catch
                { return(false); }
                finally
                {
                    cmd.Connection.Dispose();
                    cmd.Connection.Close();
                    cmd.Dispose();
                    conn.closeConnection();
                }
                return(true);
            }
            catch
            {
                return(false);
            }
        }
 public Entities.SaoLuuHeThong[] LayBackUp()
 {
     try
     {
         string path = duongdanFolder;
         DirectoryInfo DI = new DirectoryInfo(path);
         if (!DI.Exists)
         {
             return null;
         }
         FileInfo[] FI = DI.GetFiles("BUSuperMarketDHT*");
         Entities.SaoLuuHeThong[] slht = new Entities.SaoLuuHeThong[FI.Length];
         int j = 0;
         for (int i = FI.Length - 1; i >= 0; i--)
         {
             slht[j] = new Entities.SaoLuuHeThong(FI[i].Name, FI[i].LastWriteTime.ToShortDateString(), FI[i].Length);
             j++;
         }
         return slht;
     }
     catch
     {
         return null;
     }
 }