static void DbRequestToFile()
{
var date = DateTime.Now;
var dbtofilefname = "request.txt";
if (!Directory.Exists(dbtofilePath))
{
Directory.CreateDirectory(dbtofilePath);
}
var fname = Path.Combine(dbtofilePath, dbtofilefname);
Console.WriteLine("{0}, export Request data to file, started...", DateTime.Now);
using (var db = new studyinContext())
{
var tempday = date.AddDays(-1);
// var yesterday = DateTime.Parse(string.Format("{0}/{1}/{2}", 2000, tempday.Month, tempday.Day));
var yesterday = DateTime.Parse(string.Format("{0}/{1}/{2}", tempday.Year, tempday.Month, tempday.Day));
var theuser = db.Request.Where(async => async.Time.CompareTo(yesterday) > 0);
Console.WriteLine("yesterday is {0},today is {1}, {2} requests need to be archived", yesterday, date, theuser.Count());
foreach (var re in theuser)
{
File.AppendAllText(fname, JsonConvert.SerializeObject(re) + "\r\n");
}
}
Console.WriteLine("{0}, export Request data to file, end...", DateTime.Now);
}
static void DbToFileForExtranetToIntranet()
{
var date = DateTime.Now;
var dir = string.Format("{0}-{1}-{2}-{3}-{4}-{5}", date.Year, date.Month.ToString("D2"), date.Day.ToString("D2"),
date.Hour.ToString("D2"), date.Minute.ToString("D2"), date.Second.ToString("D2"));
var dbtofilefname = string.Format("{0}-{1}-{2}", date.Year, date.Month.ToString("D2"), date.Day.ToString("D2"))
+ "extranetToIntranet.dat";
if (!Directory.Exists(dbtofilePath))
{
Directory.CreateDirectory(dbtofilePath);
}
var fname = Path.Combine(dbtofilePath, dbtofilefname);
Console.WriteLine("{0}, export out-in data to file, started...", DateTime.Now);
using (var db = new studyinContext())
{
var tempday = date.AddDays(-1);
var yesterday = DateTime.Parse(string.Format("{0}/{1}/{2}", tempday.Year, tempday.Month, tempday.Day));
var theuser = db.History.Where(async => async.Finishdate.CompareTo(date) <= 0 &&
async.Finishdate.CompareTo(yesterday) > 0
);
Console.WriteLine("yesterday is {0},today is {1}, {2} records need to be archived", yesterday, date, theuser.Count());
foreach (var re in theuser)
{
File.AppendAllText(fname, JsonConvert.SerializeObject(re) + "\r\n");
NewMethod(re.Photofile);
}
}
if (!Directory.Exists(exportPath))
{
Directory.CreateDirectory(exportPath);
}
var zipfname = Path.Combine(exportPath, dir);
var a = new System.Diagnostics.Process();
a.StartInfo.UseShellExecute = true;
a.StartInfo.Arguments =
string.Format(" {0} {1}/* -r", zipfname, dbtofilePath);
a.StartInfo.FileName = "zip";
a.Start();
a.WaitForExit();
Console.WriteLine("{0}, export out-in data to file, end...", DateTime.Now);
}
static void DbUserToFile()
{
var date = DateTime.Now;
// var dir = string.Format("{0}-{1}-{2}-{3}-{4}-{5}", date.Year, date.Month.ToString("D2"), date.Day.ToString("D2"),
// date.Hour.ToString("D2"), date.Minute.ToString("D2"), date.Second.ToString("D2"));
var dbtofilefname = "user.txt";
if (!Directory.Exists(dbtofilePath))
{
Directory.CreateDirectory(dbtofilePath);
}
var fname = Path.Combine(dbtofilePath, dbtofilefname);
Console.WriteLine("{0}, export user data to file, started...", DateTime.Now);
var actualcount = 0;
using (var db = new studyinContext())
{
try{
var tempday = date.AddDays(-1);
// var yesterday = DateTime.Parse(string.Format("{0}/{1}/{2}", 2000, tempday.Month, tempday.Day));
var yesterday = DateTime.Parse(string.Format("{0}/{1}/{2}", tempday.Year, tempday.Month, tempday.Day));
var theuser = db.User.Where(async => async.Syncdate.CompareTo(yesterday) > 0 &&
(async.Firstsigned == "1" || async.Signed == "1" || !string.IsNullOrEmpty(async.Studylog)));
Console.WriteLine("yesterday is {0},today is {1}, {2} users need to be archived", yesterday, date, theuser.Count());
foreach (var re in theuser)
{
if (re.Startdate?.CompareTo(date.AddMonths(-2)) < 0)
{
continue;
}
File.AppendAllText(fname, JsonConvert.SerializeObject(re) + "\r\n");
NewMethod(re.Photofile);
actualcount++;
}
}catch (Exception ex) {
Console.WriteLine("{0}, export usesr data to file, error={1}", DateTime.Now, ex.Message);
}
}
Console.WriteLine("{0}, export {1} users data to file, end...", DateTime.Now, actualcount);
}
static void Main(string[] args)
{
var quit = false;
do
{
var now = DateTime.Now;
try
{
using (var abdb = new studyinContext())
{
var req = abdb.Request.OrderBy(a => a.Ordinal).LastOrDefault();
if (req == null)
{
sendautomsg("db-error");
}
else
{
if (now.Hour >= 6)
{
if (req.Time < now.AddMinutes(-10))
{
sendautomsg(string.Format("last-request-time-{0}", getdate(req.Time)));
}
}
}
// if (now.Minute < 10)//report per hour
// {
// var cc = abdb.Request.Where(b => b.Time > now.AddHours(-1)).Count();
// sendautomsg(string.Format("last-hour-had-{0}-requests", cc));
// }
}
}
catch (Exception ex)
{
Console.WriteLine(now + "something happened ... " + ex.Message);
}
Thread.Sleep(1000 * 60 * 10);
} while (!quit);
}
static void DbToFileForStatistics()
{
var date = DateTime.Now;
var dir = string.Format("{0}-{1}-{2}-{3}-{4}-{5}", date.Year, date.Month.ToString("D2"), date.Day.ToString("D2"),
date.Hour.ToString("D2"), date.Minute.ToString("D2"), date.Second.ToString("D2"));
var dbtofilefname = string.Format("{0}-{1}-{2}", date.Year, date.Month.ToString("D2"), date.Day.ToString("D2"))
+ "statistics.txt";
if (!Directory.Exists(dbtofilePath))
{
Directory.CreateDirectory(dbtofilePath);
}
var fname = Path.Combine(dbtofilePath, dbtofilefname);
Console.WriteLine("{0}, export Statistics data to file, started...", DateTime.Now);
using (var db = new studyinContext())
{
var temp = string.Format("{0}/{1}/{2}", date.Year, date.Month, date.Day);
var tempday = DateTime.Parse(temp);
// var theuser = db.History.Where(async => async.Finishdate.CompareTo(date) <= 0
// && async.Finishdate.CompareTo(yesterday) > 0
// );
Console.WriteLine("tempday is {0},today is {1},", tempday, date);
var visitorVolumeAll = db.Request.Count();
var usageAmountAll = db.Request.Where(us => !us.Method.Contains("LoginAndQuery")).Count();
var visitorVolumeToday = db.Request.Where(us => us.Time.CompareTo(tempday) >= 0).Count();
var usageAmountToday = db.Request.Where(us => us.Time.CompareTo(tempday) >= 0 && !us.Method.Contains("LoginAndQuery")).Count();
var startLearningVolume = db.User.Where(bb => !string.IsNullOrEmpty(bb.Studylog)).Count();
var startLearningVolumetoday = db.User.Where(bb => !string.IsNullOrEmpty(bb.Studylog) && bb.Startdate > date.AddDays(-1)).Count();
File.AppendAllText(fname, string.Format("{0},{1},{2},{3},{4},{5},{6}",
temp, visitorVolumeAll, usageAmountAll, visitorVolumeToday, usageAmountToday, startLearningVolume, startLearningVolumetoday));
}
Console.WriteLine("{0}, export Statistics data to file, end...", DateTime.Now);
}