static void FileToDbIhistory()
{
using (var db = new studyinContext())
{
var filebase = "DateSync/history.txt";
var fname = Path.Combine(importPath, filebase);
if (!File.Exists(fname))
{
Console.WriteLine("file {0} does not exist, exit.{1}", fname, DateTime.Now);
return;
}
var content = File.ReadAllLines(fname);
foreach (var line in content)
{
try
{
var aaa = JsonConvert.DeserializeObject <IHistory>(line);
db.IHistory.Add(new IHistory
{
Id = aaa.Id,
Idcard = aaa.Idcard,
Licence = aaa.Licence,
Sremark = aaa.Sremark,
Phonenumber = aaa.Phonenumber,
Deductpoints = aaa.Deductpoints,
Zhiduinumber = aaa.Zhiduinumber,
Address = aaa.Address,
Name = aaa.Name,
Filename = aaa.Filename,
Licencenumber = aaa.Licencenumber,
Status = aaa.Status,
Time = aaa.Time,
Photo = aaa.Photo,
Printed = aaa.Printed,
Processed = aaa.Processed,
Messaged = aaa.Messaged,
Studylog = aaa.Studylog,
Failure = aaa.Failure,
Syyxqz = aaa.Syyxqz,
Ordinal = aaa.Ordinal,
Dabh = aaa.Dabh,
County = aaa.County,
});
db.SaveChanges();
Console.WriteLine("ihistory {0} has already updated.{1}", aaa.Id, DateTime.Now);
}
catch (Exception ex)
{
Console.WriteLine("ihistory {0} error.{1}", ex.Message, DateTime.Now);
}
}
}
}
static void FileToDb()
{
using (var db = new studyinContext())
{
var filebase = "allowToStudy.txt";
var fname = Path.Combine(importPath, filebase);
if (!File.Exists(fname))
{
Console.WriteLine("file {0} does not exist, exit.{1}", fname, DateTime.Now);
return;
}
var content = File.ReadAllLines(fname);
foreach (var line in content)
{
var fields = line.Split(',');
if (fields.Length < 9)
{
Console.WriteLine(" invalid data line {0},{1}", fields.Length, line);
continue;
}
var identity = fields[0];
if (identity.Length > 44)
{
Console.WriteLine(" invalid data line, identity={0}-{2},{1}", identity.Length, line, identity);
continue;
}
var phone = fields[1];
var drivertype = fields[2].Substring(0, 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 status = fields[8];
var ideducted = 0;
if (!int.TryParse(deductedmarks, out ideducted))
{
ideducted = 1;
}
var theuser = db.User.FirstOrDefault(async => async.Identity == identity);
if (theuser == null)
{
try
{
var today = DateTime.Now;
var his = db.History.Where(async => async.Identity == identity).OrderBy(al => al.Finishdate).LastOrDefault();
if (his != null)
{
if (his.Finishdate.CompareTo(today.AddMonths(-1)) > 0)
{
Console.WriteLine("user {0} had already finished learning on that day {10}, discarded! {1},{2},{3},{4},{5},{6},{7},{8},{9}",
identity, ((int)enumtype).ToString(), drugrelated, phone,
pictureok, licensenumber, ideducted
, photofile, status, today, his.Finishdate);
continue;
}
}
// Console.WriteLine("import user {0} , {1},{2},{3},{4},{5},{6},{7},{8},{9}",
// identity, ((int)enumtype).ToString(), drugrelated, phone,
// pictureok, licensenumber, ideducted
// , photofile, status, today);
var inspect = "1";
if (fields.Length > 9)
{
if (fields[9] == "0")
{
inspect = "0";
}
}
db.User.Add(new User
{
Identity = identity,
Licensetype = ((int)enumtype).ToString(),
Drugrelated = drugrelated,
Syncphone = phone,
Inspect = inspect,
Photostatus = pictureok,
Drivinglicense = licensenumber,
Deductedmarks = ideducted,
Photofile = photofile,
Status = status,
Syncdate = today
});
db.SaveChanges();
Console.WriteLine("import user {0} ok {1}", identity, DateTime.Now);
}
catch (Exception ex)
{
Console.WriteLine("user {0} sync error{1}.", identity, ex.Message);
}
}
else
{
if (status != theuser.Status)
{
theuser.Status = status;
}
if (drugrelated == "1")
{
theuser.Drugrelated = drugrelated;
}
theuser.Syncdate = DateTime.Now;
if (fields.Length > 9)
{
switch (fields[9])
{
case "0":
theuser.Inspect = fields[9];
break;
default:
theuser.Inspect = "1";
break;
}
}
else
{
theuser.Inspect = "1";
}
if (theuser.Inspect == "1" &&
theuser.Firstsigned == "1" && !string.IsNullOrEmpty(theuser.Token)
// &&! string.IsNullOrEmpty( theuser.Studylog)
&& theuser.Startdate < DateTime.Now.AddMonths(-2)
)
{
Console.WriteLine("user {0} has already updated.{1}, have right to learn.{2}", identity, DateTime.Now, theuser.Startdate);
theuser.Firstsigned = "0";
theuser.Studylog = string.Empty;
theuser.Token = string.Empty;
theuser.Startdate = DateTime.Now;
}
db.SaveChanges();
// Console.WriteLine("user {0} has already updated.{1}", identity, DateTime.Now);
}
}
}
}
