static void DbToFileForExtranetToIntranet()
{
var date = DateTime.Today;
var dir = string.Format("{0}{1}{2}", date.Year, date.Month, date.Day);
var dbtofilefname = dir + "extranetToIntranet.dat";
if (!Directory.Exists(dbtofilePath))
{
Directory.CreateDirectory(dbtofilePath);
}
var fname = Path.Combine(dbtofilePath, dbtofilefname);
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));
Console.WriteLine("yesterday is {0},today is {1}", yesterday, date);
var theuser = db.History.Where(async => async.Finishdate.CompareTo(date) <= 0 &&
async.Finishdate.CompareTo(yesterday) > 0);
foreach (var re in theuser)
{
File.AppendAllText(fname, JsonConvert.SerializeObject(re));
}
}
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} {2} /home/inspect/signature/{1}/* /home/inspect/logphoto/{1}/*", zipfname, dir, fname);
a.StartInfo.FileName = "zip";
a.Start();
}
static void FileToDb()
{
using (var db = new studyinContext())
{
var fname = Path.Combine(importPath, "allowToStudy.txt");
if (File.Exists(fname))
{
var content = File.ReadAllLines(fname);
foreach (var line in content)
{
var fields = line.Split(',');
var identity = fields[0];
var phone = fields[1];
var drivertype = fields[2];
DrivingLicenseType enumtype;
if (!Enum.TryParse(drivertype, out enumtype))
{
enumtype = DrivingLicenseType.Unknown;
}
var drugrelated = fields[3];
var pictureok = fields[4];
var deductedmarks = fields[5];
var licensenumber = fields[6];
var photofile = fields[7];
var ideducted = 0;
if (!int.TryParse(deductedmarks, out ideducted))
{
ideducted = 1;
}
var theuser = db.User.FirstOrDefault(async => async.Identity == identity);
if (theuser == null)
{
try
{
db.User.Add(new User
{
Identity = identity,
Licensetype = ((int)enumtype).ToString(),
Drugrelated = drugrelated,
Syncphone = phone,
Photostatus = pictureok,
Drivinglicense = licensenumber,
Deductedmarks = ideducted,
Photofile = photofile,
Syncdate = DateTime.Now
});
}
catch (Exception ex)
{
Console.WriteLine("user {0} sync error{1}.", identity, ex.Message);
}
}
else
{
Console.WriteLine("user {0} has already existed.", identity);
}
db.SaveChanges();
}
}
}
}
