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 bool deleteGuest(EventGuest _guest)
{
using (EventrixDBDataContext mde = new EventrixDBDataContext())
{
try
{
int _id = Convert.ToInt32(_guest.ID);
Guest gst = mde.Guests.Single(p => p.G_ID == _id);
mde.Guests.DeleteOnSubmit(gst);
//mde.Guests.Remove(gst);
//mde.SaveChanges();
mde.SubmitChanges();
return(true);
}
catch
{
return(false);
}
};
}
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");
}
};
}
public bool editGuest(EventGuest _guest)
{
using (EventrixDBDataContext mde = new EventrixDBDataContext())
{
try
{
int _id = Convert.ToInt32(_guest.ID);
Guest gst = mde.Guests.Single(p => p.G_ID == _id);
gst.Name = _guest.NAME;
gst.Surname = _guest.SURNAME;
gst.Password = _guest.PASS;
gst.Email = _guest.EMAIL;
mde.Guests.InsertOnSubmit(gst);
//mde.SaveChanges();
return(true);
}
catch
{
return(false);
}
};
}
public bool createGuest(EventGuest _guest)
{
using (EventrixDBDataContext mde = new EventrixDBDataContext())
{
try
{
Guest gst = new Guest();
gst.Name = _guest.NAME;
gst.Surname = _guest.SURNAME;
gst.Email = _guest.EMAIL;
gst.Password = _guest.PASS;
gst.Type = "Public";
mde.Guests.InsertOnSubmit(gst);
//mde.Guests.Add(gst);
//mde.SaveChanges();
mde.SubmitChanges();
return(true);
}
catch
{
return(false);
}
}
}