/// <summary>
/// Eigentliche Lese-Methode.
/// </summary>
/// <param name="fileName">Der dateiname.</param>
public static void Read(string fileName)
{
using (StreamReader reader = new StreamReader(fileName, Encoding.GetEncoding("iso-8859-1")))
{
while (!reader.EndOfStream)
{
string line = reader.ReadLine();
if (string.IsNullOrEmpty(line))
{
continue;
}
string[] array = line.Split(new string[] { "\",\"" }, StringSplitOptions.None);
string[] cleanArray = array.Select(aString => aString.Trim(new char[] { '\"', ' ', '\n' })).ToArray();
using (LehrerTableAdapter adapter = new LehrerTableAdapter())
{
if (adapter.GetDataByKuerzel(cleanArray[kuerzelSpalte]).Count == 0)
{
string mailAdresse = cleanArray[vornameSpalte] + "." + cleanArray[nachnameSpalte] + "@fosbos-kempten.de";
mailAdresse = mailAdresse.Replace("ä", "ae");
mailAdresse = mailAdresse.Replace("ö", "oe");
mailAdresse = mailAdresse.Replace("ü", "ue");
mailAdresse = mailAdresse.Replace("ß", "ss");
adapter.Insert(cleanArray[kuerzelSpalte], cleanArray[vornameSpalte] + " " + cleanArray[nachnameSpalte], cleanArray[dienstbezeichnungSpalte], mailAdresse);
}
}
}
}
}
public DatenbankArgs add(string L_Vorname, string L_Name, string L_Anrede, string L_Email, string L_Passwort, string L_Titel)
{
try
{
if (getby(L_Email, "L_Email").Success == false)
{
lta.Insert(L_Vorname, L_Name, L_Anrede, L_Email, L_Passwort, L_Titel);
DataTable data = lta.GetData();
DataTable dataout = data.Clone();
dataout.ImportRow(data.Rows[data.Rows.Count - 1]);
return(new DatenbankArgs(dataout));
}
throw new Exception("Email bereits registriert");
}
catch (Exception ex)
{
return(new DatenbankArgs(ex.Message));
}
}
