public IActionResult Create([FromBody] MeetingSchemaViewModel meetingSchema)
{
if (!ModelState.IsValid)
{
return(BadRequest());
}
MeetingSchemas NewMSchemas = Mapper.Map <MeetingSchemaViewModel, MeetingSchemas>(meetingSchema);
NewMSchemas.DateCreated = DateTime.Now;
_meetingSchemasRepository.Add(NewMSchemas);
_meetingSchemasRepository.Commit();
foreach (var item in meetingSchema.Participants)
{
NewMSchemas.Participants.Add(new Participants {
UserId = item
});
}
_meetingSchemasRepository.Commit();
meetingSchema = Mapper.Map <MeetingSchemas, MeetingSchemaViewModel>(NewMSchemas);
//Create
CreatedAtRouteResult result = CreatedAtRoute("Get", new { controller = "MeetingSchemas", Id = meetingSchema.Id }, meetingSchema);
// return result;
return(Json(result));
}
public IActionResult Delete(int id, int participants)
{
MeetingSchemas _meetingSchemas = _meetingSchemasRepository.GetSingle(id);
if (_meetingSchemas == null)
{
return(new NotFoundResult());
}
else
{
_participantsRepository.DeleteWhere(e => e.MeetingSchemaId == id && e.UserId == participants);
_participantsRepository.Commit();
return(new NotFoundResult());
}
}
public IActionResult Get(int id)
{
MeetingSchemas _meetingSchemas = _meetingSchemasRepository
.GetSingle(e => e.Id == id, e => e.Creator, e => e.Participants);
if (_meetingSchemas != null)
{
MeetingSchemaViewModel meetingSchemaVM = Mapper.Map <MeetingSchemas, MeetingSchemaViewModel>(_meetingSchemas);
return(new OkObjectResult(meetingSchemaVM));
}
else
{
return(NotFound());
}
}
public IActionResult Delete(int id)
{
MeetingSchemas _meetingSchemas = _meetingSchemasRepository.GetSingle(id);
if (_meetingSchemas == null)
{
return(new NoContentResult());
}
else
{
_participantsRepository.DeleteWhere(e => e.MeetingSchemaId == id);
_meetingSchemasRepository.Delete(_meetingSchemas);
_meetingSchemasRepository.Commit();
return(new NoContentResult());
}
}
public IActionResult GetMeetingDetialsSchema(int id)
{
MeetingSchemas _meetingSchemas = _meetingSchemasRepository
.GetSingle(e => e.Id == id, e => e.Creator, e => e.Participants);
if (_meetingSchemas != null)
{
MeetingSchemaDetailsViewModel meetingDatailsSchemaVM = Mapper.Map <MeetingSchemas, MeetingSchemaDetailsViewModel>(_meetingSchemas);
foreach (var participants in _meetingSchemas.Participants)
{
User users = _userRepository.GetSingle(participants.UserId);
meetingDatailsSchemaVM.Participants.Add(Mapper.Map <User, UserViewModel>(users));
}
return(new OkObjectResult(meetingDatailsSchemaVM));
}
else
{
return(NotFound());
}
}
public IActionResult Put(int id, [FromBody] MeetingSchemaViewModel meetingSchemaViewModel)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
MeetingSchemas _meetingSchemas = _meetingSchemasRepository.GetSingle(id);
if (_meetingSchemas == null)
{
return(NotFound());
}
else
{
_meetingSchemas.Title = meetingSchemaViewModel.Title;
_meetingSchemas.Location = meetingSchemaViewModel.Location;
_meetingSchemas.Description = meetingSchemaViewModel.Description;
_meetingSchemas.Status = (MeetingSchemaStatus)Enum.Parse(typeof(MeetingSchemaStatus), meetingSchemaViewModel.Status);
_meetingSchemas.Type = (MeetingSchemaType)Enum.Parse(typeof(MeetingSchemaType), meetingSchemaViewModel.Type);
_meetingSchemas.TimeStart = meetingSchemaViewModel.TimeStart;
_meetingSchemas.TimeEnd = meetingSchemaViewModel.TimeEnd;
_participantsRepository.DeleteWhere(e => e.MeetingSchemaId == id);
foreach (var user_id in meetingSchemaViewModel.Participants)
{
_meetingSchemas.Participants.Add(new Participants {
MeetingSchemaId = id, UserId = id
});
}
_meetingSchemasRepository.Commit();
}
//Mapp to ViewModel from DB
meetingSchemaViewModel = Mapper.Map <MeetingSchemas, MeetingSchemaViewModel>(_meetingSchemas);
return(new NoContentResult());
}
// Populate the database using Entityframework dotnet command
private static void InitializeMeetingSchemas(MeetingSchemaContext context)
{
if (!context.Users.Any())
{
User user_one = new User {
Name = "Peter Larsson", Profession = "Designer", Avatar = "avatar_01.png"
};
User user_two = new User {
Name = "Hans Gustasson", Profession = "Developer", Avatar = "avatar_02.png"
};
User user_tree = new User {
Name = "Lennert Bengsson", Profession = "Backend developer", Avatar = "avatar_03.png"
};
User user_four = new User {
Name = "Hellena Bensson", Profession = "Engineer", Avatar = "avatar_04.png"
};
User user_five = new User {
Name = "Sara Onofors", Profession = "Fronend developer", Avatar = "avatar_05.png"
};
User user_sex = new User {
Name = "Tomas prochery", Profession = "Architecture designer", Avatar = "avatar_02.png"
};
//Add users to DB
context.Users.Add(user_one);
context.Users.Add(user_two);
context.Users.Add(user_tree);
context.Users.Add(user_four);
context.Users.Add(user_five);
context.Users.Add(user_sex);
//Save EF DB
context.SaveChanges();
}
if (!context.MeetingSchemas.Any())
{
MeetingSchemas meetingSchemas_one = new MeetingSchemas
{
Title = "Meeting",
Description = "Meeting with developer team",
Location = "Word tread center",
CreatorId = 15,
Status = MeetingSchemaStatus.Valid,
Type = MeetingSchemaType.Work,
TimeStart = DateTime.Now.AddHours(3),
TimeEnd = DateTime.Now.AddHours(6),
//Add the participants
Participants = new List <Participants>
{
new Participants()
{
MeetingSchemaId = 1, UserId = 15
},
new Participants()
{
MeetingSchemaId = 1, UserId = 17
},
new Participants()
{
MeetingSchemaId = 1, UserId = 19
}
}
};
//Create instance for coffe
MeetingSchemas meetingSchemas_two = new MeetingSchemas
{
Title = "Coffe time",
Description = "Coffe time with developer",
Location = "Stockholm sale",
CreatorId = 16,
Status = MeetingSchemaStatus.Valid,
Type = MeetingSchemaType.Coffe,
TimeStart = DateTime.Now.AddHours(2),
TimeEnd = DateTime.Now.AddHours(4),
//Add Participants to be at coffe
Participants = new List <Participants>
{
new Participants()
{
MeetingSchemaId = 2, UserId = 15
},
new Participants()
{
MeetingSchemaId = 1, UserId = 19
},
new Participants()
{
MeetingSchemaId = 2, UserId = 20
}
}
};
//Create Shoping instance
MeetingSchemas meetingSchemas_tree = new MeetingSchemas
{
Title = " Shoping plan",
Description = "Shoping at Kista galleria",
Location = "Kista Galleria",
CreatorId = 17,
Status = MeetingSchemaStatus.Valid,
Type = MeetingSchemaType.Shopping,
TimeStart = DateTime.Now.AddHours(4),
TimeEnd = DateTime.Now.AddHours(6),
//Add participants to shoping timme
Participants = new List <Participants>
{
new Participants()
{
MeetingSchemaId = 3, UserId = 17
},
new Participants()
{
MeetingSchemaId = 3, UserId = 15
},
new Participants()
{
MeetingSchemaId = 3, UserId = 19
}
}
};
//Create instace for famliy meeting
MeetingSchemas meetingSchemas_four = new MeetingSchemas
{
Title = "family meeting",
Description = "My family will have a meeting at home",
Location = "Home",
CreatorId = 18,
Status = MeetingSchemaStatus.Valid,
Type = MeetingSchemaType.Others,
TimeStart = DateTime.Now.AddHours(2),
TimeEnd = DateTime.Now.AddHours(5),
//Add participants
Participants = new List <Participants>
{
new Participants()
{
MeetingSchemaId = 4, UserId = 16
},
new Participants()
{
MeetingSchemaId = 4, UserId = 17
},
new Participants()
{
MeetingSchemaId = 4, UserId = 20
}
}
};
//Create instace for famliy meeting
MeetingSchemas meetingSchemas_five = new MeetingSchemas
{
Title = "Student friends",
Description = " Meeting with my friends at KTH",
Location = "KTH D-Sale",
CreatorId = 19,
Status = MeetingSchemaStatus.Valid,
Type = MeetingSchemaType.Others,
TimeStart = DateTime.Now.AddHours(3),
TimeEnd = DateTime.Now.AddHours(5),
//Add participants
Participants = new List <Participants>
{
new Participants()
{
MeetingSchemaId = 4, UserId = 15
},
new Participants()
{
MeetingSchemaId = 4, UserId = 16
},
new Participants()
{
MeetingSchemaId = 4, UserId = 17
},
new Participants()
{
MeetingSchemaId = 4, UserId = 18
},
new Participants()
{
MeetingSchemaId = 4, UserId = 19
}
}
};
//Create instace for visiting a doctor
MeetingSchemas meetingSchemas_sex = new MeetingSchemas
{
Title = "Meeting doctor",
Description = "Meeting a doctor for employees",
Location = "Karolinska hospital",
CreatorId = 20,
Status = MeetingSchemaStatus.Valid,
Type = MeetingSchemaType.Doctor,
TimeStart = DateTime.Now.AddHours(2),
TimeEnd = DateTime.Now.AddHours(4),
//Create instance of participants for doctor meeting
Participants = new List <Participants>
{
new Participants()
{
MeetingSchemaId = 4, UserId = 15
},
new Participants()
{
MeetingSchemaId = 4, UserId = 16
},
new Participants()
{
MeetingSchemaId = 4, UserId = 19
}
}
};
//Add MeetingSchemas obj to DB
context.MeetingSchemas.Add(meetingSchemas_one);
context.MeetingSchemas.Add(meetingSchemas_two);
context.MeetingSchemas.Add(meetingSchemas_tree);
context.MeetingSchemas.Add(meetingSchemas_four);
context.MeetingSchemas.Add(meetingSchemas_five);
context.MeetingSchemas.Add(meetingSchemas_sex);
//Save EF DB
context.SaveChanges();
}
}
