public bool cancelRequest(int aRequestId)
{
PsDbContex db = new PsDbContex();
List <Booking> data;
try
{
var el = from r in db.Bookings
where r.ID == aRequestId
select r;
data = el.ToList();
if (data.Count != 1)
{
return(false);
}
db.Bookings.Remove(data[0]);
db.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
public List <Booking> getAllBookings(int aOwnerId)
{
PsDbContex db = new PsDbContex();
List <ParkingPlace> placeData;
try
{
var el = from r in db.ParkingPlaces
where r.OwnerId == aOwnerId
select r;
placeData = el.ToList();
}
catch
{
return(null);
}
/**********************************************************************/
List <Booking> data = new List <Booking>();
for (int i = 0; i < placeData.Count; i++)
{
int placeId = placeData[i].ID;
Booking el = db.Bookings.SingleOrDefault(r => r.PlaceId == placeId);
if (el != null)
{
data.Add(el);
}
}
return(data);
}
//pending = 0 and active = 1
public bool acceptRequest(int aRequestId)
{
// Caution: Update May Not Work..
PsDbContex db = new PsDbContex();
List <Booking> data;
try
{
var el = from r in db.Bookings
where r.ID == aRequestId
select r;
data = el.ToList();
}
catch
{
return(false);
}
if (data.Count != 1)
{
return(false);
}
data[0].IsPending = 0;
db.SaveChanges();
return(true);
}
public string getFacility(int placeId)
{
PsDbContex db = new PsDbContex();
List <Facility> data = new List <Facility>();
var el = from r in db.Facilities
where r.Popularity == placeId
select r;
data = el.ToList();
if (data.Count == 0)
{
return("N/A");
}
else
{
string str = "\n";
for (int i = 0; i < data.Count; i++)
{
str += data[i].Description;
}
return(str);
}
}
public int login(string aUserName, string password)
{
PsDbContex db = new PsDbContex();
List <LogInInfo> logs;
try
{
var res = from info in db.LogInfos
where info.Username == aUserName && info.Password == password
select info;
logs = res.ToList();
}
catch (Exception ex)
{
return(0);
}
if (logs.Count == 1)
{
return(logs[0].ID);
}
else
{
return(0);
}
}
public bool register(LogInInfo log, User aUser)
{
PsDbContex db = new PsDbContex();
LogInInfo el = db.LogInfos.SingleOrDefault(r => r.Username == log.Username);
if (el != null)
{
return(false);
}
LogInInfo newInfo = new LogInInfo
{
ID = 10,
Username = log.Username,
Password = log.Password,
Type = 1,
IsBlocked = 0
};
db.LogInfos.Add(newInfo);
db.SaveChanges();
string _username = log.Username;
List <LogInInfo> logs;
try
{
var res = from info in db.LogInfos
where info.Username == _username
select info;
logs = res.ToList();
}
catch (Exception ex)
{
return(false);
}
if (logs.Count != 1)
{
return(false);
}
User newUser = new User
{
ID = 10,
UserId = logs[0].ID,
Email = aUser.Email,
Mobile = aUser.Mobile,
CarModel = aUser.CarModel,
LicensNumber = aUser.LicensNumber
};
db.Users.Add(newUser);
db.SaveChanges();
return(true);
}
// GET: Test
public string GetRat()
{
int pId = 7;
PsDbContex db = new PsDbContex();
var rat = db.PlaceReviews.Where(r => r.ToPlaceId == pId).Average(r => r.Rating);
return(rat.ToString());
}
public int setNewFacilty(Facility aFacility)
{
PsDbContex db = new PsDbContex();
var x = db.Facilities.Add(aFacility);
db.SaveChanges();
return(x.ID);
}
public bool createOffer(Offer aOffer)
{
PsDbContex db = new PsDbContex();
db.Offers.Add(aOffer);
db.SaveChanges();
return(true);
}
public int RequestPlace(Booking book)
{
PsDbContex db = new PsDbContex();
var x = db.Bookings.Add(book);
db.SaveChanges();
return(x.ID);
}
public int createPlace(ParkingPlace aParkingPlace)
{
PsDbContex db = new PsDbContex();
var x = db.ParkingPlaces.Add(aParkingPlace);
db.SaveChanges();
return(x.ID);
}
public int SubscribePlace(Subscriptions sub)
{
PsDbContex db = new PsDbContex();
var x = db.Subscriptions.Add(sub);
db.SaveChanges();
return(x.ID);
}
public bool createPromo(Promo aPromo)
{
PsDbContex db = new PsDbContex();
db.Promos.Add(aPromo);
db.SaveChanges();
return(true);
}
public bool createReview(Review aReview)
{
aReview.Time = DateTime.Today;
PsDbContex db = new PsDbContex();
db.Reviews.Add(aReview);
db.SaveChanges();
return(true);
}
public Booking getBookInfo(int id)
{
PsDbContex db = new PsDbContex();
Booking el = db.Bookings.SingleOrDefault(r => r.ID == id);
if (el == null)
{
return(el);
}
return(el);
}
public int createPlaceReview(PlaceReview rev)
{
rev.Time = DateTime.Today;
PsDbContex db = new PsDbContex();
var x = db.PlaceReviews.Add(rev);
db.SaveChanges();
return(x.ID);
}
public Subscriptions getSubInfo(int id)
{
PsDbContex db = new PsDbContex();
Subscriptions el = db.Subscriptions.SingleOrDefault(r => r.ID == id);
if (el == null)
{
return(el);
}
return(el);
}
public string getUsername(int id)
{
PsDbContex db = new PsDbContex();
LogInInfo el = db.LogInfos.SingleOrDefault(r => r.ID == id);
if (el == null)
{
return("undefined");
}
return(el.Username);
}
public int getType(int id)
{
PsDbContex db = new PsDbContex();
LogInInfo el = db.LogInfos.SingleOrDefault(r => r.ID == id);
if (el == null)
{
return(-1);
}
return(el.Type);
}
public ParkingPlace getPlaceInfo(int id)
{
PsDbContex db = new PsDbContex();
ParkingPlace el = new ParkingPlace()
{
SpotName = "DEBUG"
};
el = db.ParkingPlaces.SingleOrDefault(r => r.ID == id);
//if (el == null) return el;
return(el);
}
public bool bookPlace(Booking aBooking, int aUserId)
{
aBooking.UserId = aUserId;
aBooking.IsPending = 0;
PsDbContex db = new PsDbContex();
db.Bookings.Add(aBooking);
db.SaveChanges();
return(true);
}
public List <ParkingPlace> getPlaceInfo2(int id)
{
PsDbContex db = new PsDbContex();
ParkingPlace el = db.ParkingPlaces.SingleOrDefault(r => r.ID == id);
List <ParkingPlace> li = new List <ParkingPlace>();
li.Add(el);
if (el == null)
{
return(li);
}
return(li);
}
public bool deletePlace(int aPlaceId)
{
PsDbContex db = new PsDbContex();
ParkingPlace el = db.ParkingPlaces.SingleOrDefault(r => r.ID == aPlaceId);
if (el == null)
{
return(false);
}
db.ParkingPlaces.Remove(el);
db.SaveChanges();
return(true);
}
public List <ParkingPlace> getMatchedPlaces(string match)
{
PsDbContex db = new PsDbContex();
List <ParkingPlace> data;
try
{
var el = from r in db.ParkingPlaces
where r.SpotLocation.Contains(match) || r.SpotName.Contains(match)
select r;
data = el.ToList();
}
catch
{
return(null);
}
return(data);
/*List<ParkingPlace> data = new List<ParkingPlace>();
* ParkingPlace p1 = new ParkingPlace()
* {
* ID = 10,
* OwnerId = 15,
* PricePerHour = 5.0,
* SpotName = "SpotA"
* };
* ParkingPlace p2 = new ParkingPlace()
* {
* ID = 10,
* OwnerId = 15,
* PricePerHour = 5.0,
* SpotName = "SpotB"
* };
* ParkingPlace p3 = new ParkingPlace()
* {
* ID = 10,
* OwnerId = 15,
* PricePerHour = 5.0,
* SpotName = "SpotC"
* };
*
* data.Add(p1);
* data.Add(p2);
* data.Add(p3);
* return data;*/
}
public bool blockUser(int userId)
{
// Caution: Update May Not Work..
PsDbContex db = new PsDbContex();
LogInInfo el = db.LogInfos.SingleOrDefault(r => r.ID == userId);
if (el == null)
{
return(false);
}
el.IsBlocked = 0;
db.SaveChanges();
return(true);
}
public List <ParkingPlace> getAllPlaces()
{
PsDbContex db = new PsDbContex();
List <ParkingPlace> data;
try
{
var el = from r in db.ParkingPlaces select r;
data = el.ToList();
}
catch
{
return(null);
}
return(data);
}
public bool approvePlace(int aPlaceId)
{
// Caution: Update May Not Work..
PsDbContex db = new PsDbContex();
ParkingPlace el = db.ParkingPlaces.SingleOrDefault(r => r.ID == aPlaceId);
if (el == null)
{
return(false);
}
el.IsBlocked = 0;
db.SaveChanges();
return(true);
}
public string Chk()
{
PlaceReview rev = new PlaceReview()
{
CarUserId = 2,
Time = DateTime.Today.Date,
ToPlaceId = 7,
Rating = 5,
Comment = "OK"
};
PsDbContex db = new PsDbContex();
var x = db.PlaceReviews.Add(rev);
db.SaveChanges();
return(x.ID.ToString());
}
public bool registerAdmin()
{
LogInInfo newUser = new LogInInfo
{
ID = 10,
Username = "******",
Password = "******",
Type = 3,
IsBlocked = 0
};
PsDbContex db = new PsDbContex();
db.LogInfos.Add(newUser);
db.SaveChanges();
return(true);
}
public IEnumerable <Owner> getOwners()
{
PsDbContex db = new PsDbContex();
List <Owner> data;
try
{
var el = from r in db.Owners
select r;
data = el.ToList();
}
catch
{
return(null);
}
return(data);
}
