IUserSchedule IMeetingRetriever.GetUserBusyTime(int entryId)
{
using (ManagementSystemDataContext dataContext = new ManagementSystemDataContext(_connectionString))
{
return(dataContext.UserScheduleDtos.Single(c => c.IndexId == entryId));
}
}
//TODO: Implement interface methods.
#region IMeetingRetriever Members
List <IMeetingMaster> IMeetingRetriever.GetAllMeetingsByUser(IUser user)
{
using (ManagementSystemDataContext dataContext = new ManagementSystemDataContext(_connectionString))
{
List <IMeetingMaster> meetings = new List <IMeetingMaster>();
List <int> meetingIds = (from schedules in dataContext.Meeting_ResponseDtos
where schedules.FKUserId == user.UserId &&
schedules.MeetingId != 0
select schedules.MeetingId).ToList();
if (meetingIds.Count != 0)
{
foreach (int id in meetingIds)
{
meetings.Add(dataContext.Meeting_MasterDtos.Single(c => c.MeetingId == id));
}
return(meetings);
}
else
{
return(new List <IMeetingMaster>());
}
}
}
public ICustomSetting GetCustomSettings()
{
using (ManagementSystemDataContext dataContext = new ManagementSystemDataContext(_connectionString))
{
return(dataContext.CustomSettingDtos.First());
}
}
IUser IUserRetriever.GetUserById(int userId)
{
using (ManagementSystemDataContext dataContext = new ManagementSystemDataContext(_connectionString))
{
return(dataContext.UserDtos.SingleOrDefault(
w => w.UserId == userId));
}
}
void IMeetingScheduler.RemoveUserBusyTime(int userScheduleIndexId)
{
using (ManagementSystemDataContext dataContext = new ManagementSystemDataContext(_connectionString))
{
dataContext.UserScheduleDtos.DeleteAllOnSubmit(dataContext.UserScheduleDtos.Where(c => c.IndexId == userScheduleIndexId));
dataContext.SubmitChanges();
}
}
void ILocationSaver.RemoveLocation(int locationId)
{
using (ManagementSystemDataContext datacontext = new ManagementSystemDataContext(_connectionString))
{
datacontext.Location_MasterDtos.DeleteAllOnSubmit(datacontext.Location_MasterDtos.Where(c => c.LocationId == locationId));
datacontext.SubmitChanges();
}
}
IMeetingMaster IMeetingRetriever.GetMeetingByMeetingId(int meetingId)
{
using (ManagementSystemDataContext dataContext = new ManagementSystemDataContext(_connectionString))
{
return(dataContext.Meeting_MasterDtos.SingleOrDefault(
c => c.MeetingId == meetingId));
}
}
ILocationMaster ILocationRetriever.GetLocationByLocationId(int locationId)
{
using (ManagementSystemDataContext dataContext = new ManagementSystemDataContext(_connectionString))
{
return(dataContext.Location_MasterDtos.SingleOrDefault(
c => c.LocationId == locationId));
}
}
int IUserRetriever.GetUserId(string userName, string password)
{
using (ManagementSystemDataContext dataContext = new ManagementSystemDataContext(_connectionString))
{
return(dataContext.UserDtos.SingleOrDefault(
w => w.UserName == userName &&
w.Password == password).UserId);
}
}
List <IMeetingResponseType> IMeetingResponseTypeRetriever.GetResponseTypes()
{
using (ManagementSystemDataContext dataContext = new ManagementSystemDataContext(_connectionString))
{
IEnumerable <MeetingResponseTypeDto> meetingResponseTypes = (from types in dataContext.MeetingResponseTypeDtos
select types);
return(meetingResponseTypes.Cast <IMeetingResponseType>().ToList());
}
}
List <IUser> IUserRetriever.GetAllUsers()
{
using (ManagementSystemDataContext dataContext = new ManagementSystemDataContext(_connectionString))
{
IEnumerable <UserDto> users = (from user in dataContext.UserDtos
select user);
return(users.Cast <IUser>().ToList());
}
}
List <IMeetingMaster> IMeetingRetriever.GetAllMeetings()
{
using (ManagementSystemDataContext dataContext = new ManagementSystemDataContext(_connectionString))
{
IEnumerable <Meeting_MasterDto> meetings = (from meeting in dataContext.Meeting_MasterDtos
select meeting);
return(meetings.Cast <IMeetingMaster>().ToList());
}
}
bool IUserRetriever.IsUserValid(string userName, string password)
{
using (ManagementSystemDataContext dataContext = new ManagementSystemDataContext(_connectionString))
{
return(dataContext.UserDtos.Any(
w => w.UserName == userName &&
w.Password == password));
}
}
List <IvwMeetingResponse> IMeetingRetriever.GetMeetingResponsesByMeetingId(int meetingId)
{
using (ManagementSystemDataContext dataContext = new ManagementSystemDataContext(_connectionString))
{
IEnumerable <vw_MeetingResponseDto> responses = (from response in dataContext.vw_MeetingResponseDtos
where meetingId == response.MeetingId
select response);
return(responses.Cast <IvwMeetingResponse>().ToList());
}
}
List <ILocationMaster> ILocationRetriever.GetAllLocations()
{
using (ManagementSystemDataContext dataContext = new ManagementSystemDataContext(_connectionString))
{
IEnumerable <Location_MasterDto> results = (from location in dataContext.Location_MasterDtos
select location);
return(results.Cast <ILocationMaster>().ToList());
}
}
List <IMeetingMaster> IMeetingRetriever.GetMeetingsByLocation(ILocationMaster location)
{
using (ManagementSystemDataContext dataContext = new ManagementSystemDataContext(_connectionString))
{
IEnumerable <Meeting_MasterDto> results = (from meeting in dataContext.Meeting_MasterDtos
where meeting.ActualLocationId == location.LocationId
select meeting);
return(results.Cast <IMeetingMaster>().ToList());
}
}
string IUserRetriever.GetUserFullNameByUserId(int userId)
{
using (ManagementSystemDataContext dataContext = new ManagementSystemDataContext(_connectionString))
{
string firstName = dataContext.UserDtos.SingleOrDefault(
u => u.UserId == userId).UserFirstName;
string lastName = dataContext.UserDtos.SingleOrDefault(
u => u.UserId == userId).UserLastName;
return(string.Concat(firstName, " ", lastName));
}
}
public void SetCustomSettings(ICustomSetting customSetting)
{
using (ManagementSystemDataContext dataContext = new ManagementSystemDataContext(_connectionString))
{
CustomSettingDto customSettingDto = dataContext.CustomSettingDtos.First();
customSettingDto.ViewDays = customSetting.ViewDays;
customSettingDto.WorkDayBegin = customSetting.WorkDayBegin;
customSettingDto.WorkDayEnd = customSetting.WorkDayEnd;
dataContext.SubmitChanges();
}
}
void IMeetingScheduler.CreateMeeting(String Desc, DateTime StartTime, DateTime EndTime, int priority
, List <int> userIds, bool avRequired, bool phoneRequired
, bool videoRequired, int prefLocation, int calledByUser
, string myPhoneBridge, string myPhoneAccess
, DateTime WindowStart, DateTime WindowEnd, int Duration)
{
int currentid;
using (ManagementSystemDataContext dataContext = new ManagementSystemDataContext(_connectionString))
{
Meeting_MasterDto meetingMasterDto = new Meeting_MasterDto
{
MeetingDesc = Desc,
MeetingStartTime = StartTime,
MeetingEndTime = EndTime,
MeetingPriority = priority,
IsAVRequired = avRequired,
IsPhoneRequired = phoneRequired,
IsVideoConfRequired = videoRequired,
PreferredLocationId = prefLocation,
ActualLocationId = prefLocation,
MeetingCalledBy = calledByUser,
PhoneBridge = myPhoneBridge,
PhoneBridgeAccessCode = myPhoneAccess,
MeetingWindowStart = WindowStart,
MeetingWindowEnd = WindowEnd,
MeetingDuration = Duration
};
dataContext.Meeting_MasterDtos.InsertOnSubmit(meetingMasterDto);
dataContext.SubmitChanges();
currentid = meetingMasterDto.MeetingId;
List <Meeting_ResponseDto> meetingResponses = new List <Meeting_ResponseDto>();
foreach (int usr in userIds)
{
Meeting_ResponseDto meetingResponseDto = new Meeting_ResponseDto
{
MeetingId = currentid,
FKUserId = usr,
InvitedOn = DateTime.Now,
RespondedOn = null
};
meetingResponses.Add(meetingResponseDto);
}
dataContext.Meeting_ResponseDtos.InsertAllOnSubmit <Meeting_ResponseDto>(meetingResponses);
dataContext.SubmitChanges();
}
}
List <IUserSchedule> IUserRetriever.GetUserSchedule(int userId)
{
List <IUserSchedule> userSchedule = new List <IUserSchedule>();
using (ManagementSystemDataContext dataContext = new ManagementSystemDataContext(_connectionString))
{
userSchedule = (from schedule in dataContext.UserScheduleDtos
where schedule.UserId == userId
select schedule).Cast <IUserSchedule>().ToList();
}
return(userSchedule);
}
List <ILocationMaster> ILocationRetriever.GetLocationsFromSearchCriteria(IUser user, bool isAvRequired, bool isPhoneRequired, bool isVideoConfRequired, int capacity)
{
using (ManagementSystemDataContext dataContext = new ManagementSystemDataContext(_connectionString))
{
IEnumerable <Location_MasterDto> results = (from location in dataContext.Location_MasterDtos
where isAvRequired == location.IsAVAvailable &&
isPhoneRequired == location.IsPhoneAvailable &&
isVideoConfRequired == location.IsVideoConfAvailable &&
capacity <= location.LocationCapacity
select location);
return(results.Cast <ILocationMaster>().ToList());
}
}
List <IUserSchedule> IUserRetriever.GetUserSchedules(List <int> userIds)
{
List <IUserSchedule> userSchedules = new List <IUserSchedule>();
using (ManagementSystemDataContext dataContext = new ManagementSystemDataContext(_connectionString))
{
foreach (int id in userIds)
{
UserScheduleDto userScheduleDto = dataContext.UserScheduleDtos.SingleOrDefault(
c => c.UserId == id);
userSchedules.Add(userScheduleDto);
}
}
return(userSchedules);
}
void IMeetingScheduler.ScheduleUserBusyTime(string description, DateTime beginTime, DateTime endTime, int userId)
{
using (ManagementSystemDataContext dataContext = new ManagementSystemDataContext(_connectionString))
{
UserScheduleDto userScheduleDto = new UserScheduleDto
{
FromTime = beginTime,
ToTime = endTime,
UserId = userId,
ScheduleEntryDescription = description,
ScheduleEntryType = 1
};
dataContext.UserScheduleDtos.InsertOnSubmit(userScheduleDto);
dataContext.SubmitChanges();
}
}
void ILocationSaver.SaveLocation(ILocationMaster location)
{
using (ManagementSystemDataContext datacontext = new ManagementSystemDataContext(_connectionString))
{
if (datacontext.Location_MasterDtos.Any(c => c.LocationId == location.LocationId))
{
Location_MasterDto lcm = datacontext.Location_MasterDtos.Single(c => c.LocationId == location.LocationId);
lcm.IsAVAvailable = location.IsAvAvailable;
lcm.IsPhoneAvailable = location.IsPhoneAvailable;
lcm.IsVideoConfAvailable = location.IsVideoConfAvailable;
lcm.LocationBuilding = location.LocationBuilding;
lcm.LocationCapacity = location.LocationCapacity;
lcm.LocationFloor = location.LocationFloor;
lcm.LocationName = location.LocationName;
lcm.LocationRoom = location.LocationRoom;
}
else
{
Location_MasterDto lcm = new Location_MasterDto
{
IsAVAvailable = location.IsAvAvailable,
IsPhoneAvailable = location.IsPhoneAvailable,
IsVideoConfAvailable = location.IsVideoConfAvailable,
LocationBuilding = location.LocationBuilding,
LocationCapacity = location.LocationCapacity,
LocationFloor = location.LocationFloor,
LocationName = location.LocationName,
LocationRoom = location.LocationRoom
};
datacontext.Location_MasterDtos.InsertOnSubmit(lcm);
}
datacontext.SubmitChanges();
}
}
