//to retrieve the data to display list
public List <TrainingListVM> GetTrainingDetails()
{
try
{
var trainingList = new List <TrainingListVM>();
using (TrainingAppEntities1 dc = new TrainingAppEntities1())
{
var data = dc.Trainings.ToList();
foreach (var item in data)
{
TrainingListVM training = new TrainingListVM();
if (item.DeletedAt == null)
{
training.TrainingId = item.TrainingId;
training.EndTime = item.Schedule.EndTime.Value;
training.StartTime = item.Schedule.StartTime.Value;
training.Topic = item.Topic;
var name = string.Concat(item.User.FirstName + item.User.LastName);
training.TrainerName = name;
training.Description = item.Description;
training.RoomName = item.Schedule.RoomDetail.RoomName;
trainingList.Add(training);
}
}
}
return(trainingList);
}
catch (Exception)
{
throw null;
}
}
//to insert the data from create training form
public bool InsertTrainingDetails(TrainingVM trainer)
{
try
{
bool status = false;
using (TrainingAppEntities1 dc = new TrainingAppEntities1())
{
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);
}
}
public bool VerifyAccount(string id)
{
try
{
using (TrainingAppEntities1 dc = new TrainingAppEntities1())
{
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 delete the specific training
public bool DeleteTrainingDetails(int id)
{
try
{
bool status = false;
using (TrainingAppEntities1 dc = new TrainingAppEntities1())
{
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);
}
}
public User GetUser(LoginVM login)
{
try
{
using (TrainingAppEntities1 dc = new TrainingAppEntities1())
{
var isValidUser = dc.UserCredentials.Where(a => a.Email == login.Email).FirstOrDefault();
if (isValidUser != null)
{
if (string.Compare(Crypto.Hash(login.Password), isValidUser.Password) == 0 && (isValidUser.IsEmailVerified == true))
{
var userObj = dc.Users.Where(a => a.UserId == isValidUser.UserId).FirstOrDefault();
return(userObj);
}
else
{
return(null);
}
}
else
{
return(null);
}
}
}
catch (Exception)
{
return(null);
}
}
public bool SendMailForForgotPasswordLink(string emailId)
{
try
{
IRegistrationInfo details = new RegistrationInfo();
using (TrainingAppEntities1 dc = new TrainingAppEntities1())
{
var account = dc.UserCredentials.Where(a => a.Email == emailId).FirstOrDefault();
if (account != null && account.IsEmailVerified == true)
{
//send mail to user
bool status = details.SendVerificationLinkEmail(account.Email, account.ActivationCode.ToString(), "VerifyPassword");
if (status)
{
dc.Configuration.ValidateOnSaveEnabled = false;
return(true);
}
else
{
return(false);
}
}
else
{
return(false);
}
}
}
catch (Exception)
{
return(false);
}
}
public List <UsersVM> GetUsersDetails()
{
try
{
var userList = new List <UsersVM>();
using (TrainingAppEntities1 dc = new TrainingAppEntities1())
{
//var data = dc1.Schedules.ToList();
var data = dc.Users.ToList();
foreach (var item in data)
{
UsersVM user = new UsersVM();
if (item.DeletedAt == null)
{
var name = string.Concat(item.FirstName + " " + item.LastName);
user.UserName = name;
user.UserId = item.UserId;
userList.Add(user);
}
}
}
return(userList);
}
catch (Exception ex)
{
throw ex;
}
}
//to update the data from edit Meeting Form
public bool UpdateMeetingDetails(int id, MeetingVM meeting)
{
try
{
bool status = false;
using (TrainingAppEntities1 dc = new TrainingAppEntities1())
{
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 InsertRegistrationInfo(UserCredentialsVM userCredentials)
{
try
{
bool status = false;
#region//Save Data To Database
using (TrainingAppEntities1 dc = new TrainingAppEntities1())
{
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 = false;
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 ex)
{
throw ex;
}
}
public bool IsEmailExist(String emailID)
{
try
{
using (TrainingAppEntities1 dc = new TrainingAppEntities1())
{
var result = dc.UserCredentials.Where(a => a.Email == emailID).FirstOrDefault();
return(result == null ? false : true);
}
}
catch (Exception)
{
return(false);
}
}
//to insert the data from create Meeting form
public bool InsertMeetingDetails(MeetingVM meeting)
{
try
{
bool status = false;
using (TrainingAppEntities1 dc = new TrainingAppEntities1())
{
#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 (TrainingAppEntities1 dc = new TrainingAppEntities1())
{
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 retrive the data to display list
public List <MeetingListVM> GetMeetingInfo()
{
try
{
var meetingList = new List <MeetingListVM>();
using (TrainingAppEntities1 dc = new TrainingAppEntities1())
{
#region // Retriving meeting list
var data = dc.Meetings.ToList();
foreach (var item in data)
{
MeetingListVM meeting = new MeetingListVM();
if (item.DeletedAt == null)
{
meeting.MeetingId = item.MeetingId;
meeting.EndTime = item.Schedule.EndTime.Value;
meeting.StartTime = item.Schedule.StartTime.Value;
meeting.MeetingName = item.MeetingName;
meeting.Agenda = item.Agenda;
meeting.OrganiserName = string.Concat(item.User.FirstName + item.User.LastName);
List <AttendeeVM> attendeeList = new List <AttendeeVM>();
foreach (var attendee in item.MeetingsAttendees)
{
AttendeeVM attend = new AttendeeVM();
attend.AttendeeID = attendee.User.UserId;
attend.AttendeeName = attendee.User.FirstName;
attendeeList.Add(attend);
}
meeting.AttendeeList = attendeeList;
meeting.RoomName = item.Schedule.RoomDetail.RoomName;
meetingList.Add(meeting);
}
}
#endregion
}
return(meetingList);
}
catch (Exception)
{
return(null);
}
}
public List <RoomVM> GetRoomsByTime(TimeSlotVM times)
{
try
{
DateTime startTime = times.StartTime;
DateTime endTime = times.EndTime;
var roomList = new List <RoomVM>();
using (TrainingAppEntities1 dc = new TrainingAppEntities1())
{
var bookedSlotList = dc.Schedules.Where(a => a.StartTime == startTime || a.EndTime == endTime || (a.StartTime <endTime && a.StartTime> startTime) || (startTime > a.StartTime && endTime < a.EndTime) || (endTime > a.EndTime && startTime < a.StartTime));
HashSet <int?> bookedIdList = new HashSet <int?>();
var uniqueDetails = dc.RoomDetails.ToList();
int count = 0;
foreach (var item in bookedSlotList)
{
bookedIdList.Add(item.RoomId);
count++;
}
Console.WriteLine(count);
foreach (var item in bookedIdList)
{
uniqueDetails.RemoveAll(a => a.RoomId == item);
}
foreach (var item in uniqueDetails)
{
RoomVM roomVM = new RoomVM();
roomVM.RoomId = item.RoomId;
roomVM.RoomName = item.RoomName;
roomList.Add(roomVM);
}
}
return(roomList);
}
catch (Exception)
{
return(null);
}
}
//to update the data from edit training form
public bool UpdateTrainingDetails(int id, TrainingVM trainer)
{
try
{
bool status = false;
using (TrainingAppEntities1 dc = new TrainingAppEntities1())
{
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);
}
}
public ActionResult VerifyPassword(ResetPasswordVM reset)
{
try
{
var message = " ";
#region// reseting the password
using (TrainingAppEntities1 dc = new TrainingAppEntities1())
{
var user = dc.UserCredentials.Where(a => a.ActivationCode.ToString() == reset.ActivationCode.ToString()).FirstOrDefault();
if (user != null)
{
if (reset.NewPassword == reset.ConfirmPassword)
{
user.Password = Crypto.Hash(reset.NewPassword);
dc.SaveChanges();
message = "new password updated successfully go and login";
}
else
{
message = "password and confirm password does not match";
}
}
else
{
message = "something went wrong";
}
}
#endregion
ViewBag.Message = message;
return(View(reset));
}
catch (Exception ex)
{
throw ex;
}
}