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 GetSpeakerName(int EventID) { SpeakerEnrollment objSpeaker = new SpeakerEnrollment(); objSpeaker = context.SpeakerEnrollments.Where(l => l.EventID == EventID).Single(); User objUser = new User(); objUser = context.Users.Where(l => l.UserID == objSpeaker.UserID).Single(); return(objUser.FirstName + " " + objUser.LastName); }
public bool InsertSpeakerEnrollment(SpeakerEnrollment speakerEnrollment) { electronicaContext.SpeakerEnrollments.Add(speakerEnrollment); electronicaContext.SaveChanges(); return(true); }