private DataTable GetParkingFee(string id)
{
dbConnection = DBConnect.getConnection();
if (dbConnection.State.ToString() == "Closed")
{
dbConnection.Open();
}
DataTable dt = new DataTable();
SqlCommand cmd = new SqlCommand("sp_GetParkingFee", dbConnection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@ParkingId", id);
SqlDataAdapter adp = new SqlDataAdapter(cmd);
try
{
adp.Fill(dt);
}
catch { }
return(dt);
}
private IEnumerable <ParkingLocations> GetAllParkingGoeLocation(LocationDetails details)
{
dbConnection = DBConnect.getConnection();
if (dbConnection.State.ToString() == "Closed")
{
dbConnection.Open();
}
DataSet dt = new DataSet();
SqlCommand cmd = new SqlCommand("getParkingLocationGeo", dbConnection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Latitude", String.Format("{0:0.000}", details.Latitude));
cmd.Parameters.AddWithValue("@Longitude", String.Format("{0:0.000}", details.Longitude));
SqlDataAdapter adp = new SqlDataAdapter(cmd);
try
{
adp.Fill(dt);
Parking_List = new List <ParkingLocations>();
for (int i = 0; i < dt.Tables[0].Rows.Count; i++)
{
objPark = new ParkingLocations();
objPark.ParkingPlace = dt.Tables[0].Rows[i]["ParkingPlace"].ToString();
objPark.Identifier = dt.Tables[0].Rows[i]["Identifier"].ToString();
objPark.Longitude = dt.Tables[0].Rows[i]["Longitude"].ToString();
objPark.Latitude = dt.Tables[0].Rows[i]["Latitude"].ToString();
objPark.Image = dt.Tables[0].Rows[i]["Image"].ToString();
objPark.Image1 = dt.Tables[0].Rows[i]["Image1"].ToString();
objPark.Image2 = dt.Tables[0].Rows[i]["Image2"].ToString();
objPark.Capacity = dt.Tables[0].Rows[i]["Capacity"].ToString();
objPark.ContactNumber1 = dt.Tables[0].Rows[i]["ContactNumber1"].ToString();
objPark.ContactNumber2 = dt.Tables[0].Rows[i]["ContactNumber2"].ToString();
objPark.ContactNumber3 = dt.Tables[0].Rows[i]["ContactNumber3"].ToString();
objPark.ContactPerson1 = dt.Tables[0].Rows[i]["ContactPerson1"].ToString();
objPark.ContactPerson2 = dt.Tables[0].Rows[i]["ContactPerson2"].ToString();
objPark.ContactPerson3 = dt.Tables[0].Rows[i]["ContactPerson3"].ToString();
objPark.ParkingArea = dt.Tables[0].Rows[i]["ParkingArea"].ToString();
objPark.SutedFor = dt.Tables[0].Rows[i]["SutedFor"].ToString();
objPark.ThrashholdValue = dt.Tables[0].Rows[i]["ThrashholdValue"].ToString();
objPark.ParkingFullTag = dt.Tables[0].Rows[i]["ParkingFullTag"].ToString();
Parking_List.Add(objPark);
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
adp.Dispose();
}
return(Parking_List);
}
private IEnumerable <ParkingLocations> GetAllParking(string id)
{
dbConnection = DBConnect.getConnection();
if (dbConnection.State.ToString() == "Closed")
{
dbConnection.Open();
}
DataSet dt = new DataSet();
SqlCommand cmd = new SqlCommand("getParkingLocation", dbConnection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@TownId", id);
SqlDataAdapter adp = new SqlDataAdapter(cmd);
try
{
adp.Fill(dt);
if (dt.Tables[0].Rows.Count > 0)
{
Parking_List = new List <ParkingLocations>();
for (int i = 0; i < dt.Tables[0].Rows.Count; i++)
{
objPark = new ParkingLocations();
objPark.ParkingPlace = dt.Tables[0].Rows[i]["ParkingPlace"].ToString();
objPark.Identifier = dt.Tables[0].Rows[i]["Identifier"].ToString();
objPark.Longitude = dt.Tables[0].Rows[i]["Longitude"].ToString();
objPark.Latitude = dt.Tables[0].Rows[i]["Latitude"].ToString();
objPark.Image = dt.Tables[0].Rows[i]["Image"].ToString();
objPark.Image1 = dt.Tables[0].Rows[i]["Image1"].ToString();
objPark.Image2 = dt.Tables[0].Rows[i]["Image2"].ToString();
objPark.Capacity = dt.Tables[0].Rows[i]["Capacity"].ToString();
objPark.ContactNumber1 = dt.Tables[0].Rows[i]["ContactNumber1"].ToString();
objPark.ContactNumber2 = dt.Tables[0].Rows[i]["ContactNumber2"].ToString();
objPark.ContactNumber3 = dt.Tables[0].Rows[i]["ContactNumber3"].ToString();
objPark.ContactPerson1 = dt.Tables[0].Rows[i]["ContactPerson1"].ToString();
objPark.ContactPerson2 = dt.Tables[0].Rows[i]["ContactPerson2"].ToString();
objPark.ContactPerson3 = dt.Tables[0].Rows[i]["ContactPerson3"].ToString();
objPark.ParkingArea = dt.Tables[0].Rows[i]["ParkingArea"].ToString();
objPark.SutedFor = dt.Tables[0].Rows[i]["SutedFor"].ToString();
objPark.ThrashholdValue = dt.Tables[0].Rows[i]["ThrashholdValue"].ToString();
objPark.ParkingFullTag = dt.Tables[0].Rows[i]["ParkingFullTag"].ToString();
objPark.Remarks = "";
DataTable dtFee = GetParkingFee(dt.Tables[0].Rows[i]["ParkingLocationId"].ToString().Trim());
if (dtFee.Rows.Count > 0)
{
for (int t = 0; t < dtFee.Rows.Count; t++)
{
if (dtFee.Rows[t]["VehicalType"].ToString().Trim().ToUpper() == "Small Car".ToUpper())
{
for (int j = 3; j < dtFee.Columns.Count; j++)
{
if (dtFee.Rows[t][j].ToString().Trim() != "0")
{
objPark.MinimumParkingFeeSmallCar = dtFee.Rows[t][j].ToString();
objPark.MinimumParkingTime = dtFee.Columns[j].ColumnName.ToString();
break;
}
}
}
if (dtFee.Rows[t]["VehicalType"].ToString().Trim().ToUpper() == "Big Car".ToUpper())
{
for (int j = 3; j < dtFee.Columns.Count; j++)
{
if (dtFee.Rows[t][j].ToString().Trim() != "0")
{
objPark.MinimumParkingFeebigCar = dtFee.Rows[t][j].ToString();
break;
}
}
}
}
}
else
{
objPark.MinimumParkingFeeSmallCar = "";
objPark.MinimumParkingTime = "";
objPark.MinimumParkingFeebigCar = "";
}
Parking_List.Add(objPark);
}
}
else
{
Parking_List = new List <ParkingLocations>();
objPark = new ParkingLocations();
objPark.Remarks = "No Record Found";
Parking_List.Add(objPark);
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
adp.Dispose();
}
return(Parking_List);
}