public static void Initialize(WarsawContext context)
{
context.Database.EnsureCreated();
if (!context.Descisions.Any())
{
Localization loc = new Localization()
{
Latitude = 20.9945904,
Longitude = 52.2330803,
Street = "Initial Warsaw"
};
Tag tag = new Tag()
{
TagName = "Initial Tag"
};
Decision dec = new Decision()
{
Content = "Initial decision",
Localizations = new List <Localization>()
{
loc
},
};
DecisionTag dg = new DecisionTag()
{
Tag = tag,
Decision = dec
};
context.Add(dec);
context.Add(dg);
context.SaveChanges();
}
//LoadFilesToDb(context);
}
public static StaticDecisionContainer GetInstance(WarsawContext context)
{
if (_instance == null)
{
_realDbContext = context;
_instance = new StaticDecisionContainer();
}
return(_instance);
}
static void LoadFilesToDb(WarsawContext context)
{
var projectPath = Directory.GetParent(Assembly.GetExecutingAssembly().Location).Parent.Parent.Parent.FullName;
var resourcesFolder = Path.Combine(projectPath, "Resources");
var mjnallFolder = Path.Combine(resourcesFolder, "txtmjnall");
if (Directory.Exists(mjnallFolder))
{
//LoadBefore2016(context, mjnallFolder);
LoadAfter2016(context, mjnallFolder);
}
}
private static void LoadAfter2016(WarsawContext context, string mjnallFolder)
{
CultureInfo provider = CultureInfo.InvariantCulture;
var filePaths2016 = Directory.GetFiles(Path.Combine(mjnallFolder, "mjn2016txtonly"));
foreach (var filePath in filePaths2016)
{
var filename = Path.GetFileName(filePath);
var fileContent = File.ReadAllText(filePath);
var submissionDate = new DateTime();
var datestring = string.Empty;
var streetFull = "No street in file name";
var decisionNumber = "decison name/number";
try
{
datestring = filename.Substring(0, 8);
submissionDate = DateTime.ParseExact(datestring, "ddMMyyyy", provider);
var endindex = filename.IndexOf('.');
decisionNumber = filename.Substring(8, endindex - 8).Replace("janr", "ja_nr").Replace("nr", "nr_");//TODO - decide how we should keep names in db
}
catch (Exception ex)
{
}
finally
{
Localization loc = new Localization()
{
Street = streetFull
};
Decision dec = new Decision()
{
Localizations = new List <Localization>()
{
loc
},
SubmissionDate = submissionDate,
Content = fileContent,
DecisionNumber = decisionNumber
};
context.Add(dec);
context.SaveChanges();
}
}
}
public static void Initialize(WarsawContext context)
{
context.Database.EnsureCreated();
if (!context.Tags.Any())
{
Tag tag = new Tag()
{
TagName = "Czy jest kurator spadku",
RegExp = "kurator"
};
Tag tag2 = new Tag()
{
TagName = "Czy jest kurator spadku",
RegExp = "otrzymuj"
};
Tag tag3 = new Tag()
{
TagName = "Kolejny wniosek do sprawy",
RegExp = "po rozpatrzeniu wniosku z dnia"
};
context.Add(tag);
context.Add(tag2);
context.Add(tag3);
context.SaveChanges();
}
// Decision dec = new Decision()
// {
// Content = "Initial decision",
// Localizations = new List<Localization>() { loc },
// };
// DecisionTag dg = new DecisionTag()
// {
// Tag = tag,
// Decision = dec
// };
// context.Add(dg);
//}
//LoadFilesToDb(context);
}
static void LoadFilesToDb(WarsawContext context)
{
var projectPath = Directory.GetParent(Assembly.GetExecutingAssembly().Location).Parent.Parent.Parent.FullName;
var resourcesFolder = Path.Combine(projectPath, "Resources");
var mjnallFolder = Path.Combine(resourcesFolder, "txtmjnall");
if (Directory.Exists(mjnallFolder))
{
CultureInfo provider = CultureInfo.InvariantCulture;
var filePaths = Directory.GetFiles(Path.Combine(mjnallFolder, "mjntxtonly"));
foreach (var filePath in filePaths)
{
var filename = Path.GetFileName(filePath);
var GKDW = filename.Contains("GKDW");
var CRWIP = filename.Contains("CRWIP") || filename.Contains("CRWiP");
var CRWIPbis = filename.Contains("CWRiP");// w minimum jednym pliku literówka...
var fileContent = File.ReadAllText(filePath);
//czasem konczy sie jakimś numeren identyfikacyjnym więc :
var s2689 = filename.Contains("2689");
var s2889 = filename.Contains("2889");
var s3490 = filename.Contains("3490");
var s2733 = filename.Contains("2733");
var randomEnding = s2689 || s2889 || s3490 || s2733;
if (GKDW)
{
var submissionDate = new DateTime();
var datestring = string.Empty;
var streetFull = "Failed to parse street";
try
{
var ind = filename.IndexOf("GKDW");
var streetstartIndex = ind + 4 + 8 + 4; //pomijam gkdw, date, i powtorzony rok
var streetEndIndex = filename.IndexOf('.'); // jeśli nic sie nie dzieje to do kropki
if (CRWIP)
{
streetEndIndex = filename.IndexOf("CRW");
}
if (CRWIPbis)
{
streetEndIndex = filename.IndexOf("CWR");
}
if (randomEnding && !(CRWIP || CRWIPbis))
{
streetEndIndex = streetEndIndex - 4;//cofamy od kropki 4 wstecz
}
streetFull = filename.Substring(streetstartIndex, streetEndIndex - streetstartIndex);
datestring = filename.Substring(ind + 4, 8);
submissionDate = DateTime.ParseExact(datestring, "yyyyddMM", provider);
}
catch (Exception ex)
{
}
finally
{
Localization loc = new Localization()
{
Street = streetFull
};
Decision dec = new Decision()
{
Localizations = new List <Localization>()
{
loc
},
SubmissionDate = submissionDate,
Content = fileContent
};
context.Add(dec);
context.SaveChanges();
}
}
if (!GKDW)
{
//przypadek do zrobienia "odtylu"
}
}
}
}
private static void LoadBefore2016(WarsawContext context, string mjnallFolder)
{
CultureInfo provider = CultureInfo.InvariantCulture;
var filePaths = Directory.GetFiles(Path.Combine(mjnallFolder, "mjntxtonly"));
foreach (var filePath in filePaths)
{
var filename = Path.GetFileName(filePath);
var GKDW = filename.Contains("GKDW");
var CRWIP = filename.Contains("CRWIP") || filename.Contains("CRWiP");
var CRWIPbis = filename.Contains("CWRiP");// w minimum jednym pliku literówka...
var fileContent = File.ReadAllText(filePath);
//czasem konczy sie jakimś numeren identyfikacyjnym więc :
var s2689 = filename.Contains("2689");
var s2889 = filename.Contains("2889");
var s3490 = filename.Contains("3490");
var s2733 = filename.Contains("2733");
var randomEnding = s2689 || s2889 || s3490 || s2733;
if (GKDW)
{
var submissionDate = new DateTime();
var datestring = string.Empty;
var streetFull = "Failed to parse street";
try
{
var ind = filename.IndexOf("GKDW");
var streetstartIndex = ind + 4 + 8 + 4; //pomijam gkdw, date, i powtorzony rok
var streetEndIndex = filename.IndexOf('.'); // jeśli nic sie nie dzieje to do kropki
if (CRWIP)
{
streetEndIndex = filename.IndexOf("CRW");
}
if (CRWIPbis)
{
streetEndIndex = filename.IndexOf("CWR");
}
if (randomEnding && !(CRWIP || CRWIPbis))
{
streetEndIndex = streetEndIndex - 4;//cofamy od kropki 4 wstecz
}
streetFull = filename.Substring(streetstartIndex, streetEndIndex - streetstartIndex);
datestring = filename.Substring(ind + 4, 8);
submissionDate = DateTime.ParseExact(datestring, "yyyyddMM", provider);
}
catch (Exception ex)
{
}
finally
{
Localization loc = new Localization()
{
Street = streetFull
};
Decision dec = new Decision()
{
Localizations = new List <Localization>()
{
loc
},
SubmissionDate = submissionDate,
Content = fileContent
};
context.Add(dec);
context.SaveChanges();
}
}
var GK = filename.Contains("GK");
// TODO
//if (GK && !GKDW)
//{
// var submissionDate = new DateTime();
// var datestring = string.Empty;
// var streetFull = "Failed to parse street";
// try
// {
// var ind = filename.IndexOf("GK");
// var streetstartIndex = ind + 2 + 8 + 4;//pomijam gkdw, date, i powtorzony rok
// var streetEndIndex = filename.IndexOf('.'); // jeśli nic sie nie dzieje to do kropki
// if (CRWIP)
// {
// streetEndIndex = filename.IndexOf("CRW");
// }
// if (CRWIPbis)
// {
// streetEndIndex = filename.IndexOf("CWR");
// }
// if (randomEnding && !(CRWIP || CRWIPbis))
// {
// streetEndIndex = streetEndIndex - 4;//cofamy od kropki 4 wstecz
// }
// streetFull = filename.Substring(streetstartIndex, streetEndIndex - streetstartIndex);
// datestring = filename.Substring(ind + 4, 8);
// submissionDate = DateTime.ParseExact(datestring, "yyyyddMM", provider);
// }
// catch (Exception ex)
// {
// }
// finally
// {
// Localization loc = new Localization()
// {
// Street = streetFull
// };
// Decision dec = new Decision()
// {
// Localizations = new List<Localization>() { loc },
// SubmissionDate = submissionDate,
// Content = fileContent
// };
// context.Add(dec);
// context.SaveChanges();
// }
//}
//if (!GK && !GKDW)
//{
// string s = "street nejm";
// int streetStart = 0;
// while (!Char.IsLetter(s[streetStart]))
// {
// ++streetStart;
// }
//}
//int pos = 0;
//while (!Char.IsLetter(s[pos]))
//{
// ++pos;
//}
}
}
