public void editEvent(EventModel eventModel)
{
Event eventEntity = new Event()
{
EventId = eventModel.EventId,
Title = eventModel.Title,
StartTime = eventModel.StartTime,
TypeOfEvent = (bool)eventModel.TypeOfEvent,
EventDate = eventModel.EventDate,
DurationInHours = eventModel.DurationInHours,
Description = eventModel.Description,
OtherDetails = eventModel.OtherDetails,
InviteByEmail = eventModel.InviteByEmail,
};
EventDataAccess eventDataAcess = new EventDataAccess();
eventDataAcess.editEvent(eventEntity);
}
public EventModel getDetailsOfEvent(int eventid)
{
EventDataAccess eventDataAcess = new EventDataAccess();
var eventDetails = eventDataAcess.getDetailsOfEvent(eventid);
EventModel eventModel = new EventModel()
{
Title = eventDetails.Title,
StartTime = eventDetails.StartTime,
TypeOfEvent = eventDetails.TypeOfEvent,
EventDate = eventDetails.EventDate,
DurationInHours = eventDetails.DurationInHours,
Description = eventDetails.Description,
OtherDetails = eventDetails.OtherDetails,
InviteByEmail = eventDetails.InviteByEmail,
Comments = eventDetails.Comments.Select(x => new CommentModel()
{
CreateDate = x.CreateDate,
Comments = x.Comments,
}),
};
return(eventModel);
}
public int createEvent(EventModel bookEvent, string Username)
{
Event eventEntity = new Event()
{
Title = bookEvent.Title,
StartTime = bookEvent.StartTime,
TypeOfEvent = (bool)bookEvent.TypeOfEvent,
EventDate = bookEvent.EventDate,
DurationInHours = bookEvent.DurationInHours,
Description = bookEvent.Description,
OtherDetails = bookEvent.OtherDetails,
InviteByEmail = bookEvent.InviteByEmail,
};
EventDataAccess eventDataAcess = new EventDataAccess();
int newEvent = eventDataAcess.createEvent(eventEntity, Username);
return(newEvent);
}
public ActionResult ApproveDataEvent(EventViewModel paramAppEv)
{
if (ModelState.IsValid)
{
paramAppEv.status = 2;
//update data
paramAppEv.approveBy = 2;
paramAppEv.approveDate = DateTime.Now;
string latestCode = EventDataAccess.ApproveEv(paramAppEv);
if (latestCode != "")
{
return(Json(new { success = true, latestCode, message = EventDataAccess.Message }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { success = false, message = EventDataAccess.Message }, JsonRequestBehavior.AllowGet));
}
}
else
{
return(Json(new { success = false, message = "Wajib menginputkan semua kotak bertanda bintang" }, JsonRequestBehavior.AllowGet));
}
}
public Dictionary <int, Event> GetEventCustom(ref string errMessage, string str)
{
Database db = DatabaseFactory.CreateDatabase();
errMessage = "";
Dictionary <int, Event> list = new Dictionary <int, Event>();
try
{
DataSet ds = EventDataAccess.GetEventCustom(db, str);
Event et;
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
et = new Event(ds.Tables[0].Rows[i]);
et.CapturePicture = CapturePictureBusiness.Instance.GetCapturePicture(ref errMessage, et.PictureID);
et.CameraInfo = CameraBusiness.Instance.GetCameraInfoByCameraId(ref errMessage,
et.CapturePicture.CameraID);
et.VideoInfo = VideoBusiness.Instance.GetVideoInfoById(ref errMessage, et.VideoId);
list.Add(et.EventId, et);
}
return(list);
}
catch (Exception ex)
{
errMessage = ex.Message + ex.StackTrace;
logger.Error("Error Message:" + ex.Message + " Trace:" + ex.StackTrace);
return(null);
}
}
public ActionResult CreateDataEvent(EventViewModel paramAddEvent)
{
if (ModelState.IsValid)
{
//is delete default value
paramAddEvent.isDelete = false;
//status default value
paramAddEvent.status = 1;
//update data manual createby and createdate
paramAddEvent.createBy = "Anastasia";
paramAddEvent.createDate = DateTime.Now;
string latestCode = EventDataAccess.CreateEvent(paramAddEvent);
if (latestCode != "")
{
return(Json(new { success = true, latestCode, message = EventDataAccess.Message }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { success = false, message = EventDataAccess.Message }, JsonRequestBehavior.AllowGet));
}
}
else
{
return(Json(new { success = false, message = "Wajib menginputkan semua kotak bertanda bintang" }, JsonRequestBehavior.AllowGet));
}
}
//[Authorize]
public List <EventDetails> GetEventDetails()
{
DataTable eventDetails = new EventDataAccess().GetEventDetails();
List <EventDetails> eventDetailsList = EventDetailEntities(eventDetails);
return(eventDetailsList);
}
public ActionResult Index(EventViewModel paramSearch)
{
if (paramSearch.statusName != null)
{
paramSearch.statusName = paramSearch.statusName.Trim().ToLower();
}
List <EventViewModel> listSearchEvent = EventDataAccess.GetListEvent(paramSearch);
return(PartialView(listSearchEvent));
}
public void addComment(CommentModel commentModel)
{
EventDataAccess eventDataAccess = new EventDataAccess();
Comment comment = new Comment()
{
Comments = commentModel.Comments,
EventId = commentModel.EventId
};
eventDataAccess.addComment(comment);
}
public List <Event> GetEventListForSearch(string userName, string eventTitle)
{
int userId = eventDataAccess.GetUserId(userName);
Event eventz = new Event()
{
EventTitle = eventTitle,
Id = userId
};
eventDataAccess = new EventDataAccess();
return(eventDataAccess.GetEventsForSearch(userId, eventTitle));
}
public List <Event> GetEventListSearchByImpotance(string userName, string importance)
{
int userId = eventDataAccess.GetUserId(userName);
Event eventz = new Event()
{
Importance = importance,
Id = userId
};
eventDataAccess = new EventDataAccess();
return(eventDataAccess.GetEventsForSearchByImportance(userId, importance));
}
// ADD EVENT
public ActionResult AddEvent()
{
int empId = 1;
Session["requestByName"] = EventDataAccess.GetEmployeeName(empId);
if (Session["requestByName"] != null)
{
Session["requestBy"] = 1;
}
Session["requestDate"] = System.DateTime.Now.Date.ToString("dd/MM/yyyy");
return(PartialView());
}
public List <EventModel> eventsInvitedTo(string username)
{
EventDataAccess eventDataAcess = new EventDataAccess();
var myEventsList = eventDataAcess.myEvents(username).Select(eventDetails => new EventModel()
{
EventId = eventDetails.EventId,
Title = eventDetails.Title,
EventDate = eventDetails.EventDate
}).ToList();
return(myEventsList);
}
public List <EventModel> getAllPublicEvents()
{
EventDataAccess eventDataAcess = new EventDataAccess();
var allPublicEventsList = eventDataAcess.getAllPublicEvents().Select(eventDetails => new EventModel()
{
EventId = eventDetails.EventId,
Title = eventDetails.Title,
EventDate = eventDetails.EventDate,
}).ToList();
return(allPublicEventsList);
}
public int ModifyEventDetails(string eventTitle, string description, string modifyDate, string mood, string importance, string eveTitle)
{
DiaryEvent diaryEvent = new DiaryEvent()
{
EventTitle = eventTitle,
Description = description,
ModificationDate = modifyDate,
Mood = mood,
Importance = importance,
};
eventDataAccess = new EventDataAccess();
return(eventDataAccess.UpdateEvent(diaryEvent, eveTitle));
}
public int AddNewEvent(string eventTitle, string date, string eventDescription, string importance, string userName)
{
int userId = eventDataAccess.GetUserId(userName);
Event eventz = new Event()
{
EventTitle = eventTitle,
Date = date,
EventDescription = eventDescription,
Importance = importance,
Id = userId
};
eventDataAccess = new EventDataAccess();
return(eventDataAccess.InsertEvent(eventz));
}
public int CreateEvent(string eventTitle, string description, string creationDate, string mood, string importance)
{
DiaryEvent diaryEvent = new DiaryEvent()
{
EventTitle = eventTitle,
Description = description,
CreationDate = creationDate,
ModificationDate = creationDate,
Mood = mood,
Importance = importance,
UserId = MyGlobals.userId
};
eventDataAccess = new EventDataAccess();
return(eventDataAccess.CreateEvent(diaryEvent));
}
public int Insert(ref string errMessage, Event oEvent)
{
Database db = DatabaseFactory.CreateDatabase();
errMessage = "";
try
{
return(EventDataAccess.Insert(db, oEvent));
}
catch (Exception ex)
{
errMessage = ex.Message + ex.StackTrace;
logger.Error("Error Message:" + ex.Message + " Trace:" + ex.StackTrace);
return(-1);
}
}
public int GetEventQuantity(ref string errMessage, string str)
{
Database db = DatabaseFactory.CreateDatabase();
errMessage = "";
int ret = 0;
try
{
return(EventDataAccess.GetEventCustomQuantity(db, str));
}
catch (Exception ex)
{
errMessage = ex.Message + ex.StackTrace;
logger.Error("Error Message:" + ex.Message + " Trace:" + ex.StackTrace);
return(0);
}
}
//APPROVE EVENT
public ActionResult ApproveEvent(int paramId)
{
var stat = EventDataAccess.GetEventStatus(paramId);
if (stat == 1)
{
ViewBag.EmpName = new SelectList(EventDataAccess.GetAllEmpName(), "EmpId", "EmpFullName");
return(PartialView(EventDataAccess.GetDetailEventById(paramId)));
}
else if (stat == 2)
{
return(PartialView("CloseRequestEvent", EventDataAccess.GetDetailEventById(paramId)));
}
else
{
return(PartialView());
}
}
public ActionResult RejectDataEvent(EventViewModel paramRejectEv)
{
if (ModelState.IsValid)
{
paramRejectEv.status = 0;
string latestCode = EventDataAccess.RejectEv(paramRejectEv);
if (latestCode != "")
{
return(Json(new { success = true, latestCode, message = EventDataAccess.Message }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { success = false, message = EventDataAccess.Message }, JsonRequestBehavior.AllowGet));
}
}
else
{
return(Json(new { success = false, message = "Wajib menginputkan semua kotak bertanda bintang" }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult EditDataEvent(EventViewModel paramEditEv)
{
if (ModelState.IsValid)
{
//update data manual createby and createdate
paramEditEv.updateBy = "Tian";
paramEditEv.updateDate = DateTime.Now;
string latestCode = EventDataAccess.UpdateEvent(paramEditEv);
if (latestCode != "")
{
return(Json(new { success = true, latestCode, message = EventDataAccess.Message }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { success = false, message = EventDataAccess.Message }, JsonRequestBehavior.AllowGet));
}
}
else
{
return(Json(new { success = false, message = "Wajib menginputkan semua kotak bertanda bintang" }, JsonRequestBehavior.AllowGet));
}
}
public Event GetEvent(ref string errMessage, int cameraId, DateTime captureDataTime)
{
Database db = DatabaseFactory.CreateDatabase();
errMessage = "";
Event et = null;
try
{
DataSet ds = EventDataAccess.GetEventCustom(db, string.Format(" and CapturePicture.CameraId={0} and CapturePicture.DateTime='{1}'", cameraId, captureDataTime));
et = new Event(ds.Tables[0].Rows[0]);
et.CapturePicture = CapturePictureBusiness.Instance.GetCapturePicture(ref errMessage, et.PictureID);
et.CameraInfo = CameraBusiness.Instance.GetCameraInfoByCameraId(ref errMessage,
et.CapturePicture.CameraID);
et.VideoInfo = VideoBusiness.Instance.GetVideoInfoById(ref errMessage, et.VideoId);
return(et);
}
catch (Exception ex)
{
errMessage = ex.Message + ex.StackTrace;
logger.Error("Error Message:" + ex.Message + " Trace:" + ex.StackTrace);
return(null);
}
}
public EventsController()
{
dataTableProcesses = new DataTableProcesses();
dataaccess = new EventDataAccess();
}
public EventDataService()
{
this.eventDataAccess = new EventDataAccess();
}
//EDIT EVENT
public ActionResult EditEvent(int paramId)
{
return(PartialView(EventDataAccess.GetDetailEventById(paramId)));
}
//CLOSE EVENT
public ActionResult CloseRequestEvent(int paramId)
{
//var stat = EventDataAccess.GetEventStatus(paramId);
return(PartialView(EventDataAccess.GetDetailEventById(paramId)));
}
public string[] getRolesOfUser(string username)
{
EventDataAccess eventDataAccess = new EventDataAccess();
return(eventDataAccess.getRolesFromTable(username));
}
/// <summary>
/// A constructor for the search service.
/// </summary>
/// <param name="bracketDAO"> A bracket data access object </param>
/// <param name="eventDAO"> An event data access object </param>
/// <param name="gamerDAO"> A gamer data access object </param>
public SearchService(TournamentBracketDatabaseQuery bracketDAO, EventDataAccess eventDAO, GamerDataAccess gamerDAO)
{
_bracketDAO = bracketDAO;
_eventDAO = eventDAO;
_gamerDAO = gamerDAO;
}
public EventService()
{
eventDataAccess = new EventDataAccess();
}
