public static void cancelRequestAtt(int id) { RequestAttraction rrd = DatabaseConnectionHandler.GetInstance().RequestAttraction.Where(x => x.ReqAttId == id).FirstOrDefault(); rrd.ReqAttStatus = "Cancel"; DatabaseConnectionHandler.GetInstance().SaveChanges(); }
public static void removeAtt(int id) { var rslt = DatabaseConnectionHandler.GetInstance().Attraction.Where(x => x.AttractionId == id).FirstOrDefault(); rslt.AttractionStatus = "Removing"; DatabaseConnectionHandler.GetInstance().SaveChanges(); }
public static void deleteTransaction(int id) { var rslt = DatabaseConnectionHandler.GetInstance().TicketTransaction.Where(x => x.TicketTransactionId == id).ToList(); rslt.ForEach(x => x.TicketTransactionStatus = "Cancel"); DatabaseConnectionHandler.GetInstance().SaveChanges(); }
public static void removeRide(int id) { var rslt = DatabaseConnectionHandler.GetInstance().Ride.Where(x => x.RideId == id).FirstOrDefault(); rslt.RideStatus = "Removing.. Prepare To Construction"; DatabaseConnectionHandler.GetInstance().SaveChanges(); }
public static void decReqRide(int id) { string oldStatus = ""; string newStatus = ""; var rslt = (from x in DatabaseConnectionHandler.GetInstance().RequestRide select new { AttractionStatus = x.ReqRideStatus }).ToList(); foreach (var i in rslt) { oldStatus = i.AttractionStatus; } if (oldStatus.Equals("Adding.. Waiting Approvement")) { newStatus = "Adding.. Decline"; } else if (oldStatus.Equals("Updating.. Waiting Approvement")) { newStatus = "Updating.. Decline"; } else if (oldStatus.Equals("Removing.. Waiting Approvement")) { newStatus = "Removing.. Decline"; } var upd = DatabaseConnectionHandler.GetInstance().RequestRide.Where(x => x.ReqRideId == id).ToList(); upd.ForEach(x => x.ReqRideStatus = newStatus); DatabaseConnectionHandler.GetInstance().SaveChanges(); }
public static void updateStatusEndMtn(int id) { var rslt = DatabaseConnectionHandler.GetInstance().Attraction.Where(x => x.AttractionId == id).ToList(); rslt.ForEach(x => x.AttractionStatus = "Active"); DatabaseConnectionHandler.GetInstance().SaveChanges(); }
public static void cancelRequestRide(int id) { RequestRide rrd = DatabaseConnectionHandler.GetInstance().RequestRide.Where(x => x.ReqRideId == id).FirstOrDefault(); rrd.ReqRideStatus = "Cancel"; DatabaseConnectionHandler.GetInstance().SaveChanges(); }
public static void delAds(int id) { Advertisement ad = DatabaseConnectionHandler.GetInstance().Advertisement.Where(x => x.AdvertisementId == id).FirstOrDefault(); ad.AdvertisementStatus = "Deleted"; DatabaseConnectionHandler.GetInstance().SaveChanges(); }
public static void insertTicket() { Ticket newTc = new Ticket(); newTc.TicketId = ticketId; DatabaseConnectionHandler.GetInstance().Ticket.Add(newTc); DatabaseConnectionHandler.GetInstance().SaveChanges(); }
public static void updAds(int id, string name, string detail) { Advertisement ad = DatabaseConnectionHandler.GetInstance().Advertisement.Where(x => x.AdvertisementId == id).FirstOrDefault(); ad.AdvertisementName = name; ad.AdvertisementDetail = detail; DatabaseConnectionHandler.GetInstance().SaveChanges(); }
public static int getQtyTicketSoldToday() { int rslt = (from x in DatabaseConnectionHandler.GetInstance().TicketTransaction.Where(x => x.TicketTransactionDate == DateTime.Today) select new { TicketQuantity = x.TicketQuantity }).ToList().Sum(x => x.TicketQuantity); return(rslt); }
public static int getQtyTicketSoldAll() { int rslt = (from x in DatabaseConnectionHandler.GetInstance().TicketTransaction.Where(x => x.TicketTransactionStatus == "Success") select new { TicketQuantity = x.TicketQuantity }).ToList().Sum(x => x.TicketQuantity); return(rslt); }
public static void addAdds(string name, string detail) { Advertisement newAd = new Advertisement(); newAd.EmployeeId = LoginHandler.idEmp; newAd.AdvertisementName = name; newAd.AdvertisementDetail = detail; DatabaseConnectionHandler.GetInstance().Advertisement.Add(newAd); DatabaseConnectionHandler.GetInstance().SaveChanges(); }
public static void updateRequestRide(int id, string name, string desc, string htw, string kindR, string safety) { RequestRide rrd = DatabaseConnectionHandler.GetInstance().RequestRide.Where(x => x.ReqRideId == id).FirstOrDefault(); rrd.ReqRideName = name; rrd.ReqRideDescription = desc; rrd.ReqRideHowToWork = htw; rrd.ReqRideKind = kindR; rrd.ReqRideSafetyInformation = safety; DatabaseConnectionHandler.GetInstance().SaveChanges(); }
public static void updateRequestAtt(int id, string name, string desc, string htw, string wp, DateTime launchDate) { RequestAttraction rrd = DatabaseConnectionHandler.GetInstance().RequestAttraction.Where(x => x.ReqAttId == id).FirstOrDefault(); rrd.ReqAttName = name; rrd.ReqAttDescription = desc; rrd.ReqAttHowToWork = htw; rrd.ReqAttWhoParticipant = wp; rrd.ReqAttStartDateLaunch = launchDate; DatabaseConnectionHandler.GetInstance().SaveChanges(); }
public static void insertRecordTicketTransaction(int empId, DateTime date, int qty) { TicketTransaction newTct = new TicketTransaction(); newTct.EmployeeId = empId; newTct.TicketTransactionDate = date; newTct.TicketQuantity = qty; newTct.TicketTransactionStatus = "Pending"; DatabaseConnectionHandler.GetInstance().TicketTransaction.Add(newTct); DatabaseConnectionHandler.GetInstance().SaveChanges(); }
public static void printTicket() { TicketTransaction tct = DatabaseConnectionHandler.GetInstance().TicketTransaction.ToArray().LastOrDefault(); int qty = tct.TicketQuantity; for (int i = 0; i < qty; i++) { ticketId = generateTicketId(); createQR(); saveQR(); } }
public static void updateAtt(int id) { var rslt = DatabaseConnectionHandler.GetInstance().RequestAttraction.Where(x => x.ReqAttId == id).FirstOrDefault(); Attraction rd = DatabaseConnectionHandler.GetInstance().Attraction.Where(x => x.AttractionId == rslt.AttractionId).FirstOrDefault(); rd.AttractionName = rslt.ReqAttName; rd.AttractionDescription = rslt.ReqAttDescription; rd.AttractionHowToWork = rslt.ReqAttHowToWork; rd.AttractionStartDateLaunch = rslt.ReqAttStartDateLaunch; rd.AttractionWhoParticipant = rslt.ReqAttWhoParticipant; DatabaseConnectionHandler.GetInstance().SaveChanges(); }
public static void updateRide(int id) { var rslt = DatabaseConnectionHandler.GetInstance().RequestRide.Where(x => x.ReqRideId == id).FirstOrDefault(); Ride rd = DatabaseConnectionHandler.GetInstance().Ride.Where(x => x.RideId == rslt.RideId).FirstOrDefault(); rd.RideName = rslt.ReqRideName; rd.RideDescription = rslt.ReqRideDescription; rd.RideHowToWork = rslt.ReqRideHowToWork; rd.RideKind = rslt.ReqRideKind; rd.RideSafetyInformation = rslt.ReqRideSafetyInformation; rd.RideStatus = "Updating.. Prepare To Construction"; DatabaseConnectionHandler.GetInstance().SaveChanges(); }
public static void insertReqFund(string detil, int amount) { RequestFund newRp = new RequestFund(); newRp.EmployeeId = LoginHandler.idEmp; newRp.RequestFundDetail = detil; newRp.RequestFundDate = DateTime.Now; newRp.PredictedAmount = amount; newRp.RequestFundStatus = "Waiting Approval"; DatabaseConnectionHandler.GetInstance().RequestFund.Add(newRp); DatabaseConnectionHandler.GetInstance().SaveChanges(); }
public static void insertReqPurchase(string detil, DateTime needDate, string time) { RequestPurchase newRp = new RequestPurchase(); newRp.EmployeeId = LoginHandler.idEmp; newRp.RequestPurchaseDetail = detil; newRp.RequestPurchaseDate = DateTime.Now; newRp.PurchaseTimeNeed = time; newRp.RequestPurchaseStatus = "Waiting Approval"; DatabaseConnectionHandler.GetInstance().RequestPurchase.Add(newRp); DatabaseConnectionHandler.GetInstance().SaveChanges(); }
public static void addRide(int reqId) { var rslt = DatabaseConnectionHandler.GetInstance().RequestRide.Where(x => x.ReqRideId == reqId).FirstOrDefault(); Ride newRd = new Ride(); newRd.RideName = rslt.ReqRideName; newRd.RideDescription = rslt.ReqRideDescription; newRd.RideHowToWork = rslt.ReqRideHowToWork; newRd.RideKind = rslt.ReqRideKind; newRd.RideSafetyInformation = rslt.ReqRideSafetyInformation; newRd.RideStatus = "Adding.. Prepare To Construction"; DatabaseConnectionHandler.GetInstance().Ride.Add(newRd); DatabaseConnectionHandler.GetInstance().SaveChanges(); }
public static void createScheduleMaintenanceAtt(int id, string name, DateTime date, string timeStart, string timeEnd, string note) { MaintenanceSchedule newMs = new MaintenanceSchedule(); newMs.AttractionId = id; newMs.AttractionName = name; newMs.MaintenanceDate = date; newMs.MaintenanceNote = note; newMs.MaintenaceStartTime = timeStart; newMs.MaintenanceEndTime = timeEnd; DatabaseConnectionHandler.GetInstance().MaintenanceSchedule.Add(newMs); DatabaseConnectionHandler.GetInstance().SaveChanges(); }
public static void insertPermitRequest(int id, DateTime fromDate, DateTime toDate, string category, string reason) { RequestPermit newRp = new RequestPermit(); newRp.EmployeeId = id; newRp.FromDate = fromDate; newRp.ToDate = toDate; newRp.Category = category; newRp.ReasonPermit = reason; newRp.PermitStatus = "Pending"; DatabaseConnectionHandler.GetInstance().RequestPermit.Add(newRp); DatabaseConnectionHandler.GetInstance().SaveChanges(); }
public static void addAtt(int reqId) { var rslt = DatabaseConnectionHandler.GetInstance().RequestAttraction.Where(x => x.ReqAttId == reqId).FirstOrDefault(); Attraction newRd = new Attraction(); newRd.AttractionName = rslt.ReqAttName; newRd.AttractionDescription = rslt.ReqAttDescription; newRd.AttractionHowToWork = rslt.ReqAttHowToWork; newRd.AttractionStartDateLaunch = rslt.ReqAttStartDateLaunch; newRd.AttractionWhoParticipant = rslt.ReqAttWhoParticipant; newRd.AttractionStatus = "Active"; DatabaseConnectionHandler.GetInstance().Attraction.Add(newRd); DatabaseConnectionHandler.GetInstance().SaveChanges(); }
public static void reqAddRide(string name, string desc, string htw, string kindR, string safety) { RequestRide newRr = new RequestRide(); newRr.EmployeeId = LoginHandler.idEmp; newRr.ReqRideName = name; newRr.ReqRideDescription = desc; newRr.ReqRideHowToWork = htw; newRr.ReqRideKind = kindR; newRr.ReqRideSafetyInformation = safety; newRr.ReqRideStatus = "Adding.. Waiting Approvement"; DatabaseConnectionHandler.GetInstance().RequestRide.Add(newRr); DatabaseConnectionHandler.GetInstance().SaveChanges(); }
public static void reqDelAtt(int id, string name, string desc, string htw, string wp, DateTime launchDate) { RequestAttraction newRa = new RequestAttraction(); newRa.EmployeeId = LoginHandler.idEmp; newRa.ReqAttName = name; newRa.ReqAttDescription = desc; newRa.ReqAttHowToWork = htw; newRa.ReqAttWhoParticipant = wp; newRa.ReqAttStartDateLaunch = launchDate; newRa.ReqAttStatus = "Removing.. Waiting Approvement"; DatabaseConnectionHandler.GetInstance().RequestAttraction.Add(newRa); DatabaseConnectionHandler.GetInstance().SaveChanges(); }
public static void sendConstruction(int id) { var rslt = DatabaseConnectionHandler.GetInstance().Ride.Where(x => x.RideId == id).FirstOrDefault(); if (rslt.RideStatus.Contains("Add")) { rslt.RideStatus = "Adding.. Waiting for constructing"; } else if (rslt.RideStatus.Contains("Upd")) { rslt.RideStatus = "Update.. Waiting for constructing"; } else if (rslt.RideStatus.Contains("Rem")) { rslt.RideStatus = "Removing.. Waiting for constructing"; } DatabaseConnectionHandler.GetInstance().SaveChanges(); }
public static string generateTicketId() { Ticket tc = DatabaseConnectionHandler.GetInstance().Ticket.ToArray().LastOrDefault(); ticketId = tc.TicketId.Substring(8); string id = "" + (Int32.Parse(ticketId) + 1); string nol = ""; if (id.Length == 1) { nol = "00"; } else if (id.Length == 2) { nol = "0"; } else if (id.Length == 3) { nol = ""; } ticketId = DateTime.Now.ToString("yyyyMMdd") + nol + id; return(ticketId); }
public static string getEmployeeDepartment(int id) { var rslt = DatabaseConnectionHandler.GetInstance().Employee.Where(x => x.EmployeeId.Equals(id)).FirstOrDefault(); return(rslt.EmployeeDepartment.EmployeeDepartmentName); }