//------------------------------------------------------------------------------------------- private Accounting_OFXSettings GetOFXSampleObj() { using (WeavverEntityContainer data = new WeavverEntityContainer()) { Guid testObjectId = new Guid(Helper.GetAppSetting("accounting_ofxsettings_testobjectid")); var ofxSettings = (from x in data.Accounting_OFXSettings where x.Id == testObjectId select x).FirstOrDefault(); data.Entry(ofxSettings).State = System.Data.Entity.EntityState.Detached; Assert.IsNotNull(ofxSettings, "could not get the ofx testing object"); return ofxSettings; } }
//------------------------------------------------------------------------------------------- private Accounting_Accounts GetAccount() { using (WeavverEntityContainer data = new WeavverEntityContainer()) { var query = (from x in data.Accounting_Accounts where x.Id == AccountId.Value select x); Accounting_Accounts acct = query.FirstOrDefault(); if (acct != null) { data.Entry(acct).State = System.Data.Entity.EntityState.Detached; } return acct; } }
//------------------------------------------------------------------------------------------- /// <summary> /// Grabs the user from the database and loads it into Weavver.Sys.User; /// </summary> /// <param name="username"></param> /// <returns></returns> public System_Users GetUser(string username) { using (WeavverEntityContainer data = new WeavverEntityContainer()) { var user = (from x in data.System_Users where x.Username == username select x).FirstOrDefault(); if (user != null) { data.Entry(user).State = System.Data.Entity.EntityState.Detached; } return user; } }