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