public void OpenFile() { String path = "..\\Files\\Users.csv"; string realativePath = UserDatabaseContext.bingPathToAppDir(path); using (System.IO.FileStream fs = File.OpenRead(realativePath)) { byte[] b = new byte[1024]; UTF8Encoding temp = new UTF8Encoding(true); while (fs.Read(b, 0, b.Length) > 0) { Console.WriteLine(temp.GetString(b)); } } }
public static void AddLineToLog(Log log) { String path = "..\\Files\\Log.csv"; string relativePath = UserDatabaseContext.bingPathToAppDir(path); // pobieram ID z ostatniej linijki w users.csv var info = new FileInfo(relativePath); //var lastLine = '0'; var lastId = 1; if (info.Length < 10) // zabezp. przed pustym plikiem { lastId = 0; } else { var lastLine = File.ReadLines(relativePath).Last(); string[] columns = lastLine.Split(";"); lastId = Convert.ToInt32(columns[0]); } //ID; LogDate; TypeOfCRUDOperation; UserName; StringBuilder sb = new StringBuilder(); sb.AppendLine(""); sb.Append(lastId + 1); //Id = lastId + 1 sb.Append(";"); sb.Append(DateTime.Now); sb.Append(";"); sb.Append(log.TypeOfCRUDOperation); sb.Append(";"); sb.Append(MyIdentity.GetLogin()); using (StreamWriter sw = File.AppendText(relativePath)) { sw.Write(sb); } Console.Clear(); }
//metoda do dodawania uzytkowników public static void AddToDatabase(User user) { String path = "..\\Files\\Users.csv"; string relativePath = UserDatabaseContext.bingPathToAppDir(path); // pobieram ID z ostatniej linijki w users.csv var lastLine = File.ReadLines(relativePath).Last(); string[] columns = lastLine.Split(";"); var lastId = Convert.ToInt32(columns[0]); StringBuilder sb = new StringBuilder(); sb.AppendLine(""); sb.Append(lastId + 1); //Id = lastId + 1 sb.Append(";"); sb.Append(user.Login); sb.Append(";"); sb.Append(codePassword(user.Password)); sb.Append(";"); sb.Append(user.Name); sb.Append(";"); sb.Append(user.Surname); sb.Append(";"); sb.Append(user.EmailAddress); sb.Append(";"); sb.Append((int)user.TypeOfUserType); sb.Append(";"); using (StreamWriter sw = File.AppendText(relativePath)) { sw.Write(sb); } Console.Clear(); Console.WriteLine("Record added to database. Press any key."); Console.ReadLine(); }