public ActionResult Register([Bind(Include = "guestnumber,paymentamount,eventname,email")] Register r)
{
using (RegistrationEntities2 entities = new RegistrationEntities2())
{
try
{
if (r.EventName == "")
{
Messagebox("Please enter an event name");
return(View("RegForm"));
}
else if (r.Email == "")
{
Messagebox("Please enter a registered clients email");
return(View("RegForm"));
}
entities.Registers.Add(r);
entities.SaveChanges();
Messagebox("Registration for event successfull");
return(View(r));
}
catch (Exception e)
{
Messagebox("An error occurred, Please ensure all required fields contain valid data and try again");
return(View("RegForm"));
}
}
}
public ActionResult Registrations()
{
RegistrationEntities2 db = new RegistrationEntities2();
var reg = from e in db.Registers
orderby e.RegisterID
select e;
return(View(reg));
}
public ActionResult DeleteEvent(string clientEmail, string eventName)
{
//trimming the whitespace of our parsed variables
clientEmail = clientEmail.ToLower().Trim();
eventName = eventName.Trim();
//grabbing both databases (clients and registrations)
RegistrationEntities cdb = new RegistrationEntities();
RegistrationEntities2 rdb = new RegistrationEntities2();
//creating lists for both databases that contain the parsed variables
List <Client> clients = cdb.Clients.Where(x => x.Email.ToLower() == clientEmail.ToLower()).ToList();
List <Register> reg = rdb.Registers.Where(x => x.EventName.ToLower() == eventName.ToLower()).ToList();
try
{
//if a valid client has been parsed
if (clients.Capacity > 0)
{
//grabbing all items that contain the client email in registration db
var r = rdb.Registers.Where(x => x.Email.ToLower() == clientEmail.ToLower()).ToList();
foreach (var ev in reg)
{
//checking to make sure a valid event has been parsed
if (reg.Capacity > 0)
{
//ensuring correct client registration is deleted
if (ev.Email == clientEmail)
{
rdb.Registers.Remove(ev);
rdb.SaveChanges();
//alerting user
Messagebox("Registration deletion Successfull");
return(View());
}
}
//deleting the events in the registration db that have the same name as the parsed event name
}
Messagebox("Please Enter a Valid Event");
return(View("EventIndex"));
}
//if no valid client email was parsed
else
{
//alerting user
Messagebox("Please Enter a Valid Client");
return(View("EventIndex"));
}
}
catch
{
//alerting user if an error was found
Messagebox("Event Registration Not Found, Registration Deletion Failed, Please Try Again");
return(View("EventIndex"));
}
}
