public void Update(Weather weather)
{
try
{
using (var context = new NewContext())
{
var q = from w in context.Weathers
where w.Timestamp == weather.Timestamp
select w;
if (q.Count() > 0)
{
return;
}
context.Weathers.Add(weather);
context.SaveChanges();
}
}
catch (DbUpdateException e)
{
MySqlException innerException = e.InnerException.InnerException as MySqlException;
if (innerException == null || innerException.Number != 1062)
{
throw;
}
}
}
public ActionResult Create(Product product)
{
try
{
if (ModelState.IsValid)
{
db.Products.Add(product);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(product));
// TODO: Add insert logic here
}
catch
{
return(View());
}
}
public string Create([Bind(Exclude = "CustomerId")] Customer obj)
{
string msg;
try
{
if (ModelState.IsValid)
{
db.Customers.Add(obj);
db.SaveChanges();
msg = "Saved Successfully";
}
else
{
msg = "Validation data not successfully";
}
}
catch (Exception ex)
{
msg = "Error occured:" + ex.Message;
}
return(msg);
}
public ActionResult AddNew(string FormHead, string FormDescription)
{
var CurrentDate = DateTime.Now;
if ((FormHead != null) && (FormDescription != null))
{
db.News.Add(new New {
Head = FormHead, Description = FormDescription, Date = CurrentDate
});
db.SaveChanges();
int last_id = (from n in db.News select n.NewId).ToList().Last();
WebImage photo = null;
photo = WebImage.GetImageFromRequest();
if (photo != null)
{
photo.FileName = last_id.ToString();
photo.Resize(width: 250, height: 168, preserveAspectRatio: true, preventEnlarge: true);
photo.Save(@"~/Content/Images/" + photo.FileName);
}
}
return(RedirectToAction("Index", "Home"));
}
public void UpdateSite(int number, string name, double latitude, double longitude)
{
using (var context = new NewContext())
{
long siteId = ResolveSite(context, number);
var q = from s in context.Sites
where s.Id == siteId
select s;
Site site = q.First();
site.Name = name;
site.Latitude = latitude;
site.Longitude = longitude;
context.SaveChanges();
}
}
static void Main(string[] args)
{
using (var db = new NewContext())
{
Console.WriteLine("请输入Name：");
var name = Console.ReadLine();
var newType = new NewType {
Name = name
};
db.NewTypes.Add(newType);
db.SaveChanges();
Console.WriteLine("Save successfully");
Console.Read();
}
}
Task MigrateSite <T>(Func <LegacyContext, DateTime, IEnumerable <T> > query)
where T : ISiteRecord
{
Console.WriteLine(typeof(T).ToString());
SiteMigrator <T> migrator = Container.Resolve <SiteMigrator <T> >();
migrator.MigrateSite();
DateTime last = SiteService.GetLastTimestamp(migrator.Number);
if (last != DateTime.MinValue)
{
last -= new TimeSpan(0, 2, 0, 0);
}
IEnumerable <T> legacyData;
using (var legacyContext = new LegacyContext())
{
legacyData = query(legacyContext, last).ToList();
}
return(Task.Run(() =>
{
foreach (var l in legacyData)
{
using (var context = new NewContext())
{
context.Configuration.AutoDetectChangesEnabled = false;
migrator.MigrateLogs(context, l);
context.ChangeTracker.DetectChanges();
context.SaveChanges();
}
}
}));
}
static void Main(string[] args)
{
Context db = new Context();
Console.WriteLine(db.Database.CanConnect());
NewContext db2 = new NewContext();
Messurement current = new Messurement();
Stopwatch watch = new Stopwatch();
watch.Start();
List <User> users2 = db.Users.Include("Contents.Entries").Include("Contents").Include("Contents").ToList();
List <User> user3 = db2.Users.ToList();
db2.Users.RemoveRange(user3.Take(2));
db2.SaveChanges();
db.Users.RemoveRange(db.Users.Skip(40));
db.SaveChanges();
List <User> users = db.Users.Include(x => x.Contents).ThenInclude(x => x.Entries).Include(x => x.Settings).ToList(); //db.Users.Include(x => x.Contents).Include(x => x.Settings).ToList();
List <Content> contents = db.Contents.Include(x => x.User).ToList();
watch.Stop();
current.TimeRead = watch.Elapsed;
current.EntryCount = users.Count + contents.Count;
Console.WriteLine((users.Count + contents.Count) + " Werte in " + watch.ElapsedMilliseconds + " ms gelesen");
watch.Restart();
User us = new User()
{
Name = "Morris Janatzek",
Username = "",
Type = User.UserType.Manager,
Test = 2
};
db.Users.Add(us);
User us3 = new User()
{
Name = "Morris Janatzek",
Username = ""
};
db2.Users.Add(us3);
db2.SaveChanges();
db.SaveChanges();
db.Users.Remove(db.Users.FirstOrDefault());
db.SaveChanges();
Content c = new Content()
{
Text = "Test",
UserId = us.Id
};
db.Contents.Add(c);
db.ContentEntries.Add(new ContentEntry()
{
Text = "das ist in set",
ContentId = c.Id
});
db.Users.Add(new User()
{
Username = "******",
Name = "Test Test"
});
db.Users.Add(new User()
{
Username = "******",
Name = "Test Test 2"
});
db.Users.Add(new User()
{
Username = "******",
Name = "Test Test 3"
});
db.SaveChanges();
watch.Stop();
current.TimeWrite = watch.Elapsed;
Console.WriteLine("Werte in " + watch.ElapsedMilliseconds + " ms geschrieben");
db.Messurements.Add(current);
db.SaveChanges();
db.Generics.Add(new GenericTest <int>()
{
Value = 1
});
db.Generics.Add(new GenericTest <int>()
{
Value = 2
});
db.SaveChanges();
Console.WriteLine(db.Generics.Count());
while (true)
{
string result = Console.ReadLine();
if (result != "q")
{
db.Users.Add(new User()
{
Username = "******",
Name = "Test User"
});
db.SaveChanges();
continue;
}
break;
}
Context db3 = new Context();
Context db4 = new Context();
List <User> users3 = db3.Users.ToList();
db4.Users.Add(new User()
{
Name = "Morris Janatzek",
Username = "******"
});
db4.SaveChanges();
users3 = db3.Users.ToList();
Console.WriteLine(db.Users.Count());
db.Users.Add(new User()
{
Name = "Test",
Username = "******"
});
db.SaveChanges();
Console.WriteLine(db.Users.Count());
Console.ReadKey();
}
public ActionResult Create(Order ord)
{
objContext.Orders.Add(ord);
objContext.SaveChanges();
return(RedirectToAction("Index"));
}
