public ViewHistoryWindow(string recordID)
{
InitializeComponent();
dbman = new DBConnectionManager();
pmsutil = new PMSUtil();
if (dbman.DBConnect().State == ConnectionState.Open)
{
MySqlCommand cmd = dbman.DBConnect().CreateCommand();
cmd.CommandText = "SELECT * FROM records_log, accounts WHERE record_id = @record_id;";
cmd.Parameters.AddWithValue("@record_id", recordID);
cmd.Prepare();
MySqlDataReader db_reader = cmd.ExecuteReader();
history = new ObservableCollection <HistoryItem>();
while (db_reader.Read())
{
if (db_reader.GetString("log_code") == "LOGC-01")
{
history.Add(new HistoryItem()
{
Details = "Recorded by " + pmsutil.GetUsername(db_reader.GetString("log_creator")),
Date = DateTime.Parse(db_reader.GetString("log_date")).ToString("MMM dd, yyyy"),
Time = DateTime.Parse(db_reader.GetString("log_time")).ToString("hh:mm tt"),
Purpose = "NA"
});
}
else if (db_reader.GetString("log_code") == "LOGC-02")
{
history.Add(new HistoryItem()
{
Details = "Edited by " + pmsutil.GetUsername(db_reader.GetString("log_creator")),
Date = DateTime.Parse(db_reader.GetString("log_date")).ToString("MMM dd, yyyy"),
Time = DateTime.Parse(db_reader.GetString("log_time")).ToString("hh:mm tt"),
Purpose = "NA"
});
}
else if (db_reader.GetString("log_code") == "LOGC-03")
{
history.Add(new HistoryItem()
{
Details = "Certificate printed by " + pmsutil.GetUsername(db_reader.GetString("log_creator")),
Date = DateTime.Parse(db_reader.GetString("log_date")).ToString("MMM dd, yyyy"),
Time = DateTime.Parse(db_reader.GetString("log_time")).ToString("hh:mm tt"),
Purpose = "For Reference"
});
}
else if (db_reader.GetString("log_code") == "LOGC-04")
{
history.Add(new HistoryItem()
{
Details = "Certificate printed by " + pmsutil.GetUsername(db_reader.GetString("log_creator")),
Date = DateTime.Parse(db_reader.GetString("log_date")).ToString("MMM dd, yyyy"),
Time = DateTime.Parse(db_reader.GetString("log_time")).ToString("HH:mm tt"),
Purpose = "For Marriage"
});
}
}
//close Connection
dbman.DBClose();
}
else
{
}
HistoryContainer2.ItemsSource = history;
}