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");
}
}
