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
}));
}
