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