public void IncorrectSettingsType() { MuscleLogContext ctx = new MuscleLogContext("metadata=res://*/Models.MuscleLogModel.csdl|res://*/Models.MuscleLogModel.ssdl|res://*/Models.MuscleLogModel.msl;provider=System.Data.SqlClient;provider connection string='data source=MAX-PC;Initial Catalog=muscle-log;User ID=Max-PC;integrated security=SSPI;multipleactiveresultsets=True;application name=EntityFramework'"); ml_Settings test = new ml_Settings(); test.StringValue = "test"; test.PropertyName = "incorrectTypeSetting"; ctx.ml_Settings.Add(test); ctx.SaveChanges(); Assert.Throws(typeof(SettingsTypeException), delegate { muscle_log.Config.GetIntVal("incorrectTypeSetting", ctx); }); test = null; test = ctx.ml_Settings.Where(s => s.PropertyName == "incorrectTypeSetting").FirstOrDefault(); ctx.ml_Settings.Remove(test); ctx.SaveChanges(); ctx.Dispose(); }
/// <summary> /// saves the current user with all its values in the database /// </summary> public void Save() { var user = new ml_User(); user.ID = ID; user.userStatus = (int)userStatus; user.userName = userName; user.userEmail = userEmail; using (var context = new MuscleLogContext()) { if (user.ID > 0) { context.ml_User.Attach(user); context.Entry(user).State = System.Data.Entity.EntityState.Modified; } else { context.ml_User.Add(user); } context.SaveChanges(); } }