public CCtblEvent[] ReadEventList()
{
using (ist420grp7Entities entities = new ist420grp7Entities())
{
var events = from s in entities.CCtblEvents select s;
return(events.ToArray());
}
}
public CCtblUser ReadUser(int UserID)
{
using (ist420grp7Entities entities = new ist420grp7Entities())
{
CCtblUser stud = new CCtblUser();
stud = entities.CCtblUsers.Find(UserID);
return(stud);
}
}
public string CreateGuestPost(CCtblGuestLookUp guest)
{
using (ist420grp7Entities entities = new ist420grp7Entities())
{
entities.CCtblGuestLookUps.Add(guest);
entities.SaveChanges();
if (guest.fldEntryNo > 0)
{
return(guest.fldEntryNo.ToString());
}
else
{
return("false");
}
}
}
public string CreateUserPost(CCtblUser CreateUser)
{
//try
//{
using (ist420grp7Entities entities = new ist420grp7Entities())
{
entities.CCtblUsers.Add(CreateUser);
entities.SaveChanges();
if (CreateUser.fldUserNo > 0)
{
return(CreateUser.fldUserNo.ToString());
}
else
{
return("false");
}
}
}
public bool DeleteEvent(int EventID)
{
using (ist420grp7Entities entities = new ist420grp7Entities())
{
//Create the student stud object
CCtblEvent User = new CCtblEvent();
try
{
User = entities.CCtblEvents.Find(EventID);
//Delete a record
entities.CCtblEvents.Remove(User);
entities.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
}