/// <summary> /// Test the SQL hookup, and debug into it to see how it works. /// </summary> private void SQLTest_Click(object sender, RoutedEventArgs e) { // Don't forget to have native debugging! FileDBManager db = new FileDBManager(); db.CreateDBExample(); }
protected void SaveFile(byte[] Data, UploadFileModel.Request value, string file) { string Name = ConfigurationManager.AppSettings["Path_Stats"] + value.device_mac; if (!Directory.Exists(Name)) { System.IO.Directory.CreateDirectory(Name); } string filename = Name + @"\" + file; File.WriteAllBytes(filename, Data); FileDBManager obj_FileDBManager = new FileDBManager(); var IP = ((HttpContextBase)Request.Properties["MS_HttpContext"]).Request.UserHostAddress; obj_FileDBManager.insertFile(value.device_mac, filename, value.os_version, value.device_model, IP, "stats"); Logger.writeLog("IP : " + IP + " Upload File stats สำเร็จ " + "\n"); }
private void handleFile() { try { int length = (int)Request.InputStream.Length; //we expect some data. If there is no data. skip it. string queryMac = null; if (length <= 0) { try { queryMac = Request.QueryString["id"].ToString(); } catch (Exception ex) { } Response.Write("Invalid Request"); if (queryMac != null) Logger.writeLog(" IP : " + Request.UserHostAddress + " Invalid request from mobile device. Device Mac: " + queryMac + "\n"); else Logger.writeLog("IP : " + Request.UserHostAddress + " Invalid requst. Unknown mac address." + "\n"); return; } byte[] buffer = new byte[length]; Request.InputStream.Read(buffer, 0, length); //read the zip file String fileName = Request.QueryString["id"]; SaveZipFile(buffer, fileName + ".zip"); //save the zip file. string path = unCompressZipFile(fileName); //extract the zip file. Path is abolute path of uncompressed file. FileDBManager fileDBManager = new FileDBManager(); //insert the file name in database. bool result = fileDBManager.insertFile(path); if (result) Logger.writeLog(" IP : " + Request.UserHostAddress + " File inserted successfuly. File Path:\t " + path + "\n"); } catch (Exception e) { Logger.writeLog("Error occured in handleFile class. Details: " + e.ToString()); } }
static void Main(string[] args) { FileDBManager fileDBManager = new FileDBManager(); //bool result=fileDBManager.insertFile(@"c:\\testfilepath\\xyz.993929493243249312.stats"); List<string> file = fileDBManager.getFilesList(); if (file.Count() == 0) { Logger.writeLog("No unprocessed files in table."); return; } long records = 0; int totalFiles = 0; foreach (string f in file) { Console.WriteLine("Processing: "+f.Trim()); DBManager dbManager = new DBManager(); records=records+dbManager.insertRecords(f.Trim()); totalFiles++; fileDBManager.setProcessed(f.Trim()); CacheAppsId.clearCache(); } Logger.writeLog(records + " Records have been inserted from " + totalFiles+" files."); Logger.writeLine(); }