//public int CreateOrUpdate(EventM eventM, UserAcc userAcc)
//{
// // if NGOAcc.ngoid <= 1 then create
// // if NGOAcc.ngoid > 1 then update is meant
// // access the database
// using (SqlConnection connection = new SqlConnection(connectionString))
// {
// string sqlQuery = "";
// if (userAcc.usernameId <= 0)
// {
// sqlQuery = "INSERT INTO dbo.User_Info Values(@username, @password, @firstname, @lastname, @age, @gender, @occupation, @title, @interests, @past_experience, @email_address, @phone_num)";
// }
// else
// {
// //update
// sqlQuery = "UPDATE dbo.User_Info SET username = @username, password = @password, firstname = @firstname, lastname = @lastname, age = @age, gender = @gender, occupation = @occupation, title = @title, interests = @interests, past_experience = @past_experience, email_address = @email_address, phone_num = @phone_num WHERE usernameId = @usernameId";
// }
// // associate @id with Id parameter beside fetchone
// SqlCommand command = new SqlCommand(sqlQuery, connection);
// command.Parameters.Add("@usernameId", System.Data.SqlDbType.VarChar, 1000).Value = userAcc.usernameId;
// command.Parameters.Add("@username", System.Data.SqlDbType.VarChar, 1000).Value = userAcc.username;
// command.Parameters.Add("@password", System.Data.SqlDbType.VarChar, 1000).Value = userAcc.password;
// command.Parameters.Add("@firstname", System.Data.SqlDbType.VarChar, 1000).Value = userAcc.firstname;
// command.Parameters.Add("@lastname", System.Data.SqlDbType.VarChar, 1000).Value = userAcc.lastname;
// command.Parameters.Add("@age", System.Data.SqlDbType.VarChar, 1000).Value = userAcc.age;
// command.Parameters.Add("@gender", System.Data.SqlDbType.VarChar, 1000).Value = userAcc.gender;
// command.Parameters.Add("@occupation", System.Data.SqlDbType.VarChar, 1000).Value = userAcc.occupation;
// command.Parameters.Add("@title", System.Data.SqlDbType.VarChar, 1000).Value = userAcc.title;
// command.Parameters.Add("@interests", System.Data.SqlDbType.VarChar, 1000).Value = userAcc.interests;
// command.Parameters.Add("@past_experience", System.Data.SqlDbType.VarChar, 1000).Value = userAcc.past_experience;
// command.Parameters.Add("@email_address", System.Data.SqlDbType.VarChar, 1000).Value = userAcc.email_address;
// command.Parameters.Add("@phone_num", System.Data.SqlDbType.VarChar, 1000).Value = userAcc.phone_num;
// connection.Open();
// //Doing an inserting
// int newID = command.ExecuteNonQuery();
// return newID;
// }
//}
public int Create(EventM eventM, int x)
{
using (SqlConnection connection = new SqlConnection(connectionString))
{
string sqlQuery = "INSERT INTO dbo.Event_Info Values(@usernameId, @event_name, @event_date, @venue, @location, @attendance_limit, @rating, @additional_info)";
// associate @id with Id parameter beside fetchone
SqlCommand command = new SqlCommand(sqlQuery, connection);
command.Parameters.Add("@usernameId", System.Data.SqlDbType.VarChar, 1000).Value = x;
command.Parameters.Add("@event_name", System.Data.SqlDbType.VarChar, 1000).Value = eventM.event_name;
command.Parameters.Add("@event_date", System.Data.SqlDbType.VarChar, 1000).Value = eventM.event_date;
command.Parameters.Add("@venue", System.Data.SqlDbType.VarChar, 1000).Value = eventM.venue;
command.Parameters.Add("@location", System.Data.SqlDbType.VarChar, 1000).Value = eventM.location;
command.Parameters.Add("@attendance_limit", System.Data.SqlDbType.VarChar, 1000).Value = eventM.attendance_limit;
//command.Parameters.Add("@budget", System.Data.SqlDbType.VarChar, 1000).Value = eventM.budget;
command.Parameters.Add("@rating", System.Data.SqlDbType.VarChar, 1000).Value = eventM.rating;
command.Parameters.Add("@additional_info", System.Data.SqlDbType.VarChar, 1000).Value = eventM.additional_info;
connection.Open();
//Doing an inserting
int newID = command.ExecuteNonQuery();
return(newID);
}
}
public ActionResult EventDetails(int id)
{
EventDAO eventDAO = new EventDAO();
EventM events = eventDAO.FetchOne(id);
TempData.Keep();
return(View("EventDetails", events));
}
public ActionResult CreateEvent(UserAcc userAcc)
{
EventM events = new EventM();
events.usernameId = userAcc.usernameId;
TempData.Keep();
return(View("EventForm", events));
}
public ActionResult EventTab()
{
int x = (int)TempData["ID"];
EventDAO eventDAO = new EventDAO();
EventM events = eventDAO.listEvent(x);
TempData.Keep();
return(View("EventTab", events));
}
public List <EventM> FetchAll()
{
List <EventM> returnList = new List <EventM>();
// access the database
using (SqlConnection connection = new SqlConnection(connectionString))
{
string sqlQuery = "SELECT * from dbo.Event_Info";
//string sqlQuery = "SELECT event_name, event_date, venue, location, attendance_limit from dbo.Event_Info";
SqlCommand command = new SqlCommand(sqlQuery, connection);
connection.Open();
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
EventM events = new EventM();
events.eventId = reader.GetInt32(0);
events.usernameId = reader.GetInt32(1);
events.event_name = reader.GetString(2);
events.event_date = reader.GetString(3);
events.venue = reader.GetString(4);
events.location = reader.GetString(5);
events.attendance_limit = reader.GetInt32(6);
events.rating = reader.GetInt32(7);
events.additional_info = reader.GetString(8);
//events.event_name = reader.GetString(0);
//events.event_date = reader.GetString(1);
//events.venue = reader.GetString(2);
//events.location = reader.GetString(3);
//events.attendance_limit = reader.GetInt32(4);
returnList.Add(events);
}
}
}
return(returnList);
}
public ActionResult ProcessEvent(EventM eventM)
{
//save to the db.
EventDAO eventDAO = new EventDAO();
int x = (int)TempData["ID"];
eventDAO.Create(eventM, x);
//UserAcc users = new UserAcc();
List <EventM> listevent = new List <EventM>();
listevent = eventDAO.FetchAll();
TempData.Keep();
return(View("Index", listevent));
}
public EventM listEvent(int id)
{
// access the database
using (SqlConnection connection = new SqlConnection(connectionString))
{
string sqlQuery = "SELECT * from dbo.Event_Info WHERE eventId = @id";
// associate @id with Id parameter beside fetchone
SqlCommand command = new SqlCommand(sqlQuery, connection);
command.Parameters.Add("@id", System.Data.SqlDbType.Int).Value = id;
connection.Open();
SqlDataReader reader = command.ExecuteReader();
EventM events = new EventM();
if (reader.HasRows)
{
while (reader.Read())
{
events.eventId = reader.GetInt32(0);
events.usernameId = reader.GetInt32(1);
events.event_name = reader.GetString(2);
events.event_date = reader.GetString(3);
events.venue = reader.GetString(4);
events.location = reader.GetString(5);
events.attendance_limit = reader.GetInt32(6);
//events.budget = reader.GetFloat(7);
events.rating = reader.GetInt32(7);
events.additional_info = reader.GetString(8);
}
}
return(events);
}
}