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