/// <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();
}
