public static void Initialize(KioskContext context) { if (!context.Kiosks.Any()) { context.Kiosks.AddRange( new Kiosk { Nomer = "1", ModelKioska = "C", Arenda = DateTime.Now.Date, Town = Towns.Гомель, Adress = "Ленина", Area = 10 }, new Kiosk { Nomer = "2", ModelKioska = "X", Arenda = DateTime.Now.Date, Town = Towns.Брагин, Adress = "Победы", Area = 15 }, new Kiosk { Nomer = "3", ModelKioska = "C", Arenda = DateTime.Now.Date, Town = Towns.Добруш, Adress = "Ильича", Area = 8 }, new Kiosk { Nomer = "4", ModelKioska = "X", Arenda = DateTime.Now.Date, Town = Towns.Гомель, Adress = "Советская", Area = 5 }, new Kiosk { Nomer = "5", ModelKioska = "Павильон", Arenda = DateTime.Now.Date, Town = Towns.Гомель, Adress = "Рогачевская", Area = 20 } ); context.SaveChanges(); } }
protected void Page_Load(object sender, EventArgs e) { //To get the string to cancel reservation table string userID = Request.QueryString["UserID"]; string facilityReservationID = Request.QueryString["FacilityReservationID"]; string reason = Request.QueryString["Reason"]; FRSWS.WSfrsClient ws = new FRSWS.WSfrsClient(); //call the NYP delFRSEntries method to insert to database string result = HttpUtility.UrlDecode(ws.delFRSEntries(facilityReservationID, "S1999557YF", "S1999557YF", reason)); //split the string result //if 0~ , success //else -1~ERRORMESSAGE....., error string[] tokens = result.Split(new[] { "~" }, StringSplitOptions.None); //if successfully return OK if (tokens[0] == "0") { //trigger a refresh of the cache database!!! ** using (var db = new KioskContext()) { db.Database.ExecuteSqlCommand( "DELETE FacilityReservation WHERE FacilityReservationID = '" + facilityReservationID + "'"); } //returns ok/error message to caller Response.Write("{"); Response.Write(" Result: \"OK\","); Response.Write(" Message: \"The facility reservation is cancelled from NYP's database successfully.\""); Response.Write("}"); Response.End(); } else { Response.Write("{"); //returns ok/error message to caller Response.Write(" Result: \"ERROR\","); Response.Write(" Message: \"" + tokens[1] + "\""); Response.Write("}"); Response.End(); } }
protected void Page_Load(object sender, EventArgs e) { //To get the string to search in facility table string departmentID = Request.QueryString["DepartmentID"]; string block = Request.QueryString["Block"]; string level = Request.QueryString["Level"]; string name = Request.QueryString["Name"]; //test if correct //Only select from a certain department //select the database for the list of facility that contains //block, level, name (%) var sqlFacList = new FacList(); sqlFacList.Facilities = new List<FacObject>(); using (var db = new KioskContext()) { var facilitys = from f in db.Facilitys where f.Department.DepartmentID == departmentID && (f.Block.Contains(block) && f.Level.Contains(level) && f.Name.Contains(name)) orderby f.FacilityID select new { f.FacilityID, f.DepartmentID, f.Description, f.Block, f.Level, f.Name, f.OpenHours, f.CloseHours, f.MaxBkTime, f.MaxBkUnits, f.MinBkTime, f.MinBkUnits}; foreach (var fac in facilitys) { FacObject facobject = new FacObject(fac.FacilityID, fac.DepartmentID, fac.Description, fac.Block, fac.Level, fac.Name, fac.OpenHours, fac.CloseHours, fac.MaxBkTime, fac.MaxBkUnits, fac.MinBkTime, fac.MinBkUnits); sqlFacList.Facilities.Add(facobject); } } //Serialize into json format output (string) string json = JsonConvert.SerializeObject(sqlFacList, Formatting.Indented); //codes to pass back the json string to the iPad Response.Write(json); Response.End(); }
protected void Page_Load(object sender, EventArgs e) { //To get the string to search in depfilter table string departmentID = Request.QueryString["DepartmentID"]; var sqlFilList = new FilterList(); sqlFilList.Filters = new List<FilterObject>(); using (var db = new KioskContext()) { //selects only from departmentfilter where department ID = SIT [Querystring] var depfilters = from df in db.DepartmentFilters where df.Department.DepartmentID == departmentID orderby df.FilterName select new { df.DepartmentFilterID, df.DepartmentID, df.FilterName, df.Block, df.Level, df.Name, }; foreach (var fil in depfilters) { FilterObject filobject = new FilterObject(fil.DepartmentFilterID, fil.DepartmentID, fil.FilterName, fil.Block, fil.Level, fil.Name); sqlFilList.Filters.Add(filobject); } } //Serialize into json format output (string) string json = JsonConvert.SerializeObject(sqlFilList, Formatting.Indented); //codes to pass back the json string to the iPad Response.Write(json); Response.End(); }
public ProductRepository(KioskContext kiosk) { Kiosk = kiosk; }
public ReviewRepository(KioskContext kiosk) { Kiosk = kiosk; }
protected void Page_Load(object sender, EventArgs e) { //To get the string to search in facility table string departmentID = Request.QueryString["DepartmentID"]; string block = Request.QueryString["Block"]; string level = Request.QueryString["Level"]; string name = Request.QueryString["Name"]; //format of date yyyy-MMM-dd string date = Request.QueryString["Date"]; var sqlResList = new ResList(); sqlResList.Reservations = new List<ResObject>(); //if date is blank, return current system date if( date == "" ) { DateTime dateToday = DateTime.Today; DateTime dateStart = new DateTime(dateToday.Year, dateToday.Month, dateToday.Day, 08, 00, 00); DateTime dateEnd = new DateTime(dateToday.Year, dateToday.Month, dateToday.Day, 18, 00, 00); using (var db = new KioskContext()) { var facilityRes = from fr in db.FacilityReservations where fr.Facility.Department.DepartmentID == departmentID && fr.Facility.Block.Contains(block) && fr.Facility.Level.Contains(level) && fr.Facility.Name.Contains(name) && fr.StartDateTime >= dateStart && fr.EndDateTime <= dateEnd orderby fr.FacilityID, fr.StartDateTime select new { fr.FacilityReservationID, fr.FacilityID, fr.StartDateTime, fr.EndDateTime, fr.UseShortDescription, fr.UseDescription }; foreach (var res in facilityRes) { ResObject resobject = new ResObject(res.FacilityReservationID, res.FacilityID, res.StartDateTime.Value, res.EndDateTime.Value, res.UseShortDescription, res.UseDescription); sqlResList.Reservations.Add(resobject); } } //Serialize into json format output (string) string json = JsonConvert.SerializeObject(sqlResList, Formatting.Indented); //codes to pass back the json string to the iPad Response.Write(json); Response.End(); } //else return only specified date else { //convert string date to datetime DateTime datePass = DateTime.ParseExact(date, "yyyy-MMM-dd", CultureInfo.InvariantCulture); DateTime dateStart = new DateTime(datePass.Year, datePass.Month, datePass.Day, 08, 00, 00); DateTime dateEnd = new DateTime(datePass.Year, datePass.Month, datePass.Day, 18, 00, 00); using (var db = new KioskContext()) { var facilityRes = from fr in db.FacilityReservations where fr.Facility.Department.DepartmentID == departmentID && fr.Facility.Block.Contains(block) && fr.Facility.Level.Contains(level) && fr.Facility.Name.Contains(name) && fr.StartDateTime >= dateStart && fr.EndDateTime <= dateEnd orderby fr.FacilityID, fr.StartDateTime select new { fr.FacilityReservationID, fr.FacilityID, fr.StartDateTime, fr.EndDateTime, fr.UseShortDescription, fr.UseDescription }; foreach (var res in facilityRes) { ResObject resobject = new ResObject(res.FacilityReservationID, res.FacilityID, res.StartDateTime.Value, res.EndDateTime.Value, res.UseShortDescription, res.UseDescription); sqlResList.Reservations.Add(resobject); } } //Serialize into json format output (string) string json = JsonConvert.SerializeObject(sqlResList, Formatting.Indented); //logging string year = DateTime.Now.Year.ToString(); string month = DateTime.Now.Month.ToString(); string day = DateTime.Now.Day.ToString(); string fulldateTime = DateTime.Now.ToString(); string full = "[Executed on " + fulldateTime + " ]"; string path = "c:\\LogTest\\GetFacilityReservations-" + year + "-" + month + "-" + day + ".txt"; string line = "-----------------------------------------------------"; using (StreamWriter file = (File.Exists(path)) ? File.AppendText(path) : File.CreateText(path)) { file.WriteLine(full); file.WriteLine(line); file.Close(); } //codes to pass back the json string to the iPad Response.Write(json); Response.End(); } }
protected void Page_Load(object sender, EventArgs e) { //To get the string to create new reservation table string userType = Request.QueryString["UserType"]; string userID = Request.QueryString["UserID"]; string facilityID = Request.QueryString["FacilityID"]; string startDateTime = Request.QueryString["StartDateTime"]; string endDateTime = Request.QueryString["EndDateTime"]; string description = Request.QueryString["Description"]; //change the date and time info if necessary // see what is passed in to to the startDateTime & endDateTime DateTime startDate = DateTime.ParseExact(startDateTime, "dd-MMM-yyyy HH:mm", CultureInfo.InvariantCulture); DateTime endDate = DateTime.ParseExact(endDateTime, "dd-MMM-yyyy HH:mm", CultureInfo.InvariantCulture); string startDateString = startDate.ToString("dd-MMM-yyyy"); string startTimeString = startDate.ToString("HH:mm"); string endDateString = endDate.ToString("dd-MMM-yyyy"); string endTimeString = endDate.ToString("HH:mm"); FRSWS.WSfrsClient ws = new FRSWS.WSfrsClient(); //call the NYP saveFRSEntries method to insert to database string result = HttpUtility.UrlDecode(ws.saveFRSEntries("STAFF", "S1999557YF", "STAFF", "S1999557YF", facilityID, "", "", startDateString, endDateString, startTimeString, endTimeString, "Y", "Y", description, "N", "", "", "", "", "", "")); //split the string result //if 0~ , success //else -1~ERRORMESSAGE....., error string[] tokens = result.Split(new[] { "~" }, StringSplitOptions.None); //if successfully return OK if (tokens[0] == "0") { //trigger a refresh of the cache database!!! ** using (var db = new KioskContext()) { FacilityReservation reser = new FacilityReservation(); Random r = new Random(); //set all fields here reser.FacilityReservationID = "T" + DateTime.Now.ToString("MMddHHmmSS") + "_" + r.Next(9999).ToString("0000"); reser.FacilityID = facilityID; reser.StartDateTime = startDate; reser.EndDateTime = endDate; reser.UseDescription = description; db.Reservations.Add(reser); db.SaveChanges(); } //returns ok/error message to caller Response.Write("{"); Response.Write(" Result: \"OK\","); Response.Write(" Message: \"The facility reservation is received and inserted into NYP's database successfully.\""); Response.Write("}"); Response.End(); } else { //returns ok/error message to caller Response.Write("{"); Response.Write(" Result: \"ERROR\","); Response.Write(" Message: \"" + tokens[1] + "\""); Response.Write("}"); Response.End(); } }
public HomeController(KioskContext context, ILogger <HomeController> logger) //ILogger<HomeController> logger { _logger = logger; db = context; }
//******write codes to return OK/Error Message to the Mr Chow's console app!!!!!!**** protected void Page_Load(object sender, EventArgs e) { //Get the department ID and json string pass to my webservice string departmentID = Request.QueryString["DepartmentID"]; string json = Request.Form["Json"]; //count the number of exception catch from db.SaveChanges int exceptionCount = 0; if (departmentID != null && json != null) { //store the deserialized json array to a list of reservations ReservationList list = JsonConvert.DeserializeObject<ReservationList>(json); using (var db = new KioskContext()) { //delete the whole FacilityReservation Table //db.Database.ExecuteSqlCommand( // "DELETE FacilityReservation"); //FROM Department INNER JOIN Facility ON Department.DepartmentID = Facility.DepartmentID " + //"INNER JOIN FacilityReservation ON Facility.FacilityID = FacilityReservation.FacilityID WHERE Department.DepartmentID = '" + departmentID + "'"); // DELETE reservations records not found in the list // Hashtable listOfReservationIDs = new Hashtable(); var reservationIDs = from r in db.Reservations select new { r.FacilityReservationID }; foreach(var reservationID in reservationIDs) listOfReservationIDs[reservationID.FacilityReservationID] = 1; foreach (Reservation res in list.Reservations) listOfReservationIDs.Remove(res.facilityReservationID); foreach (string reservationIDToDelete in listOfReservationIDs.Keys) { db.Database.ExecuteSqlCommand( "DELETE FacilityReservation WHERE FacilityReservationID = '" + reservationIDToDelete + "'"); } db.SaveChanges(); //loop through each reservations and insert into the database //record by record foreach (Reservation res in list.Reservations) { var reservations = from r in db.Reservations where r.FacilityReservationID == res.facilityReservationID select r; if (reservations.Count() > 0) { // Record exists, just update. foreach(var reservation in reservations) { reservation.FacilityID = res.facilityID; reservation.StartDateTime = res.startDateTime; reservation.EndDateTime = res.endDateTime; reservation.UseDescription = res.useDescription; reservation.UseShortDescription = res.useShortDescription; break; } } else { // Record does not exist, insert. FacilityReservation reser = new FacilityReservation(); //set all fields here reser.FacilityReservationID = res.facilityReservationID; reser.FacilityID = res.facilityID; reser.StartDateTime = res.startDateTime; reser.EndDateTime = res.endDateTime; reser.UseShortDescription = res.useShortDescription; reser.UseDescription = res.useDescription; db.Reservations.Add(reser); } } try { db.SaveChanges(); } catch (Exception) { exceptionCount += 1; } } //returns in Json format Response.Write("{"); Response.Write(" Result: \"OK\""); Response.Write(" Message: \"The record is received and inserted into database successfully. " + exceptionCount + " records not inserted possibly due to duplicate primary key or some other errors.\""); Response.Write("}"); Response.End(); } else { Response.Write("{"); Response.Write(" Result: \"ERROR\""); Response.Write(" Message: \"There is an error occured and data cannot be received.\""); Response.Write("}"); Response.End(); } }
public IceCreamRepository(KioskContext kiosk) { Kiosk = kiosk; }
public StoreRepository(KioskContext kiosk) { Kiosk = kiosk; }