public void WriteActivity3() { MP.Activity.Activity reg = new Activity(); reg.name = "Evenement 3"; reg.description = "Evenement 3 zal leuk zijn!"; reg.Period = new Period() { start = DateTime.Parse("24-5-2017 9:00:00"), end = null }; reg.Period1.Add(new Period() { start = DateTime.Parse("24-5-2017 9:00:00"), end = DateTime.Parse("24-5-2017 9:20:00") }); reg.Period1.Add(new Period() { start = DateTime.Parse("24-5-2017 9:20:00"), end = DateTime.Parse("24-5-2017 9:40:00") }); var db = new MP.Activity.ActivitiesEntities(); db.Activity.Add(reg); db.SaveChanges(); }
public void DeleteSlot(int id) { var db = new MP.Activity.ActivitiesEntities(); Period slot = db.Period.Where(s => s.Id == id).FirstOrDefault(); db.Period.Remove(slot); db.SaveChanges(); }
public bool SaveEnrollment(Enrollment item) { bool saved = false; var db = new MP.Activity.ActivitiesEntities(); //db.Entry(item).State = item.Id == 0 ? // System.Data.Entity.EntityState.Added : // System.Data.Entity.EntityState.Modified; //db.SignUp.Attach(item); if (item.Id == 0) { db.Enrollment.Add(item); } else { var enrollment = db.Enrollment.SingleOrDefault(s => s.Id == item.Id); if (enrollment != null) { db.Entry(enrollment).CurrentValues.SetValues(item); //if (sign.Slots != null) //{ // //get added slots // var dbslots = sign.Slots.ToList(); // var myslots = item.Slots.ToList(); // var addslots = myslots.Where(s => !dbslots.Exists(ds => ds.Id == s.Id)); // addslots.ToList().ForEach(s => db.Entry(s).State = System.Data.Entity.EntityState.Added); // var removeslots = dbslots.Where(s => !myslots.Exists(ds => ds.Id == s.Id)); // removeslots.ToList().ForEach(s => db.Entry(s).State = System.Data.Entity.EntityState.Deleted); // foreach (Period slot in addslots.ToList()) // { // sign.Slots.Add(slot); // //slot.SignUp1.Add(item); // } //} } } db.SaveChanges(); return(saved); }
public void DeleteActivity(int id) { var db = new MP.Activity.ActivitiesEntities(); Activity activity = db.Activity.Where(s => s.Id == id).FirstOrDefault(); List <Period> ids = new List <Period>(); activity.Period1.ToList().ForEach(s => ids.Add(s)); foreach (Period slot in ids) { db.Period.Remove(slot); } db.Activity.Remove(activity); db.SaveChanges(); }
public void WriteActivity() { MP.Activity.Activity reg = new Activity(); reg.name = "Evenement 1"; reg.description = "Evenement 1 zal leuk zijn!"; reg.Period = new Period() { start = DateTime.Now, end = null }; //reg.lifetime = reg.Period.Id; //reg.timeslots = new System.Collections.Generic.List<Period>(); //reg.timeslots.Add(new Period() { start = DateTime.Now, end = DateTime.Now.AddMinutes(20) }); //reg.timeslots.Add(new Period() { start = DateTime.Now.AddMinutes(20), end = DateTime.Now.AddMinutes(40) }); MP.Activity.Enrollment enr = new Enrollment(); enr.Period = new Period() { start = DateTime.Now, end = DateTime.Now.AddMinutes(20) }; enr.Activity = reg; var db = new MP.Activity.ActivitiesEntities(); //var result = db.Books.SingleOrDefault(b => b.BookNumber == bookNumber); //var regi = db.SignUp..SignUp.Attach(reg); //if (result != null) //{ // result.SomeValue = "Some new value"; // db.SaveChanges(); //} db.Activity.Add(reg); db.Enrollment.Add(enr); db.SaveChanges(); //ActivityContainer container = new ActivityContainer(); //container.enrollments = new System.Collections.Generic.List<Enrollment>(); //container.registrations = new System.Collections.Generic.List<Registration>(); //container.registrations.Add(reg); //var instance = MP.Activity.ActivityStore.GetInstance("D:\\"); //instance.Save(container); }
public bool SaveActivity(Activity item) { bool saved = false; var db = new MP.Activity.ActivitiesEntities(); //db.Entry(item).State = item.Id == 0 ? // System.Data.Entity.EntityState.Added : // System.Data.Entity.EntityState.Modified; //db.SignUp.Attach(item); if (item.Id == 0) { db.Activity.Add(item); } else { var activity = db.Activity.SingleOrDefault(s => s.Id == item.Id); if (activity != null) { db.Entry(activity).CurrentValues.SetValues(item); if (activity.Period1 != null) { //get added slots var dbslots = activity.Period1.ToList(); var myslots = item.Period1.ToList(); var addslots = myslots.Where(s => !dbslots.Exists(ds => ds.Id == s.Id)); addslots.ToList().ForEach(s => db.Entry(s).State = System.Data.Entity.EntityState.Added); var removeslots = dbslots.Where(s => !myslots.Exists(ds => ds.Id == s.Id)); removeslots.ToList().ForEach(s => db.Entry(s).State = System.Data.Entity.EntityState.Deleted); foreach (Period slot in addslots.ToList()) { activity.Period1.Add(slot); //slot.SignUp1.Add(item); } } // //foreach (Period slot in sign.Slots) // //{ // // db.Entry(slot).CurrentValues.SetValues(); // //} // //sign.Slots.ToList().ForEach(s => // // db.Entry(s).CurrentValues.SetValues(); // //); //} } //db.Entry(item).State = System.Data.Entity.EntityState.Modified; } db.SaveChanges(); return(saved); }