private Uczelnia LoadAcademy()
{
Uczelnia academy = new Uczelnia();
academy.nazwa_uczelni = window.AcademyName;
academy.nazwa_wydzialu = window.FacultyName;
return(academy);
}
public ActionResult DeleteConfirmed(int id)
{
Uczelnia uczelnia = db.Uczelnia.Find(id);
db.Uczelnia.Remove(uczelnia);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public static void writeToXML(String file, List <Student> students)
{
FileStream writer = new FileStream(file, FileMode.Append);
XmlSerializer serializer = new XmlSerializer(typeof(Uczelnia));
Uczelnia uczelnia = new Uczelnia {
studenci = students, author = "Maciej Petrykowski", createdAt = System.DateTime.Now.ToString()
};
serializer.Serialize(writer, uczelnia);
}
public ActionResult Edit([Bind(Include = "id_uczelni,nazwa,id_adresu")] Uczelnia uczelnia)
{
if (ModelState.IsValid)
{
db.Entry(uczelnia).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.id_adresu = new SelectList(db.Adres, "id_adresu", "miejscowosc", uczelnia.id_adresu);
return(View(uczelnia));
}
public static void writeToJson(string file, List <Student> students)
{
Uczelnia uczelnia = new Uczelnia {
author = "Maciej Petrykowski", createdAt = System.DateTime.Now.ToString(), studenci = students
};
var jsonString = "{\"uczelnia\":" + JsonSerializer.Serialize(uczelnia) + "}";
using (StreamWriter writer = new StreamWriter(file, true))
{
writer.Write(jsonString);
}
}
// GET: Uczelnias/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Uczelnia uczelnia = db.Uczelnia.Find(id);
if (uczelnia == null)
{
return(HttpNotFound());
}
return(View(uczelnia));
}
static void Main(string[] args)
{
var inputPath = args.Length > 0 ? args[0] : @"Files\dane.csv";
var outputPath = args.Length > 1 ? args[0] : @"Files\result.xml";
var dataType = args.Length > 2 ? args[0] : "xml";
var university = new Uczelnia();
//Console.WriteLine($"{arg1} {arg2} {arg3}");
try
{
if (!File.Exists(inputPath))
{
throw new FileNotFoundException("ERR", inputPath.Split("\\")[^ 1]);
// GET: Uczelnias/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Uczelnia uczelnia = db.Uczelnia.Find(id);
if (uczelnia == null)
{
return(HttpNotFound());
}
ViewBag.id_adresu = new SelectList(db.Adres, "id_adresu", "miejscowosc", uczelnia.id_adresu);
return(View(uczelnia));
}
static void Main(string[] args)
{
string path;
string result;
string dataFormat;
string logPath = "log.txt";
var list = new List <Student>();
if (args.Length != 3)
{
path = @"Data/data.csv";
result = @"result.xml";
dataFormat = "xml";
}
else
{
path = args[0];
result = args[1];
dataFormat = args[2];
}
//If log file doesn't exist the follwing line creates it; if it does the line does nothing
using (StreamWriter w = File.AppendText("log.txt"));
//Wczytywanie pliku
var fi = new FileInfo(path);
try {
using (var stream = new StreamReader(fi.OpenRead())) {
string line = null;
while ((line = stream.ReadLine()) != null)
{
string[] kolumny = line.Split(',');
bool whitespace = false;
bool duplicate = false;
//Check if any column is whitespace
for (int i = 0; i < kolumny.Length; i++)
{
if (String.IsNullOrWhiteSpace(kolumny[i]))
{
whitespace = true;
}
}
//Check if there already is this student in a list
foreach (Student student in list)
{
string index = "s" + kolumny[4];
if (string.Equals(student.Imie, kolumny[0]) && string.Equals(student.Nazwisko, kolumny[1]) && string.Equals(student.Indeks, index))
{
duplicate = true;
}
}
//If any column is missing ignore the line and write it to log file
if (kolumny.Length != 9)
{
StreamWriter streamWriter = File.AppendText(logPath);
streamWriter.WriteLine("Brak wszystkich danych: " + line);
streamWriter.Close();
}
//If any column is whitespace ignore it and write it to log file
else if (kolumny.Length == 9 && whitespace == true)
{
StreamWriter streamWriter = File.AppendText(logPath);
streamWriter.WriteLine("Brak wszystkich danych(kolumna zawiera znaki biale): " + line);
streamWriter.Close();
}
//If this studentInfo is a duplicate then ignore it and write it to log file
else if (kolumny.Length == 9 && duplicate == true)
{
StreamWriter streamWriter = File.AppendText(logPath);
streamWriter.WriteLine("Duplikat: " + line);
streamWriter.Close();
}
//All information is valid -> add it to the list
else
{
Student student = new Student {
Imie = kolumny[0],
Nazwisko = kolumny[1],
studies = new Studies(),
Indeks = "s" + kolumny[4],
Urodz = kolumny[5],
Email = kolumny[6],
ImieMatki = kolumny[7],
ImieOjca = kolumny[8]
};
student.studies.Kierunek = kolumny[2];
student.studies.Tryb = kolumny[3];
list.Add(student);
}
}
}
} catch (FileNotFoundException fileNotFoundException) {
StreamWriter streamWriter = File.AppendText(logPath);
streamWriter.WriteLine("Plik " + path + " nie istnieje");
streamWriter.Close();
Console.WriteLine("Plik " + path + " nie istnieje");
}
//getting dictionary with unique activeStudies and their student numbers
Dictionary <string, int> studentNumbers = getActiveStudiesDict(list);
//putting unique activeStudies into an array
Studies[] studies = new Studies[studentNumbers.Count];
int counter = 0;
foreach (KeyValuePair <string, int> entry in studentNumbers)
{
studies[counter] = new Studies {
activeStudiesName = entry.Key,
numberOfStudents = ((int)entry.Value).ToString()
};
counter++;
}
ActiveStudies activeStudies = new ActiveStudies()
{
studies = studies
};
//combining final Uczelnia object to serialize
Uczelnia uczelnia = new Uczelnia {
createdAt = "13.03.2020",
author = "Kamil Kojs",
studenci = list,
activeStudies = activeStudies
};
//preparing fileStream to save XML to file
FileStream writer = null;
try {
writer = new FileStream(result, FileMode.Create);
} catch (ArgumentException argumentException) {
StreamWriter streamWriter = File.AppendText(logPath);
streamWriter.WriteLine("Podana sciezka jest niepoprawna");
streamWriter.Close();
Console.WriteLine("Podana sciezka jest niepoprawna");
}
//preparing XML serializer
var xns = new XmlSerializerNamespaces();
xns.Add(string.Empty, string.Empty);
//If serializing in XML
if (string.Equals("xml", dataFormat))
{
XmlSerializer serializer = new XmlSerializer(typeof(Uczelnia));
serializer.Serialize(writer, uczelnia, xns);
}
}
static void Main(string[] args)
{
string path = null;
string outPath = null;
string format = null;
/*string path = @"Dane\dane.csv";;
* string outPath = @"result.xml";
* string format = "xml";*/
string pathLogi = @Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments) + "logi.txt");
StreamWriter logi = File.CreateText(pathLogi);
File.AppendAllText(Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments) + "/logi.txt"), "Uruchoomienie....." + Environment.NewLine);
//File logi = new File(Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments), "/logi.txt"), FileMode.Create);
//File logFile = new StreamWriter(Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments), "logi.txt"));
string log = "";
try
{
if (args[0] != null)
{
try
{
path = args[0];
Console.WriteLine("ustalono plik wejsciowy z args");
}
catch
{
File.AppendAllText(Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments) + "/logi.txt"), "podana sciezka nie jest poprawna" + Environment.NewLine);
path = @"Dane\dane.csv";
}
}
else
{
path = @"Dane\dane.csv";
}
if (args[1] != null)
{
try
{
outPath = args[1];
Console.WriteLine("ustalono sciezke pliku docelowego z args");
}
catch
{
File.AppendAllText(Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments) + "/logi.txt"), "podana sciezka nie jest poprawna" + Environment.NewLine);
outPath = @"result.xml";
}
}
else
{
outPath = @"result.xml";
}
if (args[2] != null)
{
try
{
format = args[2];
Console.WriteLine("format to " + args[2]);
}
catch
{
File.AppendAllText(Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments) + "/logi.txt"), "podana sciezka nie jest poprawna" + Environment.NewLine);
format = "xml";
}
}
else
{
format = "xml";
}
//path = @"Dane\dane.csv";
//string[] plik = path.Split('/');
Console.WriteLine("Rozpoczynam działanie...");
int liczba = 0;
var fi = new FileInfo(path);
var list = new List <Student>();
Console.WriteLine("Utworzono listą na studentow");
var kierunkis = new List <string>();
var liczbynakierunkach = new List <int>();
var listaKier = new List <activeStudies>();
Console.WriteLine("Utworzono listą na kierunki");
using (var stream = new StreamReader(fi.OpenRead()))
{
string line = null;
//string line = null;
Console.WriteLine("wczytuje dane studentow i tworze obiekty");
while ((line = stream.ReadLine()) != null)
{
//Console.WriteLine(line);
liczba++;
string[] student = line.Split(',');
if (student.Length == 9)
{
bool istnieje = false;
for (int i = 0; i < 9; i++)
{
if (student[i].Equals("") || student[i].Equals(" "))
{
istnieje = true;
File.AppendAllText(Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments) + "/logi.txt"), "za malo danych dla studenta" + Environment.NewLine);
}
}
var stu = new Student
{
Imie = student[0],
Nazwisko = student[1],
Studia = new Studies
{
Kierunek = student[2],
TrybSt = student[3]
},
Eska = int.Parse(student[4]),
DataUr = student[5],
Email = student[6],
ImieM = student[7],
ImieO = student[8]
};
//bool istnieje = false;
foreach (Student st in list)
{
if ((stu.equals(st)))
{
//list.Add(stu);
istnieje = true;
//logFile.WriteLine("pominieto");
//File.AppendAllText(Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments) + "/logi.txt"), "pominieto "+st.Eska + Environment.NewLine);
}
else
{
File.AppendAllText(Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments) + "/logi.txt"), "duplikat " + st.Eska + Environment.NewLine);
}
}
if (istnieje == false)
{
list.Add(stu);
if (!(kierunkis.Contains(stu.Studia.Kierunek)))
{
kierunkis.Add(stu.Studia.Kierunek);
liczbynakierunkach.Add(0);
activeStudies KierunekJakis = new activeStudies {
};
KierunekJakis.name = stu.Studia.Kierunek;
KierunekJakis.numberOfStud = "1";
listaKier.Add(KierunekJakis);
}
else
{
int index = kierunkis.FindIndex(x => x == stu.Studia.Kierunek);
listaKier[index].numberOfStud = (1 + int.Parse(listaKier[index].numberOfStud)).ToString();
}
/*int index = kierunkis.FindIndex(x => x == stu.Studia.Kierunek);
* int item = liczbynakierunkach[index];
* liczbynakierunkach[index] = (liczbynakierunkach[index] + 1);*/
}
}
}
/*foreach(string kierunki in kierunkis)
* {
* Console.WriteLine(kierunki);
* }*/
Console.WriteLine("koniec tworzenia");
Console.WriteLine("liczba studentow w pliku to " + liczba);
Console.WriteLine("liczba studentow dodanych do listy to " + list.Count);
}
var listaActAndliczby = new List <string>();
for (int i = 0; i < kierunkis.Count; i++)
{
listaActAndliczby.Add("name:" + kierunkis[i] + " " + "numberOfStudents " + liczbynakierunkach[i] + "");
}
var ucz = new Uczelnia
{
data = "13.03.2020",
author = "Seweryn_Kruk",
studenci = list,
kierunki = listaKier
};
if (format.Equals("xml"))
{
Console.WriteLine("Tworze xml");
FileStream writer = new FileStream(outPath, FileMode.Create);
XmlSerializer serializer = new XmlSerializer(typeof(Uczelnia), new XmlRootAttribute("uczelnia"));
XmlSerializerNamespaces empty = new XmlSerializerNamespaces();
empty.Add("", "");
serializer.Serialize(writer, ucz, empty);
}
if (format.Equals("json"))
{
Console.WriteLine("Tworze json");
var jsonString = JsonSerializer.Serialize(list, new JsonSerializerOptions {
WriteIndented = true
});
File.WriteAllText("data.json", jsonString);
}
Console.WriteLine("zakończopno działnie programu");
}
catch (ArgumentException e)
{
File.AppendAllText(Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments) + "/logi.txt"), "podana sciezka nie jest poprawna" + Environment.NewLine);
}
catch (FileNotFoundException e)
{
File.AppendAllText(Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments) + "/logi.txt"), "plik nie istnieje" + Environment.NewLine);
}
}
public static List <Student> czytaj(string plikWejscie)
{
//LETS GETET STARTET YEE
//string file = @"Data/dane.csv";
try
{
if (!File.Exists(plikWejscie))
{
throw
new FileNotFoundException("Plik nie istnieje");
}
/*var regex = new Regex(@"[A-Z,a-z]\/[A-Z,a-z]\.csv");
* var name = plikWejscie.Substring(0, plikWejscie.LastIndexOf('v'));
* if (!regex.IsMatch(name))
* throw
* new ArgumentException("Podana ścieżka jest niepoprawna");
*
* nwm czemu mi to nie dziala próbowalam to naprawic godzine
* ale zakladam ze jak sciezka bedzie zla to wywali FileNotFoE
*/
//XLM
//Wczytywaie pliku
FileInfo f = new FileInfo(plikWejscie);
using (StreamReader stream = new StreamReader(f.OpenRead()))
{
string line = "";
while ((line = stream.ReadLine()) != null)
{
string[] studentWiersz = line.Split(',');
for (int i = 0; i < studentWiersz.Length; i += 9)
{
bool jakTam1 = sprawdzamStudenta(studentWiersz, line);
if (jakTam1)
{
Studies s = new Studies
{
name = studentWiersz[2],
mode = studentWiersz[3],
};
var st = new Student
{
Imie = studentWiersz[i],
Nazwisko = studentWiersz[i + 1],
numer_indexu = "s" + studentWiersz[i + 4],
data_urodzenia = studentWiersz[i + 5],
Email = studentWiersz[i + 6],
imie_matki = studentWiersz[i + 7],
imie_ojca = studentWiersz[i + 8],
studies = new Studies {
name = studentWiersz[i + 2], mode = studentWiersz[i + 3]
},
studKU = s
};
list.Add(st);
if (studKU.ContainsKey(s.name))
{
studKU[s.name]++;
}
else
{
studKU.Add(s.name, 1);
}
}
//kierynek 2,3
//index4
//uro5
//mail6
//mama7
//mode3
// stream.Dispose(); //.... IDisposible
}
// ...
}
ActiveStudies active = new ActiveStudies()
{
ACl = new List <AC>()
};
foreach (KeyValuePair <string, int> entry in studKU)
{
AC a = new AC
{
name = entry.Key,
number = entry.Value
};
active.ACl.Add(a);
}
Uczelnia uczelnia = new Uczelnia
{
studenci = list,
autor = "Patrycja Dankowska",
czas = System.DateTime.Now.ToString(),
activeStudies = active
};
FileStream writer = new FileStream(@"data.xml", FileMode.Create);
XmlSerializer serializer = new XmlSerializer(typeof(Uczelnia),
new XmlRootAttribute("uczelnia"));
serializer.Serialize(writer, uczelnia);
Console.WriteLine(line + "zakonczenie robienia xml i log ,nacisnij enter i sprawdz bin");
}
}
catch (FileNotFoundException e)
{
Console.WriteLine(e);
//throw;
}
catch (ArgumentException e1)
{
Console.WriteLine(e1);
}
return(list);
}
static void Main(string[] args)
{
var list = new List <Student>();
using (StreamWriter fw = new StreamWriter("log.txt"))
{
Console.WriteLine("Podaj lokalizację pliku!");
string par1 = Console.ReadLine();
var lokalizacja = (String.IsNullOrEmpty(par1) ? "dane.csv" : par1);
if (!File.Exists(lokalizacja))
{
Console.Error.Write("File not found!");
fw.Write("File not found! : " + lokalizacja + " exiting program!");
fw.Dispose();
Environment.Exit(1);
}
Console.WriteLine("Podaj plik wyjściowy!");
string par2 = Console.ReadLine();
var output = (String.IsNullOrEmpty(par2) ? "result.xml" : par2);
Console.WriteLine(lokalizacja);
Console.WriteLine(output);
var lines = File.ReadAllLines(lokalizacja); //tablica stringow jeden to jedna linijka
bool czyZapisac = true;
for (int i = 0; i < lines.Length; i++)
{
var line = lines[i].Split(",");
czyZapisac = true;
foreach (var z in line)
{
if (String.IsNullOrEmpty(z))
{
fw.Write("Niekompletny student: " + lines[i] + "\n");
czyZapisac = false;
break;
}
}
if (czyZapisac)
{
foreach (var z in list)
{
if (z.eska == line[4])
{
fw.Write("Duplikat studenta: " + lines[i] + "\n");
czyZapisac = false;
break;
}
}
}
if (czyZapisac)
{
Studia s = new Studia
{
name = line[2],
mode = line[3]
};
list.Add(new Student
{
Imie = line[0],
Nazwisko = line[1],
Data_urodzenia = line[5],
Email = line[6],
Imie_matki = line[7],
Imie_Ojca = line[8],
eska = line[4],
Studia = s
});
}
}
Dictionary <string, int> hash = new Dictionary <string, int>();
for (int i = 0; i < list.Count; i++)
{
if (hash.ContainsKey(list[i].Studia.name))
{
hash[list[i].Studia.name]++;
}
if (!hash.ContainsKey(list[i].Studia.name))
{
hash.Add(list[i].Studia.name, 1);
}
}
List <Studia> l = new List <Studia>();
foreach (var i in hash)
{
Console.WriteLine(i.Key + " " + i.Value);
l.Add(new Studia()
{
name2 = i.Key,
numberOfStudents = i.Value
});
}
FileStream writer = new FileStream(output, FileMode.Create);
XmlSerializer serializer = new XmlSerializer(typeof(Uczelnia));
XmlSerializerNamespaces ns = new XmlSerializerNamespaces();
ns.Add("", "");
Uczelnia u = new Uczelnia()
{
createdAt = DateTime.Today.ToShortDateString(),
Author = "Szymon Pierzchała",
studenci = list,
activeStudies = l
};
serializer.Serialize(writer, u, ns);
writer.Dispose();
}
}
private void FillAcademyData(Uczelnia academy)
{
window.AcademyName = academy.nazwa_uczelni;
window.FacultyName = academy.nazwa_wydzialu;
}
static void Main(string[] args)
{
var input = args.Length > 0 ? args[0] : @"Files\dane.csv"; //@"Files\dane.csv"
var output = args.Length > 1 ? args[1] : @"Files\result.xml"; //
var form = args.Length > 2 ? args[2] : "xml";
try
{
var university = new Uczelnia()
{
Author = "Gabriel Sek",
};
foreach (var line in File.ReadAllLines(input))
{
var array = line.Split(",");
if (array.Length < 9)
{
File.AppendAllText("Log.txt", $"{DateTime.UtcNow} Invalid number of students arguments" + "\n");
}
if (array[0] == "" || array[1] == "" || array[2] == "" || array[3] == "" || array[4] == "" ||
array[5] == "" || array[6] == "" || array[7] == "" || array[8] == "")
{
File.AppendAllText("Log.txt", $"{DateTime.UtcNow} Empty brackets!!!" + "\n");
}
var stud = new Student
{
id = array[4],
fname = array[0],
lname = array[1],
birthdate = array[5],
email = array[6],
mothersName = array[7],
fathersName = array[8],
studies = new Studies
{
name = array[2],
mode = array[3]
}
};
if (!university.Students.Contains(stud))
{
university.Students.Add(stud);
}
var actStudies = new ActiveStudies
{
name = array[2],
count = 1
};
if (!university.activeStudies.Contains(actStudies))
{
university.activeStudies.Add(actStudies);
}
else
{
foreach (ActiveStudies temp in university.activeStudies)
{
if (temp.Equals(actStudies))
{
temp.count++;
}
}
}
}
if (form.Equals("xml"))
{
using var writer = new FileStream($"{output}", FileMode.Create);
var serializer = new XmlSerializer(typeof(Uczelnia));
serializer.Serialize(writer, university);
}
else if (form.Equals("json"))
{
using var writer = new FileStream($"{output}", FileMode.Create);
var options = new JsonSerializerOptions
{
WriteIndented = true,
IgnoreNullValues = true
}
;
var serializer = JsonSerializer.Serialize(university, options);
File.WriteAllText($"{output}", serializer);
}
else
{
File.AppendAllText("Log.txt", $"{DateTime.UtcNow} not supported form" + "\n");
}
}
catch (FileNotFoundException e)
{
File.AppendAllText("Log.txt", $"{DateTime.UtcNow} {e.Message} {e.FileName}" + "\n");
}
catch (ArgumentException e)
{
File.AppendAllText("Log.txt", $"{DateTime.UtcNow} {e.Message} {e.ParamName}" + "\n");
}
}
