public List <EventsStatus> SelectAllByName()
{
//Step 1 - Define a connection to the database
string DBConnect = ConfigurationManager.ConnectionStrings["ConnStr"].ConnectionString;
SqlConnection myConn = new SqlConnection(DBConnect);
//Step 2 - Create a DataAdapter to retrieve data from db table
string sqlStmt = "Select * from tdEvent Order By eventDate DESC, eventStartTime";
SqlDataAdapter da = new SqlDataAdapter(sqlStmt, myConn);
//Step 3 - Create a DataSet to store the data to be retrieved
DataSet ds = new DataSet();
//Step 4 - Use the DataAdapter to fill the DataSet with data retrieved
da.Fill(ds);
//Step 5 - Read data from DataSet to List
List <EventsStatus> evStList = new List <EventsStatus>();
List <EventsStatus> tempList = new List <EventsStatus>();
var dateList = new List <string>();
int rec_cnt = ds.Tables[0].Rows.Count;
for (int i = 0; i < rec_cnt; i++)
{
DataRow row = ds.Tables[0].Rows[i]; // Sql command returns only one record
string eventTitle = row["eventTitle"].ToString();
string eventId = row["eventId"].ToString();
string eventVenue = row["eventVenue"].ToString();
string eventDate = row["eventDate"].ToString();
string eventStartTime = row["eventStartTime"].ToString();
string eventEndTime = row["eventEndTime"].ToString();
string eventDesc = row["eventDesc"].ToString();
string eventPic = row["eventPic"].ToString();
string eventOrganiser = row["user_id"].ToString();
string eventCompletion = "Incomplete";
string eventOrganiserPic = "";
int eventNum = 0;
EventsStatus obj = new EventsStatus(eventTitle, eventId, eventVenue, eventDate
, eventStartTime, eventEndTime, eventDesc, eventPic, eventOrganiser
, eventCompletion, eventOrganiserPic, eventNum);
evStList.Add(obj);
}
;
System.Diagnostics.Debug.WriteLine("This is evStList: " + string.Join(Environment.NewLine, evStList));
return(evStList);
}
protected void Page_Load(object sender, EventArgs e)
{
viewingUserId = Request.QueryString["userId"];
EventsStatus evSt = new EventsStatus();
Users usr = new Users();
if (Session["user"] == null)
{
Response.Redirect("homepage.aspx");
}
else
{
if (radioButtonList.SelectedIndex == 0)
{
msg.Visible = false;
if (viewingUserId != null)
{
// This is a counter
evStListEventCounter = evSt.GetAllEventsByName();
counterId = evSt.GetAllEventsParticipate(int.Parse(viewingUserId));
evStListParticipateCounter = evSt.GetAllEventsEventId(counterId);
foreach (var element in evStListParticipateCounter)
{
participated += 1;
}
foreach (var element in evStListEventCounter)
{
if (element.Organiser == viewingUserId)
{
eventCount += 1;
}
}
if (eventCount == 0)
{
msg.Visible = true;
}
evStListTemp = evSt.GetAllEventsByName();
Users viewingUser = new Users();
usr = viewingUser.GetUserById(int.Parse(viewingUserId));
for (int i = 0; i < evStListTemp.Count; i++)
{
if (evStListTemp[i].Organiser == viewingUserId)
{
evStListTemp[i].OrganiserPic = usr.DPimage;
evStListTemp[i].OrganiserName = usr.name;
evStListTemp[i].Attendee = 0;
evStList.Add(evStListTemp[i]);
}
}
foreach (EventsStatus element in evStList)
{
element.NumCompleted = eventCount;
int index = element.Date.IndexOf(" ");
element.Date = element.Date.Substring(0, index);
element.StartTime = element.StartTime.Substring(0, 5);
if (int.Parse(element.StartTime.Substring(0, 2)) >= 12)
{
if (int.Parse(element.StartTime.Substring(0, 2)) == 12)
{
element.StartTime = (int.Parse(element.StartTime.Substring(0, 2))).ToString() + ":" + element.StartTime.Substring(3, 2) + " PM";
}
else
{
element.StartTime = (int.Parse(element.StartTime.Substring(0, 2)) - 12).ToString() + ":" + element.StartTime.Substring(3, 2) + " PM";
}
}
else
{
element.StartTime = element.StartTime + " AM";
}
if (int.Parse(element.EndTime.Substring(0, 2)) >= 12)
{
if (int.Parse(element.EndTime.Substring(0, 2)) == 12)
{
element.EndTime = (int.Parse(element.EndTime.Substring(0, 2))).ToString() + ":" + element.EndTime.Substring(3, 2) + " PM";
}
else
{
element.EndTime = (int.Parse(element.EndTime.Substring(0, 2)) - 12).ToString() + ":" + element.EndTime.Substring(3, 2) + " PM";
}
}
else
{
element.EndTime = element.EndTime + " AM";
}
string date = element.Date + " " + element.EndTime;
DateTime dt1 = DateTime.Parse(date);
DateTime dt2 = DateTime.Now;
int result = DateTime.Compare(dt1, dt2);
if (result < 0 || result == 0)
{
element.Completed = "Complete";
}
forCount += 1;
}
}
else
{
// This is a counter
evStListEventCounter = evSt.GetAllEventsByName();
counterId = evSt.GetAllEventsParticipate(int.Parse(Session["id"].ToString()));
evStListParticipateCounter = evSt.GetAllEventsEventId(counterId);
foreach (var element in evStListParticipateCounter)
{
participated += 1;
}
foreach (var element in evStListEventCounter)
{
if (element.Organiser == Session["id"].ToString())
{
eventCount += 1;
}
}
if (eventCount == 0)
{
msg.Visible = true;
}
Users viewingUser = new Users();
usr = viewingUser.GetUserById(int.Parse(Session["id"].ToString()));
evStListTemp = evSt.GetAllEventsByName();
for (int i = 0; i < evStListTemp.Count; i++)
{
if (evStListTemp[i].Organiser == usr.id.ToString())
{
evStListTemp[i].OrganiserPic = usr.DPimage;
evStListTemp[i].OrganiserName = usr.name;
evStList.Add(evStListTemp[i]);
}
}
foreach (EventsStatus element in evStList)
{
element.NumCompleted = eventCount;
int index = element.Date.IndexOf(" ");
element.Date = element.Date.Substring(0, index);
element.StartTime = element.StartTime.Substring(0, 5);
if (int.Parse(element.StartTime.Substring(0, 2)) >= 12)
{
if (int.Parse(element.StartTime.Substring(0, 2)) == 12)
{
element.StartTime = (int.Parse(element.StartTime.Substring(0, 2))).ToString() + ":" + element.StartTime.Substring(3, 2) + " PM";
}
else
{
element.StartTime = (int.Parse(element.StartTime.Substring(0, 2)) - 12).ToString() + ":" + element.StartTime.Substring(3, 2) + " PM";
}
}
else
{
element.StartTime = element.StartTime + " AM";
}
if (int.Parse(element.EndTime.Substring(0, 2)) >= 12)
{
if (int.Parse(element.EndTime.Substring(0, 2)) == 12)
{
element.EndTime = (int.Parse(element.EndTime.Substring(0, 2))).ToString() + ":" + element.EndTime.Substring(3, 2) + " PM";
}
else
{
element.EndTime = (int.Parse(element.EndTime.Substring(0, 2)) - 12).ToString() + ":" + element.EndTime.Substring(3, 2) + " PM";
}
}
else
{
element.EndTime = element.EndTime + " AM";
}
string date = element.Date + " " + element.EndTime;
DateTime dt1 = DateTime.Parse(date);
DateTime dt2 = DateTime.Now;
int result = DateTime.Compare(dt1, dt2);
if (result < 0 || result == 0)
{
element.Completed = "Complete";
}
forCount += 1;
}
}
}
if (radioButtonList.SelectedIndex == 1)
{
msg.Visible = false;
if (viewingUserId != null)
{
Users viewingUser = new Users();
eventIds = evSt.GetAllEventsParticipate(int.Parse(viewingUserId));
evStListTemp = evSt.GetAllEventsEventId(eventIds);
//this is a counter
evStListEventCounter = evSt.GetAllEventsByName();
counterId = evSt.GetAllEventsParticipate(int.Parse(viewingUserId));
evStListParticipateCounter = evSt.GetAllEventsEventId(counterId);
foreach (var element in evStListParticipateCounter)
{
participated += 1;
}
if (participated == 0)
{
msg.Visible = true;
}
foreach (var element in evStListEventCounter)
{
if (element.Organiser == viewingUserId)
{
eventCount += 1;
}
}
for (int i = 0; i < evStListTemp.Count; i++)
{
usr = viewingUser.GetUserById(int.Parse(evStListTemp[i].Organiser));
evStListTemp[i].Organiser = usr.id.ToString();
evStListTemp[i].OrganiserPic = usr.DPimage;
evStListTemp[i].OrganiserName = usr.name;
evStList.Add(evStListTemp[i]);
}
foreach (EventsStatus element in evStList)
{
element.NumCompleted = eventCount;
int index = element.Date.IndexOf(" ");
element.Date = element.Date.Substring(0, index);
element.StartTime = element.StartTime.Substring(0, 5);
if (int.Parse(element.StartTime.Substring(0, 2)) >= 12)
{
if (int.Parse(element.StartTime.Substring(0, 2)) == 12)
{
element.StartTime = (int.Parse(element.StartTime.Substring(0, 2))).ToString() + ":" + element.StartTime.Substring(3, 2) + " PM";
}
else
{
element.StartTime = (int.Parse(element.StartTime.Substring(0, 2)) - 12).ToString() + ":" + element.StartTime.Substring(3, 2) + " PM";
}
}
else
{
element.StartTime = element.StartTime + " AM";
}
if (int.Parse(element.EndTime.Substring(0, 2)) >= 12)
{
if (int.Parse(element.EndTime.Substring(0, 2)) == 12)
{
element.EndTime = (int.Parse(element.EndTime.Substring(0, 2))).ToString() + ":" + element.EndTime.Substring(3, 2) + " PM";
}
else
{
element.EndTime = (int.Parse(element.EndTime.Substring(0, 2)) - 12).ToString() + ":" + element.EndTime.Substring(3, 2) + " PM";
}
}
else
{
element.EndTime = element.EndTime + " AM";
}
string date = element.Date + " " + element.EndTime;
DateTime dt1 = DateTime.Parse(date);
DateTime dt2 = DateTime.Now;
int result = DateTime.Compare(dt1, dt2);
if (result < 0 || result == 0)
{
element.Completed = "Complete";
}
forCount += 1;
}
}
else
{
Users viewingUser = new Users();
eventIds = evSt.GetAllEventsParticipate(int.Parse(Session["id"].ToString()));
evStListTemp = evSt.GetAllEventsEventId(eventIds);
// This is a counter
evStListEventCounter = evSt.GetAllEventsByName();
counterId = evSt.GetAllEventsParticipate(int.Parse(Session["id"].ToString()));
evStListParticipateCounter = evSt.GetAllEventsEventId(counterId);
foreach (var element in evStListParticipateCounter)
{
participated += 1;
}
if (participated == 0)
{
msg.Visible = true;
}
foreach (var element in evStListEventCounter)
{
if (element.Organiser == Session["id"].ToString())
{
eventCount += 1;
}
}
for (int i = 0; i < evStListTemp.Count; i++)
{
usr = viewingUser.GetUserById(int.Parse(evStListTemp[i].Organiser));
evStListTemp[i].Organiser = usr.id.ToString();
evStListTemp[i].OrganiserPic = usr.DPimage;
evStListTemp[i].OrganiserName = usr.name;
evStList.Add(evStListTemp[i]);
}
foreach (EventsStatus element in evStList)
{
element.NumCompleted = eventCount;
int index = element.Date.IndexOf(" ");
element.Date = element.Date.Substring(0, index);
element.StartTime = element.StartTime.Substring(0, 5);
if (int.Parse(element.StartTime.Substring(0, 2)) >= 12)
{
if (int.Parse(element.StartTime.Substring(0, 2)) == 12)
{
element.StartTime = (int.Parse(element.StartTime.Substring(0, 2))).ToString() + ":" + element.StartTime.Substring(3, 2) + " PM";
}
else
{
element.StartTime = (int.Parse(element.StartTime.Substring(0, 2)) - 12).ToString() + ":" + element.StartTime.Substring(3, 2) + " PM";
}
}
else
{
element.StartTime = element.StartTime + " AM";
}
if (int.Parse(element.EndTime.Substring(0, 2)) >= 12)
{
if (int.Parse(element.EndTime.Substring(0, 2)) == 12)
{
element.EndTime = (int.Parse(element.EndTime.Substring(0, 2))).ToString() + ":" + element.EndTime.Substring(3, 2) + " PM";
}
else
{
element.EndTime = (int.Parse(element.EndTime.Substring(0, 2)) - 12).ToString() + ":" + element.EndTime.Substring(3, 2) + " PM";
}
}
else
{
element.EndTime = element.EndTime + " AM";
}
string date = element.Date + " " + element.EndTime;
DateTime dt1 = DateTime.Parse(date);
DateTime dt2 = DateTime.Now;
int result = DateTime.Compare(dt1, dt2);
if (result < 0 || result == 0)
{
element.Completed = "Complete";
}
forCount += 1;
}
}
}
total = eventCount + participated;
}
}
public List <Notifications> SelectAllEventsEnd()
{
List <Notifications> notiList = new List <Notifications>();
// Get date and time to see which event has ended already
EventsStatus evSt = new EventsStatus();
evStList = evSt.GetAllEventsByName();
foreach (EventsStatus element in evStList)
{
int index = element.Date.IndexOf(" ");
element.Date = element.Date.Substring(0, index);
element.StartTime = element.StartTime.Substring(0, 5);
if (int.Parse(element.StartTime.Substring(0, 2)) >= 12)
{
if (int.Parse(element.StartTime.Substring(0, 2)) == 12)
{
element.StartTime = (int.Parse(element.StartTime.Substring(0, 2))).ToString() + ":" + element.StartTime.Substring(3, 2) + " PM";
}
else
{
element.StartTime = (int.Parse(element.StartTime.Substring(0, 2)) - 12).ToString() + ":" + element.StartTime.Substring(3, 2) + " PM";
}
}
else
{
element.StartTime = element.StartTime + " AM";
}
if (int.Parse(element.EndTime.Substring(0, 2)) >= 12)
{
if (int.Parse(element.EndTime.Substring(0, 2)) == 12)
{
element.EndTime = (int.Parse(element.EndTime.Substring(0, 2))).ToString() + ":" + element.EndTime.Substring(3, 2) + " PM";
}
else
{
element.EndTime = (int.Parse(element.EndTime.Substring(0, 2)) - 12).ToString() + ":" + element.EndTime.Substring(3, 2) + " PM";
}
}
else
{
element.EndTime = element.EndTime + " AM";
}
string date = element.Date + " " + element.EndTime;
DateTime dt1 = DateTime.Parse(date);
DateTime dt2 = DateTime.Now;
int result = DateTime.Compare(dt1, dt2);
if (result <= 0)
{
eventIds.Add(int.Parse(element.Id));
}
}
string combinedInt = "";
for (int i = 0; i < eventIds.Count; i++)
{
combinedInt = string.Join(",", eventIds);
}
System.Diagnostics.Debug.WriteLine("This is eventid: " + combinedInt);
//Step 1 - Define a connection to the database by getting
// the connection string from web.config
string DBConnect = ConfigurationManager.ConnectionStrings["ConnStr"].ConnectionString;
SqlConnection myConn = new SqlConnection(DBConnect);
//Step 2 - Create a DataAdapter to retrieve data from the database table
string sqlStmt = "Select * from Attendance Where ','+@eventId+',' like '%,'+cast(Event_Id as varchar(50))+',%' and Attend = 1 and Feedback = 0";
SqlDataAdapter da = new SqlDataAdapter(sqlStmt, myConn);
da.SelectCommand.Parameters.AddWithValue("@eventId", combinedInt);
//Step 3 - Create a DataSet to store the data to be retrieved
DataSet ds = new DataSet();
//Step 4 - Use the DataAdapter to fill the DataSet with data retrieved
da.Fill(ds);
//Step 5 - Read data from DataSet to List
int rec_cnt = ds.Tables[0].Rows.Count;
List <Events> evList = new List <Events>();
Events ev = new Events();
for (int i = 0; i < rec_cnt; i++)
{
DataRow row = ds.Tables[0].Rows[i]; // Sql command returns only one record
int eventId = int.Parse(row["Event_Id"].ToString());
int userId = int.Parse(row["Users_Id"].ToString());
int attend = int.Parse(row["Attend"].ToString());
int feedback = int.Parse(row["Feedback"].ToString());
evList.Add(ev.getEventDetails(eventId));
string eventName = evList[i].Title;
Notifications obj = new Notifications(eventId, eventName, userId, attend, feedback);
notiList.Add(obj);
}
for (int i = 0; i < notiList.Count; i++)
{
System.Diagnostics.Debug.WriteLine("This is user_id: " + notiList[i].User_id);
System.Diagnostics.Debug.WriteLine("This is event Name: " + notiList[i].EventName);
System.Diagnostics.Debug.WriteLine("This is event id: " + notiList[i].EventId);
}
return(notiList);
}
public List <EventsStatus> SelectAllByEventId(List <int> ids)
{
//Step 1 - Define a connection to the database
string DBConnect = ConfigurationManager.ConnectionStrings["ConnStr"].ConnectionString;
SqlConnection myConn = new SqlConnection(DBConnect);
string combinedInt = "";
for (int i = 0; i < ids.Count; i++)
{
combinedInt = string.Join(",", ids);
}
//Step 2 - Create a DataAdapter to retrieve data from db table
string sqlStmt = "Select * from tdEvent Where ','+@eventId+',' like '%,'+cast(eventId as varchar(50))+',%' Order By eventDate DESC, eventStartTime";
SqlDataAdapter da = new SqlDataAdapter(sqlStmt, myConn);
da.SelectCommand.Parameters.AddWithValue("@eventId", combinedInt);
//Step 3 - Create a DataSet to store the data to be retrieved
DataSet ds = new DataSet();
//Step 4 - Use the DataAdapter to fill the DataSet with data retrieved
da.Fill(ds);
//Step 5 - Read data from DataSet to List
List <EventsStatus> evStList = new List <EventsStatus>();
List <EventsStatus> tempList = new List <EventsStatus>();
var dateList = new List <string>();
int rec_cnt = ds.Tables[0].Rows.Count;
for (int i = 0; i < rec_cnt; i++)
{
DataRow row = ds.Tables[0].Rows[i]; // Sql command returns only one record
string eventTitle = row["eventTitle"].ToString();
string eventId = row["eventId"].ToString();
string eventVenue = row["eventVenue"].ToString();
string eventDate = row["eventDate"].ToString();
string eventStartTime = row["eventStartTime"].ToString();
string eventEndTime = row["eventEndTime"].ToString();
string eventDesc = row["eventDesc"].ToString();
string eventPic = row["eventPic"].ToString();
string eventOrganiser = row["user_id"].ToString();
string eventCompletion = "Incomplete";
string eventOrganiserPic = "";
int eventNum = 0;
EventsStatus obj = new EventsStatus(eventTitle, eventId, eventVenue, eventDate
, eventStartTime, eventEndTime, eventDesc, eventPic, eventOrganiser
, eventCompletion, eventOrganiserPic, eventNum);
evStList.Add(obj);
}
;
foreach (var element in evStList)
{
System.Diagnostics.Debug.WriteLine("This is evstList by ID: " + element.Title);
}
return(evStList);
}
public void initializePPFields(Users userI)
{
if (userI == null)
{
Response.Redirect("homepage.aspx");
}
else
{
userI.UpdateRatingByID(userI.id);
Users user = userI.GetUserById(userI.id);
Users sUser = (Users)Session["user"];
if (sUser != null && user.id == sUser.id) // i wanted to comment an explanation but was too lazy halfway.
{
Session["user"] = user;
}
EventsStatus events = new EventsStatus();
var eventList = events.GetAllEventsByName();
int eventCount = 0;
for (int i = 0; i < eventList.Count; i++)
{
if (eventList[i].Organiser == user.id.ToString())
{
eventCount++;
}
}
if (user.verified == 1)
{
bluetick.Visible = true;
}
if (eventCount == 0)
{
lblEventCount.Visible = false;
}
else
{
lblEventCount.Text = "(" + eventCount.ToString() + ")";
}
lblUserName.Text = user.name;
if (user.facebook != "")
{
hlFacebook.NavigateUrl = user.facebook;
}
if (user.instagram != "")
{
hlInstagram.NavigateUrl = user.instagram;
}
if (user.twitter != "")
{
hlTwitter.NavigateUrl = user.twitter;
}
hlInstagram.NavigateUrl = user.instagram;
hlTwitter.NavigateUrl = user.twitter;
imgDP.ImageUrl = user.DPimage;
imgBP.ImageUrl = user.BPimage;
if (user.desc != "")
{
lblDesc.Text = user.desc;
}
else
{
lblDesc.Text = "This user has not added any description."; lblDesc.CssClass += "text-muted font-italic";
}
rating = user.rating;
}
}
