public bool DeleteById(object id) { string query = "Delete Bus Where busId = @id"; SqlParameter[] sqlParameters = new SqlParameter[1]; sqlParameters[0] = new SqlParameter("@id", SqlDbType.NVarChar) { Value = id }; try { conn.ExecuteDeleteQuery(query, sqlParameters); return(true); } catch (Exception ex) { throw ex; } }
public bool DeleteById(object id) { string query = "Delete Route Where id = @id"; SqlParameter[] sqlParameters = new SqlParameter[1]; sqlParameters[0] = new SqlParameter("@id", SqlDbType.Int) { Value = Convert.ToInt32(id) }; try { conn.ExecuteDeleteQuery(query, sqlParameters); return(true); } catch (Exception ex) { throw ex; } }