public int FindLastIdStatus() { BDContext db = new BDContext(); List <Status> statuses = db.Statuses.ToList(); int id = 0; foreach (Status status in statuses) { id = status.Id; } return(id); }
public int FindLastIdKvestRoom() { BDContext db = new BDContext(); List <KvestRoom> kvests = db.KvestRooms.ToList(); int id = 0; foreach (KvestRoom kvest in kvests) { id = kvest.Id; } return(id); }
public int FindLastIdOrder() { BDContext db = new BDContext(); List <Order> orders = db.Orders.ToList(); int id = 0; foreach (Order order in orders) { id = order.Id; } return(id); }
public int[] FindUsersVal(int ID) { BDContext db = new BDContext(); int[] mm = new int[2]; using (db) { var val = db.UsersValues.Find(ID); mm[0] = val.min; mm[1] = val.max; } return(mm); }
public int[] FindAge(int ID) { BDContext db = new BDContext(); int[] mm = new int[2]; using (db) { var val = db.AgeCategories.Find(ID); mm[0] = val.min; mm[1] = val.max; } return(mm); }
public void AddSertificate(int SertNum, Boolean shown) { BDContext db = new BDContext(); using (db) { Sertificate value = new Sertificate(); value.SertificateNumber = SertNum; value.Shown = shown; db.Sertificates.Add(value); db.SaveChanges(); } }
public void AddUsersValues(int Min, int Max) { BDContext db = new BDContext(); using (db) { UsersValue value = new UsersValue(); value.min = Min; value.max = Max; db.UsersValues.Add(value); db.SaveChanges(); } }
public void AddAgeCategories(int Min, int Max) { BDContext db = new BDContext(); using (db) { AgeCategory first = new AgeCategory(); first.min = Min; first.max = Max; db.AgeCategories.Add(first); db.SaveChanges(); } }
public void AddTimeCategories(string day, int start, int finish) { BDContext db = new BDContext(); using (db) { TimeCategory value = new TimeCategory(); value.Day = day; value.Start = start; value.Finish = finish; db.TimeCategories.Add(value); db.SaveChanges(); } }
public void AddStatus(int IDOrder, int IDTime, int IDKvestRoom) { BDContext db = new BDContext(); using (db) { Status value = new Status(); value.TimeCategoryId = IDTime; value.OrderId = IDOrder; value.KvestRoomId = IDKvestRoom; value.Id = find.FindLastIdStatus() + 1; db.Statuses.Add(value); db.SaveChanges(); } }
public void AddKvestRoom(string RoomName, int IDUsersValue, int IDAge, int OnePrice) { BDContext db = new BDContext(); using (db) { KvestRoom value = new KvestRoom(); value.Name = RoomName; value.UsersValueId = IDUsersValue; value.AgeCategory = IDAge; value.PriceForOneUser = OnePrice; db.KvestRooms.Add(value); db.SaveChanges(); } }
public int[,] ShowAllAgeCategories() { BDContext db = new BDContext(); int[,] age = new int[3, 2]; using (db) { AgeCategory[] Age = new AgeCategory[5]; Age = db.AgeCategories.ToArray(); for (int i = 0; i < 3; i++) { age[i, 0] = Age[i].min; age[i, 1] = Age[i].max; } } return(age); }
public int[,] ShowAllUsersValue() { BDContext db = new BDContext(); int[,] usersVal = new int[3, 2]; using (db) { UsersValue[] user = new UsersValue[5]; user = db.UsersValues.ToArray(); for (int i = 0; i < 3; i++) { usersVal[i, 0] = user[i].min; usersVal[i, 1] = user[i].max; } } return(usersVal); }
public bool FindSertificateID(int sertNum) { BDContext db = new BDContext(); using (db) { var val = db.Sertificates.Where(b => b.Id == sertNum) .Select(b => b.Id).ToList(); if (val.Contains(sertNum)) { return(true); } else { return(false); } } }
public string[] FindKvestNames(int usersID, int ageID, int price) { string[] names; BDContext db = new BDContext(); using (db) { var val = db.KvestRooms .Where(b => b.AgeCategory == ageID && b.UsersValueId == usersID && b.PriceForOneUser <= price) .Select(b => b.Name).ToList(); names = new string [val.Count]; for (int i = 0; i < val.Count; i++) { names[i] = val.ElementAt(i); } } return(names); }
public string[,] ShowAllTimeCategories() { BDContext db = new BDContext(); string[,] age = new string[15, 3]; using (db) { TimeCategory[] Age = new TimeCategory[15]; Age = db.TimeCategories.ToArray(); for (int i = 0; i < age.GetLength(0); i++) { age[i, 0] = Age[i].Day; age[i, 1] = Convert.ToString(Age[i].Start); age[i, 2] = Convert.ToString(Age[i].Finish); } } return(age); }
public bool CheckAdmin(string login, int password) { BDContext db = new BDContext(); using (db) { var val = db.Administrators .Where(b => b.Login == login) .Select(b => b.Password).ToList(); if (val.Contains(password)) { return(true); } else { return(false); } } }
public string[,] ShowKvestRooms() { BDContext db = new BDContext(); string[,] kvestRoom; using (db) { List <KvestRoom> kvest = new List <KvestRoom>(); kvest = db.KvestRooms.ToList(); kvestRoom = new string[kvest.Count(), 4]; for (int i = 0; i < kvest.Count(); i++) { kvestRoom[i, 0] = kvest.ElementAt(i).Name; kvestRoom[i, 1] = Convert.ToString(kvest.ElementAt(i).UsersValueId); kvestRoom[i, 2] = Convert.ToString(kvest.ElementAt(i).AgeCategory); kvestRoom[i, 3] = Convert.ToString(kvest.ElementAt(i).PriceForOneUser); } } return(kvestRoom); }