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();
}
