/// <summary>
/// Get expected system properties for the entered IC/BootCamper
/// </summary>
/// <returns></returns>
private IEnumerable <OutputProperties> GetExpectedSystemProperties()
{
var enteredIcProjectDetails = GetICsProjectList().Where(e => e.IcEmail == _icEmail).ToList();
if (enteredIcProjectDetails.Count <= 0)
{
return(null);
}
{
var spreadSheetId = _configuration["SpreadSheetID"];
var range = _configuration["ExpectedSystemPropertiesSheet"];
var response = GoogleDriveHelper.GetValuesFromGoogleDrive(spreadSheetId, range,
SpreadsheetsResource.ValuesResource.GetRequest.MajorDimensionEnum.COLUMNS);
return((from value in response.Values
let projectName = value[0].ToString()
where enteredIcProjectDetails.Exists(e => e.Projects.Exists(d => d == projectName))
select new OutputProperties
{
OperatingSystem = value[1]?.ToString(),
MinimalCpuBenchmarkScore = Convert.ToInt32(value[2]),
Memory = Convert.ToDouble(value[3]),
Storage = Convert.ToInt64(value[4]),
FreeDiskSpace = Convert.ToInt64(value[5]),
Architecture = value[6]?.ToString()
}).ToList());
}
}
public string[] ReadDriveFolderForFiles(string folder = "In")
{
DriveService service = Authentication.AuthenticateOauth(GoogleClientId, GoogleClientSecret, GoogleUserName);
string q = "title = '" + folder + "' and mimeType = 'application/vnd.google-apps.folder'";
var dir = GoogleDriveHelper.GetFiles(service, q);
if (dir == null || dir.Count == 0)
{
return(null);
}
q = "'" + dir[0].Id + "' in parents";
var _filesInsideDir = GoogleDriveHelper.GetFiles(service, q);
var retList = new List <string>();
foreach (var f in _filesInsideDir)
{
string downloadedFile = Path.Combine(DownloadLocation, f.OriginalFilename);
GoogleDriveHelper.downloadFile(service, f.DownloadUrl, downloadedFile);
if (System.IO.File.Exists(downloadedFile))
{
retList.Add(downloadedFile);
GoogleDriveHelper.removeFileFromFolder(service, dir[0].Id, f.Id);
}
}
return(retList.ToArray());
}
public static string Push(int timeToWait)
{
string result = "";
DateTime synchronizationStartTime = DateTime.Now;
Thread.Sleep(timeToWait);
foreach (var directory in settings.synchronizedDirectories)
{
FileHelper fh = new FileHelper(settings.lastUpdateTime, directory.path, directory.name);
int filesCount = fh.GetFiles(synchronizationStartTime);
if (filesCount > 0)
{
string package = fh.CreatePackage();
GoogleDriveHelper.UploadAndDeleteFile(package);
settings.uploadedPackages.Add(package);
result += "Pushed: " + filesCount + " files from " + directory.name + " directory. ";
}
else
{
result += NoChangesFound;
}
}
settings.lastUpdateTime = synchronizationStartTime;
Serializer.SerializeObject(settings, "settings.mr");
return(result);
}
static void Main(string[] args)
{
var options = new CommandLineOptions();
if (Parser.Default.ParseArguments(args, options))
{
if (!File.Exists(options.DatabasePath))
{
Console.WriteLine($"Database File ${options.DatabasePath} not found!");
return;
}
_silent = options.Quiet;
_dbHelper = new DatabaseHelper(options.DatabasePath);
_upload = options.Upload;
UpdateDatabase();
if (_upload)
{
Console.Write($"Uploading Database File to Google Drive...");
var gdHelper = new GoogleDriveHelper();
gdHelper.UpdateStoredFile(options.DatabasePath, "5DFileData");
Console.WriteLine($"Done");
}
}
}
private ValueRange GetIcsFromGoogleDrive()
{
var range = _configuration["IcsSheet"];
var spreadSheetId = _configuration["SpreadSheetID"];
var response = GoogleDriveHelper.GetValuesFromGoogleDrive(spreadSheetId, range);
return(response);
}
private void uploadToGoogleDriveToolStripMenuItem_Click(object sender, EventArgs e)
{
richTextBox1.Clear();
PrintInfo($"Uploading {_dbPath} to Google Drive...");
var gdh = new GoogleDriveHelper();
gdh.UpdateStoredFile(_dbPath, "5DFileData");
PrintInfo("Done.");
}
// GET: /Gallery/
public ActionResult GalleryIndex()
{
string secretJsonPath = Path.Combine(Server.MapPath("~/GoogleDrive/client_secret.json"));
string credentialsJSONPath = Path.Combine(Server.MapPath("~/GoogleDrive/.credentials/drive-dotnet-quickstart.json"));
string applicationName = "Drive API .NET Quickstart"; //"PhysioFirstAouth";
GoogleDriveHelper driveHelper = new GoogleDriveHelper(secretJsonPath, applicationName, credentialsJSONPath);
var listFiles = driveHelper.GetFilesFromGDrive();
//var model = _IGallery.GetAllPhoto();
return(View("Index", listFiles));
}
public async Task <ActionResult> Index()
{
var service = await GoogleDriveHelper.AuthenticateServiceAccount("*****@*****.**", HttpRuntime.AppDomainAppPath + "Kia feed-69b23139ac76.p12");
var filePath = HttpRuntime.AppDomainAppPath + "Kia feeds.xlsx";
var file = await GoogleDriveHelper.UploadFile(service, filePath, "");
var files = await GoogleDriveHelper.GetFiles(service);
return(View());
}
/// <summary>
/// https://github.com/LindaLawton/Google-Dotnet-Samples/tree/master/Google-Drive
/// </summary>
/// <param name="context"></param>
public async void Execute(IJobExecutionContext context)
{
// connect with a Service Account
const string serviceAccountEmail = "*****@*****.**";
var serviceAccountkeyFile = Path.Combine(HttpRuntime.AppDomainAppPath, "Temp", "My Project-b1363c7ae5f1.p12");
var service = await GoogleDriveHelper.AuthenticateServiceAccount(serviceAccountEmail, serviceAccountkeyFile);
var uploadFile = Path.Combine(HttpRuntime.AppDomainAppPath, "Temp", "Kia feed#1.xlsx");
await GoogleDriveHelper.UploadFile(service, uploadFile, "Kia vehicle feeds");
}
private IEnumerable <CpuBenchMarkScoreProperties> GetCpuBenchMarkScores()
{
var range = _configuration["CpuScoresSheet"];
var spreadSheetId = _configuration["SpreadSheetID"];
var response = GoogleDriveHelper.GetValuesFromGoogleDrive(spreadSheetId, range);
return(response.Values.Select(value => new CpuBenchMarkScoreProperties
{
CpuType = value[0].ToString(),
Score = Convert.ToInt32(value[1])
}).ToList());
}
static AppManagement()
{
var a = GoogleDriveHelper.GetAllProgramFiles();
settings = Serializer.DeSerializeObject <Settings>("settings.mr");
if (settings == null)
{
settings = new Settings(DateTime.MinValue);
}
backgroundProcessing = false;
}
public MainWindowViewModel()
{
CurrentWindowState = WindowState.Normal;
ShowBarInCalendarMenuButton = false;
ShowBarInEventListMenuButton = false;
ShowBarInAddNewEventMenuButton = false;
ShowLogInButton = true;
googleDriveHelper = new GoogleDriveHelper();
tokenPath = Path.Combine(tokenPath, ".credentials\\menadzer_zespolow_token.json");
if (Directory.Exists(tokenPath))
{
GoogleDriveService = googleDriveHelper.GetGoogleDriveService();
LoggedInAccount = "Zalogowano";
}
}
private static List <string> DownloadAllPackagesToSynchronize()
{
List <string> packages = new List <string>();
List <File> uploadedPackages = GoogleDriveHelper.GetAllProgramFiles();
foreach (var uploadedPackage in uploadedPackages)
{
if (!settings.uploadedPackages.Contains(uploadedPackage.Name))
{
string name = GoogleDriveHelper.DownloadAndUnzipPackage(uploadedPackage.Id, uploadedPackage.Name);
packages.Add(name);
GoogleDriveHelper.DeleteFile(uploadedPackage.Id);
}
}
return(packages);
}
public void Initialize()
{
_helper = new GoogleDriveHelper();
_shapes = new List <Shape>();
Shape shape = new ShapeFactory().CreateShape(ShapeType.Line);
shape.SetStartPoint(1, 1);
shape.SetEndPoint(10, 10);
_shapes.Add(shape);
shape = new ShapeFactory().CreateShape(ShapeType.Rectangle);
shape.SetStartPoint(2, 2);
shape.SetEndPoint(9, 9);
_shapes.Add(shape);
}
private async void btnReadFromGoogle_Click(object sender, RoutedEventArgs e)
{
GoogleDriveHelper gh = new GoogleDriveHelper();
if (await gh.LoginToGoogle(GoogleAuthJSON))
{
GoogleAuthJSON = gh.GoogleAuthJSON;
ApplicationDataContainer adc = ApplicationData.Current.LocalSettings.CreateContainer("GoogleDrive", ApplicationDataCreateDisposition.Always);
if (adc.Values.Keys.Contains("json"))
{
adc.Values["json"] = gh.GoogleAuthJSON;
}
else
{
adc.Values.Add("json", gh.GoogleAuthJSON);
}
if (gh.CreateService())
{
if (gh.ReadFile("TextEncryptor"))
{
txtData.Text = gh.fileData;
var alert = new MessageDialog("Successfully read file from Google!");
await alert.ShowAsync();
}
else
{
var alert = new MessageDialog("Error reading file from Google!");
await alert.ShowAsync();
}
}
else
{
var alert = new MessageDialog("Error creating Google Drive Service!");
await alert.ShowAsync();
}
}
else
{
var alert = new MessageDialog("Error connecting to Google!");
await alert.ShowAsync();
}
}
/// <summary>
/// Updating Boot Camper Machine in Google Drive
/// </summary>
public void UpdateBootCamperMachineDetails()
{
var currentSystemProps = GetSystemProperties();
var validate = ValidateSystemProperties(currentSystemProps);
var icList = GetIcsFromGoogleDrive();
var index = (from ic in icList.Values
where ic.Any(e => e.ToString() == _icEmail)
select icList.Values.IndexOf(ic)).FirstOrDefault();
// Why index + 3?
// We started with retrieving data from third row. So +2
// Retrieved index value starts from 0 so if it is 1 then actual value is 1+1
// Finally it 2 + index + 1
index = index + 3;
//Update Enough Specifications
var enoughSpecsStoredCell = _configuration["EnoughSpecsStoredCell"];
var spreadSheetId = _configuration["SpreadSheetID"];
GoogleDriveHelper.UpdateValuesInGoogleDrive(spreadSheetId, enoughSpecsStoredCell + index,
validate ? "Yes" : "No");
//Update Actual Machine Specs
var actualMachineSpecs = new StringBuilder();
actualMachineSpecs.AppendLine(" - CPU:" + currentSystemProps.ProcessorName);
actualMachineSpecs.AppendLine(" - CPU Score:" + currentSystemProps.CpuBenchMarkScore);
actualMachineSpecs.AppendLine(" - Memory:" + currentSystemProps.UsableMemory + "G");
actualMachineSpecs.AppendLine(" - OS:" + currentSystemProps.OperatingSystemEdition);
actualMachineSpecs.AppendLine(" - Storage:" + currentSystemProps.StorageSpace + "G");
actualMachineSpecs.AppendLine(" - Free disk space:" + currentSystemProps.FreeDiskSpace + "G");
actualMachineSpecs.Append(" - Arch:" + currentSystemProps.Architecture);
var actualMachineSpecsStoredCell = _configuration["ActualMachineSpecsStoredCell"];
GoogleDriveHelper.UpdateValuesInGoogleDrive(spreadSheetId, actualMachineSpecsStoredCell + index,
actualMachineSpecs.ToString());
WriteLine("Machine Configuration Details Updated Successfully in Google Drive in ICs sheets");
}
public Resourse Create(Resourse resourse)
{
resourse.Link = GoogleDriveHelper.UploadFile(resourse.Base64String, resourse.Title, resourse.Type);
_resourses.InsertOne(resourse);
return(resourse);
}
public AppWindowVM()
{
// Initiating command with async lambda function that will call Helper class to perform authentication and then fetching files
OAuth2AuthenticationCommand = new DelegateCommand(async() => { Files = await GoogleDriveHelper.GetFilesAsync(); });
}
