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