public static void FinishDeleteRide(Ride ride) { var rslt = DatabaseSingleton.GetInstance().Rides.Where(x => x.RideID == ride.RideID).FirstOrDefault(); rslt.RideStatus_ = "Deleted"; DatabaseSingleton.GetInstance().SaveChanges(); }
public static void AcceptAttraction(int id, String action) { var rslt = DatabaseSingleton.GetInstance().RequestAttractions.Where(x => x.RequestAttractionID == id).FirstOrDefault(); rslt.AttractionStatus = action; DatabaseSingleton.GetInstance().SaveChanges(); }
public static void ProgressAdd(Ride ride) { var rslt = DatabaseSingleton.GetInstance().Rides.Where(x => x.RideID == ride.RideID).FirstOrDefault(); rslt.RideStatus_ = "In Progress To Add"; DatabaseSingleton.GetInstance().SaveChanges(); }
public static void RejectingPurchaseRequest(PurchaseRequest purchaseRequest) { var rslt = DatabaseSingleton.GetInstance().PurchaseRequests.Where(x => x.PurchaseID == purchaseRequest.PurchaseID).FirstOrDefault(); rslt.PurchaseStatus = "Rejected"; DatabaseSingleton.GetInstance().SaveChanges(); }
public static void WaitingFundRequest(int id) { var rslt = DatabaseSingleton.GetInstance().PurchaseRequests.Where(x => x.PurchaseID == id).FirstOrDefault(); rslt.PurchaseStatus = "Waiting For Fund"; DatabaseSingleton.GetInstance().SaveChanges(); }
public static void AcceptRide(int id, String action) { var rslt = DatabaseSingleton.GetInstance().RequestRides.Where(x => x.RequestRideID == id).FirstOrDefault(); rslt.RideStatus_ = action; DatabaseSingleton.GetInstance().SaveChanges(); }
public static void deleteAttraction(RequestAttraction requestAttraction) { var rslt = DatabaseSingleton.GetInstance().Attractions.Where(x => x.AttractionID == requestAttraction.AttractionID).FirstOrDefault(); rslt.AttractionStatus = "Deleted"; DatabaseSingleton.GetInstance().SaveChanges(); }
public static void FinishRequestRide(int id) { var rslt = DatabaseSingleton.GetInstance().RequestRides.Where(x => x.RequestRideID == id).FirstOrDefault(); rslt.RideStatus_ = "Applied to Construct"; DatabaseSingleton.GetInstance().SaveChanges(); }
public static void RejectingFundRequest(int id) { var rslt = DatabaseSingleton.GetInstance().FundRequests.Where(x => x.FundId == id).FirstOrDefault(); rslt.FundStatus = "Rejected"; DatabaseSingleton.GetInstance().SaveChanges(); }
public static void RejectRide(int id) { var rslt = DatabaseSingleton.GetInstance().RequestRides.Where(x => x.RequestRideID == id).FirstOrDefault(); rslt.RideStatus_ = "Rejected"; DatabaseSingleton.GetInstance().SaveChanges(); }
public static void deleteRide(RequestRide ride) { var rslt = DatabaseSingleton.GetInstance().Rides.Where(x => x.RideID == ride.RideID).FirstOrDefault(); rslt.RideStatus_ = "Waiting For Construction To Delete"; DatabaseSingleton.GetInstance().SaveChanges(); }
public static void Delete(Ingredient newIngredient) { var rslt = DatabaseSingleton.GetInstance().Ingredients.Where(x => x.IngredientID == newIngredient.IngredientID).FirstOrDefault(); rslt.IngredientStatus = "Deleted"; DatabaseSingleton.GetInstance().SaveChanges(); }
public static void FinishRequestAttraction(int id) { var rslt = DatabaseSingleton.GetInstance().RequestAttractions.Where(x => x.RequestAttractionID == id).FirstOrDefault(); rslt.AttractionStatus = "Finish"; DatabaseSingleton.GetInstance().SaveChanges(); }
public static void deleteTransaction(int id) { var rslt = DatabaseSingleton.GetInstance().TicketTransactions.Where(x => x.TicketTransactionID == id).FirstOrDefault(); rslt.TransactionStauts = "Deleted"; DatabaseSingleton.GetInstance().SaveChanges(); }
public static void updateQty(int qty, int id) { var rslt = DatabaseSingleton.GetInstance().TicketTransactions.Where(x => x.TicketTransactionID == id).FirstOrDefault(); rslt.Quantity = qty; DatabaseSingleton.GetInstance().SaveChanges(); }
public static void insertTicket() { Ticket newTc = new Ticket(); newTc.TicketID = ticketId; DatabaseSingleton.GetInstance().Tickets.Add(newTc); DatabaseSingleton.GetInstance().SaveChanges(); }
public static void UpdateAds(Advertisement newAds) { Advertisement rd = DatabaseSingleton.GetInstance().Advertisements.Where(x => x.AdvertisementID == newAds.AdvertisementID).FirstOrDefault(); rd.AdvertisementDescription = newAds.AdvertisementDescription; rd.AdvertisementStatus = newAds.AdvertisementStatus; rd.EmployeeID = rd.EmployeeID; rd.Deadline = newAds.Deadline; DatabaseSingleton.GetInstance().SaveChanges(); }
public static void Update(Ingredient newIngredient) { Ingredient rd = DatabaseSingleton.GetInstance().Ingredients.Where(x => x.IngredientID == newIngredient.IngredientID).FirstOrDefault(); rd.IngredientName = newIngredient.IngredientName; rd.IngredientStock = newIngredient.IngredientStock; rd.IngredientStatus = "Active"; DatabaseSingleton.GetInstance().SaveChanges(); }
public static void insertRecordTicketTransaction(DateTime date, int qty) { TicketTransaction newTct = new TicketTransaction(); newTct.TicketDate = date; newTct.Quantity = qty; newTct.TransactionStauts = "Active"; DatabaseSingleton.GetInstance().TicketTransactions.Add(newTct); DatabaseSingleton.GetInstance().SaveChanges(); }
public static void UpdateAttraction(RequestAttraction requestAttraction) { Attraction rd = DatabaseSingleton.GetInstance().Attractions.Where(x => x.AttractionID == requestAttraction.AttractionID).FirstOrDefault(); rd.AttractionName = requestAttraction.AttractionName; rd.AttractionDescription = requestAttraction.AttractionDescription; rd.AttractionHowToWork = requestAttraction.AttractionHowToWork; rd.AttractionStartDate = requestAttraction.AttractionStartDate; rd.AttractionParticipant = requestAttraction.AttractionParticipant; DatabaseSingleton.GetInstance().SaveChanges(); }
public static Employee DoSearchEmployee(String username, String password) { Employee employee = DatabaseSingleton.GetInstance().Employees.Where(x => x.EmployeeUsername.Equals(username) && x.EmployeePassword.Equals(password)).FirstOrDefault(); if (employee == null || employee.EmployeeBannedStatus.Equals("True")) { return(null); } return(employee); }
public static void UpdateRide(RequestRide requestedRide) { Ride rd = DatabaseSingleton.GetInstance().Rides.Where(x => x.RideID == requestedRide.RideID).FirstOrDefault(); rd.RideName = requestedRide.RideName; rd.RideDescription = requestedRide.RideDescription; rd.RideHowToWork = requestedRide.RideHowToWork; rd.RideType = requestedRide.RideType; rd.RideSafetyInformation = requestedRide.RideSafetyInformation; rd.RideStatus_ = "Waiting For Construction To Update"; DatabaseSingleton.GetInstance().SaveChanges(); }
public static void CreateRide(RequestRide requestedRide) { Ride rd = new Ride(); rd.RideName = requestedRide.RideName; rd.RideDescription = requestedRide.RideDescription; rd.RideHowToWork = requestedRide.RideHowToWork; rd.RideType = requestedRide.RideType; rd.RideSafetyInformation = requestedRide.RideSafetyInformation; rd.RideStatus_ = "Waiting For Construction To Add"; DatabaseSingleton.GetInstance().Rides.Add(rd); DatabaseSingleton.GetInstance().SaveChanges(); }
public static void CreateRide(RequestAttraction requestedAttraction) { Attraction rd = new Attraction(); rd.AttractionName = requestedAttraction.AttractionName; rd.AttractionDescription = requestedAttraction.AttractionDescription; rd.AttractionHowToWork = requestedAttraction.AttractionHowToWork; rd.AttractionStartDate = requestedAttraction.AttractionStartDate; rd.AttractionParticipant = requestedAttraction.AttractionParticipant; rd.AttractionStatus = "Active"; DatabaseSingleton.GetInstance().Attractions.Add(rd); DatabaseSingleton.GetInstance().SaveChanges(); }
public static string generateTicketId() { Ticket tc = DatabaseSingleton.GetInstance().Tickets.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 RequestAttraction SearchByID(int id) { return(DatabaseSingleton.GetInstance().RequestAttractions.Where(x => x.RequestAttractionID == id).FirstOrDefault()); }
public static void CreateAdvertisement(Advertisement newAds) { newAds.AdvertisementStatus = "Active"; DatabaseSingleton.GetInstance().Advertisements.Add(newAds); DatabaseSingleton.GetInstance().SaveChanges(); }
public static void CreateRequestAttraction(RequestAttraction newRequest) { DatabaseSingleton.GetInstance().RequestAttractions.Add(newRequest); DatabaseSingleton.GetInstance().SaveChanges(); }
public static Advertisement SearchByID(int id) { return DatabaseSingleton.GetInstance().Advertisements.Where(x => x.AdvertisementID == id).FirstOrDefault(); }
public static void DeleteAds(Advertisement newAds) { var rslt = DatabaseSingleton.GetInstance().Advertisements.Where(x => x.AdvertisementID == newAds.AdvertisementID).FirstOrDefault(); rslt.AdvertisementStatus = "Deleted"; DatabaseSingleton.GetInstance().SaveChanges(); }