public bool CreateEvent(EventDTO eventManager) { Electronica.Entity.Event eventObject = new Event(); Electronica.Repository.EventDAL eventDALObject = new EventDAL(); eventObject.EventName = eventManager.EventName; eventObject.EventStartDate = eventManager.EventStartDate; eventObject.EventEndDate = eventManager.EventEndDate; eventObject.TopicID = eventManager.TopicID; eventObject.LocationID = eventManager.LocationID; eventObject.PromoCode = eventManager.PromoCode; eventObject.PromoDiscount = eventManager.PromoDiscount; eventObject.PromoExpiry = eventManager.PromoExpiry; eventObject.EventFee = eventManager.EventFee; eventObject.EventIntake = eventManager.EventIntake; eventObject.EventStatus = 1; //upcoming eventObject.EventCreatedBy = 1; //eventManager.EventCreatedBy; eventObject.EventDeleteStatus = 0; //not deleted eventObject.EventDescription = eventManager.EventDescription; int eventID = eventDALObject.InsertEvent(eventObject); //insertion into eventtable SpeakerEnrollmentDAL speakerEnrollmentDALObject = new SpeakerEnrollmentDAL(); SpeakerEnrollment speakerEnrollmentObject = new SpeakerEnrollment(); speakerEnrollmentObject.EventID = eventID; speakerEnrollmentObject.UserID = eventManager.SpeakerID; speakerEnrollmentDALObject.InsertSpeakerEnrollment(speakerEnrollmentObject); //insertion to speaker enrollment table return(true); }
// public string UpdateEventStatus(int eventid) // { //} public void AfterDateSelect(DateTime startDate, DateTime endDate, int SkillID) { speakerList = new List <User>(); SpeakerSkillMapDAL speakerSkillMap = new SpeakerSkillMapDAL(); EventDAL eventObject = new EventDAL(); UserDAL userObject = new UserDAL(); EnrollmentDal enrollmentObject = new EnrollmentDal(); SpeakerEnrollmentDAL speakerEnrollmentObject = new SpeakerEnrollmentDAL(); List <User> speakerListTemp; List <User> speakerListTemp2; speakerListTemp = userObject.UserForSelect(); int[] skilledUserID = speakerSkillMap.SelectSpeakerForEvent(SkillID); int[] eventList = eventObject.SelectForEvent(startDate, endDate); List <SpeakerEnrollment> enrolledSpeakers = speakerEnrollmentObject.SpeakerForSelect(eventList); List <ParticipantEnrollment> enrolledParticipants = enrollmentObject.ParticipantForSelect(eventList); int skilledLength = skilledUserID.Length; for (int i = 0; i < skilledLength; i++) { speakerListTemp2 = speakerListTemp.Where(s => s.UserID == skilledUserID[i]).ToList <User>(); speakerList.AddRange(speakerListTemp2); } int enrolledSpeakerLength = enrolledSpeakers.Count(); for (int i = 0; i < enrolledSpeakerLength; i++) { speakerList = speakerList.Where(s => s.UserID != enrolledSpeakers[i].UserID).ToList <User>(); } int enrolledParticipanLength = enrolledParticipants.Count(); for (int i = 0; i < enrolledParticipanLength; i++) { if ((speakerList.Find(s => s.UserID == enrolledParticipants[i].UserID)) != null) { speakerList = speakerList.Where(s => s.UserID != enrolledParticipants[i].UserID).ToList <User>(); } } // int k= speakerlist.Count(); }