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