//to insert the data from create training form public bool InsertTrainingDetails(TrainingVM trainer) { try { bool status = false; using (TrainingAppEntities dc = new TrainingAppEntities()) { Schedule schedule = new Schedule(); schedule.StartTime = trainer.StartTime; schedule.EndTime = trainer.EndTime; schedule.RoomId = trainer.RoomId; var obj = dc.Schedules.Add(schedule); dc.SaveChanges(); Training traine = new Training(); traine.Topic = trainer.Topic; traine.Description = trainer.Description; traine.ScheduleId = obj.ScheduleId; traine.UserId = trainer.UserId; traine.CreatedAt = DateTime.Now; traine.UpdatedAt = DateTime.Now; dc.Trainings.Add(traine); dc.SaveChanges(); status = true; } return(status); } catch (Exception) { return(false); } }
//to delete the specific training public bool DeleteTrainingDetails(int id) { try { bool status = false; using (TrainingAppEntities dc = new TrainingAppEntities()) { var trainerEntity = dc.Trainings.FirstOrDefault(a => a.TrainingId == id); if (trainerEntity == null) { return(status); } else { var scheduleEntity = dc.Schedules.FirstOrDefault(a => a.ScheduleId == trainerEntity.ScheduleId); dc.Schedules.Remove(scheduleEntity); dc.SaveChanges(); //dc.Trainings.Remove(trainerEntity); trainerEntity.DeletedAt = DateTime.Now; dc.SaveChanges(); status = true; return(status); } } } catch (Exception) { return(false); } }
//to update the data from edit Meeting Form public bool UpdateMeetingDetails(int id, MeetingVM meeting) { try { bool status = false; using (TrainingAppEntities dc = new TrainingAppEntities()) { var meetingEntity = dc.Meetings.FirstOrDefault(a => a.MeetingId == id); if (meetingEntity == null) { return(status); } else { #region//updating schedule for specific record var scheduleEntity = dc.Schedules.FirstOrDefault(a => a.ScheduleId == meetingEntity.ScheduleId); scheduleEntity.StartTime = meeting.StartTime; scheduleEntity.EndTime = meeting.EndTime; scheduleEntity.RoomId = meeting.RoomId; dc.SaveChanges(); #endregion #region//updating meeting for specific record meetingEntity.MeetingName = meeting.MeetingName; meetingEntity.Agenda = meeting.Agenda; //for updating meeting schedule Id is not require cause it is already present in database //for updating meeting User Id is not require cause it is already present in database.() meetingEntity.UpdatedAt = DateTime.Now; dc.SaveChanges(); #endregion #region//updating meeting attendance for specific record var meetingAttendeeIdObject = dc.MeetingsAttendees.Where(a => a.MeetingId == id).ToList(); foreach (var item in meetingAttendeeIdObject) { dc.MeetingsAttendees.Remove(item); dc.SaveChanges(); } foreach (int userid in meeting.MeetingAttendeeId) { MeetingsAttendee attendee = new MeetingsAttendee(); attendee.MeetingId = id; attendee.UserId = userid; dc.MeetingsAttendees.Add(attendee); dc.SaveChanges(); } #endregion status = true; } } return(status); } catch (Exception) { return(false); } }
public bool InsertRegistrationDetails(UserCredentialsVM userCredentials) { try { bool status = false; #region//Save Data To Database using (TrainingAppEntities dc = new TrainingAppEntities()) { User user = new User(); user.FirstName = userCredentials.FirstName; user.LastName = userCredentials.LastName; user.IsActive = true; user.RoleId = 1; user.CreatedAt = DateTime.Now; user.UpdatedAt = DateTime.Now; var obj = dc.Users.Add(user); dc.SaveChanges(); #region//Taking data fromviewmodel and assigning to database entity UserCredential credentials = new UserCredential(); credentials.Email = userCredentials.Email; #region//Generate Activation credentials.ActivationCode = Guid.NewGuid(); #endregion #region//Password Hashing credentials.Password = Crypto.Hash(userCredentials.Password); #endregion credentials.IsActivated = true; credentials.IsEmailVerified = true; credentials.UserId = obj.UserId; dc.UserCredentials.Add(credentials); dc.SaveChanges(); #endregion #region//Send Email to User SendVerificationLinkEmail(userCredentials.Email, credentials.ActivationCode.ToString()); #endregion status = true; } #endregion return(status); } catch (Exception) { return(false); } }
public bool VerifyAccount(string id) { try { using (TrainingAppEntities dc = new TrainingAppEntities()) { dc.Configuration.ValidateOnSaveEnabled = false; var compare = dc.UserCredentials.Where(a => a.ActivationCode == new Guid(id)).FirstOrDefault(); if (compare != null) { compare.IsEmailVerified = true; dc.SaveChanges(); return(true); } else { return(false); } } } catch (Exception) { return(false); } }
//to insert the data from create Meeting form public bool InsertMeetingDetails(MeetingVM meeting) { try { bool status = false; using (TrainingAppEntities dc = new TrainingAppEntities()) { #region//Creating new schedule record Schedule schedule = new Schedule(); schedule.StartTime = meeting.StartTime; schedule.EndTime = meeting.EndTime; schedule.RoomId = meeting.RoomId; var obj = dc.Schedules.Add(schedule); dc.SaveChanges(); #endregion #region//Creating new meeting record Meeting meetin = new Meeting(); meetin.MeetingName = meeting.MeetingName; meetin.Agenda = meeting.Agenda; meetin.ScheduleId = obj.ScheduleId; meetin.UserId = meetin.UserId; meetin.CreatedAt = meetin.CreatedAt; meetin.UpdatedAt = meetin.UpdatedAt; var obj1 = dc.Meetings.Add(meetin); dc.SaveChanges(); #endregion #region//inserting attendeesId's(user's) into meetingattendee's table foreach (int userid in meeting.MeetingAttendeeId) { MeetingsAttendee attendee = new MeetingsAttendee(); attendee.MeetingId = obj1.MeetingId; attendee.UserId = userid; dc.MeetingsAttendees.Add(attendee); dc.SaveChanges(); } #endregion status = true; } return(status); } catch (Exception) { return(false); } }
//to delete the specific meeting public bool DeleteMeetingDetails(int id) { try { bool status = false; using (TrainingAppEntities dc = new TrainingAppEntities()) { var meetingEntity = dc.Meetings.FirstOrDefault(a => a.MeetingId == id); if (meetingEntity == null) { return(status); } else { #region//Deleting the Schedule for specific meeting var scheduleEntity = dc.Schedules.FirstOrDefault(a => a.ScheduleId == meetingEntity.ScheduleId); dc.Schedules.Remove(scheduleEntity); dc.SaveChanges(); #endregion #region//Deleting the meeting meetingEntity.DeletedAt = DateTime.Now; dc.SaveChanges(); #endregion #region//Deleting the meeting attendees var meetingAttendeeObjects = dc.MeetingsAttendees.Where(a => a.MeetingId == id).ToList(); foreach (var item in meetingAttendeeObjects) { dc.MeetingsAttendees.Remove(item); dc.SaveChanges(); } #endregion status = true; } } return(status); } catch (Exception) { return(false); } }
//to update the data from edit training form public bool UpdateTrainingDetails(int id, TrainingVM trainer) { try { bool status = false; using (TrainingAppEntities dc = new TrainingAppEntities()) { var trainerEntity = dc.Trainings.FirstOrDefault(a => a.TrainingId == id); if (trainerEntity == null) { return(status); } else { //updating schedule for specific record var scheduleEntity = dc.Schedules.FirstOrDefault(a => a.ScheduleId == trainerEntity.ScheduleId); scheduleEntity.StartTime = trainer.StartTime; scheduleEntity.EndTime = trainer.EndTime; scheduleEntity.RoomId = trainer.RoomId; dc.SaveChanges(); //updating training for specific record trainerEntity.Topic = trainer.Topic; trainerEntity.Description = trainer.Description; //for update schedule Id is not require cause it is already present in database. //for update User Id is not require cause it is already present in database. trainerEntity.UpdatedAt = DateTime.Now; dc.SaveChanges(); status = true; return(status); } } } catch (Exception) { return(false); } }