public void AfterDateSelectForLocation(DateTime startDate, DateTime endDate) { locationListForSelect = new List <LocationDTO>(); EventDAL locationObject = new EventDAL(); LocationDTO locationDtoObject = new LocationDTO(); LocationDAL locationDALObject = new LocationDAL(); List <Location> locationList = locationDALObject.SelectLocation(); int[] collidingLocationID = locationObject.SelectForEventLocation(startDate, endDate); int collidingLocationIDLength = collidingLocationID.Length; for (int i = 0; i < collidingLocationIDLength; i++) { locationList = locationList.Where(w => w.LocationID != collidingLocationID[i]).ToList <Location>(); } foreach (var item in locationList) { locationDtoObject = new LocationDTO(); locationDtoObject.LocationID = item.LocationID; locationDtoObject.LocationName = item.LocationName; locationListForSelect.Add(locationDtoObject); } }
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 IHttpActionResult GetTopEventSortByMoneyDonateIn(int top) { try { List <EventBasicInfo> eventList; using (var db = new EventDAL()) { eventList = db.GetTopEventSortByMoneyDonateIn(top); } return(Ok(new HTTPMessageDTO { Status = WsConstant.HttpMessageType.SUCCESS, Message = "", Type = "", Data = eventList })); } catch (Exception) { return(Ok(new HTTPMessageDTO { Status = WsConstant.HttpMessageType.ERROR, Message = "", Type = "" })); } }
public IHttpActionResult OrderEventListOfOrganizationByStatus(int orgId, bool isStatus) { try { List <EventBasicInfo> eventListBasicInfo; using (var db = new EventDAL()) { eventListBasicInfo = db.GetEventsBelongToCreatorByStatus(orgId, isStatus); } return(Ok(new HTTPMessageDTO { Status = WsConstant.HttpMessageType.SUCCESS, Message = "", Type = "", Data = eventListBasicInfo })); } catch (Exception) { return(Ok(new HTTPMessageDTO { Status = WsConstant.HttpMessageType.ERROR, Message = "", Type = "" })); } }
public IHttpActionResult GetAllComment(int eventId) { List <BasicCommentThread> commentList = new List <BasicCommentThread>(); using (var db = new EventDAL()) { if (User.Identity.IsAuthenticated) { commentList = db.GetAllCommentInEvent(eventId, User.Identity.Name); } else { commentList = db.GetAllCommentInEvent(eventId, ""); } } if (commentList == null || commentList.Count == 0) { return(Ok(new HTTPMessageDTO { Status = WsConstant.HttpMessageType.NOT_FOUND })); } else { return(Ok(new HTTPMessageDTO { Status = WsConstant.HttpMessageType.SUCCESS, Data = commentList })); } }
public IHttpActionResult ChangeSatusOfEventType(int eventTypeId) { try { bool eventTypeStatus; using (var db = new EventDAL()) { var eventType = db.GetEventTypeById(eventTypeId); eventType.IsActive = !eventType.IsActive; eventTypeStatus = eventType.IsActive; db.UpdateEventType(eventType); } return(Ok(new HTTPMessageDTO { Status = WsConstant.HttpMessageType.SUCCESS, Message = "Change status of eventType successfully", Type = "", Data = eventTypeStatus })); } catch (Exception) { return(Ok(new HTTPMessageDTO { Status = WsConstant.HttpMessageType.ERROR, Message = "Cannot change status of eventType", Type = "" })); } }
public IHttpActionResult CreateEventType(EventType eventType) { try { bool createStatus; eventType.IsActive = true; using (var db = new EventDAL()) { createStatus = db.CreateEventType(eventType); } return(Ok(new HTTPMessageDTO { Status = WsConstant.HttpMessageType.SUCCESS, Message = "Change status of eventType successfully", Type = "", Data = createStatus })); } catch (Exception) { return(Ok(new HTTPMessageDTO { Status = WsConstant.HttpMessageType.ERROR, Message = "Cannot change status of eventType", Type = "" })); } }
public IHttpActionResult GetEventManageBasicInfor() { try { EventCircleTileDTO circleInfor = new EventCircleTileDTO(); using (var db = new EventDAL()) { circleInfor = db.GetEventCircleTile(); } return(Ok(new HTTPMessageDTO { Status = WsConstant.HttpMessageType.SUCCESS, Data = circleInfor })); } catch (Exception) { return(Ok(new HTTPMessageDTO { Status = WsConstant.HttpMessageType.ERROR, Message = "Cannot Get Event info for Circle Tiles", Type = "" })); } }
public IHttpActionResult GetAllEventType() { try { List <EventTypeDTO> listEventType; using (var db = new EventDAL()) { listEventType = db.GetAllEventType(); } return(Ok(new HTTPMessageDTO { Status = WsConstant.HttpMessageType.SUCCESS, Message = "Get all event type successfully", Type = "", Data = listEventType })); } catch (Exception) { return(Ok(new HTTPMessageDTO { Status = WsConstant.HttpMessageType.ERROR, Message = "Cannot get event type", Type = "" })); } }
public IHttpActionResult GetEventWithId(int eventId) { try { EventBasicInfo currentThread; using (var db = new EventDAL()) { currentThread = db.GetFullEventBasicInformation(eventId); } return(Ok(new HTTPMessageDTO { Status = WsConstant.HttpMessageType.SUCCESS, Message = "Get Event with ID Successfully", Type = "", Data = currentThread })); } catch (Exception) { return(Ok(new HTTPMessageDTO { Status = WsConstant.HttpMessageType.ERROR, Message = "Cannot Get Event with ID", Type = "" })); } }
public IHttpActionResult AddSubComment(AddSubCommentDTO comment) { int CurrenUser = 0; using (var db = new UserDAL()) { CurrenUser = db.GetUserByUserNameOrEmail(User.Identity.Name).UserID; } var newSubComment = new SubCommentEvent { UserId = CurrenUser, CommentEventId = comment.CommentThreadId, Content = comment.CommentContent, Status = true, CommentDate = DateTime.Now }; using (var db = new EventDAL()) { try { newSubComment = db.AddNewSubComment(newSubComment); return(Ok(new HTTPMessageDTO { Status = WsConstant.HttpMessageType.SUCCESS })); } catch (Exception) { return(Ok(new HTTPMessageDTO { Status = WsConstant.HttpMessageType.ERROR })); } } }
// GET: Event public JsonResult GetEvents() { List <SalesForceEvent> listEvents = new List <SalesForceEvent>(); EventDAL eventdal = new EventDAL(); listEvents = eventdal.GetEvents(); return(Json(listEvents, JsonRequestBehavior.AllowGet)); }
public IHttpActionResult ChangeLikeStateForComment(int CommentId) { using (var db = new EventDAL()) { var change = db.ChangelikeStateForComment(CommentId, User.Identity.Name); } return(Ok(new HTTPMessageDTO { Status = WsConstant.HttpMessageType.SUCCESS })); }
public IHttpActionResult GetEventsSortByPoint() { List <Event> EventFollowPoint = null; var basicEventList = new List <EventBasicInfo>(); try { using (var db = new EventDAL()) { EventFollowPoint = db.GetEventSortByPoint(); foreach (Event events in EventFollowPoint) { var eventMainImage = db.GetMainImageEventById(events.EventID); //get name of organizationt which is owner of this event. string organizationName; string eventType; using (var dbOrg = new OrganizationDAL()) { var orgOwner = dbOrg.GetOrganizationById(events.CreatorID); organizationName = orgOwner.OrganizationName; } //get type of this event. using (var dbWscontext = new Ws_DataContext()) { var eventTypes = dbWscontext.EventTypes.Find(events.EventType); eventType = eventTypes.EventTypeName; } basicEventList.Add(new EventBasicInfo { EventID = events.EventID, CreatorID = events.CreatorID, CreatorName = organizationName, EventName = events.EventName, MainImageUrl = eventMainImage.ImageUrl, Content = events.Description, ShortDescription = events.ShortDescription, Status = true, EventType = eventType, CreatedDate = events.Created_Date.ToString("H:mm:ss dd/MM/yy") }); } } return(Ok(new HTTPMessageDTO { Status = WsConstant.HttpMessageType.SUCCESS, Data = basicEventList })); } catch (Exception) { //ViewBag.ErrorMessage = ex; return(Redirect("/#/Error")); } }
public EventBLL EventFindByID(int EventID) { EventBLL proposedReturnValue = null; EventDAL item = _context.EventFindByID(EventID); if (item != null) { proposedReturnValue = new EventBLL(item); } return(proposedReturnValue); }
public DataTable GetById(int id) { try { EventDAL evntDAL = new EventDAL(); return(evntDAL.GetById(id)); } catch (Exception) { throw; } }
public bool Delete(Events evnt) { try { EventDAL evntDAL = new EventDAL(); return(evntDAL.Delete(evnt)); } catch (Exception) { throw; } }
public DataTable GetAll() { try { EventDAL evntDAL = new EventDAL(); return(evntDAL.GetAll()); } catch (Exception) { throw; } }
public ActionResult CreateEvent() { EventDAL eventdal = new EventDAL(); SalesForceEvent eventsales = new SalesForceEvent(); eventsales.Subject = "TestEvent to check for Creating events"; eventsales.StartDate = DateTime.Now; eventsales.EndDate = eventsales.StartDate.Value.AddHours(1); eventsales.Location = "Conference Room"; eventdal.CreateEvent(eventsales); return(View("Index")); }
public IHttpActionResult GetpublicMessage(int EventId) { List <MessageBasicInfoDTO> publicMessage = new List <MessageBasicInfoDTO>(); using (var db = new EventDAL()) { publicMessage = db.GetAllPublicMessage(EventId); } return(Ok(new HTTPMessageDTO { Status = WsConstant.HttpMessageType.SUCCESS, Data = publicMessage })); }
public IHttpActionResult CheckCurrentUserIsLikedOrNot(int EventId) { bool isLiked = false; using (var db = new EventDAL()) { isLiked = db.CheckUserIsLikedOrNot(EventId, User.Identity.Name); } return(Ok(new HTTPMessageDTO { Status = WsConstant.HttpMessageType.SUCCESS, Data = isLiked })); }
public IHttpActionResult CountLikeInCommentEvent(int CommentId) { int numberOfLikes = 0; using (var db = new EventDAL()) { numberOfLikes = db.CountLikeInCommentEvent(CommentId); } return(Ok(new HTTPMessageDTO { Status = WsConstant.HttpMessageType.SUCCESS, Data = numberOfLikes })); }
public ActionResult CreateEvent(CreateEventInfo eventInfo, IEnumerable <HttpPostedFileBase> FileUpload) { //Get Event Time Lines string[] FromDate = Request.Form.GetValues("FromDate"); string[] ToDate = Request.Form.GetValues("ToDate"); string[] Description = Request.Form.GetValues("Description"); List <CreateEventSchedule> eventTimeLine = new List <CreateEventSchedule>(); if (FromDate != null && FromDate.Length >= 1) { for (int i = 0; i < FromDate.Length; i++) { if (FromDate[i] != "" && ToDate[i] != "" && Description[i] != "") { eventTimeLine.Add(new CreateEventSchedule(FromDate[i], ToDate[i], Description[i])); } } } Event newEvent = new Event(); using (var db = new EventDAL()) { newEvent = db.AddNewEvent(eventInfo, User.Identity.Name); foreach (var scheduleInfo in eventTimeLine) { db.AddNewEventTimeLine(scheduleInfo, newEvent.EventID); } } //Add Image to server try { foreach (HttpPostedFileBase img in FileUpload) { //rebuild image name string imageName = WsConstant.randomString() + Path.GetExtension(img.FileName).ToLower(); string path = Path.Combine(System.Web.HttpContext.Current.Server.MapPath("~/Content/Upload"), imageName); img.SaveAs(path); string imgaeUrl = "/Content/Upload/" + imageName; //Add Image to db. using (var db = new AlbumImageDAL()) { db.AddEventAlbum(new EventAlbumImageDTO(newEvent.EventID, imgaeUrl)); } } } catch (Exception) { return(Redirect("/#/Error")); } return(Redirect("/#/EventDetail/" + newEvent.EventID)); }
public ActionResult CreateEvent() { EventTypeDropList eventTypeDropList = new EventTypeDropList(); using (var db = new EventDAL()) { eventTypeDropList = db.GetEventType(); } if (eventTypeDropList.EventTypeList.Count <= 0) { return(PartialView("~/Views/Error/_Error.cshtml")); } return(PartialView("~/Views/Event/_CreateEvent.cshtml", eventTypeDropList)); }
public IHttpActionResult DeleteSubComment(int subCommentId) { using (var db = new EventDAL()) { var result = db.DeleteSubComment(subCommentId, User.Identity.Name); return(Ok(new HTTPMessageDTO { Status = WsConstant.HttpMessageType.SUCCESS, Message = "", Type = "", Data = result })); } }
/// <summary> /// Check Event state to donate /// </summary> /// <param name="eventId"></param> /// <returns></returns> public JsonResult CheckDonateEvent(int eventId) { using (var db = new EventDAL()) { var eventGet = db.GetEventById(eventId); if (!eventGet.Status || DateTime.Now > eventGet.Finish_Date) { return(Json(false, JsonRequestBehavior.AllowGet)); } else { return(Json(true, JsonRequestBehavior.AllowGet)); } } }
public IHttpActionResult GetEventDetailById(int id) { EventBasicInfo EvtBasicInfo = new EventBasicInfo(); try { using (var db = new EventDAL()){ EvtBasicInfo = db.GetFullEventBasicInformation(id); } }catch (Exception) { return(Redirect("/#/Error")); } return(Ok(new HTTPMessageDTO { Status = WsConstant.HttpMessageType.SUCCESS, Data = EvtBasicInfo })); }
public IHttpActionResult CheckExistedSubCommentOrNot() { using (var db = new EventDAL()) { var commentList = db.GetAllCommentIdAndSubCommentId(); if (commentList == null || commentList.Count == 0) { return(Ok(new HTTPMessageDTO { Status = WsConstant.HttpMessageType.NOT_FOUND })); } else { return(Ok(new HTTPMessageDTO { Status = WsConstant.HttpMessageType.SUCCESS, Data = commentList })); } } }
// 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(); }
public IHttpActionResult GetDonatorInEvent(int id) { List <ListDonatorDTO> list = new List <ListDonatorDTO>(); try { using (var db = new EventDAL()) { list = db.GetDonatorInEvent(id); } } catch (Exception) { return(Redirect("/#/Error")); } return(Ok(new HTTPMessageDTO { Status = WsConstant.HttpMessageType.SUCCESS, Data = list })); }