public DriverModel Get(int id)
{
DriverModel obj = new DriverModel();
try
{
using (SqlConnection conn = new SqlConnection(ConnectionString))
{
conn.Open();
string tsql = "sp_getDriver";
using (SqlCommand cmd = new SqlCommand(tsql, conn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@IDDriver", id);
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
obj = new DriverModel
{
IDDriver = (int)reader["IDDriver"],
Name = reader["Name"].ToString(),
Picture = reader["Picture"].ToString(),
Status = reader["Status"].ToString(),
ActualPosition = new PositionModel
{
Latitude = reader["Latitude"].ToString(),
Longitude = reader["Longitude"].ToString()
}
};
}
}
}
}
return(obj);
}
catch (Exception)
{
throw;
}
}
public DriverModel Get(int id)
{
DriverModel driver = new DriverModel();
try
{
using (SqlConnection conn = new SqlConnection(ConnectionString))
{
conn.Open();
string tsql = "SELECT * FROM Driver INNER JOIN Position ON Driver.IDActualPosition = Position.IDPosition WHERE IDDriver = @IDDriver";
using (SqlCommand cmd = new SqlCommand(tsql, conn))
{
cmd.Parameters.AddWithValue("@IDDriver", id);
using (SqlDataReader reader = cmd.ExecuteReader())
{
if (reader.Read())
{
driver = new DriverModel
{
IDDriver = (int)reader["IDDriver"],
Name = reader["Name"].ToString(),
Status = reader["Status"].ToString(),
Picture = reader["Picture"].ToString(),
ActualPosition = new PositionModel
{
Latitude = reader["Latitude"].ToString(),
Longitude = reader["Longitude"].ToString()
}
};
}
}
}
}
return(driver);
}
catch (Exception)
{
throw;
}
}