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