public int closeEvent(int eventId)
{
EventDAO dao = new EventDAO();
int result = dao.closeEvent(eventId);
return(result);
}
public int AddEvent()
{
EventDAO dao = new EventDAO();
int result = dao.Insert(this);
return(result);
}
public int GroupJoinEvent(int eventid, int groupid)
{
EventDAO dao = new EventDAO();
int result = dao.GroupJoinEvent(eventid, groupid);
return(result);
}
protected void BtnConfirm_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(TbEventName.Text) || string.IsNullOrEmpty(TbEyearTaken.Text) || string.IsNullOrEmpty(TbSEMTaken.Text))
{
LblResult.Text = "pls fill in all the blank";
}
else
{
//String Status = "active";
String AdminNo = lbAdminNo.Text.ToString();
String EventName = TbEventName.Text.ToString();
String EyearTaken = TbEyearTaken.Text.ToString();
String EsemTaken = TbSEMTaken.Text.ToString();
EventDAO fmTd = new EventDAO();
int insCnt = fmTd.InsertTD(EventName, EyearTaken, EsemTaken, AdminNo);
if (insCnt == 1)
{
LblResult.Text = "Event Added!";
Response.Redirect("EventPage.aspx");
}
else
{
LblResult.Text = "Unable to insert Event, please inform system administrator!";
}
BtnConfirm.Enabled = false;
}
}
private void button1_Click(object sender, EventArgs e)
{
if (MetroMessageBox.Show(this, "Are you sure you want to update this register?", "Update", MessageBoxButtons.YesNo, MessageBoxIcon.Stop, MessageBoxDefaultButton.Button2) == DialogResult.Yes)
{
// Tratamento das Datas
EntitiesContext context = new EntitiesContext();
EventDAO edao = new EventDAO();
aBeg = DateTime.Parse(mdtDateBegin.Text);
bBeg = aBeg.ToString("dd/MM/yyyy");
cBeg = bBeg + " " + txtTimeBegin.Text;
aEnd = DateTime.Parse(mdtDateEnd.Text);
bEnd = aEnd.ToString("dd/MM/yyyy");
cEnd = bEnd + " " + txtTimeEnd.Text;
//Tratamento da Combo Box Artista
ArtistDAO adao = new ArtistDAO();
idart = adao.FindIdByCb(mcbArtEvent.Text);
//Tratamento da Combo Box Menu
MenuDAO mdao = new MenuDAO();
idmenu = mdao.FindIdByCb(mcbMenuEvent.Text);
Event eve = edao.FindId(global.ideve);
eve.Name = txtNameEvent.Text;
eve.Desc = txtDescEvent.Text;
eve.TimeBegin = DateTime.Parse(cBeg);
eve.TimeEnd = DateTime.Parse(cEnd);
eve.ArtistId = idart;
eve.MenuId = idmenu;
edao.Update();
MetroMessageBox.Show(this, "Register Successfully Updated", "Updated", MessageBoxButtons.OK, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2);
}
}
private void mt3_Click(object sender, EventArgs e)
{
lblTitle.Text = Strings.Event_Edit;
ucAddEvent1.Visible = false;
ucQueryEvent1.Visible = false;
ucEditEvent1.Visible = true;
ucEditEvent21.Visible = false;
EventDAO edao = new EventDAO();
var bindingList = new BindingList <Event>(edao.List());
var source = new BindingSource(bindingList, null);
ucEditEvent1.dgvEvents.DataSource = source;
ucEditEvent1.dgvEvents.Columns.Remove("Artist");
ucEditEvent1.dgvEvents.Columns.Remove("Menu");
ucEditEvent1.dgvEvents.Columns.Remove("Tickets");
ucEditEvent1.dgvEvents.Columns[0].HeaderText = "Event ID";
ucEditEvent1.dgvEvents.Columns[1].HeaderText = "Name";
ucEditEvent1.dgvEvents.Columns[2].HeaderText = "Description";
ucEditEvent1.dgvEvents.Columns[3].HeaderText = "Begin";
ucEditEvent1.dgvEvents.Columns[4].HeaderText = "End";
ucEditEvent1.dgvEvents.Columns[5].HeaderText = "Artist ID";
ucEditEvent1.dgvEvents.Columns[6].HeaderText = "Menu ID";
}
public int UpdateEvent()
{
EventDAO dao = new EventDAO();
int result = dao.Update(this);
return(result);
}
public static int addEvent(ImproperCalendarEvent improperEvent)
{
CalendarEvent cevent = new CalendarEvent()
{
title = improperEvent.title,
description = improperEvent.description,
purpose = improperEvent.purpose,
start = DateTime.ParseExact(improperEvent.start, "dd-MM-yyyy hh:mm:ss tt", CultureInfo.InvariantCulture),
end = DateTime.ParseExact(improperEvent.end, "dd-MM-yyyy hh:mm:ss tt", CultureInfo.InvariantCulture),
contactNumber = improperEvent.contactNumber,
CPAID = int.Parse(System.Web.HttpContext.Current.Session["userID"].ToString()),
interval = 30
};
if (CheckAlphaNumeric(cevent.title) && CheckAlphaNumeric(cevent.description))
{
int key = EventDAO.addEvent(cevent);
List <int> idList = (List <int>)System.Web.HttpContext.Current.Session["idList"];
if (idList != null)
{
idList.Add(key);
}
return(key);//return the primary key of the added cevent object
}
return(-1);//return a negative number just to signify nothing has been added
}
public ActionResult Submit(string event_id)
{
EventDAO eDao = new EventDAO();
EVENT ev = eDao.GetEventByID(event_id);
return(View(ev));
}
public int UserLeaveEvent(int eventid, int userid)
{
EventDAO dao = new EventDAO();
int result = dao.UserLeaveEvent(eventid, userid);
return(result);
}
public static int addEvent(ImproperCalendarEvent improperEvent)
{
CalendarEvent cevent = new CalendarEvent()
{
title = improperEvent.title,
description = improperEvent.description,
start = Convert.ToDateTime(improperEvent.start),
end = Convert.ToDateTime(improperEvent.end),
allDay = improperEvent.allDay
};
if (CheckAlphaNumeric(cevent.title) && CheckAlphaNumeric(cevent.description))
{
int key = EventDAO.addEvent(cevent);
List <int> idList = (List <int>)System.Web.HttpContext.Current.Session["idList"];
if (idList != null)
{
idList.Add(key);
}
return(key); //return the primary key of the added cevent object
}
return(-1); //return a negative number just to signify nothing has been added
}
public static int addEvent(ImproperCalendarEvent improperEvent)
{
CalendarEvent cevent = new CalendarEvent()
{
title = improperEvent.title,
description = improperEvent.description,
start = DateTime.ParseExact(improperEvent.start, "dd-MM-yyyy hh:mm:ss tt", CultureInfo.InvariantCulture),
end = DateTime.ParseExact(improperEvent.end, "dd-MM-yyyy hh:mm:ss tt", CultureInfo.InvariantCulture),
intschool = HttpContext.Current.Session["SchoolID"].ToString(),
backgroundcolor = improperEvent.backgroundcolor,
textcolor = improperEvent.textcolor,
patrontype = HttpContext.Current.Session["Patrontype"].ToString(),
userid = improperEvent.userid
};
if (CheckAlphaNumeric(cevent.title) && CheckAlphaNumeric(cevent.description))
{
int key = EventDAO.addEvent(cevent);
List <int> idList = (List <int>)System.Web.HttpContext.Current.Session["idList"];
if (idList != null)
{
idList.Add(key);
}
return(key); //return the primary key of the added cevent object
}
return(-1); //return a negative number just to signify nothing has been added
}
protected void gv_Students_RowCommand(object sender, GridViewCommandEventArgs e)
{
Event selTD = new Event();
EventDAO tdDAO = new EventDAO();
int updCnt;
String Status = "delete";
int EventID = Convert.ToInt32(e.CommandArgument.ToString());
if (e.CommandName == "Delete")
{
updCnt = tdDAO.delete(EventID, Status);
if (updCnt == 1)
{
Response.Redirect("EventPage.aspx");
}
}
else if (e.CommandName == "Edit")
{
Session["SSEventID"] = Convert.ToInt32(e.CommandArgument.ToString());
Response.Redirect("EditEvent.aspx");
}
}
public static int addEvent(ImproperCalendarEvent improperEvent)
{
string dt = Convert.ToDateTime(improperEvent.start).ToString("yyyy-MM-dd hh:mm:ss");
string dt1 = Convert.ToDateTime(improperEvent.end).ToString("yyyy-MM-dd hh:mm:ss");
CalendarEvent cevent = new CalendarEvent()
{
title = improperEvent.title,
description = improperEvent.description,
start = DateTime.ParseExact(dt, "yyyy-MM-dd hh:mm:ss", CultureInfo.InvariantCulture),
end = DateTime.ParseExact(dt1, "yyyy-MM-dd hh:mm:ss", CultureInfo.InvariantCulture)
};
if (CheckAlphaNumeric(cevent.title) && CheckAlphaNumeric(cevent.description))
{
int key = EventDAO.addEvent(cevent);
List <int> idList = (List <int>)System.Web.HttpContext.Current.Session["idList"];
if (idList != null)
{
idList.Add(key);
}
return(key);//return the primary key of the added cevent object
}
return(-1);//return a negative number just to signify nothing has been added
}
private void btnFilter_Click(object sender, EventArgs e)
{
if (mcbFilterBy.SelectedIndex == 0)
{
idevent = int.Parse(txtFilter.Text);
nameevent = null;
}
if (mcbFilterBy.SelectedIndex == 1)
{
nameevent = txtFilter.Text;
idevent = 0;
}
EventDAO edao = new EventDAO();
var bindingList = new BindingList <Event>(edao.Filter(idevent, nameevent));
var source = new BindingSource(bindingList, null);
dgvEvents.DataSource = source;
dgvEvents.Columns.Remove("Artist");
dgvEvents.Columns.Remove("Menu");
dgvEvents.Columns.Remove("Tickets");
dgvEvents.Columns[0].HeaderText = "Event ID";
dgvEvents.Columns[1].HeaderText = "Name";
dgvEvents.Columns[2].HeaderText = "Description";
dgvEvents.Columns[3].HeaderText = "Begin";
dgvEvents.Columns[4].HeaderText = "End";
dgvEvents.Columns[5].HeaderText = "Artist ID";
dgvEvents.Columns[6].HeaderText = "Menu ID";
}
public bool AddEvent(EventDAO _eventCreate)
{
bool success = false;
try
{
using (SqlConnection _connection = new SqlConnection(connectionstring))
{
using (SqlCommand _command = new SqlCommand("sp_CreateEvent", _connection))
{
_command.CommandType = CommandType.StoredProcedure;
_command.Parameters.AddWithValue("@Event", _eventCreate.Event);
_command.Parameters.AddWithValue("@EventDesc", _eventCreate.EventDesc);
_command.Parameters.AddWithValue("@EventDate", _eventCreate.EventDate);
_command.Parameters.AddWithValue("@AddedBy", _eventCreate.AddedBy);
_connection.Open();
_command.ExecuteNonQuery();
success = true;
_connection.Close();
}
}
}
catch (Exception error)
{
Errorlog Problem = new Errorlog();
Problem.LogError(error);
}
return(success);
}
private void btnRegister_Click(object sender, EventArgs e)
{
if (MetroMessageBox.Show(this, Strings.ConfRegister, Strings.Register, MessageBoxButtons.YesNo, MessageBoxIcon.Stop, MessageBoxDefaultButton.Button2) == DialogResult.Yes)
{
// Tratamento das Datas
EntitiesContext context = new EntitiesContext();
EventDAO edao = new EventDAO();
aBeg = DateTime.Parse(mdtDateBegin.Text);
bBeg = aBeg.ToString("dd/MM/yyyy");
cBeg = bBeg + " " + txtTimeBegin.Text;
aEnd = DateTime.Parse(mdtDateEnd.Text);
bEnd = aEnd.ToString("dd/MM/yyyy");
cEnd = bEnd + " " + txtTimeEnd.Text;
//Tratamento da Combo Box Artista
ArtistDAO adao = new ArtistDAO();
idart = adao.FindIdByCb(mcbArtEvent.Text);
//Tratamento da Combo Box Menu
MenuDAO mdao = new MenuDAO();
idmenu = mdao.FindIdByCb(mcbMenuEvent.Text);
Event even = new Event()
{
Name = txtNameEvent.Text,
Desc = txtDescEvent.Text,
TimeBegin = DateTime.Parse(cBeg),
TimeEnd = DateTime.Parse(cEnd),
ArtistId = idart,
MenuId = idmenu
};
edao.Add(even);
MetroMessageBox.Show(this, Strings.SuccessRegistered, Strings.Registered, MessageBoxButtons.OK, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2);
}
}
// GET: Teacher/Assessment
public ActionResult Index(string id)
{
List <EVENT> listEvent = new List <EVENT>();
EventDAO eventDao = new EventDAO();
listEvent = eventDao.GetEventsOfCourse(id);
return(View(listEvent));
}
public static void Save(Event dialog)
{
var dao = new EventDAO();
if (dialog.Id == 0)
dialog.Id = dao.Insert(dialog);
else
dao.Update(dialog);
}
public DatabaseOutput(string fileName)
{
LinqToDB.Data.DataConnection.DefaultSettings = new DatabaseSettingsSQLITE(fileName);
eventDAO = new EventDAO();
// Common.logger.Info(Util.ObjToJson(eventDAO.GetAll()));
}
public AppController()
{
_client = new MongoClient("mongodb://*****:*****@ds044229.mlab.com:44229/gatewayz");
_database = _client.GetDatabase(("gatewayz"));
_userDAO = new UserDAO();
_eventDAO = new EventDAO();
_signup = new SignUp();
}
public ActionResult EventDetails(int id)
{
EventDAO eventDAO = new EventDAO();
EventM events = eventDAO.FetchOne(id);
TempData.Keep();
return(View("EventDetails", events));
}
public ActionResult EventTab()
{
int x = (int)TempData["ID"];
EventDAO eventDAO = new EventDAO();
EventM events = eventDAO.listEvent(x);
TempData.Keep();
return(View("EventTab", events));
}
private void btnDelete_Click(object sender, EventArgs e)
{
if (MetroMessageBox.Show(this, "Are you sure you want to delete this register?", "Delete", MessageBoxButtons.YesNo, MessageBoxIcon.Stop, MessageBoxDefaultButton.Button2) == DialogResult.Yes)
{
EventDAO edao = new EventDAO();
Event eve = edao.FindId(global.ideve);
edao.Remove(eve);
MetroMessageBox.Show(this, "Register Successfully Deleted", "Deleted", MessageBoxButtons.OK, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2);
}
}
public ActionResult UpdateEvent(EVENT ev)
{
EventDAO eventDao = new EventDAO();
if (eventDao.UpdateEvent(ev))
{
return(Json(new { success = true }));
}
return(Json(new { success = false }));
}
public JsonResult DeleteEvent(string id)
{
EventDAO eventDao = new EventDAO();
if (eventDao.DeleteEvent(id))
{
return(Json(new { success = true }));
}
return(Json(new { success = false }));
}
private void InitializeDataAccessObjects()
{
_userDAO = new UserDAO();
_noticeDAO = new NoticeDAO();
_eventDAO = new EventDAO();
_userDAO.AInitialize();
_noticeDAO.AInitialize();
_eventDAO.AInitialize();
}
protected void Page_Load(object sender, EventArgs e)
{
LblAdminNo.Text = Session["AdminNo"].ToString();
String adminNo = LblAdminNo.Text.ToString();
EventDAO tdDAO = new EventDAO();
List <Event> tdList = new List <Event>();
tdList = tdDAO.getCurrentEvent(LblAdminNo.Text);
GridView_Event.DataSource = tdList;
GridView_Event.DataBind();
LblAdminNo.Visible = false;
}
/// <summary>
/// Logguje wszystkie zdarzenia zgłoszone przez czujniki w bazie danych.
/// </summary>
/// <param name="sensorEvent"></param>
public void Log(Event sensorEvent)
{
if (sensorEvent == null)
{
throw new ArgumentNullException("sensorEvent");
}
// mapowanie do TO i zapisanie w bazie danych
var mappedTo = Event2EventTO.Map(sensorEvent);
EventDAO.GetInstance().Insert(mappedTo);
}
public ActionResult EventList()
{
List <EventM> events = new List <EventM>();
//ngo.Add(new NGOAcc(111, "asda", "adas", "dasdsa", "dasdasd", "dasdasd", "dasdsa", "dqawewq", "dqawedwq", "1/1/2001", "dqwewq"));
EventDAO eventDAO = new EventDAO();
events = eventDAO.FetchAll();
TempData.Keep();
return(View("EventList", events));
}
public EventDAO Map(Events _eventtomap)
{
EventDAO _eventtoview = new EventDAO();
_eventtoview.EventID = _eventtomap.EventID;
_eventtoview.Event = _eventtomap.Event;
_eventtoview.EventDesc = _eventtomap.EventDesc;
_eventtoview.EventDate = _eventtomap.EventDate;
_eventtoview.AddedBy = _eventtomap.AddedBy;
_eventtoview.Username = _eventtomap.Username;
return(_eventtoview);
}
public static List<Event> LoadAll()
{
var dao = new EventDAO();
return dao.SelectAll();
}
public static Event Load(int p)
{
var dao = new EventDAO();
return dao.Select(p);
}
