//מחיקת רכב
public static void DeleteCar(int car_id)
{
Car car = db.Cars.Find(car_id);
db.Cars.Remove(car);
db.SaveChanges();
}
public IHttpActionResult PutPayment(int id, Payment payment)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != payment.id)
{
return(BadRequest());
}
db.Entry(payment).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!PaymentExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
//Funcion para insertar un nuevo registro
public String InsertPrice(PriceRequest priceRequest)
{
try
{
PriceResponse priceResponse = GetPriceByVehicleType(priceRequest.idVehicleType);
if (priceResponse == null)
{
Price price = new Price();
price.idVehicleType = priceRequest.idVehicleType;
price.valueMinute = priceRequest.valueMinute;
price.valueMonth = priceRequest.valueMonth;
db.Price.Add(price);
db.SaveChanges();
mensaje = "OK";
}
else
{
mensaje = "PRICE_EXIST_FOR_THIS_VEHICLE_TYPE";
}
}
catch (DbEntityValidationException e)
{
mensaje = "Error al crear un precio" + e;
}
return(mensaje);
}
//
public static void EditSetting_user(Setting_user_Entity setting)
{
foreach (var item in db.Setting_user.ToList())
{
if (item.s_user_id == setting.s_user_id)
{
item.s_choose_criterion = setting.s_choose_criterion;
item.s_range = setting.s_range;
db.SaveChanges();
}
}
}
public ActionResult CreateGate(UserProfile objUser)
{
TempData["errorMsg"] = string.Empty;
TempData["statusMsg"] = string.Empty;
if (ModelState.IsValid &&
Session["UserID"] != null &&
Session["UserType"].ToString().Equals("1"))
{
using (ParkingEntities db = new ParkingEntities())
{
var obj = db.UserProfiles
.Where(a => a.UserName.Equals(objUser.UserName))
.FirstOrDefault();
if (obj == null)
{
objUser.IsActive = true;
objUser.CreatedBy = Session["UserName"].ToString();
db.UserProfiles.Add(objUser);
db.SaveChanges();
TempData["statusMsg"] = "Account is created successfully.";
return(RedirectToAction("AdminUserDashBoard"));
}
else
{
TempData["errorMsg"] = "GateID is already exists, Please create with seperate name";
return(RedirectToAction("AdminUserDashBoard"));
}
}
}
// When user is not logged-in.
Session.Clear();
return(RedirectToAction("Signin"));
}
public ActionResult EntryGate(ParkingLog parkingLog)
{
TempData["statusMsg"] = string.Empty;
if (ModelState.IsValid &&
Session["UserID"] != null &&
Session["UserType"].ToString().Equals("2"))
{
if (!string.IsNullOrEmpty(parkingLog.PlateNumber))
{
using (ParkingEntities db = new ParkingEntities())
{
parkingLog.Status = "OnGoing";
parkingLog.InGateSessionID = Session.SessionID;
parkingLog.InTimeStamp = DateTime.Now;
parkingLog.INAgentMACID = Session["UserName"].ToString();
db.ParkingLogs.Add(parkingLog);
db.SaveChanges();
TempData["statusMsg"] = "Successfully Submitted Your IN Entry.";
}
}
ModelState.Clear();
return(View());
}
// When user is not logged-in
Session.Clear();
return(RedirectToAction("Signin", "Login"));
}
public Record InsertRecord(RecordRequest rq)
{
Record recordReturn = new Record();
try
{
Record record = new Record();
record.idParkCell = rq.idCell;
record.license = rq.license;
record.timeEntry = DateTime.UtcNow.ToLocalTime();
record.idPrice = rq.idprice;
db.Record.Add(record);
db.SaveChanges();
UpdateStateParkCells(rq);
mensaje = "OK";
}
catch (DbEntityValidationException e)
{
mensaje = "Error al insertar vehicculo" + e;
}
return(recordReturn);
}
public IHttpActionResult DeleteRecord(int id)
{
Record record = db.Record.Find(id);
if (record == null)
{
return(NotFound());
}
db.Record.Remove(record);
db.SaveChanges();
return(Ok(record));
}
public User InsertUser(UserRequest userRequest)
{
User userReturn = new User();
try
{
userReturn = this.GetByUsernameUser(userRequest.username);
if (userReturn == null)
{
User user = new User();
user.username = userRequest.username;
user.pass = userRequest.pass;
db.User.Add(user);
db.SaveChanges();
mensaje = "OK";
userReturn = this.GetByUsernameUser(user.username);
}
}
catch (DbEntityValidationException e)
{
mensaje = "Error al crear un usuario" + e;
}
return(userReturn);
}
public ActionResult OutGate(ParkingLog parkingLog)
{
TempData["statusMsg"] = string.Empty;
TempData["errorMsg"] = string.Empty;
if (ModelState.IsValid &&
Session["UserID"] != null &&
Session["UserType"].ToString().Equals("3"))
{
if (!string.IsNullOrEmpty(parkingLog.PlateNumber))
{
using (ParkingEntities db = new ParkingEntities())
{
var obj = db.ParkingLogs
.Where(car
=> car.PlateNumber.Equals(parkingLog.PlateNumber) &&
car.Status.Equals("OnGoing"))
.OrderByDescending(car => car.InTimeStamp)
.FirstOrDefault();
if (obj != null)
{
obj.Status = "Completed";
obj.OutGateSessionID = Session.SessionID;
obj.OutTimeStamp = DateTime.Now;
obj.OUTAgentMACID = Session["UserName"].ToString();
db.SaveChanges();
TempData["statusMsg"] = "Sucessfully submited your OUT Entry.";
}
else
{
TempData["errorMsg"] = "Sorry We don't have your records in our server.";
}
}
}
ModelState.Clear();
return(View());
}
//When user is not logged-in
Session.Clear();
return(RedirectToAction("Signin", "Login"));
}
//הוספת חניון
public static void AddParking(Parking_Entity parking)
{
db.Parkings.Add(Convert_Parking.convertToDal(parking));
db.SaveChanges();
}
//הוספת חניון למנהל קיים
public static void AddOwner_parkings(Parkings_of_owner_Entity owner)
{
db.Parkings_of_owner.Add(Convert_Parkings_of_owner.convertToDal(owner));
db.SaveChanges();
}
//הוספת משתמש
public static void AddUser(User_Entity user)
{
db.users.Add(Convert_User.convertToDal(user));
db.SaveChanges();
}
//הוספת רכב לחניון
public static void AddCar(Car_in_parking_Entity car)
{
db.Car_in_parking.Add(Convert_Car_in_parking.convertToDal(car));
db.SaveChanges();
}
