public static bool updatePriceAttraction(string na, double pa, DateTime ds, DateTime de)
{
if (ds > de)
{
DateTime tmp = ds;
ds = de;
de = tmp;
}
if (ds < DateTime.Today)
{
return(false);
}
if (pa < 0)
{
return(false);
}
using (AquaparkDBDataContext db = new AquaparkDBDataContext())
{
var getid =
from i in db.tbl_Attractions
where i.Name == na
select i.ID;
var getidp =
from p in db.tbl_PriceListAttractions
where p.IDAttraction == getid.First()
select p.ID;
var testdate =
from d in db.tbl_AttractionHistories
where d.IDAttractionList == getidp.First() && d.EndDate >= DateTime.Today
select d;
foreach (var i in testdate)
{
if ((ds >= i.BeginDate && ds <= i.EndDate) || (de >= i.BeginDate && de <= i.EndDate) || (ds <= i.BeginDate && de >= i.EndDate))
{
return(false);
}
}
var insDate = new tbl_AttractionHistory
{
BeginDate = ds,
EndDate = de,
IDAttractionList = getidp.First(),
AttractionName = na,
AttractionPrice = pa
};
db.tbl_AttractionHistories.InsertOnSubmit(insDate);
db.SubmitChanges();
return(true);
}
}
public static void insRFID()
{
using (AquaparkDBDataContext db = new AquaparkDBDataContext())
{
var nw = new tbl_RFIDWatch
{
Status = false
};
db.tbl_RFIDWatches.InsertOnSubmit(nw);
db.SubmitChanges();
}
}
public static bool updateTicketPrice(string nt, double pt, DateTime ds, DateTime de)
{
if (ds > de)
{
DateTime tmp = ds;
ds = de;
de = tmp;
}
if (ds < DateTime.Today)
{
return(false);
}
if (pt < 0)
{
return(false);
}
using (AquaparkDBDataContext db = new AquaparkDBDataContext())
{
var getid =
from p in db.tbl_PriceLists
where p.Entry == nt
select p.ID;
var testdate =
from d in db.tbl_PriceHistories
where d.IDPriceList == getid.First() && d.EndDate >= DateTime.Today
select d;
foreach (var i in testdate)
{
if ((ds >= i.BeginDate && ds <= i.EndDate) || (de >= i.BeginDate && de <= i.EndDate) || (ds <= i.BeginDate && de >= i.EndDate))
{
return(false);
}
}
var insDate = new tbl_PriceHistory
{
BeginDate = ds,
EndDate = de,
IDPriceList = getid.First(),
TicketName = nt,
TicketPrice = pt,
};
db.tbl_PriceHistories.InsertOnSubmit(insDate);
db.SubmitChanges();
return(true);
}
}
public static void addClient(string n, string s, string p)
{
using (AquaparkDBDataContext db = new AquaparkDBDataContext())
{
var nc = new tbl_Client
{
Name = n,
Surname = s,
PESEL = p
};
db.tbl_Clients.InsertOnSubmit(nc);
db.SubmitChanges();
}
}
public static void exitAquapark(int idw, DateTime stop)
{
using (AquaparkDBDataContext db = new AquaparkDBDataContext())
{
var update =
from p in db.tbl_Visits
where p.IDWatch == idw && p.StopTime == null
select p;
foreach (tbl_Visit p in update)
{
p.StopTime = stop;
}
db.SubmitChanges();
}
}
public static void changeStatus(int id)
{
using (AquaparkDBDataContext db = new AquaparkDBDataContext())
{
var update =
from p in db.tbl_RFIDWatches
where p.ID == id
select p;
foreach (tbl_RFIDWatch p in update)
{
p.Status ^= true;
}
db.SubmitChanges();
}
}
public static void addVisitPass(int iw, int ip)
{
using (AquaparkDBDataContext db = new AquaparkDBDataContext())
{
var insVis = new tbl_Visit
{
StartTime = DateTime.Now,
StopTime = null,
IDWatch = iw,
IDPriceEntry = null,
IDPass = ip
};
db.tbl_Visits.InsertOnSubmit(insVis);
db.SubmitChanges();
}
}
public static void insertGateEntering(int idg, int idw)
{
using (AquaparkDBDataContext db = new AquaparkDBDataContext())
{
var idv = (from i in db.tbl_Visits
where i.IDWatch == idw && i.StopTime == null
select i.ID);
var insGE = new tbl_GateHistory
{
Timestamp = DateTime.Now,
IDGate = idg,
IDVisit = idv.First()
};
db.tbl_GateHistories.InsertOnSubmit(insGE);
db.SubmitChanges();
}
}
public static void addPass(string p)
{
using (AquaparkDBDataContext db = new AquaparkDBDataContext())
{
var sel =
from s in db.tbl_Clients
where s.PESEL == p
select s;
var ap = new tbl_Pass
{
WhenEnds = DateTime.Today.AddDays(30),
IDClient = sel.First().ID
};
db.tbl_Passes.InsertOnSubmit(ap);
db.SubmitChanges();
}
}