public IActionResult DeleteVehicalById([FromRoute] int ParkingId) { try { DeleteCacheData(); ParkDetailedModel employee = null; employee = parkingLotBL.DeleteVehicalById(ParkingId); if (!employee.Equals(null)) { //Message For MSMQ. string message = "\n Hello " + Convert.ToString(employee.VehicalOwnerName) + "\n Your " + " Vehicle UnPark Succesfully" + "\n Driver Name :" + Convert.ToString(employee.DriverName) + "\n Email :" + Convert.ToString(employee.VehicalOwnerEmail) + "\n Vehicle Number: " + Convert.ToString(employee.VehicalNumber) + "\n vehicle Brand : " + Convert.ToString(employee.Brand) + "\n Vehicle Color : " + Convert.ToString(employee.Color) + "\n Parking Slot : " + Convert.ToString(employee.ParkingSlot) + "\n Parking Date : " + Convert.ToString(employee.ParkingDate) + "\n Handicapped : " + Convert.ToString(employee.IsHandicap) + "\n"; string status = "Unparked"; senderObject.Send(message, status); bool Success = true; var Message = "Vehical UnParked Using By Id"; return(Ok(new { Success, Message, Data = employee })); } else if (employee == null) { bool Success = false; var Message = "Vehical Is Already UnParked"; return(Conflict(new { Success, Message })); } else { bool Success = false; var Message = "Lot Is Full"; return(NotFound(new { Success, Message })); } } catch (Exception exception) { return(BadRequest(new { Success = false, Message = exception.Message })); } }
/// <summary> /// Function For Unpark Api. /// </summary> /// <param name="VehicalNumber"></param> /// <returns></returns> public ParkDetailedModel DeleteVehicalById(int ParkingId) { try { int status; ParkDetailedModel Parkmodel = new ParkDetailedModel(); if (ParkingId != 0) { SqlCommand sqlCommand = new SqlCommand("spDeleteVehicalById", this.sqlConnectionVariable); sqlCommand.CommandType = CommandType.StoredProcedure; sqlCommand.Parameters.AddWithValue("@ParkingId", ParkingId); this.sqlConnectionVariable.Open(); SqlDataReader sqlDataReader = sqlCommand.ExecuteReader(); while (sqlDataReader.Read()) { status = sqlDataReader.GetInt32(0); if (status > 0) { Parkmodel.ReceiptNumber = Convert.ToInt32(sqlDataReader["ReceiptNumber"]); Parkmodel.VehicalOwnerName = sqlDataReader["VehicalOwnerName"].ToString(); Parkmodel.VehicalOwnerEmail = sqlDataReader["VehicalOwnerEmail"].ToString(); Parkmodel.VehicalNumber = sqlDataReader["VehicalNumber"].ToString(); Parkmodel.Brand = sqlDataReader["Brand"].ToString(); Parkmodel.Color = sqlDataReader["Color"].ToString(); Parkmodel.DriverName = sqlDataReader["DriverName"].ToString(); Parkmodel.IsHandicap = sqlDataReader["IsHandicap"].ToString(); Parkmodel.ParkingSlot = sqlDataReader["ParkingSlot"].ToString(); Parkmodel.Status = sqlDataReader["Status"].ToString(); Parkmodel.ParkingDate = sqlDataReader["ParkingDate"].ToString(); Parkmodel.UnparkDate = sqlDataReader["UnparkDate"].ToString(); Parkmodel.TotalTime = sqlDataReader["Minutes"].ToString() + " Minute"; Parkmodel.TotalAmount = AmountCanculation(Convert.ToInt32(sqlDataReader["Minutes"])).ToString() + " Rupees"; break; } else { return(null); } } } return(Parkmodel); } catch (Exception exception) { throw exception; } }