public CarrierObject GetCarrierById(int id) { CarrierObject carrier = new CarrierObject(); try { db.OpenConnection(); string sql = $"Select * From tbl_Carrier WHERE ID = '{id}'"; SqlCommand myCommand = new SqlCommand(sql, db._connection); using (SqlDataReader myDataReader = myCommand.ExecuteReader()) { while (myDataReader.Read()) { carrier.carrierId = int.Parse(myDataReader["ID"].ToString()); carrier.carrier = myDataReader["Carrier"].ToString(); carrier.service = myDataReader["Service"].ToString(); carrier.price = decimal.Parse(myDataReader["Price"].ToString()); } } } catch { return(null); } finally { db.CloseConnection(); } return(carrier); }
public void UppdateCarier(CarrierObject carrier, int id) { try { db.OpenConnection(); string sql = $"UPDATE tbl_Carrier SET Carrier = '{carrier.carrier}', Service = '{carrier.service}', Price = '{carrier.price}' WHERE ID = '{id}'"; SqlCommand insertCmd = new SqlCommand(sql, db._connection); insertCmd.ExecuteNonQuery(); } catch { //TODO Exeption } finally { db.CloseConnection(); } }
public void AddCarrier(CarrierObject carrier) { try { db.OpenConnection(); string sql = $"Insert Into tbl_Carrier (Carrier, Service, Price ) Values('{carrier.carrier}', '{carrier.service}', '{carrier.price}' )"; SqlCommand insertCmd = new SqlCommand(sql, db._connection); insertCmd.ExecuteNonQuery(); } catch { //TODO exeption } finally { db.CloseConnection(); } }