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();
}