public string registerUser(User objUser)
{
string objMesaje = "-1";
try
{
using (ParkingDataClassesDataContext sql = new ParkingDataClassesDataContext(cadenaConexion))
{
user objuser = new user
{
email = objUser.email,
lastName = objUser.lastName,
name = objUser.name,
password = objUser.password,
registerDate = DateTime.Now,
status = true,
};
sql.users.InsertOnSubmit(objuser);
sql.SubmitChanges();
objMesaje = "0";
};
}
catch (Exception ex)
{
objMesaje = ex.Message;
}
return(objMesaje);
}
public string updteParkingSpace(ParkingSpace objParkingSpace)
{
string objMesaje = "-1";
try
{
using (var sql = new ParkingDataClassesDataContext(cadenaConexion))
{
var objparkingSpace = sql.parkingSpaces.Single(x => x.parkingSpaceID == objParkingSpace.parkingSpaceID);
objparkingSpace.parkingLotID = objParkingSpace.parkingLotID;
objparkingSpace.parkingSpaceID = objParkingSpace.parkingSpaceID;
objparkingSpace.shortName = objParkingSpace.shortName;
objparkingSpace.status = objParkingSpace.status;
sql.SubmitChanges();
objMesaje = "0";
};
}
catch (Exception ex)
{
objMesaje = ex.Message;
}
return(objMesaje);
}
public string updteReservation(Reservation objReservation)
{
string objMesaje = "-1";
try
{
using (var sql = new ParkingDataClassesDataContext(cadenaConexion))
{
var objreservation = sql.reservations.Single(x => x.reservationID == objReservation.reservationID);
objreservation.dateReservation = DateTime.Now;
objreservation.startParking = objReservation.startParking;
objreservation.finishParking = objReservation.finishParking;
objreservation.parkingSpaceID = objReservation.parkingSpaceID;
objreservation.userID = objReservation.userID;
objreservation.status = true;
objreservation.reservationID = objReservation.reservationID;
sql.SubmitChanges();
objMesaje = "0";
};
}
catch (Exception ex)
{
objMesaje = ex.Message;
}
return(objMesaje);
}
public string registerReservation(Reservation objReservation)
{
string objMesaje = "-1";
try
{
using (ParkingDataClassesDataContext sql = new ParkingDataClassesDataContext(cadenaConexion))
{
reservation objreservation = new reservation
{
dateReservation = DateTime.Now,
startParking = objReservation.startParking,
finishParking = objReservation.finishParking,
parkingSpaceID = objReservation.parkingSpaceID,
userID = objReservation.userID,
status = true,
};
sql.reservations.InsertOnSubmit(objreservation);
sql.SubmitChanges();
objMesaje = "0";
};
}
catch (Exception ex)
{
objMesaje = ex.Message;
}
return(objMesaje);
}
public string updateUser(User objUser)
{
string objMesaje = "-1";
try
{
using (var sql = new ParkingDataClassesDataContext(cadenaConexion))
{
var objuser = sql.users.Single(x => x.userID == objUser.userID);
objuser.email = objUser.email;
objuser.lastName = objUser.lastName;
objuser.name = objUser.name;
objuser.password = objUser.password;
objuser.registerDate = ConvertirAFecha(objUser.registerDate);
objuser.status = true;
sql.SubmitChanges();
objMesaje = "0";
};
}
catch (Exception ex)
{
objMesaje = ex.Message;
}
return(objMesaje);
}
public string updateProvider(Provider objProvider)
{
string objMesaje = "-1";
try
{
using (var sql = new ParkingDataClassesDataContext(cadenaConexion))
{
var objprovider = sql.providers.Single(x =>
x.providerID == objProvider.providerID);
objprovider.userID = objProvider.userID;
objprovider.status = true;
objprovider.providerID = objProvider.providerID;
sql.SubmitChanges();
objMesaje = "0";
};
}
catch (Exception ex)
{
objMesaje = ex.Message;
}
return(objMesaje);
}
public Reservation getReservation(string reservationID)
{
Reservation objreservation = null;
try
{
using (ParkingDataClassesDataContext SQLDC = new ParkingDataClassesDataContext(cadenaConexion))
{
var lstReser = from rs in SQLDC.reservations
where rs.reservationID == (string.IsNullOrEmpty(reservationID) ? 0 : Convert.ToInt32(reservationID))
select rs;
foreach (reservation objReservation in lstReser)
{
objreservation = new Reservation();
objreservation.parkingSpaceID = objReservation.parkingSpaceID;
objreservation.dateReservation = objReservation.dateReservation;
objreservation.finishParking = objReservation.finishParking;
objreservation.reservationID = objReservation.reservationID;
objreservation.startParking = objReservation.startParking;
objreservation.userID = objReservation.userID;
objreservation.status = objReservation.status;
}
}
}
catch (Exception)
{
throw;
}
return(objreservation);
}
public Provider getProvider(string providerID)
{
Provider objprovider = null;
try
{
using (ParkingDataClassesDataContext SQLDC = new ParkingDataClassesDataContext(cadenaConexion))
{
var lstReser = from rs in SQLDC.providers
where rs.providerID == (string.IsNullOrEmpty(providerID) ?
0 :
Convert.ToInt32(providerID))
select rs;
foreach (provider objProvider in lstReser)
{
objprovider = new Provider();
objprovider.providerID = objProvider.providerID;
objprovider.userID = objProvider.userID;
objprovider.status = objProvider.status;
}
}
}
catch (Exception)
{
throw;
}
return(objprovider);
}
public string registerParkingSpace(ParkingSpace objParkingSpace)
{
string objMesaje = "-1";
try
{
using (ParkingDataClassesDataContext sql = new ParkingDataClassesDataContext(cadenaConexion))
{
parkingSpace objparkingSpace = new parkingSpace
{
parkingSpaceID = objParkingSpace.parkingSpaceID,
parkingLotID = objParkingSpace.parkingLotID,
shortName = objParkingSpace.shortName,
status = true,
};
sql.parkingSpaces.InsertOnSubmit(objparkingSpace);
sql.SubmitChanges();
objMesaje = "0";
};
}
catch (Exception ex)
{
objMesaje = ex.Message;
}
return(objMesaje);
}
public User FindUser(string userID)
{
User objUser = null;
try
{
using (ParkingDataClassesDataContext SQLDC = new ParkingDataClassesDataContext(cadenaConexion))
{
var usuario = from result in SQLDC.users
where result.userID == Convert.ToInt32(userID)
select result;
foreach (var item in usuario)
{
objUser = new User
{
email = item.email,
lastName = item.lastName,
name = item.name,
password = item.password,
registerDate = item.registerDate.HasValue ? item.registerDate.Value.ToString() : DateTime.Now.ToString(),
status = item.status ? "1" : "0",
userID = item.userID
};
}
};
}
catch (Exception ex)
{
throw ex;
}
return(objUser);
}
public string registerUser(string name, string lastname, string email, string password)
{
var json = string.Empty;
JavaScriptSerializer jss = new JavaScriptSerializer();
try
{
ParkingDataClassesDataContext SQLDC = new ParkingDataClassesDataContext();
SQLDC.user.InsertOnSubmit(new user
{
name = name,
lastName = lastname,
email = email,
password = password,
registerDate = DateTime.Now,
});
SQLDC.SubmitChanges();
json = jss.Serialize("OK");
}
catch (Exception ex)
{
json = jss.Serialize(ex.Message);
}
return(json);
}
public string validateUser(string pEmail, string pPassword)
{
var json = string.Empty;
try
{
ParkingDataClassesDataContext SQLDC = new ParkingDataClassesDataContext();
var usuario = from result in SQLDC.user
where result.password == pPassword &&
result.email == pEmail
select result;
JavaScriptSerializer jss = new JavaScriptSerializer();
json = jss.Serialize(usuario);
}
catch (Exception ex)
{
throw ex;
}
return(json);
}
public string deleteReservation(string reservationID)
{
string objMesaje = "-1";
try
{
using (var sql = new ParkingDataClassesDataContext(cadenaConexion))
{
var objreservation = sql.reservations.Single(x =>
x.reservationID == (string.IsNullOrEmpty(reservationID)?0:Convert.ToInt32(reservationID)));
sql.reservations.DeleteOnSubmit(objreservation);
sql.SubmitChanges();
objMesaje = "0";
};
}
catch (Exception ex)
{
objMesaje = ex.Message;
}
return(objMesaje);
}
public ParkingSpace getParkingSpace(string parkingSpaceID)
{
ParkingSpace objParkingSpace = null;
using (ParkingDataClassesDataContext SQLDC = new ParkingDataClassesDataContext(cadenaConexion))
{
var result = from pl in SQLDC.parkingSpaces
where pl.parkingSpaceID == (string.IsNullOrEmpty(parkingSpaceID) ? 0 : Convert.ToInt32(parkingSpaceID))
select pl;
foreach (parkingSpace parkSpa in result)
{
objParkingSpace = new ParkingSpace();
objParkingSpace.parkingSpaceID = parkSpa.parkingSpaceID;
objParkingSpace.parkingLotID = parkSpa.parkingLotID;
objParkingSpace.shortName = parkSpa.shortName;
objParkingSpace.status = parkSpa.status;
}
}
return(objParkingSpace);
}
public List <Reservation> getReservationByUser(string pEmail)
{
List <Reservation> lstReservation = new List <Reservation>();
try
{
using (ParkingDataClassesDataContext SQLDC = new ParkingDataClassesDataContext(cadenaConexion))
{
var objUser = from result in SQLDC.users
where result.email.IndexOf(pEmail) > -1
select new
{
result.userID
};
var lstReser = from rs in SQLDC.reservations
where rs.userID == objUser.SingleOrDefault().userID
select rs;
foreach (reservation objReservation in lstReser)
{
Reservation objreservation = new Reservation();
objreservation.parkingSpaceID = objReservation.parkingSpaceID;
objreservation.dateReservation = objReservation.dateReservation;
objreservation.finishParking = objReservation.finishParking;
objreservation.reservationID = objReservation.reservationID;
objreservation.startParking = objReservation.startParking;
objreservation.userID = objReservation.userID;
objreservation.status = objReservation.status;
lstReservation.Add(objreservation);
}
}
}
catch (Exception)
{
throw;
}
return(lstReservation);
}
public string deleteProvider(string providerID)
{
string objMesaje = "-1";
try
{
using (var sql = new ParkingDataClassesDataContext(cadenaConexion))
{
var objprovider = sql.providers.Single(x =>
x.providerID == (string.IsNullOrEmpty(providerID) ?
0 :
Convert.ToInt32(providerID)));
sql.providers.DeleteOnSubmit(objprovider);
sql.SubmitChanges();
objMesaje = "0";
};
}
catch (Exception ex)
{
objMesaje = ex.Message;
}
return(objMesaje);
}
public string registerProvider(Provider objProvider)
{
string objMesaje = "-1";
try
{
using (ParkingDataClassesDataContext sql = new ParkingDataClassesDataContext(cadenaConexion))
{
provider objprovider = new provider
{
userID = objProvider.userID,
status = true,
};
sql.providers.InsertOnSubmit(objprovider);
sql.SubmitChanges();
objMesaje = "0";
};
}
catch (Exception ex)
{
objMesaje = ex.Message;
}
return(objMesaje);
}
public List <ParkingLot> getParkingLots()
{
List <ParkingLot> lstParkingLot = new List <ParkingLot>();
try
{
using (ParkingDataClassesDataContext SQLDC = new ParkingDataClassesDataContext(cadenaConexion))
{
var parkingLot = from pl in SQLDC.parkingLots
join pv in SQLDC.providers
on pl.providerID equals pv.providerID
join us in SQLDC.users
on pv.userID equals us.userID
join dt in SQLDC.disctricts
on pl.districtId equals dt.districtId
join pr in SQLDC.provinces
on dt.provinceId equals pr.provinceId
join dp in SQLDC.departments
on pr.departmentId equals dp.departmentId
where pl.parkingLotID <= 15
select new
{
pl.address,
pl.closeTime,
pl.description,
pl.disctrict,
pl.districtId,
pl.latitude,
pl.LocalPhone,
pl.longitud,
pl.name,
pl.openTime,
pl.parkingLotID,
pl.parkingSpaces,
pl.priceHour,
pl.provider,
pl.providerID,
pl.status,
pl.urlPicture,
};
foreach (var item in parkingLot)
{
ParkingLot objParkingLot = new ParkingLot();
objParkingLot.address = item.address;
objParkingLot.closeTime = item.closeTime;
objParkingLot.description = item.description;
objParkingLot.districtId = item.districtId;
objParkingLot.latitude = item.latitude;
objParkingLot.LocalPhone = item.LocalPhone;
objParkingLot.longitud = item.longitud;
objParkingLot.name = item.name;
objParkingLot.openTime = item.openTime;
objParkingLot.parkingLotID = item.parkingLotID;
objParkingLot.priceHour = item.priceHour;
objParkingLot.providerID = item.providerID;
objParkingLot.status = item.status;
objParkingLot.urlPicture = item.urlPicture;
objParkingLot.objDisctrict = new Disctrict
{
disctrictId = item.disctrict.districtId,
name = item.disctrict.name,
provinceId = item.disctrict.provinceId,
objProvince = new Province
{
name = item.disctrict.province.name,
objDepartment = new Department
{
name = item.disctrict.province.department.name
}
}
};
objParkingLot.objProvider = new Provider
{
providerID = item.provider.providerID,
status = item.provider.status,
userID = item.provider.userID
};
objParkingLot.lstParkingSpace = getParkingPlaceByLot(item.parkingLotID.ToString());
lstParkingLot.Add(objParkingLot);
}
};
}
catch (Exception ex)
{
throw ex;
}
return(lstParkingLot);
}
