public void AddLogEntry(string username, string actionMessage) { EventLogTable newlog = new EventLogTable(); //replaces any white spaces in the message actionMessage = System.Text.RegularExpressions.Regex.Replace(actionMessage, @"\s+", " "); //get the accounts table object for the user passed var GetUserData = DataContextInv.AccountsTables.Single(x => x.Username == username); //setup the new event log instance newlog.Username = GetUserData.Username; newlog.FirstName = GetUserData.FirstName; newlog.Role = GetUserData.Role; newlog.Action = actionMessage; newlog.TimeOfAction = DateTime.Now; DataContextInv.EventLogTables.InsertOnSubmit(newlog); DataContextInv.SubmitChanges(); }
partial void DeleteEventLogTable(EventLogTable instance);
partial void InsertEventLogTable(EventLogTable instance);
partial void UpdateEventLogTable(EventLogTable instance);
private void detach_EventLogTables(EventLogTable entity) { this.SendPropertyChanging(); entity.AccountsTable = null; }