public static void Log(string action, string desc, string entityId) { using (var db = new GiftCheckDataContext()) { AuditTrail log = new AuditTrail(); log.User = HttpContext.Current.User.Identity.Name; log.Action = action; log.Description = desc; log.AssociatedId = entityId; log.ActionDate = DateTime.Now; db.AuditTrails.InsertOnSubmit(log); //commit db.SubmitChanges(); } }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { //UserAccountsDataContext dbUser = new UserAccountsDataContext(@"C:\dbUserAccounts.mdf"); GiftCheckDataContext dbGC = new GiftCheckDataContext(@"C:\dbGC.mdf"); //if (dbUser.DatabaseExists()) //{ // dbUser.DeleteDatabase(); //} if (dbGC.DatabaseExists()) { dbGC.DeleteDatabase(); } //dbUser.CreateDatabase(); dbGC.CreateDatabase(); if (!Roles.RoleExists("Admin-GC")) { Roles.CreateRole("Admin-GC"); } if (!Roles.RoleExists("can-create-gc")) { Roles.CreateRole("can-create-gc"); } if (!Roles.RoleExists("can-approve-gc")) { Roles.CreateRole("can-approve-gc"); } if (!Roles.RoleExists("frontoffice")) { Roles.CreateRole("frontoffice"); } //user if (Membership.GetUser("admin-GC") == null) { Membership.CreateUser("admin-GC", "pa$$word"); } if (!Roles.IsUserInRole("admin-GC", "Admin-GC")) { Roles.AddUserToRole("admin-GC", "Admin-GC"); } //create site status var status = (from s in dbGC.StatusSites where s.Id == 1 select s).ToList(); if (status.Count < 1) { StatusSite ss = new StatusSite(); ss.Status = false; dbGC.StatusSites.InsertOnSubmit(ss); dbGC.SubmitChanges(); } } }