private static void InitializeSchedules() { if (!context.Contacts.Any()) { Contact c1 = new Contact { FirstName = "Arun", LastName = "Kumar", Email = "*****@*****.**", PhoneNumber = 1233445, Status = 1 }; Contact c2 = new Contact { FirstName = "Arun", LastName = "Kumar", Email = "*****@*****.**", PhoneNumber = 1233445, Status = 1 }; Contact c3 = new Contact { FirstName = "Arun", LastName = "Kumar", Email = "*****@*****.**", PhoneNumber = 1233445, Status = 1 }; Contact c4 = new Contact { FirstName = "Arun", LastName = "Kumar", Email = "*****@*****.**", PhoneNumber = 1233445, Status = 1 }; Contact c5 = new Contact { FirstName = "Arun", LastName = "Kumar", Email = "*****@*****.**", PhoneNumber = 1233445, Status = 1 }; Contact c6 = new Contact { FirstName = "Arun", LastName = "Kumar", Email = "*****@*****.**", PhoneNumber = 1233445, Status = 1 }; context.Contacts.Add(c1); context.Contacts.Add(c2); context.Contacts.Add(c3); context.Contacts.Add(c4); context.Contacts.Add(c5); context.Contacts.Add(c6); context.SaveChanges(); } }
public bool Save() { try { return(_ctx.SaveChanges() > 0); // izvrsila neka promjena } catch (Exception) { // TODO dovrsi return(false); } }
public bool Save() { try { return(_ctx.SaveChanges() > 0); // izvrsi saveChanges i vraca true ako se stvarno // izvrsila neka promjena // saveChanges gotova funkcija u dbContext? // ako se izvrsio npr ctx Add ispravno? } catch (Exception) { // TODO dovrsi return(false); } }
private static void InitializeSchedules(SchedulerContext context) { if (!context.Users.Any()) { User user_01 = new User { Name = "Chris Sakellarios", Profession = "Developer", Avatar = "avatar_02.png" }; User user_02 = new User { Name = "Charlene Campbell", Profession = "Web Designer", Avatar = "avatar_03.jpg" }; User user_03 = new User { Name = "Mattie Lyons", Profession = "Engineer", Avatar = "avatar_05.png" }; User user_04 = new User { Name = "Kelly Alvarez", Profession = "Network Engineer", Avatar = "avatar_01.png" }; User user_05 = new User { Name = "Charlie Cox", Profession = "Developer", Avatar = "avatar_03.jpg" }; User user_06 = new User { Name = "Megan Fox", Profession = "Hacker", Avatar = "avatar_05.png" }; context.Users.Add(user_01); context.Users.Add(user_02); context.Users.Add(user_03); context.Users.Add(user_04); context.Users.Add(user_05); context.Users.Add(user_06); context.SaveChanges(); } if (!context.Schedules.Any()) { Schedule schedule_01 = new Schedule { Title = "Meeting", Description = "Meeting at work with the boss", Location = "Korai", CreatorId = 1, Status = ScheduleStatus.Valid, Type = ScheduleType.Work, TimeStart = DateTime.Now.AddHours(4), TimeEnd = DateTime.Now.AddHours(6), Attendees = new List <Attendee> { new Attendee() { ScheduleId = 1, UserId = 2 }, new Attendee() { ScheduleId = 1, UserId = 3 }, new Attendee() { ScheduleId = 1, UserId = 4 } } }; Schedule schedule_02 = new Schedule { Title = "Coffee", Description = "Coffee with folks", Location = "Athens", CreatorId = 2, Status = ScheduleStatus.Valid, Type = ScheduleType.Coffee, TimeStart = DateTime.Now.AddHours(3), TimeEnd = DateTime.Now.AddHours(6), Attendees = new List <Attendee> { new Attendee() { ScheduleId = 2, UserId = 1 }, new Attendee() { ScheduleId = 1, UserId = 3 }, new Attendee() { ScheduleId = 2, UserId = 4 } } }; Schedule schedule_03 = new Schedule { Title = "Shopping day", Description = "Shopping therapy", Location = "Attica", CreatorId = 3, Status = ScheduleStatus.Valid, Type = ScheduleType.Shopping, TimeStart = DateTime.Now.AddHours(3), TimeEnd = DateTime.Now.AddHours(6), Attendees = new List <Attendee> { new Attendee() { ScheduleId = 3, UserId = 1 }, new Attendee() { ScheduleId = 3, UserId = 4 }, new Attendee() { ScheduleId = 3, UserId = 5 } } }; Schedule schedule_04 = new Schedule { Title = "Family", Description = "Thanks giving day", Location = "Home", CreatorId = 5, Status = ScheduleStatus.Valid, Type = ScheduleType.Other, TimeStart = DateTime.Now.AddHours(3), TimeEnd = DateTime.Now.AddHours(6), Attendees = new List <Attendee> { new Attendee() { ScheduleId = 4, UserId = 1 }, new Attendee() { ScheduleId = 4, UserId = 2 }, new Attendee() { ScheduleId = 4, UserId = 5 } } }; Schedule schedule_05 = new Schedule { Title = "Friends", Description = "Friends giving day", Location = "Home", CreatorId = 5, Status = ScheduleStatus.Cancelled, Type = ScheduleType.Other, TimeStart = DateTime.Now.AddHours(5), TimeEnd = DateTime.Now.AddHours(7), Attendees = new List <Attendee> { new Attendee() { ScheduleId = 4, UserId = 1 }, new Attendee() { ScheduleId = 4, UserId = 2 }, new Attendee() { ScheduleId = 4, UserId = 3 }, new Attendee() { ScheduleId = 4, UserId = 4 }, new Attendee() { ScheduleId = 4, UserId = 5 } } }; Schedule schedule_06 = new Schedule { Title = "Meeting with the boss and collegues", Description = "Discuss project planning", Location = "Office", CreatorId = 3, Status = ScheduleStatus.Cancelled, Type = ScheduleType.Other, TimeStart = DateTime.Now.AddHours(22), TimeEnd = DateTime.Now.AddHours(30), Attendees = new List <Attendee> { new Attendee() { ScheduleId = 4, UserId = 1 }, new Attendee() { ScheduleId = 4, UserId = 2 }, new Attendee() { ScheduleId = 4, UserId = 5 } } }; Schedule schedule_07 = new Schedule { Title = "Scenario presentation", Description = "Discuss new movie's scenario", Location = "My special place", CreatorId = 6, Status = ScheduleStatus.Cancelled, Type = ScheduleType.Other, TimeStart = DateTime.Now.AddHours(11), TimeEnd = DateTime.Now.AddHours(13), Attendees = new List <Attendee> { new Attendee() { ScheduleId = 4, UserId = 4 }, new Attendee() { ScheduleId = 4, UserId = 2 }, new Attendee() { ScheduleId = 4, UserId = 3 } } }; context.Schedules.Add(schedule_01); context.Schedules.Add(schedule_02); context.Schedules.Add(schedule_03); context.Schedules.Add(schedule_04); context.Schedules.Add(schedule_05); context.Schedules.Add(schedule_06); } context.SaveChanges(); }
private static void InitializeSchedules() { /* * if (!context.Jobs.Any()) { * Job job_01 = new Job { JobType = 0, AddressId = 15, CustomerId = 2 }; * context.Add(job_01); * context.SaveChanges(); * } * * if (!context.WorkDescriptions.Any()) { * WorkDescription workDescription_01 = new WorkDescription { JobId = 12, WorkType = 0, Revenue = 34 }; * context.Add(workDescription_01); * context.SaveChanges(); * } * if (!context.EndUsers.Any()) { * EndUser endUser_01 = new EndUser * { * CreatedDate = DateTime.Now.Date, * FirstName = "Joe", * LastName = "Doe", * Email = "*****@*****.**", * Type = 0 * }; * context.Add(endUser_01); * context.SaveChanges(); * } * * * if (!context.PhoneNumbers.Any()) * { * PhoneNumber phoneNumber_01 = new PhoneNumber { CustomerId = 1, Number = "3059114545" }; * PhoneNumber phoneNumber_02 = new PhoneNumber { CustomerId = 1, Number = "3059114545" }; * PhoneNumber phoneNumber_03 = new PhoneNumber { CustomerId = 3, Number = "3059114545" }; * context.PhoneNumbers.Add(phoneNumber_01); * context.PhoneNumbers.Add(phoneNumber_02); * context.PhoneNumbers.Add(phoneNumber_03); * * context.SaveChanges(); * * } * if (!context.Addresses.Any()) * { * Address address_03 = new Address { Address1 = "16578 Nw 34 st", City = "Miami", CustomerId = 1, State = "FL", ZipCode = "33015" }; * Address address_04 = new Address { Address1 = "14578 Sw 31 st", City = "Kendall", CustomerId = 2, State = "FL", ZipCode = "33012" }; * context.Addresses.Add(address_03); * context.Addresses.Add(address_04); * * context.SaveChanges(); * * } * if (!context.Customers.Any()) { * Customer customer_03 = new Customer { * FirstName = "Juan", * LastName = "Medina", * CompanyName = "DB" * }; * Customer customer_04 = new Customer * { * FirstName = "Juan", * LastName = "Perez", * CompanyName = "Microsoft" * }; * context.Customers.Add(customer_03); * context.Customers.Add(customer_04); * context.SaveChanges(); * } */ if (!context.Users.Any()) { User user_01 = new User { Name = "Chris Sakellarios", Profession = "Developer", Avatar = "avatar_02.png" }; User user_02 = new User { Name = "Charlene Campbell", Profession = "Web Designer", Avatar = "avatar_03.jpg" }; User user_03 = new User { Name = "Mattie Lyons", Profession = "Engineer", Avatar = "avatar_05.png" }; User user_04 = new User { Name = "Kelly Alvarez", Profession = "Network Engineer", Avatar = "avatar_01.png" }; User user_05 = new User { Name = "Charlie Cox", Profession = "Developer", Avatar = "avatar_03.jpg" }; User user_06 = new User { Name = "Megan Fox", Profession = "Hacker", Avatar = "avatar_05.png" }; context.Users.Add(user_01); context.Users.Add(user_02); context.Users.Add(user_03); context.Users.Add(user_04); context.Users.Add(user_05); context.Users.Add(user_06); context.SaveChanges(); } if (!context.Schedules.Any()) { Schedule schedule_01 = new Schedule { Title = "Meeting", Description = "Meeting at work with the boss", Location = "Korai", CreatorId = 1, Status = ScheduleStatus.Valid, Type = ScheduleType.Work, TimeStart = DateTime.Now.AddHours(4), TimeEnd = DateTime.Now.AddHours(6), Attendees = new List <Attendee> { new Attendee() { ScheduleId = 1, UserId = 2 }, new Attendee() { ScheduleId = 1, UserId = 3 }, new Attendee() { ScheduleId = 1, UserId = 4 } } }; Schedule schedule_02 = new Schedule { Title = "Coffee", Description = "Coffee with folks", Location = "Athens", CreatorId = 2, Status = ScheduleStatus.Valid, Type = ScheduleType.Coffee, TimeStart = DateTime.Now.AddHours(3), TimeEnd = DateTime.Now.AddHours(6), Attendees = new List <Attendee> { new Attendee() { ScheduleId = 2, UserId = 1 }, new Attendee() { ScheduleId = 1, UserId = 3 }, new Attendee() { ScheduleId = 2, UserId = 4 } } }; Schedule schedule_03 = new Schedule { Title = "Shopping day", Description = "Shopping therapy", Location = "Attica", CreatorId = 3, Status = ScheduleStatus.Valid, Type = ScheduleType.Shopping, TimeStart = DateTime.Now.AddHours(3), TimeEnd = DateTime.Now.AddHours(6), Attendees = new List <Attendee> { new Attendee() { ScheduleId = 3, UserId = 1 }, new Attendee() { ScheduleId = 3, UserId = 4 }, new Attendee() { ScheduleId = 3, UserId = 5 } } }; Schedule schedule_04 = new Schedule { Title = "Family", Description = "Thanks giving day", Location = "Home", CreatorId = 5, Status = ScheduleStatus.Valid, Type = ScheduleType.Other, TimeStart = DateTime.Now.AddHours(3), TimeEnd = DateTime.Now.AddHours(6), Attendees = new List <Attendee> { new Attendee() { ScheduleId = 4, UserId = 1 }, new Attendee() { ScheduleId = 4, UserId = 2 }, new Attendee() { ScheduleId = 4, UserId = 5 } } }; Schedule schedule_05 = new Schedule { Title = "Friends", Description = "Friends giving day", Location = "Home", CreatorId = 5, Status = ScheduleStatus.Cancelled, Type = ScheduleType.Other, TimeStart = DateTime.Now.AddHours(5), TimeEnd = DateTime.Now.AddHours(7), Attendees = new List <Attendee> { new Attendee() { ScheduleId = 4, UserId = 1 }, new Attendee() { ScheduleId = 4, UserId = 2 }, new Attendee() { ScheduleId = 4, UserId = 3 }, new Attendee() { ScheduleId = 4, UserId = 4 }, new Attendee() { ScheduleId = 4, UserId = 5 } } }; Schedule schedule_06 = new Schedule { Title = "Meeting with the boss and collegues", Description = "Discuss project planning", Location = "Office", CreatorId = 3, Status = ScheduleStatus.Cancelled, Type = ScheduleType.Other, TimeStart = DateTime.Now.AddHours(22), TimeEnd = DateTime.Now.AddHours(30), Attendees = new List <Attendee> { new Attendee() { ScheduleId = 4, UserId = 1 }, new Attendee() { ScheduleId = 4, UserId = 2 }, new Attendee() { ScheduleId = 4, UserId = 5 } } }; Schedule schedule_07 = new Schedule { Title = "Scenario presentation", Description = "Discuss new movie's scenario", Location = "My special place", CreatorId = 6, Status = ScheduleStatus.Cancelled, Type = ScheduleType.Other, TimeStart = DateTime.Now.AddHours(11), TimeEnd = DateTime.Now.AddHours(13), Attendees = new List <Attendee> { new Attendee() { ScheduleId = 4, UserId = 4 }, new Attendee() { ScheduleId = 4, UserId = 2 }, new Attendee() { ScheduleId = 4, UserId = 3 } } }; context.Schedules.Add(schedule_01); context.Schedules.Add(schedule_02); context.Schedules.Add(schedule_03); context.Schedules.Add(schedule_04); context.Schedules.Add(schedule_05); context.Schedules.Add(schedule_06); } context.SaveChanges(); }
private static void InitializeSchedules() { #region Work Item Type WorkItemType witCmsAqua = new WorkItemType(); WorkItemType witCmsFarm = new WorkItemType(); if (!context.WorkItemTypes.Any()) { witCmsAqua = new WorkItemType { Name = "CMS Aqua" }; witCmsFarm = new WorkItemType { Name = "CMS Farm" }; context.WorkItemTypes.Add(witCmsAqua); context.WorkItemTypes.Add(witCmsFarm); } #endregion #region Cms Cms cmsConfiata = new Cms(); Cms cmsChacaraRM = new Cms(); if (!context.Cmsies.Any()) { cmsConfiata = new Cms { Titulo = "Confiata", Avatar = "AvatarConfiata.png", WorkItemTypeId = witCmsAqua.Id, QtdFields = 50 }; cmsChacaraRM = new Cms { Titulo = "Chácara RM", Avatar = "AvatarChacaraRM.png", WorkItemTypeId = witCmsFarm.Id, QtdFields = 50 }; context.Cmsies.Add(cmsConfiata); context.Cmsies.Add(cmsChacaraRM); } #endregion #region Field if (!context.Fields.Any()) { Field field_01 = new Field { Name = "nome", Type = "Texto", Description = "Nome do Field", CmsId = cmsConfiata.Id, DateCreated = DateTime.UtcNow }; Field field_02 = new Field { Name = "slogan", Type = "Texto", Description = "Slogan do Field", CmsId = cmsConfiata.Id, DateCreated = DateTime.UtcNow }; Field field_03 = new Field { Name = "subtitulo", Type = "Texto", Description = "Subtitulo do Field", CmsId = cmsConfiata.Id, DateCreated = DateTime.UtcNow }; Field field_04 = new Field { Name = "nome", Type = "Texto", Description = "Nome do Field", CmsId = cmsChacaraRM.Id, DateCreated = DateTime.UtcNow }; context.Fields.Add(field_01); context.Fields.Add(field_02); context.Fields.Add(field_03); context.Fields.Add(field_04); } #endregion if (!context.Users.Any()) { User user_01 = new User { Name = "Chris Sakellarios", Profession = "Developer", Avatar = "avatar_02.png" }; User user_02 = new User { Name = "Charlene Campbell", Profession = "Web Designer", Avatar = "avatar_03.jpg" }; User user_03 = new User { Name = "Mattie Lyons", Profession = "Engineer", Avatar = "avatar_05.png" }; User user_04 = new User { Name = "Kelly Alvarez", Profession = "Network Engineer", Avatar = "avatar_01.png" }; User user_05 = new User { Name = "Charlie Cox", Profession = "Developer", Avatar = "avatar_03.jpg" }; User user_06 = new User { Name = "Megan Fox", Profession = "Hacker", Avatar = "avatar_05.png" }; context.Users.Add(user_01); context.Users.Add(user_02); context.Users.Add(user_03); context.Users.Add(user_04); context.Users.Add(user_05); context.Users.Add(user_06); context.SaveChanges(); } if (!context.Schedules.Any()) { Schedule schedule_01 = new Schedule { Title = "Meeting", Description = "Meeting at work with the boss", Location = "Korai", CreatorId = 1, Status = ScheduleStatus.Valid, Type = ScheduleType.Work, TimeStart = DateTime.Now.AddHours(4), TimeEnd = DateTime.Now.AddHours(6), Attendees = new List <Attendee> { new Attendee() { ScheduleId = 1, UserId = 2 }, new Attendee() { ScheduleId = 1, UserId = 3 }, new Attendee() { ScheduleId = 1, UserId = 4 } } }; Schedule schedule_02 = new Schedule { Title = "Coffee", Description = "Coffee with folks", Location = "Athens", CreatorId = 2, Status = ScheduleStatus.Valid, Type = ScheduleType.Coffee, TimeStart = DateTime.Now.AddHours(3), TimeEnd = DateTime.Now.AddHours(6), Attendees = new List <Attendee> { new Attendee() { ScheduleId = 2, UserId = 1 }, new Attendee() { ScheduleId = 1, UserId = 3 }, new Attendee() { ScheduleId = 2, UserId = 4 } } }; Schedule schedule_03 = new Schedule { Title = "Shopping day", Description = "Shopping therapy", Location = "Attica", CreatorId = 3, Status = ScheduleStatus.Valid, Type = ScheduleType.Shopping, TimeStart = DateTime.Now.AddHours(3), TimeEnd = DateTime.Now.AddHours(6), Attendees = new List <Attendee> { new Attendee() { ScheduleId = 3, UserId = 1 }, new Attendee() { ScheduleId = 3, UserId = 4 }, new Attendee() { ScheduleId = 3, UserId = 5 } } }; Schedule schedule_04 = new Schedule { Title = "Family", Description = "Thanks giving day", Location = "Home", CreatorId = 5, Status = ScheduleStatus.Valid, Type = ScheduleType.Other, TimeStart = DateTime.Now.AddHours(3), TimeEnd = DateTime.Now.AddHours(6), Attendees = new List <Attendee> { new Attendee() { ScheduleId = 4, UserId = 1 }, new Attendee() { ScheduleId = 4, UserId = 2 }, new Attendee() { ScheduleId = 4, UserId = 5 } } }; Schedule schedule_05 = new Schedule { Title = "Friends", Description = "Friends giving day", Location = "Home", CreatorId = 5, Status = ScheduleStatus.Cancelled, Type = ScheduleType.Other, TimeStart = DateTime.Now.AddHours(5), TimeEnd = DateTime.Now.AddHours(7), Attendees = new List <Attendee> { new Attendee() { ScheduleId = 4, UserId = 1 }, new Attendee() { ScheduleId = 4, UserId = 2 }, new Attendee() { ScheduleId = 4, UserId = 3 }, new Attendee() { ScheduleId = 4, UserId = 4 }, new Attendee() { ScheduleId = 4, UserId = 5 } } }; Schedule schedule_06 = new Schedule { Title = "Meeting with the boss and collegues", Description = "Discuss project planning", Location = "Office", CreatorId = 3, Status = ScheduleStatus.Cancelled, Type = ScheduleType.Other, TimeStart = DateTime.Now.AddHours(22), TimeEnd = DateTime.Now.AddHours(30), Attendees = new List <Attendee> { new Attendee() { ScheduleId = 4, UserId = 1 }, new Attendee() { ScheduleId = 4, UserId = 2 }, new Attendee() { ScheduleId = 4, UserId = 5 } } }; Schedule schedule_07 = new Schedule { Title = "Scenario presentation", Description = "Discuss new movie's scenario", Location = "My special place", CreatorId = 6, Status = ScheduleStatus.Cancelled, Type = ScheduleType.Other, TimeStart = DateTime.Now.AddHours(11), TimeEnd = DateTime.Now.AddHours(13), Attendees = new List <Attendee> { new Attendee() { ScheduleId = 4, UserId = 4 }, new Attendee() { ScheduleId = 4, UserId = 2 }, new Attendee() { ScheduleId = 4, UserId = 3 } } }; context.Schedules.Add(schedule_01); context.Schedules.Add(schedule_02); context.Schedules.Add(schedule_03); context.Schedules.Add(schedule_04); context.Schedules.Add(schedule_05); context.Schedules.Add(schedule_06); } context.SaveChanges(); }