public TransportModel GetData(ITransportKey key)
{
TransportModel result = null;
var sql = @"
SELECT
TransportName
FROM
OFTA_Transport
WHERE
TransportID = @TransportID ";
using (var conn = new SqlConnection(ConnStringHelper.Get()))
using (var cmd = new SqlCommand(sql, conn))
{
cmd.AddParam("@TransportID", key.TransportID, SqlDbType.VarChar);
conn.Open();
using (var dr = cmd.ExecuteReader())
{
if (!dr.HasRows)
{
return(null);
}
dr.Read();
result = new TransportModel
{
TransportID = key.TransportID,
TransportName = dr["TransportName"].ToString()
};
}
}
return(result);
}
public void Delete(ITransportKey key)
{
var sql = @"
DELETE
OFTA_Transport
WHERE
TransportID = @TransportID ";
using (var conn = new SqlConnection(ConnStringHelper.Get()))
using (var cmd = new SqlCommand(sql, conn))
{
cmd.AddParam("@TransportID", key.TransportID, SqlDbType.VarChar);
conn.Open();
cmd.ExecuteNonQuery();
}
}