public string SaveForm(Blankett b1) { KrimmDBEntities2 db = new KrimmDBEntities2(); string username = CreateAccount(b1); if (!username.Equals("Error")) { Form form = new Form(); int id = db.Users.Where(s => s.Username == username).Select(s => s.UserId).FirstOrDefault(); form.User = id; form.Email = b1.EMail; form.VisitorFName = b1.VisitorFName; form.VisitorLName = b1.VisitorLName; form.Status = "Pending"; form.Phonenumber = b1.PhoneNumber; form.PersonOfInterest = b1.InmateSSN; db.Form.Add(form); db.SaveChanges(); string pass = db.Users.Where(s => s.Username == username).Select(s => s.Password).FirstOrDefault(); return("Blanketten är mottagen. Du har fått ett konto med" + " användarnamn: " + username + " och lösenord: " + pass + " Skriv ner dina uppgifter"); } else { return("Error"); } }
public bool CreateInamate(string inmateFirstname, string InmateSurname) { KrimmDBEntities2 db = new KrimmDBEntities2(); Inmates inmate = new Inmates(); inmate.Firstname = inmateFirstname; inmate.Surname = InmateSurname; db.Inmates.Add(inmate); db.SaveChanges(); return(true); }
public string CreateAccount(Blankett b1) { bool b = true; while (b) { Random rnd = new Random(); KrimmDBEntities2 db = new KrimmDBEntities2(); int username = rnd.Next(0000000, 99999999); string sUsername = username.ToString(); string password = rnd.Next(0000000, 99999999).ToString(); string result = db.Users.Where(u => u.Username == sUsername).Select(u => u.Username).FirstOrDefault(); if (result != sUsername) { var inmateSSN = db.Inmates.Where(i => i.InmateSSN == b1.InmateSSN).Select(i => i.InmateSSN); int intInmateSSN = (int)inmateSSN.FirstOrDefault(); if (intInmateSSN == b1.InmateSSN) { int admin = 0; Users create = new Users(); create.Username = sUsername; create.Password = password; create.PersonOfInterest = intInmateSSN; create.Admin = admin; db.Users.Add(create); db.SaveChanges(); b = false; return(sUsername); } else { b = false; return("Error"); } } else { b = true; //FORTSÄTT LOOP TILLS KONTO SKAPAS } } return("Error"); }
public bool SaveAvailableTimeToDB(string date, string time) { KrimmDBEntities2 db = new KrimmDBEntities2(); if (date == null || time == null) { return(false); } else { Bookings createBooking = new Bookings(); createBooking.Date = date; createBooking.Time = time; db.Bookings.Add(createBooking); db.SaveChanges(); } return(true); }
public void ChangeStatusForm(Blankett b1, string newStatus) { b1.Status = newStatus; KrimmDBEntities2 db = new KrimmDBEntities2(); int result = db.Form.Where(f => f.FormId == b1.FormId).Select(f => f.FormId).FirstOrDefault(); if (result == b1.FormId) { Form updateStatus = db.Form.Single(s => s.FormId == b1.FormId); updateStatus.Status = b1.Status; db.SaveChanges(); } //Save db; //0 = Declined //1 = Accepted //2 = Pending }
public string BookTime(string date, string time, string user, int inmateSSN) { KrimmDBEntities2 db = new KrimmDBEntities2(); int booking = db.Bookings.Where(s => s.Date == date).Where(s => s.Time == time).Select(s => s.BookingId).FirstOrDefault(); var tempUser = db.Bookings.Where(s => s.BookingId == booking).Select(s => s.Iduser).FirstOrDefault(); if (tempUser == null) { int userId = db.Users.Where(s => s.Username == user).Select(s => s.UserId).FirstOrDefault(); Bookings book = db.Bookings.Single(s => s.BookingId == booking); book.Iduser = userId; book.PersonOfInterest = inmateSSN; db.SaveChanges(); return("Din bokning har genomförts den " + date + " klockan " + time); } else { return("Tiden var redan upptagen"); } }