public void ReadFromCSV(string FileName) { List <QSUser> values = null; try { var fileString = File.ReadAllLines(FileName, System.Text.Encoding.Default); if (fileString.Any()) { values = fileString .Skip(0) .Where(v => v.Trim().Any()) .Select(v => QSUser.FromCsv(v)) .ToList(); } } catch (Exception e) { Console.WriteLine("Error in QSUsers with file \"{0}\": {1} Exception caught.", FileName, e); values = null; } if (values != null) { Users = values; } }
public static string ToCsv(QSUser U) { string csvLine; csvLine = string.Format("{0};{1};{2};{3};{4};{5};{6};{7}", U.UserId, U.UserName, U.QSUserId, U.QSUserDir, U.QSUserName, U.LastAccess.ToString(cntDateTimeParseFormat), U.Allowed ? "Y" : "N", U.Language); return(csvLine); }
public void WriteToCSV(string FileName) { try { File.WriteAllLines(FileName, Users.Select(u => QSUser.ToCsv(u)), System.Text.Encoding.Default); } catch (Exception e) { Console.WriteLine("Error in QSUsers writing to file \"{0}\": {1} Exception caught.", FileName, e); } }
public QSUser AddUser(string UserId, string UserName = "", string QSUserId = "", string QSUserDir = "", string QSUserName = "" , string LastAccess = "", bool Allowed = true) { QSUser Usr; try { Usr = GetUser(UserId); if (Usr == null) { Usr = new QSUser(); Usr.UserId = UserId.Trim(); Usr.Allowed = Allowed; Users.Add(Usr); } if (Usr.UserName == "" || UserName != "") { Usr.UserName = UserName.Trim(); } if (Usr.QSUserId == "" || QSUserId != "") { Usr.QSUserId = QSUserId.Trim(); } if (Usr.QSUserDir == "" || QSUserDir != "") { Usr.QSUserDir = QSUserDir.Trim(); } if (Usr.QSUserName == "" || QSUserName != "") { Usr.QSUserName = QSUserName.Trim(); } DateTime LastAccessDateTime; if (LastAccess == "") { LastAccessDateTime = DateTime.Now; } else { LastAccessDateTime = DateTime.ParseExact(LastAccess, QSUser.cntDateTimeParseFormat, CultureInfo.InvariantCulture); } Usr.LastAccess = LastAccessDateTime; } catch (Exception e) { Console.WriteLine("Error in AddUser with UserId \"{0}\": {1} Exception caught.", UserId, e); return(null); } return(Usr); }
public static QSUser FromCsv(string csvLine) { string[] values = csvLine.Split(';'); QSUser U = new QSUser(); U.UserId = values[0].ToLower().Trim(); U.UserName = values[1].Trim(); U.QSUserId = values[2].Trim(); U.QSUserDir = values[3].Trim(); U.QSUserName = values[4].Trim(); U.LastAccess = DateTime.ParseExact(values[5], cntDateTimeParseFormat, CultureInfo.InvariantCulture); U.Allowed = values[6].Trim() == "Y" ? true : false; if (values.Length > 7) { U.Language = values[7].Trim(); } return(U); }