public int DeleteEmployee(ParkingCL data)
{
try
{
SqlCommand com = StoreProcedureConnection("spDeleteParkingRcords", connection);
com.Parameters.AddWithValue("@ParkingId", data.ParkingId);
connection.Open();
int Response = com.ExecuteNonQuery();
connection.Close();
if (Response != 0)
{
return(1);
}
else
{
return(0);
}
}
catch (Exception e)
{
throw new Exception(e.Message);
}
finally
{
connection.Close();
}
}
public bool ParkingLogin(ParkingCL data)
{
try
{
SqlCommand command = StoreProcedureConnection("spParkingLogin", connection);
string Password = EncryptedPassword.EncodePasswordToBase64(data.Password);
command.Parameters.AddWithValue("@ParkingId", data.ParkingId);
command.Parameters.AddWithValue("@Password", Password);
connection.Open();
int Response = command.ExecuteNonQuery();
connection.Close();
if (Response != 0)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception e)
{
throw new Exception(e.Message);
}
}
public ParkingCL GetspecifiParkingDetails(int ID)
{
try
{
ParkingCL park = new ParkingCL();
SqlCommand com = StoreProcedureConnection("spSpecificParkingDetails", connection);
com.Parameters.Add("@ParkingId", SqlDbType.Int).Value = ID;
connection.Open();
SqlDataReader Response = com.ExecuteReader();
while (Response.Read())
{
park.ParkingId = Convert.ToInt32(Response["ParkingSlotNo"]);
park.VehicalNo = Convert.ToInt32(Response["VehicalNo"]);
park.VehicalBrand = Response["VehicalBrand"].ToString();
park.VehicalColor = Response["VehicalColor"].ToString();
park.ChargePerHr = Convert.ToInt32(Response["ChargePerHr"]);
park.EntryTime = DateTime.Parse(Response["EntryTime"].ToString());
park.DriverCategory = Convert.ToInt32(Response["DriverCategory"]);
park.ParkingType = Response["ParkingType"].ToString();
park.ExitTime = DateTime.Parse(Response["ExitTime"].ToString());
park.Password = Response["Password"].ToString();
}
connection.Close();
return(park);
}
catch (Exception e)
{
throw new Exception(e.Message);
}
finally
{
connection.Close();
}
}
public IEnumerable <ParkingCL> GetAllParkingDetails()
{
try
{
List <ParkingCL> listParking = new List <ParkingCL>();
SqlCommand com = StoreProcedureConnection("spAllParkingDetails", connection);
connection.Open();
SqlDataReader Response = com.ExecuteReader();
while (Response.Read())
{
ParkingCL park = new ParkingCL();
park.ParkingId = Convert.ToInt32(Response["ParkingSlotNo"]);
park.VehicalNo = Convert.ToInt32(Response["VehicalNo"]);
park.VehicalBrand = Response["VehicalBrand"].ToString();
park.VehicalColor = Response["VehicalColor"].ToString();
park.ChargePerHr = Convert.ToInt32(Response["ChargePerHr"]);
park.EntryTime = DateTime.Parse(Response["EntryTime"].ToString());
park.DriverCategory = Convert.ToInt32(Response["DriverCategory"]);
park.ParkingType = Response["ParkingType"].ToString();
park.ExitTime = DateTime.Parse(Response["ExitTime"].ToString());
park.Password = Response["Password"].ToString();
listParking.Add(park);
}
connection.Close();
return(listParking);
}
catch (Exception e)
{
throw new Exception(e.Message);
}
finally
{
connection.Close();
}
}
public int UpdateEmployee(ParkingCL data)
{
try
{
SqlCommand com = StoreProcedureConnection("spUpdateParkingDetails", connection);
string Password = EncryptedPassword.EncodePasswordToBase64(data.Password);
com.Parameters.AddWithValue("@ParkingId", data.ParkingId);
com.Parameters.AddWithValue("VehicalNo", data.VehicalNo);
com.Parameters.AddWithValue("VehicalBrand", data.VehicalBrand);
com.Parameters.AddWithValue("VehicalColor", data.VehicalColor);
if (data.ExitTime > data.EntryTime && data.ParkingType != "Own")
{
data.ChargePerHr = CHARGE_PER_HR;
}
com.Parameters.AddWithValue("ChargePerHr", data.ChargePerHr);
com.Parameters.AddWithValue("EntryTime", data.EntryTime);
com.Parameters.AddWithValue("DriverCategory", data.DriverCategory);
com.Parameters.AddWithValue("ParkingType", data.ParkingType);
if (data.ExitTime < data.EntryTime)
{
data.ExitTime = data.EntryTime;
}
com.Parameters.AddWithValue("ExitTime", data.ExitTime);
com.Parameters.AddWithValue("@Password", Password);
connection.Open();
int Response = com.ExecuteNonQuery();
connection.Close();
if (Response == 0)
{
return(0);
}
else
{
return(1);
}
}
catch (Exception e)
{
throw new Exception(e.Message);
}
finally
{
connection.Close();
}
}
public int DeleteEmployee(ParkingCL Data)
{
try
{
int Result = Parking.DeleteEmployee(Data);
if (Result == 0)
{
return(0);
}
else
{
return(1);
}
}
catch (Exception e)
{
throw new Exception(e.Message);
}
}
public bool ParkingDatails(ParkingCL data)
{
try
{
var Result = Parking.ParkingDatails(data);
if (!Result.Equals(null))
{
return(true);
}
else
{
return(false);
}
}
catch (Exception e)
{
throw new Exception(e.Message);
}
}
public IActionResult ParkingLOTDetails([FromBody] ParkingCL Info)
{
try
{
bool data = BusinessLayer.ParkingDatails(Info);
if (!data.Equals(null))
{
var status = true;
var Message = "Parking Details Entered Succesfully";
return(this.Ok(new { status, Message, data }));
}
else
{
var status = false;
var Message = "Parking Details Entered Failed";
return(this.BadRequest(new { status, Message }));
}
}
catch (Exception e)
{
return(BadRequest(new { error = e.Message }));
}
}
public IActionResult UpdateEmployee([FromBody] ParkingCL data)
{
try
{
int Result = BusinessLayer.UpdateEmployee(data);
if (Result == 0)
{
var Status = "False";
var Message = "wrong input";
return(this.BadRequest(new { Status, Message, data }));
}
else
{
var Status = "True";
var Message = "Parking Data Updated Sucessfully";
return(this.Ok(new { Status, Message, data }));
}
}
catch (Exception e)
{
throw new Exception(e.Message);
}
}
public IActionResult ParkingLogin([FromBody] ParkingCL Info)
{
try
{
var Result = BusinessLayer.ParkingLogin(Info);
if (!Result.Equals(null))
{
var status = "True";
var Message = "Login Successful";
return(Ok(new { status, Message, Result }));
}
else
{
var status = "False";
var Message = "Invaid Username Or Password";
return(BadRequest(new { status, Message, Result }));
}
}
catch (Exception e)
{
throw new Exception(e.Message);
}
}
public IActionResult DeleteEmployee(ParkingCL Data)
{
try
{
int result = BusinessLayer.DeleteEmployee(Data);
if (result != 0)
{
var Status = "True";
var Message = "Parking Data deleted Sucessfully";
return(this.Ok(new { Status, Message, Data }));
}
else
{
var Status = "False";
var Message = "Parking Data is not deleted Sucessfully";
return(this.BadRequest(new { Status, Message, Data }));
}
}
catch (Exception e)
{
throw new Exception(e.Message);
}
}
