public EventStaff StaffLogin(string email, string password)
{
HashPass hashedPass = new HashPass();
string pass = HashPass.HashPassword(password);
using (EventrixDBDataContext mde = new EventrixDBDataContext())
{
try
{
return(mde.Staffs.Where(pe => pe.Email == email && pe.Password == pass).Select(pe => new EventStaff
{
ID = pe.StaffId,
NAME = pe.Name,
EMAIL = pe.Email,
Occupation = pe.Occupation,
PASS = pe.Password,
EventID = Convert.ToInt32(pe.eventid)
}).First());
}
catch
{
return(null);
}
};
}
public EventGuest GuestLogin(string email, string password)
{
HashPass hashedPass = new HashPass();
string pass = HashPass.HashPassword(password);
using (EventrixDBDataContext mde = new EventrixDBDataContext())
{
try
{
return(mde.Guests.Where(pe => pe.Email == email && pe.Password == pass).Select(pe => new EventGuest
{
ID = pe.G_ID,
NAME = pe.Name,
EMAIL = pe.Email,
SURNAME = pe.Surname,
PASS = pe.Password,
TYPE = pe.Type
}).First());
}
catch
{
return(null);
}
};
}
public string RegisterHost(Host host)
{
HashPass hashedPass = new HashPass();
string pass = HashPass.HashPassword(host.PASS);
using (EventrixDBDataContext dbd = new EventrixDBDataContext())
{
try
{
int MailChecker = (from eh in dbd.EventHosts where eh.Email.Equals(host.EMAIL) select eh).Count();
if (MailChecker == 0)
{
EventHost _host = new EventHost();
_host.Name = host.NAME;
_host.Email = host.EMAIL;
_host.Surname = host.SURNAME;
_host.Password = pass;
dbd.EventHosts.InsertOnSubmit(_host);
dbd.SubmitChanges();
return("Registered " + _host.Name + "successfully");
}
else
{
return("Error: Account already taken");
}
}
catch (Exception e)
{
return(e.GetBaseException().ToString());
}
};
}
public string RegisterStaff(EventStaff _staff)
{
HashPass hashedPass = new HashPass();
string pass = HashPass.HashPassword(_staff.PASS);
using (EventrixDBDataContext dbd = new EventrixDBDataContext())
{
try
{
int MailChecker = (from eh in dbd.Staffs where eh.Email.Equals(_staff.EMAIL) && eh.eventid == _staff.EventID select eh).Count();
if (MailChecker == 0)
{
int _id = Convert.ToInt32(_staff.EventID);
Staff staff = new Staff();
staff.Name = _staff.NAME;
staff.Email = _staff.EMAIL;
staff.Occupation = _staff.Occupation;
staff.Password = pass;
staff.eventid = _id;
dbd.Staffs.InsertOnSubmit(staff);
dbd.SubmitChanges();
return("Registered " + staff.Name + " successfully");
}
else
{
return("Error: Account already taken");
}
}
catch (Exception e)
{
return(e.GetBaseException().ToString());
}
};
}
public int RegisterGuest(EventGuest guest)
{
string reg = "";
HashPass hashedPass = new HashPass();
string pass = HashPass.HashPassword(guest.PASS);
using (EventrixDBDataContext dbd = new EventrixDBDataContext())
{
try
{
int MailChecker = (from gst in dbd.Guests where gst.Email.Equals(guest.EMAIL) select gst).Count();
if (MailChecker == 0)
{
Guest _guest = new Guest();
_guest.Name = guest.NAME;
_guest.Email = guest.EMAIL;
_guest.Surname = guest.SURNAME;
_guest.Type = guest.TYPE;
_guest.Password = pass;
dbd.Guests.InsertOnSubmit(_guest);
dbd.SubmitChanges();
reg = "success";
}
else
{
reg = "fail";
}
}
catch (Exception e)
{
return(-1);
}
};
if (reg.Equals("success"))
{
using (EventrixDBDataContext db = new EventrixDBDataContext())
{
try
{
var query = (from res in db.Guests select res).ToList();
Guest lastEntry = query.Last();
int ID = lastEntry.G_ID;
return(ID);
}
catch (Exception)
{
return(-1);
}
};
}
else
{
return(-1);
}
}
public string InsertOTP(EventGuest guest, string ID)
{
HashPass hashedPass = new HashPass();
string pass = HashPass.HashPassword(guest.PASS);
using (EventrixDBDataContext db = new EventrixDBDataContext())
{
try
{
int _id = Convert.ToInt32(ID);
var query = (from gst in db.Guests where gst.G_ID.Equals(_id) select gst).First();
Guest toUpdate = query;
toUpdate.Password = pass;
db.SubmitChanges();
return("success");
}catch (Exception)
{
return("fail");
}
};
}
